XML Import

[Scott Walker]

John,

 

Thanks for the input.  I need to get on something with this.  I was hoping
someone had developed a generic "black box" where you could plug in the xml
schema info and your fp file map info and have it do a lot of the heavy
lifting.  With the fact that every xml file from a different source will
have a different schema the only constant is my applications layout.
Perhaps each xml source will have to be programmed by hand.  I will have to
do some real thinking on this.  There has to be a better way than that.

 

Regards,

 

Scott

 

 

From:
filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.
com] On Behalf Of John Esak
Sent: Sunday, April 12, 2009 12:03 AM
To: 'filePro Mailing List'
Subject: RE: XML Import

 

At the FP Developer meeting held in Wilmington recently among FP friends and
colleagues at the house of Larry Hoover... we were told that the XML filePro
function was half done... the export part I believe is done, and the import
is nearly done.  (Or the other way around.... sorry... someone else who
attended the meeting will remember).  I believe the part that is done could
probably be obtained from FP Tech within the next couple months or so....
with the remaining half coming a little later.  We also learned that a mySQL
interface of some sort (high level/low level kind of thing like ODBC) was
also in the works.  It has a slightly longer ETA I think because it is being
outsourced I think.  

 

Other than waiting, Nancy has developed some XML apps.  I have, too, but
they are in no shape to send anyone being  a one time knock off each time I
do it.  The XML function has been in the works for awhile, so I haven't
wanted to consolidate my needs into some universal functions.  I just do
what I need to as it comes and am waiting like everyone else for the filePro
upgrades. Why pre-write the wheel?  :-)

 

John

 

 

 


  _____  


From: filepro-list-bounces+john=valar.com at lists.celestial.com
[mailto:filepro-list-bounces+john=valar.com at lists.celestial.com] On Behalf
Of Scott Walker
Sent: Saturday, April 11, 2009 9:58 PM
To: 'filePro Mailing List'
Subject: XML Import

I have a new project I am starting on and would like some advice & perhaps
some code.

 

My customer has about (20) factories that they represent.  Each factory has
their own program used to produce  a quote for stuff sold by that factory.
So when my customer needs to produce a quote to one of their customers for
something they sell for factory A, they use factory A's program to produce
the quote.  Then they reenter the data from that quote into my software.
Likewise, if they need to produce a quote to one of their customers for
something they sell for factory B, they use factory B's program to produce
the quote and then reenter data from that quote into my software.  In this
way, my customer can track all the quotes to their cusotomers in one
centralized database.  Many of these programs can (or will in the future) be
able to output an XML file.  The layout of the XML files from each different
factory will be different (and not controlled by us!).

 

Sounds sort of like EDI with no agreed upon standards.

 

So I need some some sort of method of mapping the data from these different
sources, which will be in XML files with different structures, into my quote
program (with it's structure)  for easy importing.   The factories may
change and their XML files may change over time so I really want to avoid
hard coding stuff and instead have some flexible black box type software in
the middle, hopefully in filePro.

 

If anyone has done anything like this and can share some guidance, I would
appreciate it.  If you have an application or code that can be incorporated
into my code that would make this process easier, I would be willing to pay
for it.

 

Regards,

 

Scott

 

Scott Walker

RAM Systems Corp

(704) 896-6549

ScottWalker at RAMSystemCorp.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090413/ec2fe912/attachment.html