I have Witango 5.5 running on Panther Server 10.3.8. We are looking at an
accounting package that will export and read in orders and customer
information that is in an XML format. I have a copy of their order format,
with the xml tages around that data.

Here is an example of the first few lines of their exported file.

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE av_import SYSTEM "av_import_dtd.xml">
<av_import version="1.0" data-source="DSC">
    <client id="15" client-name="Pedels Galore">
        <field name="client name">Pedels Galore</field>
        <field name="first name"></field>
        <field name="address1">7899 West Main Street</field>
        <field name="address2">P.O. Box 1232</field>
        <field name="address3"></field>
        <field name="city">Los Angeles</field>
        <field name="state">CA</field>
        <field name="zip">91207</field>
        <field name="country">USA</field>

Etc....

Is there an easy way to export data using Witango in this format? I mean I
can put all the information in variables and embed the variable between the
tags and export that. Is it that simple?

Then going the other way...
In reading in the data that the accounting system exports, is there some
kind of library or something that runs on OSX that makes is easy to parse
this stuff out of the Accounting package file Through Tango into our DB? I
guess I am just a rookie when it comes to parsing logic. How do you isolate
the data between the field tags? I just have to believe someone smarter than
me has the logic figured out.

Thanks for any input or articles to read.

Thanks

Mark Weiss


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to