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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Decrypting files before ingensting

Avatar

Level 3

Since the data files that will be uploaded to Campaign Servers will have PII data, the source system will encrypt (PGP encryption) the data files before uploading them to Adobe Campaign server. As part of the data ingestion process/workflow, we need to first decrypt the files and then ingest the data. Can you please suggest potential solutions for achieving it?

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

There are two options to solve this

option 1: use the "script" i.e use shell script , activity to decrypt the file in the workflow before importing file into adobe  campaign.

option 2: you can follow the following steps:

Step 1:

download pgp either from https://sourceforge.net/projects/ppgp/ or https://pgp.en.softonic.com/

step 2: install the pgp

step 3: Use Data loading (file) activity in your adobe campaign workflow:

step 4: choose pre process the file option: refer to screen:

Capture.PNG

Step 5: Use the following command:

<path-to_pgp_if-not_global_or_server/>pgp.exe --decrypt --input nl6/var/vp/import/filename.pgp --passphrase "your password" --recipient recipient @email.com --verbose --output nl6/var/vp/import/filename

step 6 : save and execute the workflow.

Regards,

Amit

5 Replies

Avatar

Correct answer by
Community Advisor

Hi,

There are two options to solve this

option 1: use the "script" i.e use shell script , activity to decrypt the file in the workflow before importing file into adobe  campaign.

option 2: you can follow the following steps:

Step 1:

download pgp either from https://sourceforge.net/projects/ppgp/ or https://pgp.en.softonic.com/

step 2: install the pgp

step 3: Use Data loading (file) activity in your adobe campaign workflow:

step 4: choose pre process the file option: refer to screen:

Capture.PNG

Step 5: Use the following command:

<path-to_pgp_if-not_global_or_server/>pgp.exe --decrypt --input nl6/var/vp/import/filename.pgp --passphrase "your password" --recipient recipient @email.com --verbose --output nl6/var/vp/import/filename

step 6 : save and execute the workflow.

Regards,

Amit

Avatar

Level 1

Hi @Amit_Kumar ,

I have tried above solution but i am getting "WKF-560006 An error occurred when loading the '' file ('Data loading (file)' step) BAS-010014 Cannot open file 'PAth to file' with read access (errno=3, The system cannot find the path specified.)" this error.

could you please help me to solve the error. 

Thanks,

Diksha

 

 

Avatar

Level 1

Hi @Amit_Kumar ,

I have tried above solution but i am getting "WKF-560006 An error occurred when loading the '' file ('Data loading (file)' step) BAS-010014 Cannot open file 'PAth to file' with read access (errno=3, The system cannot find the path specified.)" this error.

could you please help me to solve the error. 

Thanks,

Diksha

 

Avatar

Level 3

Thanks a lot Amit for the detailed response. We will try out the solution options that you suggested.