Import zipped input file into campaign

Avatar

Avatar

askdctm

Avatar

askdctm

askdctm

16-05-2018

Hi,

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)

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

Jyoti_Y
MVP

16-10-2019

Hi,

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);

Thanks.

Answers (1)

Answers (1)

Avatar

Avatar

askdctm

Avatar

askdctm

askdctm

16-05-2018

Hi All,

Any thoughts on this will be helpful.