Skip to main content
askdctm
Level 9
May 16, 2018 2:18 PM UTC
Solved

Import zipped input file into campaign

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.
    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    Oct 16, 2019 7:08 AM UTC

    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.

    View in thread

    2 replies

    askdctmAuthor
    Level 9
    May 17, 2018 4:39 AM UTC

    Hi All,

    Any thoughts on this will be helpful.

    Translate
    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    Oct 16, 2019 7:08 AM UTC

    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...