import a CSV file w/ First row of data as field names by program not interactive way

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl - 23 Jul 2008 14:55 GMT

I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox Dos
cannot import directly data such as First row of data as field names. I have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?

Reply to this Message

Steven Green - 23 Jul 2008 15:03 GMT

> Pdox Dos cannot import directly data such as First row of data as field
> names.

of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina 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

>I need to import a CSV comma delimited file which has First row of data as
> field names by program not interactive way.
[quoted text clipped - 13 lines]
> to launch Pdox Win or other software from Dos program to import CSV data.
> Does anyone know such conversion software which masks interactive import?

Reply to this Message

Steven Green - 23 Jul 2008 15:06 GMT

> Pdox Dos cannot import directly data such as First row of data as field
> names.

or, if your pdoxdos issue is the field names.. import the file, and pass the
first record to an array, then delete the first record.. then use the
restruct screen to change the field names..

in other words, you can do anything you want, directly within pdoxdos.. all
you need, is to know how.. (g)

--
Steven Green - Myrtle Beach, South Carolina 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

Reply to this Message

Tom Nelson - 23 Jul 2008 17:38 GMT

Carl,

I have a small script which works in Paradox 5/10 windows which allows you
to import comma or other delimited records. The fields in the result table
are ASCII. It used to be on the thedbcommunity.com as a download, but I
can't seem to get there. It allows you to use the first record, if
desired, as field names.

Steve may have answered your needs. If there are many files with ASCII
fields, the script can eliminate the need for editing. I can email the
script to you if it will be helpful.

Tom Nelson

Reply to this Message

Carl - 24 Jul 2008 06:14 GMT

There are going to be a bunch of files a few times a week throughout years
not one time shot to communicate data among companies. So it should be
automated not interactive at all.
Could you send the script to carlogawa@verizon.net
Thank you.

| Carl,
|
[quoted text clipped - 27 lines]
| > to launch Pdox Win or other software from Dos program to import CSV data.
| > Does anyone know such conversion software which masks interactive import?

Reply to this Message

Steven Green - 24 Jul 2008 13:18 GMT

> So it should be automated not interactive at all.

the suggestions that I made were for an automated process, too.. you just
need to determine from which end the automation is best served..

--
Steven Green - Myrtle Beach, South Carolina 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

> There are going to be a bunch of files a few times a week throughout years
> not one time shot to communicate data among companies. So it should be
[quoted text clipped - 41 lines]
> | > Does anyone know such conversion software which masks interactive
> import?

Reply to this Message

Carl - 24 Jul 2008 16:48 GMT

Thanks! I figured out how to do by dos based on your suggestion. They till
use my old pdox program since 1991. Great pdoxdox rarely use anymore though.

Reply to this Message

Tony McGuire - 24 Jul 2008 14:43 GMT

Using Paradox for Windows (v9), check out the datatransfer() method,
amd its functions & parameters.

One parameter is exactly what you are asking for, and a native
methodology within Paradox for doing what you want.

setSourceFieldNamesFromFirst method

Sets field names using the data in the first row of input.

Syntax

setSourceFieldNamesFromFirst ( const namesFirst Logical)

Description

setSourceFieldNamesFromFirst sets field names using the first row of
the input data. Setting namesFirst to True always skips the first row.
However, the field names only apply to newly created tables that do
not already have field names. setSourceFieldNamesFromFirst only
applies when the source is a spreadsheet or a delimited text file.

------------------------------
Tony McGuire

Reply to this Message

Carl - 24 Jul 2008 16:28 GMT

| Using Paradox for Windows (v9), check out the datatransfer() method,
| amd its functions & parameters.
[quoted text clipped - 20 lines]
| ------------------------------
| Tony McGuire

Reply to this Message