Database Table Dump

Yahoo Archive
1
Most, if not all of the issues you are encountering can be alleviated. Feel
free to contact me off of the list and I will be happy to assist you with
the repairs.



Best Regards,



Michael



Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kersten MacLennan
Sent: Wednesday, November 28, 2007 7:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



Thanks. Others won't open because there are too many fields and still
others because some fields are too long. It does make things rather
difficult.


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mark Wonsil
Sent: Wednesday, November 28, 2007 10:09 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

> That won't do it. I heard that Progress is no longer suppling the tool
> but thought you might have it from an earlier version. The other
option
> you have is to connect via Access. Depending on the table, you can
> connect to the DB via ODBC and select all from the table either to a
> file or to display and then copy and paste to Excel

Some tables won't connect through ODBC because of the number of indices.
You
can create a pass-though query and just do a FILE | EXPORT to a
delimited text
file.

Mark W.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]
3
If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database Table Dump



Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
I don't seem to have a SQL Explorer Tool, but I do have a Progress
Explorer Tool..



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 8:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Database Table Dump

Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
That won't do it. I heard that Progress is no longer suppling the tool
but thought you might have it from an earlier version. The other option
you have is to connect via Access. Depending on the table, you can
connect to the DB via ODBC and select all from the table either to a
file or to display and then copy and paste to Excel


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



I don't seem to have a SQL Explorer Tool, but I do have a Progress
Explorer Tool..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 8:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Database Table Dump

Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
6
Another way is to setup a BAQ that is the table you want dumped and
include all the fields. Then 'test' it, copy all and paste into Excel.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 7:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



That won't do it. I heard that Progress is no longer suppling the tool
but thought you might have it from an earlier version. The other option
you have is to connect via Access. Depending on the table, you can
connect to the DB via ODBC and select all from the table either to a
file or to display and then copy and paste to Excel


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

I don't seem to have a SQL Explorer Tool, but I do have a Progress
Explorer Tool..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 8:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Database Table Dump

Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> > >
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
7
Here's the 4GL code to get it done...

/* Dump out the info for analysis */
Output to "C:\temp\ShipDtl.csv".
Export Delimiter "," "CustNum" "JobNum" "PartNum" "RevisionNum"
"ShipToNum".
For Each ShipDtl where ShipDtl.Company = "YourCompany"
no-lock:
Export Delimiter "," CustNum JobNum PartNum RevisionNum ShipToNum.
End.
OUTPUT CLOSE.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Wednesday, November 28, 2007 8:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



Another way is to setup a BAQ that is the table you want dumped and
include all the fields. Then 'test' it, copy all and paste into Excel.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 7:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

That won't do it. I heard that Progress is no longer suppling the tool
but thought you might have it from an earlier version. The other option
you have is to connect via Access. Depending on the table, you can
connect to the DB via ODBC and select all from the table either to a
file or to display and then copy and paste to Excel

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

I don't seem to have a SQL Explorer Tool, but I do have a Progress
Explorer Tool..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 8:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Database Table Dump

Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> > >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> > > >
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
8
> That won't do it. I heard that Progress is no longer suppling the tool
> but thought you might have it from an earlier version. The other option
> you have is to connect via Access. Depending on the table, you can
> connect to the DB via ODBC and select all from the table either to a
> file or to display and then copy and paste to Excel

Some tables won't connect through ODBC because of the number of indices. You
can create a pass-though query and just do a FILE | EXPORT to a delimited text
file.

Mark W.
9
Matt:



Listed below is some progress code that will allow you to export any Vantage
table and will give all the field names on the first line of the delimited
table. Progress has a file structure that allows a person to access the
file and field names, format, etc. _file, _field, etc.



It is my suggestion for you to paste this code into your Progress editor
save it and then change the word customer to the table name to the table
name you want.



Find out how to get the Progress editor and use the program - it works! The
Progress editor access should be under the 8.03 Administrator icon





def var vTable as char format "x(20)" LABEL "Table" no-undo.

DEF VAR ofile AS CHAR FORMAT "x(40)" NO-UNDO.





vTable = "customer".

ofile = "C:\temp\customer.txt".

OUTPUT TO value(oFile).



DEF VAR i AS INT.



FOR EACH _file WHERE _file._file-name = vtable NO-LOCK:



FOR EACH _field OF _file BY

_field._order.



IF _field._extent > 0 THEN DO:



DO i = 1 TO _field._extent.

PUT UNFORMATTED TRIM(_field._field-name) "[" i "]" "|".

END.



END.



ELSE DO:

PUT UNFORMATTED TRIM(_field._field-name) "|".

END.



END. /* each _field */

PUT SKIP.

END.



DEF VAR vCnt-d AS INTE NO-UNDO.

DEF STREAM t.

OUTPUT STREAM t TO TERMINAL.

vCnt-d = 0.

Data-LOOP:

FOR EACH customer.

EXPORT DELIMITER "|" customer.

vCnt-d = vCnt-d + 1.

IF vCnt-d MOD 10 = 0 THEN

DISPLAY STREAM t vcnt-d WITH 1 COL 1 DOWN. PAUSE(0).

END.



OUTPUT CLOSE. PAUSE(0).

MESSAGE "Done: Records: " vcnt-d

VIEW-AS ALERT-BOX.









Carl D. Peterson, CPIM

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database Table Dump



Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
10
Thanks. Others won't open because there are too many fields and still
others because some fields are too long. It does make things rather
difficult.


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Wednesday, November 28, 2007 10:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



> That won't do it. I heard that Progress is no longer suppling the tool
> but thought you might have it from an earlier version. The other
option
> you have is to connect via Access. Depending on the table, you can
> connect to the DB via ODBC and select all from the table either to a
> file or to display and then copy and paste to Excel

Some tables won't connect through ODBC because of the number of indices.
You
can create a pass-though query and just do a FILE | EXPORT to a
delimited text
file.

Mark W.






[Non-text portions of this message have been removed]
11
This worked using the Progress Procedure Editor. I got my data from
part, customer, and shipto! TY



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jeff Lewis
Sent: Wednesday, November 28, 2007 8:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database Table Dump



Here's the 4GL code to get it done...

/* Dump out the info for analysis */
Output to "C:\temp\ShipDtl.csv".
Export Delimiter "," "CustNum" "JobNum" "PartNum" "RevisionNum"
"ShipToNum".
For Each ShipDtl where ShipDtl.Company = "YourCompany"
no-lock:
Export Delimiter "," CustNum JobNum PartNum RevisionNum ShipToNum.
End.
OUTPUT CLOSE.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Wednesday, November 28, 2007 8:40 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

Another way is to setup a BAQ that is the table you want dumped and
include all the fields. Then 'test' it, copy all and paste into Excel.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 7:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

That won't do it. I heard that Progress is no longer suppling the tool
but thought you might have it from an earlier version. The other option
you have is to connect via Access. Depending on the table, you can
connect to the DB via ODBC and select all from the table either to a
file or to display and then copy and paste to Excel

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

I don't seem to have a SQL Explorer Tool, but I do have a Progress
Explorer Tool..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kersten MacLennan
Sent: Wednesday, November 28, 2007 8:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Database Table Dump

If you have the SQL Explorer tool you change the logging and select all.
It will send it to a text file

Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>
<mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: Wednesday, November 28, 2007 9:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Database Table Dump

Do any of you have any suggestions on how to dump the contents of a
table to either a text file or a CSV file? We are still in
implementation, but have Vantage 8.03.403C.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> > >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
<http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> > > >
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]