How toation Read XML file as single string

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

jagan
Posts: 12
Joined: Tue Aug 19, 2014 2:33 pm

How toation Read XML file as single string

Postby jagan » Fri Apr 03, 2015 4:19 pm

Hi Team,

I want to read attached XML file from one location and write same xml file into another location.

For that i am using Universal Data reader-> Meta data -> Universal Data writer

But universal data writer is giving below error, does any one help on this.

Component [UniversalDataReader:UNIVERSAL_DATA_READER] finished with status ERROR. (Out0: 488 recs)
Parsing error: Unexpected end of file in record 489, field 1 ("XMLString"), metadata "recordName1"; value: 'SimpleDataParser does not provide raw record.'

Thanks in Advance.

Thanks,
Jagan.
Attachments
PayrollFileMove.grf
(1.41 KiB) Downloaded 156 times
Bi_Daily_Changes20150327031442 - Copy.xml
(1.93 KiB) Downloaded 214 times

imriskal
Posts: 398
Joined: Wed Aug 15, 2012 8:18 am

Re: How toation Read XML file as single string

Postby imriskal » Thu Apr 09, 2015 11:07 am

Hi Jagan,

You should read the whole file in one big field instead of trying to read it line by line. Just delete delimiters in your metadata, set the field to byte type and set "EOF as delimiter" to true. PFA your modified graph.

PayrollFileMove_modified.grf
(1.46 KiB) Downloaded 291 times
---
Lubos Imriska
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron