Sort/Selection processing

[Richard Kreiss]

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
  






> -----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