Transferring Files via Secure Protocol
Transfer your data via an SFTP in two steps.
Step 1. Access Credentials
Please provide us with access credentials. You can email the connection information to support@optilyz.com.
Example:
Host: sftp://myserver.com
Port: 22
User: optilyz
Password: We will send you our public key file upon request. Alternatively, you can provide us with a private key file or if you would like us to use a password to access the SFTP server, please provide that as well.
After you have helped us connect to your data source, you will need to provide us with additional information about the structure of your data.
Step 2. Configuration Data
For us to be able to properly read and import your data, you will need to provide us with some information about the format of the files you will be uploading. Please send the following to support@optilyz.com
Encoding
UTF-8 is standard, we also support:
latin1
ascii
windows-1252
macroman
latin9
Delimiter
How are the columns separated? comma, semi-colon or tab.
Column Headers
What are the headers for your data and how do they map to optilyz fields? The full list can be found here. You can just send us a list:
For example:
First Name = firstName,
Last Name = lastName,
Address 1 = address1...
Tip: Send us a sample file the represents the files you plan to upload to the remote storage location and we will help you figure out these configuration details.