Re: XML to PF -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: XML to PF
From: "rick baird" <rick.baird@xxxxxxxxx>
Date: Tue, 16 Sep 2008 18:23:26 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Thanks Dan,

If you want to be real simple and don't have to import often you can
import the XML into Microsoft Excel and then export it as a CSV, then
CPYFRMIMPF into the PF or use the Excel database connection to import to
your table. OpenOffice also has nice tools for this.

I knew that, but was hoping to automate.

You could also do a simple XSLT to transform the XML into CSV provided
you have java or some other such animal with JAXP support.

this sounds promising, but might be as much trouble as Scott's stuff.

I downloaded his save files for http and xml apis, I might just sneak
it into production...

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.