<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)">
<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;}
/* 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-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@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>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>
</body>
</html>