Copy text in processing to Word or Excel

[Richard Hane]

Sorry I should have replied earlier but was at the company holiday party late yesterday. :-}

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.

We are upgrading our ERP software which has not been done in over 8 years.  Obviously some of the tables and fields have changed.

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.

Hope that is clearer.
Thanks again
Rick Hane
 


On Monday, December 8, 2014 6:26 PM, Bruce Easton <bruce at stn.com> wrote:
  


On 12/8/14, 6:44 PM, Bruce Easton wrote:
> On 12/8/14, 5:49 PM, Jay Ashworth wrote:
>> ----- Original Message -----
>>> From: "Brian K. White" <brian at aljex.com>
>>> On 12/8/2014 3:19 PM, Richard Hane wrote:
>>>> Does anyone have some suggestions for my problem?
>>>>
>>>> We are updating our MRP software to the new ERP version. I have
>>>> about 8 processes that import data from the MRP (in SQL Server) to
>>>> filePro via an ODBC link.
>>>>
>>>> I need to list in Excel the existing Table name and Field name. This
>>>> information is located in my definition in each of the processing
>>>> table.
>>>>
>>>> I tried the mark, copy and paste but that doesn't seem to work well
>>>> for me. Anyone have a better solution?
>>>  From reading this, I have no idea what the problem or question is.
>> I can't be sure, but I think he's trying to import his maps into Excel
>> sheets.
>>
>> In that case, copy the map, delete the first line, transform colons 
>> to tabs,
>> and then import as TSV.
>>
>> Cheers,
>> -- jra
> If that's the goal and it's a large map, and they don't keep a large 
> generic import/export assignment table handy, then it might be quicker 
> to make use of the fieldname function within a loop.
>
> Bruce
>
> Oh gosh - sorry - I misread part of that.  Yes, let Excel do the work 
> importing the transformed map file.  Should be easy peasy as they say.

>


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20141209/50e79297/attachment.html>