Solved

Talend importing XML data

Posted on 2014-02-26
6
411 Views
Last Modified: 2014-03-10
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
0
Comment
Question by:samjud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 13

Expert Comment

by:Jeff Darling
ID: 39890636
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

0
 

Author Comment

by:samjud
ID: 39890881
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.
0
 
LVL 13

Expert Comment

by:Jeff Darling
ID: 39894814
Can you post the xsd file?  That may reveal more info.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 13

Expert Comment

by:Jeff Darling
ID: 39896032
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.
0
 

Accepted Solution

by:
samjud earned 0 total points
ID: 39907371
The answer is that there is a limit loop box with a default of 50 i raised that value and now it works
0
 

Author Closing Comment

by:samjud
ID: 39917012
fixed
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question