Top Post Reply to Richard Re: Import Dif Help

[haroldef]

I am replying to Richard's reply on 6/19/11.

I doubled check.  Changing the name to text.csv will not work.  it gives 
the error:

*** A System Error Has Occurred ***

On File: c:\appl\mac_email_address\text.cxv

Output Processing
Line Number: 2

IMPORT word tst=c:\appl\mac_email_address\text.cxv

No such file or directory


Harold


On 6/19/2011 9:26 AM, haroldef wrote:
> 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
>