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:
When exporting your data, the “Daily Summary to have Total Counts” gives you flexibility on your summary row. When not checked, it will show you the exact data as show in your Stream. If this option is checked, the daily summary row will contain the total of the steps for the day. If there is not a summary row by default for that date, one will be added to your dataset.
To help with the column mapping, you can select the “Choose Columns by Uploading Sample” button which will allow you to upload a sample 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.
Some services may produce CSV files which represent an activity. Such files are supported, however, you must use the Map-based option to configure this.
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 provided or an activity or description, more than likely you are missing a required field or that it was unable to be parsed. 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 Reset the task.