Page 1 of 1

Export templates

PostPosted: Wed Dec 15, 2010 9:56 pm
by dspaan
We have at least two customers for which we have to export the same results and send them by e-mail daily. As the export function is right now you have to click campaign, group, list, statusus and custom fields select each time.

It would be awesome to have campaign specific export templates so the same results could be exported each day with the press of a button. If it could be automatically e-mailed at a scheduled time would be even more awesome.

Also it would be nice the fields that are exported could be chosen in this template and even be renamed so it's easier for the customer to import the data.

PostPosted: Thu Dec 16, 2010 12:29 am
by williamconley
use a cron job to activate the AST_VDsales_export.pl and email your results :)

PostPosted: Thu Dec 16, 2010 6:20 am
by dspaan
No idea how to do that. :( Can you give me some more pointers? I never made a cron job.

PostPosted: Thu Dec 16, 2010 4:54 pm
by williamconley
start here:
Code: Select all
nano /usr/share/AST_VDsales_export.pl
the file itself contains directions for what switches to use on the command line to get specific results. Exiting nano if no changes have been made can be done via "control x"

Read the manual.

the script can be executed via:
Code: Select all
nano /usr/share/AST_VDsales_export.pl --test
with whatever switches you choose after --