Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Talend importing XML data

Posted on 2014-02-26
6
Medium Priority
?
423 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses

636 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