<html 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" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>John,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Scott<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
filepro-list-bounces+scottwalker=ramsystemscorp.com@lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com@lists.celestial.com]
<b>On Behalf Of </b>John Esak<br>
<b>Sent:</b> Sunday, April 12, 2009 12:03 AM<br>
<b>To:</b> 'filePro Mailing List'<br>
<b>Subject:</b> RE: XML Import<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>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. </span><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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? :-)</span><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>John</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>
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</span><span style='font-size:12.0pt;font-family:
"Times New Roman","serif"'><o:p></o:p></span></p>
<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>
</blockquote>
</div>
</body>
</html>