import

GCC Consulting gccconsulting at comcast.net
Tue Jan 10 12:48:03 PST 2006


 

-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Steven Waters
Sent: Tuesday, January 10, 2006 1:17 PM
To: Filepro-list at lists.celestial.com
Subject: RE: import

Bruce Easton wrote,

For that type of data, I usually use the tab-delimited export from Excel and
then on *nix, using vi remove any Ctrl-M's and quote marks with two ed
commands:Richard Kreiss
GCC Consulting
 

:g/^M/s/^M//g     (Ctrl-V,Ctrl-M to get the ^M) and
:g/\"/s/\"//g

Thanks, that is good advice.

I figured out a workaround for the csv problem that I am having. Which is,
some of my data has commas and double quotes randomly in it. When I import
csv, the data gets moved around. Jeff suggested to use a "~" This is not in
any of my data. So I found a work around. Go to; Control Panel in Windows ->
Regional and Language options -> Regional options tab Customize button->
List Separator. Change the "," to "~". Run the save as csv in excel and all
of the separators are now "~". I imported to my file and it works great.
Don't forget to change it back.
Also,
Is the DBCOPY part of Filepro or an add-on?

Thanks for all of the support


DBCopy is part of filePro utilities.  It is found on the utility menu.

Note that the dbf file should be in the root directory for filePro.

I.e..  If filePro folder is c:\filePro the place the file at c:\filename.dbf
     If filePro is in c:\appl\filepro the place filename.dbf in c:\appl

You will be asked for the file name, no extension.  Next you will be
prompted for a filePro name.

If the filePro file already exists, you will be prompted to overwrite it.
Answer (Y).  This will replace any records already in the file.  You can set
this up as a menu command.  However, one must ALWAYS answer the yes/no
question.

I have found it easier to keep this file as I have a screen, browse and the
necessary processing tables for handling the data.





More information about the Filepro-list mailing list