Question Re: UDF for Timestamp in Technology Q&A

UDF for Timestamp

Former Member — Tue, 29 Mar 2011 13:54:35 GMT

Hi Friends,

Can anyone please provide me the UDF for the following case.I need my output file name in following format

156WE_YYYYmmddHHMMSS.xml

Thanks for quick help..

Regards,

Dinesh

Re: UDF for Timestamp

DG — Tue, 29 Mar 2011 13:57:18 GMT

It is farily simple using the following imports

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.Date;

 
		    Date now = new Date();  
		    DateFormat df = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SS:SZ");  
		    String date = df.format(now);

You can change the date parameters, search for simpledateformat.

Re: UDF for Timestamp

aashish_sinha — Tue, 29 Mar 2011 14:00:30 GMT

Hi,

In the target file adapter, you can choose target file name as 156WE_.xml, then in next tab choose ADD time stamp. It will create a output filename as 156WE_YYYYmmddHHMMSS.xml, if values till underscore is fixed.

Else you can use below code.

/* Using Dynamic Configuration */

DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

//conf.removeAll();

DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");

//String filename= conf.get(key);

conf.put(key, fileName);

key= null;

return fileName;

Refer link --- http://wiki.sdn.sap.com/wiki/display/Snippets/SAPXIDynamic+Configuration

Regards

Aashish Sinha

Re: UDF for Timestamp

Former Member — Tue, 29 Mar 2011 14:07:09 GMT

My receiver is SFTP..so i think i can try with Danielle post..

Thanks

Dinesh

Re: UDF for Timestamp

aashish_sinha — Tue, 29 Mar 2011 14:14:41 GMT

you can try with my way also..

Regards

Aashish Sinha

Re: UDF for Timestamp

baskar_gopalakrishnan2 — Tue, 29 Mar 2011 14:19:28 GMT

Try this code snippet ...

Date date = new Date(); // get the current date
DateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); // set the format
String concat ="156WE_" + df.format(date);
DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);
DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");
conf.put(key,concat);

Re: UDF for Timestamp

Former Member — Wed, 30 Mar 2011 04:20:03 GMT

Thnx for everyone help