Import zipped input file into campaign | Community
Skip to main content
A
askdctm
Level 9
May 16, 2018
Solved

Import zipped input file into campaign

  • May 16, 2018
  • 2 replies
  • 3135 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jyoti_Yadav

    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.

    2 replies

    A
    askdctmAuthor
    Level 9
    May 17, 2018

    Hi All,

    Any thoughts on this will be helpful.

    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    October 16, 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.

      Terms & ConditionsAccessibility statement

      Loading footer...