Solved

Talend importing XML data

Posted on 2014-02-26
6
405 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 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
jboss 7.1 start up error 1 63
ejb entity bean example 2 37
how to access a remote mysql database with xampp 3 42
glassfish admin console 1 22
In this post we will learn different types of Android Layout and some basics of an Android App.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

733 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