Solved

XML Question / Problems

Posted on 2013-01-15
2
139 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Header in SQL XML PATH 4 54
VB.NET and XML parsing 6 67
Load XML file into a SQL Server Table using SSIS 2012 9 57
XML to SQL Table using c# 5 57
The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
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.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

864 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now