LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Decrypt after saving encrypted data to file won't work?

    Employee
    Posted 05-03-2016 18:19

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rene.cravioto

    Hello Lavastorm friends,
    I am having problems trying to decrypt back the contents of an XML file after having encrypted it. I am not getting any error messages, the output of the decrypt block just looks the same as its input.
    To troubleshoot, I added a block that decrypts right after encrypting and that works well.
    The problem arises if I store the encrypted output as XML, CSV or XLS files (yes, I tried all of them) and then read the data from the files with it's corresponding block and then try to decrypt.

    What's strange is that the Decrypt Output block shows the output pin as "Encrypt".

    Q: has anyone had this issue? Do you know how to fix it? Am I doing something wrong?

    Your help is greatly appreciated!

    decrypt.jpg DecryptScreenshot.PNG


  • 2.  RE: Decrypt after saving encrypted data to file won't work?

    Employee
    Posted 05-05-2016 00:41

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: simon.wilby

    Hi,

    could you provide some example data so we can take a closer look please? I'm struggling to see the detail in the screenshots.

    thanks

    Simon


  • 3.  RE: Decrypt after saving encrypted data to file won't work?

    Employee
    Posted 05-05-2016 00:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: simon.wilby

    I've had a further look into this and from the node help the intention was for this to only work with an input brd file (first line of the help for the decrypt fields node)
    Is there a reason why you cannot use the output brd node to save the data?

    Simon


  • 4.  RE: Decrypt after saving encrypted data to file won't work?

    Employee
    Posted 05-05-2016 04:12

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi,

    It is possible to save encrypted data to CSV, XLSX, BRD and raw data files - see the examples in the attached data flow.

    Note that the Decrypt Fields node requires the data type of the fields containing encrypted data to be 'string' and not 'unicode'.
    In the case where XLSX or raw file types are used as the intermediate file format, you need to convert the fields to string prior to using the Decrypt Fields node.

    Encrypted_XML_Data_Saved_to_File_Examples.brg


    Regards,
    Adrian