Top Post Re: Import Dif Help

[haroldef]

On 6/15/2011 12:09 PM, haroldef wrote:
> On 6/15/2011 11:39 AM, Richard Kreiss wrote:
>>
>>
>> -----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 haroldef
>> Sent: Wednesday, June 15, 2011 12:20 PM
>> To: Kenneth Brody
>> Cc: 'FilePro Mailing List'
>> Subject: Top Post Re: Import Dif Help
>>
>> Hi,
>>
>> What I thought would work did not work.  First I tried:
>> import dif data=c:\appl\mac_email_address\emailadd.csv
>> This produced an error message that the file was not a valid dif file.
>>
>> Then I tried:  import word data=c:\appl\mac_email_address_emailadd.csv
>> It did not fail, but I could not read anything.
>>
>> A few days ago I created a program that would export a csv file, consisting
>> of the last name, the first name and the email addresses of over 500 members
>> of our reunion group.  That was easy as there is advise on the fpteck site
>> about creating a program that exports a csv file.
>>
>> Can someone point me to where I can read about importing a csv file that
>> provides more information then that given in the filepro manual?
>>
>> Harold
>>
>> Harold,
>>
>> I'll do a "Ken", define not working.
>>
>> Is the path to the file correct?
>> Is it a comma delimited file?
>>
>> Richard Kreiss
>>
>
> Hi,  Right after I sent that email I knew I had goofed.  I didn't say
> how it failed.  It failed because I had a blank for the first import
> word name=c:\appl\mac_email_address
>
> To see if I had anything I used na(60,*) = name, and na was sixty spaces
> of blanks.
>
> To answer your question
>
> The path is correct, and it is a comma delimited file, a csv file.
>
> In the csv file each line has:
>
> "last name","first name","city","email address"
>
> Isn't there any information on how to use import like there is using export?
>
> Harold
>
>

Hi,

I have the program working to read a csv file and correct email 
addresses is a file called testmac.  However,

When using Then IMPORT ASCII tst=c:\temp\test.txt R=^J f=, O=" C=", as 
suggested in the manual a lookup was performed on testmac using last 
name, first name and city from the csv file, but I could never get the 
lookup to find he proper name.  The problem was probably the R=, F=, O= 
and C=, but I could not what these items should be.

I solved the problem of importing a csv file by using the simple:

Then: IMPORT word tst=c:\appl\mac_email_address\text.txt

I changed the csv file name from something.csv to text.txt, and it now 
corrects the email addresses in the file testmac.

Harold