We can produce a Comma Separated File (CSV) and read them from Amazon S3, DropBox, Google Drive, and OneDrive. This is a simple way to import data from other services or to export files for backups or sharing with other applications. To allow the maximum flexibility and support with all services, the configuration is quite rich. Here is how you configure it:
To help with the column mapping, you can select the “Choose Columns by Uploading Sample” button which will allow you to upload a same portion of the file, then interactively map the columns and save that configuration. This is a great way to ensure that you have all of the required fields, such as a start date.
To configure Amazon S3, place your Access Key into the username field, your Secret Key into the Password field, and for the path, use bucket/directory/file.
If you receive an error indicating that a row does not have a date or an activity or description, more than likely you are missing a required field. We recommend using our sample uploader which will list the required fields for that data type.
Note: For destination tasks, we do not rewrite the file but rather append the file with what we believe is the new information. If you delete the file and want to repopulate it, you will need to use the Reset button on the task.