I'm using Para9 on Win2000.
I have imported a database from a .csv file where the first record values
are all of the field names. Is there a Para9 keystroke shortcut to transfer
all of the first record values to field names, instead of manually renaming
each field in Format / Restructure?

Thanks.

if you import a proper csv correctly, it *WILL* pick up the field names..
can you show us how you did it?

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Don" <donn (AT) princetonair (DOT) com> wrote

Don - There is an option in the import process to use the first row as field
names.

HTH
"Don" <donn (AT) princetonair (DOT) com> wrote

"Don" <donn (AT) princetonair (DOT) com> wrote:
Here's how I do the .csv import in Para9:

File\import\click on Import button in initial dialogue box; select ASCII


delimited txt or csv file format; select the .csv file to be imported;

click on "from text" tab; checkmark "use first row of data as field

names"; click on Import button; get error message "There were 642

problems during the import. The problems are described in the table

Problem.db"; Problem.db has three fields: LineNo (shows a sequential

number value for each of 642 records,eg 1,2,3,4,....), Line (shows

values from first three fields); and Reason: Translate Error. Value out

of bounds. Date List Produced.

To work-around this error, I begin the import process again and select "Text
Expert" in the initial Import dialogue box; This import process works without
an error, but the field names are in the first row of data & I then use Format
\ Restructure to rename the fields.

Don, hi,

Worked for me on a .csv file with Pdox9 (but that was produced out of
Pdox

Maybe the formatting of the .csv file is problematic. Open in notepad and
check that it conforms to the import selection specs. How many chars in
the largest field?

Anne

"Don" <donn (AT) princetonair (DOT) com> wrote in
news:45dcdc33 (AT) pnews (DOT) thedbcommunity.com:

-----
Anne Wainwright
Please reply to group

"Don" <donn (AT) princetonair (DOT) com> wrote:
As suggested, I opened the .csv file in Notebook & learned that most of the
values in each record were missing their quotation mark delimiters.
Thanks for the help,
Don

Hi, Don,

The "" normally enclose a field designated as text by the original
source; non-numeric, integer, and number type fields don't get enclosed
in ""

The problem occurs if a non-"" field has a comma in because this can get
confused with the field seperating commas in the import process.

The auto option you use must do something correct.

Regards
Anne

"Don" <donn (AT) princetonair (DOT) com> wrote in
news:45de0420 (AT) pnews (DOT) thedbcommunity.com:

-----
Anne Wainwright
Please reply to group