Report Settings

Storage

Choose from this Storage options:

• DataChamp

• DataChamp - Feed

  • A feed URL is provided. Take a look to the tutorial "Product Feed" for further details.

• Google Drive / Google Sheets

• Dropbox

• FTP

• FTP 2

Note If you indent to use Google Drive, FTP or Dropbox - please configure your storages first.

Export Mode

Choose from these export modes:

• Items

  • Standard: All items that match the filter criteria are exported each time the report is run

  • Incremental: Only items that match the filter criteria and were not exported in a previous run are exported

• Lines

  • Standard: For each sub item e.g. order lines in orders, a separate line is inserted

  • Compress: Sub items e.g. order lines in orders are inserted in a single line

  • Fill: Like "Standard" but values of the main item are copied in each line e.g. "Order note" is inserted for each order line

  • Duplicate by quantity: Sub items e.g. order lines are duplicated based on the quantity. So for a single order line with a quantity of 5, 5 lines are created

File Type & File Name

Choose between these File Types:

• Excel

• CSV

• TXT

When using Google Drive / Google Sheets as Storage you will see this additional option:

• How to write data to Google Sheets

  • Overwrite

  • Append

  • Add sheets

  • Create new file

You can also use this function within your file name: "addDays(dateformat, number of days)":

CSV - Encoding, Delimiter and Quote

These are the available options when using CSV file type:

• Encoding

• UTF-8 (Default)

• UTF-8 with BOM

  • ASCII

  • CP1252 (Windows-1252)

  • ISO-8859-1

  • ISO-8859-8

  • Shift JIS

• Delimiter

  • , (Default)

  • ;

  • tab

  • |

• Quote

  • " (Default)

  • '

  • none

  • " (forced)

• Line break

  • LF (Mac | Linux | Unix)

  • CRLF (Windows)

File Name

User-defined file names can be used.

Please use one of this placeholders:

DataChamp will show a preview of your customized file name: