Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

XML Question / Problems

Posted on 2013-01-15
2
Medium Priority
?
150 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 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline

963 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