Solved

XML Question / Problems

Posted on 2013-01-15
2
145 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
[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
2 Comments
 
LVL 143

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

Setting up LaraDock for Laravel

Learn how to set up LaraDock in a Laravel project - LaraDock gives us an easy way to run a Laravel application using Docker in a single command.

Question has a verified solution.

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

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…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

617 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