Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Import zipped input file into campaign

Avatar

Avatar
Validate 50
Level 5
askdctm
Level 5

Likes

48 likes

Total Posts

476 posts

Correct Reply

7 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Boost 5
View profile

Avatar
Validate 50
Level 5
askdctm
Level 5

Likes

48 likes

Total Posts

476 posts

Correct Reply

7 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Boost 5
View profile
askdctm
Level 5

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
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
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
Validate 50
Level 5
askdctm
Level 5

Likes

48 likes

Total Posts

476 posts

Correct Reply

7 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Boost 5
View profile

Avatar
Validate 50
Level 5
askdctm
Level 5

Likes

48 likes

Total Posts

476 posts

Correct Reply

7 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Boost 5
View profile
askdctm
Level 5

16-05-2018

Hi All,

Any thoughts on this will be helpful.