<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.5726" name=GENERATOR>
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2>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? :-)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2>John</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=576155303-12042009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
filepro-list-bounces+john=valar.com@lists.celestial.com
[mailto:filepro-list-bounces+john=valar.com@lists.celestial.com] <B>On Behalf
Of </B>Scott Walker<BR><B>Sent:</B> Saturday, April 11, 2009 9:58
PM<BR><B>To:</B> 'filePro Mailing List'<BR><B>Subject:</B> XML
Import<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal>I have a new project I am starting on and would like some
advice & perhaps some code.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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!).<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Sounds sort of like EDI with no agreed upon
standards.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Regards,<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Scott<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Scott Walker<o:p></o:p></P>
<P class=MsoNormal>RAM Systems Corp<o:p></o:p></P>
<P class=MsoNormal>(704) 896-6549<o:p></o:p></P>
<P class=MsoNormal>ScottWalker@RAMSystemCorp.com<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BLOCKQUOTE></BODY></HTML>