Import zipped input file into campaign




I have extended custom recipient table and have few other custom tables.

I have zipped input file(which has data in excel sheet corresponding to one of the table) whose data is to be imported into say (custom recipient table).

I am aware of using Data loading activity to import an excel file present on local folder on system[windows OS] into campaign and put that data into the table. But not sure how it is to be done, when it is zipped and provided.

Campaign version 7.0.8863

Any pointers/thoughts on this will be helpful. Let us know, in case additional details required.

Accepted Solutions (1)

Accepted Solutions (1)





You can try to unzip file using javascript command at one of the server location and then process it using 'Data Loading' activity.

Command to use unzip file:

var cmdStr="unzip -j <full path and name of your zipped file> -d <location where you want to place unzipped file>";

var res=execCommand(cmdStr);