Sort/Selection processing
Harold
haroldef at sbcglobal.net
Wed Jun 16 11:45:39 PDT 2010
On 6/16/2010 1:21 PM, Richard Kreiss wrote:
> Harold,
>
> I have a number of programs that generate csv files and when the process
> completes, the file is opened in Excel
>
> These are run from a menu command file.
>
> @title Export Itemdata information to A CSV file
> @\fp56\fp\rreport itemdata -f post_to_excel -y jnk -u -ia
> @start excel c:\temp\item.csv
>
> Are you using the correct command to open the csv file with Excel?
>
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>
>
Hi Richard,
Thanks for replying. I will look at what you sent, but right now I have to meet some
people.
Actually, Excel does run, but it cannot find the file in c:\maclbs\. The file's name
is mac061510.csv, for today. Each file has the date that it is created.
Harold
>
>
>
>
>
>> -----Original Message-----
>> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-
>> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Harold
>> Sent: Wednesday, June 16, 2010 12:01 PM
>> To: john at valar.com
>> Cc: filepro-list at lists.celestial.com
>> Subject: Re: Sort/Selection processing
>>
>> On 6/15/2010 3:51 PM, John Esak wrote:
>>>
>>> Yes, I realized right away that @ts wouldn't have a meaning other than
> Total
>>> Records Processed, not Total Records Selected. I think it *would* be
> useful
>>> in this context. Not *real* useful... But somewhat, maybe...
> Sometimes...
>>> Perhaps. Oh, okay, it's pretty much not to useful a thing to know, other
>>> than to just know it? Since it has no relation to how many you actually
>>> select, you couldn't use it for much of anything.
>>>
>>> John
>>>
>>
>> Hi John,
>>
>> I am still working on my problem--I can create the CSV file, but haven't
> been able to
>> open the CSV file while in filepro, using Excel, after the CSV file has
> been created.
>>
>> I use @ts to see how many records have been selected, and as each record
> has
>> been
>> sent to the CSV file I increment a variable field rn. When rn is equal to
> @ts I try
>> to open CSV.
>>
>> To prove that @ts is the number of records selected I have created the JPG
> file
>> attached. Note at the bottom left where it shows @ts, which contains the
> number of
>> records selected, which is that same number as that above.
>>
>> Take Care,
>>
>> Harold
>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>>>> Sent: Tuesday, June 15, 2010 3:49 PM
>>>> To: john at valar.com
>>>> Cc: filepro-list at lists.celestial.com
>>>> Subject: Re: Sort/Selection processing
>>>>
>>>> On 6/15/2010 2:12 PM, John Esak wrote:
>>>> [...]
>>>>> I will assume that @ts has no value either on the -v table.
>>>> Although, who
>>>>> knows (besides Ken :-) maybe it does. In which case, you
>>>> could set an
>>>>> incrmenting counter for every record encoutnerd selected or
>>>> not and when @ts
>>>>> equalled this counter, you'd be done with the -v processing.
>>>> [...]
>>>>
>>>> I'd have to check is @TS has any value during sort/select
>>>> processing. But,
>>>> even if it did, what would it mean?
>>>>
>>>> Consider this:
>>>>
>>>> I hand you my Rolodex, and ask you to pull out all the
>>>> clients from New
>>>> York. Part-way through, I ask you "how many New York clients
>>>> are in my
>>>> Rolodex, and have you gotten all of them yet?"
>>>>
>>>> --
>>>> Kenneth Brody
>>>>
>>>
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>>
>>
>>
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: RecordsSelected.jpg
>> Type: image/jpeg
>> Size: 49919 bytes
>> Desc: not available
>> Url : http://mailman.celestial.com/pipermail/filepro-
>> list/attachments/20100616/874517dd/attachment.jpg
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
More information about the Filepro-list
mailing list