Solved

XML Question / Problems

Posted on 2013-01-15
2
140 Views
Last Modified: 2013-01-19
I am receiving XML files from a vendor which I need to import into SQL.  I am using a tool called the Pervasive Data Integrator because it has a plugin for my application.

However, the XML files are not formated like I would expect and it appears to be causing problems.

The xml files has

<?xml version...
<account timestamp="2013..." accountid="1234"><contact><email>test@test.com>  etc

all the data is one line and I am having trouble parsing it.  Is there another way to accomplish this?  I noticed if I formated this properly, then extracting the data is easy.

Is there an application which will format?  

Any ideas are appreciated.
0
Comment
Question by:red_75116
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38782183
>all the data is one line
which is not a problem for XML as such

>and I am having trouble parsing it.
which problems?
with Pervasive itself?

>Is there an application which will format?  
you can surely reformat the XML with regular expressions ...
can you show exactly what you have, and what you want it to be instead?
0
 

Author Closing Comment

by:red_75116
ID: 38797610
I downloaded a trial of a program which created an XML schema for the file and with that I was able to get it working.  The extract schema designer in Pervasive was having issues separating the columns, but one I got the schema I was able to get it to work.

Thank you for your time!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to read XML file attributes... 17 59
Insert Powershell variable into XML 4 45
XML XSLT If loop 4 25
XML response optional elements 12 37
The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

774 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