Talend importing XML data

samjud
samjud used Ask the Experts™
on
I am importing an xml file it never goes past the first 50 rows any ideas?

attached is the file i am trying to import
000113-thunderball-product-datao.xml
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeff DarlingDeveloper Analyst

Commented:
It may be just a coincidence, but <Row> 50 appears to be the first <Row> that does not have a <Long_Description>  Maybe the absence of <Long_Description> is the problem?

Did you validate against the schema?
Can you post the Schema?  It may reveal more info.

      
<Row>
		<Item_SKU>MB906D</Item_SKU>
		<Promo_Title>DEI REMOTE START FOR MB</Promo_Title>
		<QTY_on_hand>0</QTY_on_hand>
		<COST>600</COST>
		<UPC />
		<Weight>5</Weight>
		<Brand>DIRECTED ELECTRONICS</Brand>
		<MSRP>0</MSRP>
		<UAP>0</UAP>
		<TOPCATEGORY>NEW PRODUCTS</TOPCATEGORY>
		<Boxed_Length>002</Boxed_Length>
		<Boxed_Height>002</Boxed_Height>
		<Boxed_Width>002</Boxed_Width>
		<CCREATEDATE>2014-01-11T13:00:03.357</CCREATEDATE>
		<MFG_PROD_ID>MB906D</MFG_PROD_ID>
		<Image_x0020_URL>/images/XYZ123/MB906D.jpg</Image_x0020_URL>
		<CATEGORY>NEW PRODUCTS</CATEGORY>
	</Row>

Open in new window

Author

Commented:
no i took out the row 50 <Long_Description>  to test that is not the issue i broke up this file in many different ways it simply does not import more than 50 rows.
Jeff DarlingDeveloper Analyst

Commented:
Can you post the xsd file?  That may reveal more info.
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Jeff DarlingDeveloper Analyst

Commented:
I see that this is also posted on the Talend Community forum.

http://www.talendforge.org/forum/viewtopic.php?pid=128524

As an open issue.  It will be interesting to see what the solution is.
Commented:
The answer is that there is a limit loop box with a default of 50 i raised that value and now it works

Author

Commented:
fixed

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial