export --.csv file question

[Jeff Harrison]

> From: Ted B Dodd <tedbdodd at cableone.net>
> To: 'Richard Kreiss' <rkreiss at verizon.net>; 'Frank Gemeinhardt' <frank7767 at aol.com>; filepro-list at celestial.com
> Cc: 
> Sent: Sunday, August 19, 2012 10:26 AM
> Subject: RE: export --.csv file question
> 
> Jhexport or something like that, was it not?
> 
> Ted B
> aka ted-b-dodd- at -gmail.com
> (remove the - signs) 
> 
>>  -----Original Message-----
>>  From: 
>>  filepro-list-bounces+tedbdodd=bigfoot.com at lists.celestial.com 
>>  [mailto:filepro-list-bounces+tedbdodd=bigfoot.com at lists.celest
>>  ial.com] On Behalf Of Richard Kreiss
>>  Sent: Saturday, August 18, 2012 16:41
>>  To: 'Frank Gemeinhardt'; filepro-list at celestial.com
>>  Subject: RE: export --.csv file question
>> 
>> 
>> 
>>  > -----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 Frank Gemeinhardt
>>  > Sent: Friday, August 17, 2012 5:47 PM
>>  > To: filepro-list at celestial.com
>>  > Subject: export --.csv file question
>>  > 
>>  > How do I or can I export a filepro <export>   .csv file to a 
> excell
>>  template
>>  > which I set up in advance with proper column sizes and possible 
>>  > headers
>>  and
>>  > Logos....O/S SCO
>>  > 
>>  > 
>>  > Thank You
>> 
>>  I forget now who has a program that allows you export and 
>>  configure a filepro CSV file but there is a program out there 
>>  for that.  I am not sure of the pricing.
>> 
>> 
>>  Richard Kreiss
>>  GCC Consulting
>> 
>>  Office: 410-653-2813
>> 
>> 
>> 
>>  _______________________________________________

JHExport is a filepro application that I wrote several years ago.  It walks you through the process of creating the export.  It can do CSV or any other delimited format.  You answer a few questions and then it writes the filepro code for you.  It will also optionally run the export and generate the file for you.  If you want to know more just reply to me directly.

Excel can open CSV files - just do file/open from excel and specify the file type of CSV.  Alternately you can set up your system so that the default program for files with the CSV extention is Excel.  Then you can just double click the CSV file and Excel will open it.

Also, if you have a preexisting Excel formatted spreadsheet, it should not be a problem to write a macro to read in the CSV or other delimited file as needed.  I have done this in the past.

Good Luck.


Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport.