change outgoing file name is vrl translation

[Gene Millard]

I have a csv file as input. I would like to use the employee id, first name and last name fields to set the outgoing filename.   lastname_firstname_employeeid.csv.

How would I do this in the translation?

Gene Millard

The Guthrie Clinic
Sayre, PA

Topic

[Jim Kosloskey]

You could try to change the DRIVERCTL metadata key FILESET.FILEID to the value you want using xpm functions inside Tcl.

If in the Xlate you cannot change the DRIVERCTL metadata, then place the value in the USERDATA Meta Data Field (use a keyed list) then in the OB Tps use the USERDATA infor to set DRIVERCTL (I know that will work).

If you would like to chat offline about this, feel free to email me.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Jim Kosloskey]

Upon further reflection, I don’t think you can directly address the DriverCTL FILEST.OBFILE key from the Xlate but even if you could it would get reset at the Protocol.

So you could place the data in the USERDATA metadata field (using a keyed list of course) with Tcl in the Xlate. Then in the OB Thread OB Tps another Tcl proc could extract the data from the USERDATA key and set the DRIVERCTL Metadata FILESET.OBFILE key.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Charlie Bursell]

After Xlate are the fields still available in the output data?  If so, simply pull them in an OB Data proc and set the DRIVERCTL Metadata FILESET.OBFILE key there.

[Author]

Replies