<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div><span>Sorry I should have replied earlier but was at the company holiday party late yesterday. :-}</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>You are reading too much in what I am trying to do. I have a filepro file called ctrl. It is my control file for all my odbc processing which I run everyday. There are over 14 processes listed in this file.</span></div><div style="color: rgb(0, 0, 0);
font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>We are upgrading our ERP software which has not been done in over 8 years. Obviously some of the tables and fields have changed.</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>All I am trying to do is
save a lot of typing time. I have to call each process up, find the table name and the field names which are read in the ERP software. Once I have this list of tables and fields from all the processes, I will compare them to the new version of the ERP software to see what has changes and where are need to change the processing in filepro.</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>Hope that is clearer.</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style:
normal; background-color: transparent;"><span>Thanks again</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>Rick Hane</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font face="Arial" size="2"> On Monday, December 8, 2014 6:26 PM, Bruce Easton <bruce@stn.com> wrote:<br>
</font> </div> <br><br> <div class="y_msg_container">On 12/8/14, 6:44 PM, Bruce Easton wrote:<br clear="none">> On 12/8/14, 5:49 PM, Jay Ashworth wrote:<br clear="none">>> ----- Original Message -----<br clear="none">>>> From: "Brian K. White" <<a href="mailto:brian@aljex.com" shape="rect" ymailto="mailto:brian@aljex.com">brian@aljex.com</a>><br clear="none">>>> On 12/8/2014 3:19 PM, Richard Hane wrote:<br clear="none">>>>> Does anyone have some suggestions for my problem?<br clear="none">>>>><br clear="none">>>>> We are updating our MRP software to the new ERP version. I have<br clear="none">>>>> about 8 processes that import data from the MRP (in SQL Server) to<br clear="none">>>>> filePro via an ODBC link.<br clear="none">>>>><br clear="none">>>>> I need to list in Excel the existing Table name and Field name. This<br
clear="none">>>>> information is located in my definition in each of the processing<br clear="none">>>>> table.<br clear="none">>>>><br clear="none">>>>> I tried the mark, copy and paste but that doesn't seem to work well<br clear="none">>>>> for me. Anyone have a better solution?<br clear="none">>>> From reading this, I have no idea what the problem or question is.<br clear="none">>> I can't be sure, but I think he's trying to import his maps into Excel<br clear="none">>> sheets.<br clear="none">>><br clear="none">>> In that case, copy the map, delete the first line, transform colons <br clear="none">>> to tabs,<br clear="none">>> and then import as TSV.<br clear="none">>><br clear="none">>> Cheers,<br clear="none">>> -- jra<br clear="none">> If that's the goal and it's a large map, and they don't keep a large <br
clear="none">> generic import/export assignment table handy, then it might be quicker <br clear="none">> to make use of the fieldname function within a loop.<br clear="none">><br clear="none">> Bruce<br clear="none">><br clear="none">> Oh gosh - sorry - I misread part of that. Yes, let Excel do the work <br clear="none">> importing the transformed map file. Should be easy peasy as they say.<div class="yqt6874239144" id="yqtfd26387"><br clear="none">><br clear="none"><br clear="none"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a href="mailto:Filepro-list@lists.celestial.com" shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank"
shape="rect">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div><br><br></div> </div> </div> </div> </div></body></html>