• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

XML Question / Problems

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
red_75116
Asked:
red_75116
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
red_75116Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now