Solved

Talend importing XML data

Posted on 2014-02-26
6
399 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
  • 3
  • 3
6 Comments
 
LVL 12

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 12

Expert Comment

by:Jeff Darling
ID: 39894814
Can you post the xsd file?  That may reveal more info.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 12

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 SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
map related example 6 48
How many transactions can mysql handle? 3 31
java stored proc example 9 29
hibernate insert example 13 28
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

770 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