dbTalk Databases Forums  

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

comp.databases.paradox comp.databases.paradox


Discuss import a CSV file w/ First row of data as field names by program not interactive way in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #51  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM






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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #52  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM






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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #53  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM



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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #54  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM



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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #55  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM



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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #56  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM



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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
  #57  
Old   
Carl
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-24-2008 , 10:48 AM



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" <greens (AT) diamondsg (DOT) com> wrote

Quote:
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" <carlogawa (AT) verizon (DOT) net> wrote in message
news:48880f99$1 (AT) pnews (DOT) thedbcommunity.com...
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 (AT) verizon (DOT) net
Thank you.

"Tom Nelson" <tnelson011 (AT) verizon (DOT) net> wrote in message
news:48875f17$1 (AT) pnews (DOT) thedbcommunity.com...
| 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" <carlogawa (AT) verizon (DOT) net> wrote in message
| news:4887384c (AT) pnews (DOT) thedbcommunity.com...
| >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 With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.