Problem in Sender File Adapter using FCC with Variable structure

[Former Member]

Hi Experts,

Hi Experts,

I have facing an issues while using FCC in Sender File adapter. Below are the configs for the same:-

Recordset structure required is ==HEADER,1,DATA,*,TRAILER,1

Recordset per message == *

Key Field Name == Key

(Sorry i dont know how to insert screen shot here..pls tell me how can i insert screen shots here on sdn)

HEADER.fieldSeparator ,

HEADER.endSeparator u2018nlu2019

HEADER.fieldNames Key,x,y,zu2026

HEADER.keyFieldValue 1

HEADER.keyFieldInStructure ignore

HEADER.fieldContentFormatting trim

HEADER.additionalLastFields ignore

HEADER.missingLastFields ignore

DATA.fieldSeparator

DATA.endSeparator

DATA.fieldNames

DATA.keyFieldValue

DATA.keyFieldInStructure

DATA.fieldContentFormatting

DATA.additionalLastFields

DATA.missingLastFields

Using same variables for Trailer record as well.

Source CSV file which i am picking:-

ADSE ,RASD,replan Contact ,2 0080509 0 8:43:25 ,

EMPL ,0011111, S Top Up ,20080401 ,20080430 ,sdf , 00000000431250 ,2007 , , , , , ,20080414 18:07:35,

EMPL ,0222222, r Cash Award ,20070701 ,20070703 ,ded , 00000000023509 ,2007 , , , , , ,20080414 18:09:31,

EMPL ,0233333, Cash Award ,20070801 ,20070831 ,df , 00000000044057 ,2007 , , , , , ,20080414 18:10:56,

EMPL ,0244444, Cash Award ,20080101 ,20080111 ,sf , 00000000026717 ,2007 , , , , , ,20080414 18:08:29,

.

.

.

.

.

BTRL , 5140,

When i tested the scenario and monitored it using MDT in CC monitoring tool its giving me below mentioned error.

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

-

---

XML document must have a top level element. Error processing resource 'http://myurlname/mdt/me...

However if i change the occurence of DATA as some specific value for eg 4 instead of * it works fine.

Kindly help me in solving this problem.

Thanks,

Aditya Verma

[madanmohan_agrawal · Accepted solution]

Hi Aditya,

Aditya Says..
HEADER.keyFieldValue 1
.....
DATA.keyFieldValue

Please set the key Field Value for DATA and TRAILER

and then test again.

Regards,

Madan Agrawal

[Former Member · Accepted solution]

Hi Madan,

I am already using the values as :

HEADER.keyFieldValue ==1

DATA.keyFieldValue ==2

TRAILER.keyFieldValue ==3

still no luck.. have u faced this kind of issue ever as i m finding this bit strange.

Is this what u wanted me to do?

Regards,

Aditya

[madanmohan_agrawal · Accepted solution]

Aditya says..
HEADER.keyFieldValue ==1
DATA.keyFieldValue ==2
TRAILER.keyFieldValue ==3

Hi Aditya,

Is the value 1, 2, 3 are coming in your input file?? and does your Key Field KEY really exist in sample file?? Please check those.

Looking to your sample file, I think the key field value should be like below.

HEADER.keyFieldValue = ADSE

DATA.keyFieldValue = EMPL

TRAILER.keyFieldValue = BTRL

Regards,

Madan Agrawal

[Former Member · Accepted solution]

Hi Madan,

Thanks a lot for giving me the way to this. But when i tested this with the below file its giving me the same error. Please let me know if i need to do any changes to the parameters mentioned above:-

ADSE ,ASDA,Sha replan Fr ont Feed Contact ,2 0080509 0 8:43:25 ,

EMPL ,0011111, Cash Top Up ,20080401 ,20080430 ,TPV , 00000000431250 ,2007 , , , , , ,20080414 18:07:35,

EMPL ,0222222, r Cash Award ,20070701 ,20070703 ,TPV , 00000000023509 ,2007 , , , , , ,20080414 18:09:31,

EMPL ,0233333, r Cash Award ,20070801 ,20070831 ,TPV , 00000000044057 ,2007 , , , , , ,20080414 18:10:56,

EMPL ,0244444, Cash Award ,20080101 ,20080111 ,TPV , 00000000026717 ,2007 , , , , , ,20080414 18:08:29,

EMPL ,0255555, Cash Award ,20080301 ,20080320 ,TPV , 00000000027870 ,2007 , , , , , ,20080414 18:08:25,

EMPL ,0266666, Cash Award ,20071001 ,20071020 ,TPV , 00000000020681 ,2007 , , , , , ,20080414 18:09:31,

EMPL ,0877777, Cash Top Up ,20080401 ,20080430 ,TPV , 00000000036000 ,2007 , , , , , ,20080414 18:07:05,

EMPL ,0888888, Leaver Cash Award ,20071201 ,20071231 ,TPV , 00000000157200 ,2007 , , , , , ,20080414 18:11:29,

EMPL ,0899999, S Leaver Cash Award ,20080301 ,20080331 ,TPV , 00000000153530 ,2007 , , , , , ,20080414 18:07:42,

EMPL ,0800000, S Leaver Cash Award ,20070701 ,20070731 ,TPV , 00000000012234 ,2007 , , , , , ,20080414 18:08:34,

BTRL , 5140,

This the original csv file which i'll get in live. Kindly suggest as ur solution worked with other file but not working with this scv file.

Thanks a lot,

Aditya.

[madanmohan_agrawal · Accepted solution]

Aditya Says..
Please let me know if i need to do any changes to the parameters mentioned 

Do not set "Key Field Name == Key" instead set the key field for all three sub structures as follows.

HEADER.keyFieldName = <First Field name of your structure of HEADER>

HEADER.keyFieldValue = ADSE

DATA.keyFieldName = <First Field name of your structure of DATA>

DATA.keyFieldValue = EMPL

TRAILER.keyFieldName = <First Field name of your structure of TRAILER>

TRAILER.keyFieldValue = BTRL

Regards,

Madan Agrawal

[Former Member · Accepted solution]

Use Following key field Value(given in quotes) in Configuration and test it.

HEADER.keyFieldValue = 'ADSE '

DATA.keyFieldValue = 'EMPL'

TRAILER.keyFieldValue = 'BTRL'

[madanmohan_agrawal · Accepted solution]

Aditya Says..
This the original csv file which i'll get in live

I would like to add one more point..

Use a XML validator to validate your input file and then test (with the configuration I have told earlier).

Regards,

Madan Agrawal

[Former Member · Accepted solution]

Hi Madan,

Thanks alot for all ur inputs but could u please tell me if there is any way by which we validate .csv or .txt files before testing as mentioned by u.

Regards,

Aditya.

[madanmohan_agrawal · Accepted solution]

Well Aditya,

Does the configuration (Suggested by me) works?

 any way by which we validate .csv or .txt files 

Go to XSMB_MONI and take the payload (xml file) of your input csv / text file and then validate if it is fine in a XML tool like XMLSPY.

Regards,

Madan Agrawal

[Former Member · Accepted solution]

Hi Madan,

Thats the main problem i am facing. When i tried running my file adapter its not picking up the csv file. In Moni its gives this error:

Parsing an empty source. Root element expected

While in MDT in CC monitoring it gives the below error:-

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

-

---

XML document must have a top level element. Error processing resource 'http://sapapdrp-sv.test.lloydstsb.co.uk:51200/mdt/me...

I feel like that the FCC is not able to read the csv due to some syntax issue. Kindly look the source csv file again and do let me know what could the reason for the above errors.

There may be some standard parameter which we can define in FCC and that could remove this problem. I have already mentioned all the parameters i am using above.

I have already awarded u points but if we can get this also i can close the thread awarding u all the points.

Regards,

Aditya.

[Former Member · Accepted solution]

Hi Aditya,

Please could you check your input file for any special characters in the beginning of the file that is being picked up.

Thanks and Regards,

Induja

[Former Member · Accepted solution]

Hi all,

Thanks a lot for your help.I have identified the problem and got the solution as well.

Special Thanks to MADAN

Cheers,

Aditya.

[madanmohan_agrawal]

Hi Again,

Looking to your sample file, I think the key field value should be like below.

HEADER.keyFieldValue = ADSE

DATA.keyFieldValue = EMPL

TRAILER.keyFieldValue = BTRL

Regards,

Madan Agrawal