import/export
Nancy Palmquist
Nancy.Palmquist at vss3.com
Fri May 30 10:34:12 PDT 2014
You may have trouble writing to C:\ drive. Windows 7 does not usually
allow it.
I usually set up an fpmerge folder - like Unix uses and write these
things there, but it could be any folder you make.
Then do:
::end: @keyI::: loop::import word imp=c:\[specialfolder]\import2014.csv:
:not imp:end: ::lookup nick=myfilename r=free -e:
::nick(1)= imp(1);nick(2)=imp(2): nick(3)=imp(3)
::write nick
::goto loop:
::end:
I would not use lookup - dash in this situation. Put the actual
filename. Lookup - will move you to that record in the current file.
It is weird in an import situation. You would be hopping all over the
place.
You can sit on any record in the file, hit I and this would load records
as long as the myfilename is changed to the current filename.
Nancy
On 5/23/2014 9:13 AM, Walter D Vaughan Jr wrote:
> <top post Friday>
>
> Whatever you do, practice with few sample databases until you get the feel.
>
> What I do is add this code like this to the default "input" table
> Do you know how to read filePro code?
> The following will import in "Add Records" if you are not in update mode,
> but standing on a deleted or blank record and press the "I" key.
> Note you do not enclose the filenames in "quotes" like you would expect
>
> ::end:
> @keyI:::
> loop::import word imp=c:\import2014.csv:
> :not imp:end:
> ::1= imp(1); 2=imp(2): 3=imp(3)
> ::lookup - r=free -e:
> ::goto loop:
> ::end:
>
> Nancy's stuff might be better to learn from
> http://www.vss3.com/tips/tip_44.htm
> http://www.vss3.com/tips/tip_15.htm
>
>
>
>
>> -----Original Message-----
>> From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
>> [mailto:filepro-list-
>> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
>> Whiting, Robart A.
>> Sent: Friday, May 23, 2014 8:33 AM
>> To: filepro-list at lists.celestial.com
>> Subject: import/export
>>
>> ________________________________
>> From: Whiting, Robart A.
>> Sent: Thursday, May 22, 2014 10:13 AM
>> To: filepro-list-request at lists.celestial.com
>> Subject:
>>
>>
>> Hi. I'm a newbie to the list-serve. I wish I found it years ago. I've
> been using
>> FilePro since 1992. Currently using 5.0.08 on Windows 7 - professional.
> Data is
>> on a server and using 3 individual terminal.
>>
>>
>>
>> I've always had trouble using the import/export functions. Up to now I've
>> been able to get by, but it's become important that I can export some
>> reports/data in either ascii or excel (multi) format. I've tried both of
> the
>> following coding but I can not find the resulting files.
>>
>>
>>
>> if
>>
>> then: export multi labels c=1
>>
>> if
>>
>> then: lables(1)=1;labels(2)=2;labels(3)=3
>>
>>
>>
>> also tried
>>
>> if
>>
>> then: export ascii labels -x
>>
>>
>>
>> I would also love to bring in data from other databases. But like with
> export, I
>> must be getting syntax wrong for import. I thought setting up non-filepro
>> files would be best....but again I cant seem to get it right. I've always
> had
>> the dbcopy function on my utilities menu but no luck there either. When I
>> try this, I get the Xbase file name, but must not be showing the file
> properly
>> because I don't get the next stop.
>>
>>
>>
>> ANY and ALL assistance would be appreciated.
>>
>>
>>
>>
>>
>> Robart Whiting
>>
>> Financial Aid Officer
>>
>> Miami Lakes Educational Center
>>
>> 5780 NW 158 St
>>
>> Miami Lakes, FL 33014
>>
>> 305/557-1100 x2256
>>
>>
>>
>> Robart Whiting
>>
>> Financial Aid Officer
>>
>> Miami Lakes Educational Center
>>
>> 5780 NW 158 St
>>
>> Miami Lakes, FL 33014
>>
>> 305/557-1100 x2256
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
--
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417
More information about the Filepro-list
mailing list