I'm having a CSV file that is full with URLs and some parameters, i want to Crypt those parameters using the function encryptDES and then export that file but with crypted parameters.
My question here is if there is a way using workflows to take datas from CSV file and crypt them then export the datas crypted to a new CSV file ? or if there is other way to do the same thing without workflow
(cryptString or SHA256 or whatever can be done here easily and efficiently considering performance with high volumes):
So you have to add your fields (button New) and unselect the checkbox of the fields coming from the 1st page (query) of Extract activity:
Use the toolbar button list box to generate the source.target__XXX or type it directly.
Your way worked perfectly, thank you so much for your help.
the extract data activity needs a inbound temp:schema, so you can write your modified data in a list.
a more complicated solution, you can modifiy your SQL temp table.
Hi J-Serge thanks for responding,
I will consider your advice and i will try to use cryptString.
My probelem here is to export datas to text file after crypt them, if there is a way with JS activity or using advanced expression in the data extraction activity.
Hii Pierre and thanks for your answer,
I'm actualy working on the JS activity, and i crypted the values and i can see them crypted with the logInfo.
I'm blocked in the exporting part, it will be so helpful if you can provide the code JS activity uses to export a string to txt or CSV.
Take care, DES is deprecated crypt algorithm.
Please use cryptString function that uses AES algorithm:
and its counterpart, decryptString function.
When it is url, don't forget to encode URL when passing it to a web site.
Sometimes the use case is not symetric algorithm (reversible decrypt) such AES but only hash MD5 or SHA256 (no reversible but usable for comparison), in that case use these functions instead.
this subject was partially covered in Functions to encrypt or decrypt PII data in Adobe Campaign Classic
Please note, DES is considered insecure, you should favor AES if you can.
You could add a custom function to encrypt in Adobe Campaign : Adding additional SQL functions or get the temp:schema in a JS activity, loop over each row and use a method such as cryptString on the field to be encrypted.
Hi Venur and thank you for responding,
But my problem here is different, i want to encrypt de parameteres not the file, for exemple im having a CSV file with the following fields:
i want to encrypt the Name, Age and Title using encryptDES and after export the file with :