Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

Configuring Environment Settings for Data Export

Configuring Environment Settings for Data Export

Edit the conf/misc/importexporttool.config file and configure the environment settings for the system from which you are exporting data. You need to configure:

  • The database connection details. For example, for a MySQL database named EP6 on the local machine running on port 3306, your settings should look similar to this:
    db.connection.url=jdbc:mysql://localhost:3306/EP6?AutoReconnect=true&useUnicode=true&characterEncoding=utf-8
    db.connection.username=root
    db.connection.password=root
    db.connection.driver_class=com.mysql.jdbc.Driver
                
  • The search server URL. Set the search.host property to the URL of the Elastic Path search server web application. For example:
    search.host=http://localhost:8080/searchserver
    
  • The VFS configuration for the Elastic Path deployment that contains the data you want to export. For example:
    asset.vfs.protocol=ftp
    asset.vfs.host=localhost
    asset.vfs.port=21
    asset.vfs.username=ftpuser
    asset.vfs.password=password
    asset.vfs.rootpath=c:/localassets/assets
    image.asset.subfolder=images
    digitalgoods.asset.subfolder=digitalassets
                
Note:
These settings must match the corresponding settings in Elastic Path. To view the setting values:
  1. Log in to Commerce Manager.
  2. Click the Configuration.
  3. Click System Configuration.