import/export

Fri May 30 11:41:20 PDT 2014

For Windows 7 and later, the OS really doesn't like having users or programs creating files in C:\.

It is a better practice to do as Nancy suggest4ed below and create a separate folder for these files.

As I live in a Windows world, some years ago changed my filePro installs to look similar to a *nix installation.  I create and \appl folder and install filepro and the support folder there.  I can share this folder if necessary and not worry that it is the root folder of the system.

Richard Kreiss
GCC Consulting

Office: 410-653-2813

> -----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 Nancy Palmquist
> Sent: Friday, May 30, 2014 1:34 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: import/export
> 
> 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
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list