Exporting Large Zip Files in the Background

When exporting a large zip file, you may prefer to export it in the background to avoid the browser timing out. Here is a sample request zip file:

Here are the contents of the csvutil.ctl file within test2.bg.zip:

-dataFileName activity_out.csv -command xcsv -tableName ACTIVITY
-dataFileName location_out.csv -command xcsv -tableName LOCATION -whereClause "rownum < 10"
-mailTo [e-mail] -mailFrom [e-mail] -subject zipFileProcessDone -message hello -smtpHost mail.example.com

Here is another example csvutil.ctl file that exports all the rate_geo records in a given domain, along with all parent and child data, but not public data:

-dataFileName rate_geo_out.csv -command xcsvwpcd -tableName RATE_GEO -whereClause "domain_name = 'MDIETL'"
-mailTo [e-mail] -mailFrom [e-mail] -subject zipFileProcessDone -message hello -smtpHost mail.example.com

Here is the same example, but this time with referenced public data:

-dataFileName rate_geo_out.csv -excludePublic N -command xcsvwpcd -tableName RATE_GEO -whereClause "domain_name = 'MDIETL'"
-mailTo [e-mail] -mailFrom [e-mail] -subject zipFileProcessDone -message hello -smtpHost mail.example.com

Note: Exporting with parent and child data is a very time consuming process since the system has to repeatedly chase after foreign key references. Expect the export to run overnight for as long as 8 hours.