import/export

Walter D Vaughan Jr wvaughan at steelerubber.com
Fri May 23 06:13:21 PDT 2014


<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



More information about the Filepro-list mailing list