how do i add time and date to target file

[Former Member]

hello,

1. When do we generally go for FCC?

2. Is it possible to assign field seperator without FCC on the reciever side file adapter?

3. how do I add timestamp as well as DATE to the target file?

thnks

venkat

[Former Member]

Hi venkat

1. When do we generally go for FCC?

we can do the FCC at sender side as well as at the receiver side.

Sender side: we do the FCC at the sender side only if we are getting a flat file from the sender, and so that it can be understand by the XI,because XI can understand only the XML.

Receiver side:we do the FCC at the receiver side only if the receiver requires the flat file.

2. Is it possible to assign field seperator without FCC on the reciever side file adapter?

no, it is not possible.

3. how do I add timestamp as well as DATE to the target file?

if you want to add date and time in the target file for this you have to select the parameter

File Construction Mode* : AddTimeStamp

in the processing parameters of the file adapter(Receiver).

Thanks

Rinku

[Former Member]

Hi,

1. When do we generally go for FCC?

a.When your flat file is coming with some delimitors...you need to convert it into XI understandable XML format.

b.When at receiver side you want to create flat file with specific spaces,commas.....XI-XML is converted into it using FCC.

2. Is it possible to assign field seperator without FCC on the reciever side file adapter?

a.FCC is not possible because anyways you are going to get XML if..without FCC.It will not generate any flat file.

3. how do I add timestamp as well as DATE to the target file?

a. there is an option Add Timestamp to the file. use it for doing this.

Regards,

AKshay.

• Reward points if find useful.

[Former Member]

1. Can you elaborate more related to FCC on reciever side?

2. the requirement is to create a file on the receiver end

3. I can add timestamp.. I need to add Date as well as Timestamp

regards,

venkat

[Former Member]

Hi,

1. Can you elaborate more related to FCC on reciever side?

>>

2. the requirement is to create a file on the receiver end

>> you have to use FCC and delimiters for recevier.

3. I can add timestamp.. I need to add Date as well as Timestamp

>>> you can go for variable substitution to add date in filename.....

Regards,

Akshay.

[Former Member]

Akshay, this is my reciever side strcture

I hav to create a text file with pipe delimitter so that even if no value comes from sender side, pipe symbols with spaces must be displayed

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_CUST_PY_MN xmlns:ns0="http://">

<root>

<Account_Num>1</Account_Num>

<Addr_Display>adsfsaddf</Addr_Display>

<Address1>venkat</Address1>

<Address2>a</Address2>

<City>blore</City>

<State>asia</State>

<Zip>34567</Zip>

<Country>blore</Country>

<ADDR_Code>errefd</ADDR_Code>

<Status>kjdsd</Status>

<Primary>2</Primary>

</root>

[Former Member]

receive CC

Recordset structure = root (do not specify occurrence)

root.fieldSeparator = '|'

rot.fieldContentFormatting = nothing (for pertaining blank spaces)

[Former Member]

Hello Mughda,

thanks for ur reply

But occurances must be unbound for this root tag as it can have multiple occurances

Q: What are the required attributes i need to specify for FCC?

does specifying both fieldcontect formating and field seperator will do?

thanks

venkat

[Former Member]

Hi,

Add root,Account_Num,Addr_Display,Address1,Address2,City,State,Zip,Country,ADDR_Code,Status,Primary in recordset.....

in parameters use record.feildseparator | .

If you know field fixed lengths add them.

Regards,

Akshay

• reward points if find useful.

[Former Member]

venkat

in receiver adapter no need to mention occurrences

as well mentioning fieldNames is not required..

<i>does specifying both fieldcontect formating and field seperator will do?</i>

-->

fieldSeparator is required to identify ur fields seperatly..

well fieldContentFormatting - i have not used it.. but it is supposed to use when u want to retain white spaces.. give a try for it

[Former Member]

would those 2 FCC parameters do?

can I activate jus with those 2 parameters of FCC?

[Former Member]

Hi,

See this,

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards,

Akshay.

[Former Member]

look at this thread

Thanks !