import a CSV file w/ First row of data as field names by p..

> 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
"Carl" wrote in message

>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?
>
>
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

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

"Carl" wrote in message

>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?
>
>
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

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 RemoveThis @verizon.net
Thank you.

"Tom Nelson" wrote in message

| 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
|
| "Carl" wrote in message
|
| >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?
| >
| >
|
|
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

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
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

> 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
"Carl" wrote in message

> 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.DeleteThis@verizon.net
> Thank you.
>
> "Tom Nelson" wrote in message
>
> | 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
> |
> | "Carl" wrote in message
> |
> | >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?
> | >
> | >
> |
> |
>
>
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

Thanks. found: setSourceFieldNamesFromFirst ( const namesFirst Logical)

Copyright 1996 - 2004. Corel Corporation. All rights reserved.
"Tony McGuire" wrote in message

|
| 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
|
|
 >> Stay informed about: import a CSV file w/ First row of data as field names by p.. 

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.

"Steven Green" wrote in message

| > 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
| "Carl" wrote in message
|
| > 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 RemoveThis @verizon.net
| > Thank you.
| >
| > "Tom Nelson" wrote in message
| >
| > | 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
| > |
| > | "Carl" wrote in message
| > |
| > | >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?
| > | >
| > | >
| > |
| > |
| >
| >
|
|
 >> Stay informed about: import a CSV file w/ First row of data as field names by p..