Customer Portal

System Execute to Move Files?

Comments 5

  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Hi Pintail,

    You can of course use SystemExecute to copy a file to another location. You should, however, keep in mind the Clover is not "in charge" of copying the data - it just invoke a system command (in your case cp, pscp etc.). An example of why you should rather use File Operations components (e.g. CopyFile or MoveFiles) is described in this thread.
    Regarding the SystemExecute configuration you can refer to the documentation. The most important (basic) attributes you need to set here is "System command" and "Working directory".

    Hope it helps.
  • Avatar
    raj
    0
    Comment actions Permalink
    I have the same requirement to do. Can you please help me how to decrypt a file in clover ETL?
    I have a csv file and encrypted it as .PGP file. Now I want to decrypt this file and want to get the original csv file.
    Can you please help me out in this.

    Thanks in advance.
  • Avatar
    Pedro Vazquez Rosario
    0
    Comment actions Permalink
    Hi Raj,

    You can accomplish this by using our SystemExecute component, simply add your command based on the decryption software you are using to decrypt your file in the "System Command" property. You will also want to specify the location of where you want to store your file in the "Output file URL" property.
  • Avatar
    raj
    0
    Comment actions Permalink
    Thanks for the reply.
    I could not follow the solution can you please share me a simple example on this!

    -Raj
  • Avatar
    Pedro Vazquez Rosario
    0
    Comment actions Permalink
    Hi Raj,

    A simple example won't be possible, since the command script depends on the decryption software you are using. However I have taken the liberty of attaching a screenshot of where you have to add the script.

    systemExecute.PNG

Please sign in to leave a comment.