Exporting from the Change Log

Yahoo Archive
1
> We get the error:
> Syntax error in SQL statement

Interesting, do you have access to EpicWeb?
If so see link below:

https://epicweb.epicor.com/ReportServer/Pages/ReportViewer.aspx?/ePortal/ABDetail&rs:Command=Render&rc:Toolbar=true&Card_ID=8479MPS&Answerbook=Vantage%2fVista+8.0+-+General+Information+documents

--- In vantage@yahoogroups.com, Marco Vissuet <mvissuet@...> wrote:
>
> We get the error:
>
> Syntax error in SQL statement at or about 'TimeStamp, Chglog_0.DCDUserID, Chglog_0.)
>
>
> Marco Vissuet
> Systems Engineer
> Pacific Contours Corporation
> Cell (619)507-2311
> Anaheim Office (714) 693-1260
> San Diego Office (619)670-3900
> Fax (714) 693-1252
> mvissuet@...<mailto:marcov@...>
> http://www.pacificcontours.com/
>
> "The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
> Sent: Monday, April 22, 2013 9:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Exporting from the Change Log
>
>
>
> > When we try to connect to the table using ODBC we get errors.
> Like the other post suggested, an Export BAQ might be a good route.
>
> Just curious though, what errors you are seeing? Progress?
> I only wonder because I've never had any trouble connecting to ChgLog.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "supertico05" <mvissuet@<mailto:mvissuet@>> wrote:
> >
> > Does anyone have an easy way on how to export the data from the change log?
> >
> > We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.
> >
> > When we try to connect to the table using ODBC we get errors.
> >
>
>
>
> [Non-text portions of this message have been removed]
>
2
Does anyone have an easy way on how to export the data from the change log?

We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.

When we try to connect to the table using ODBC we get errors.
3
Might not be fun but a BAQ on the table to populate a dashboard.

Let it run for the hour or two it might need to populate...

Then Copy and Paste.

Of course, I would just query the table in SQL and paste it into a file. If you are stuck with progress, try Squirrel or whatever it is that Vic is always harping about.

Tom Christie | Information Technology Manager | AGM Container Controls, Inc. | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of supertico05
Sent: Monday, April 22, 2013 8:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting from the Change Log



Does anyone have an easy way on how to export the data from the change log?

We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.

When we try to connect to the table using ODBC we get errors.



[Non-text portions of this message have been removed]
4
You could create a BAQ and right click the results grid to export to excel.




________________________________
From: supertico05 <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Monday, April 22, 2013 11:43 AM
Subject: [Vantage] Exporting from the Change Log


Does anyone have an easy way on how to export the data from the change log?

We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.

When we try to connect to the table using ODBC we get errors.



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
5
There is also a BAQ export process located under System Mgmt > Utilities




________________________________
From: supertico05 <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Monday, April 22, 2013 11:43 AM
Subject: [Vantage] Exporting from the Change Log


Does anyone have an easy way on how to export the data from the change log?

We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.

When we try to connect to the table using ODBC we get errors.



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
6
What about just dumping it out of SQL into excel. There are exporters out there that you could take the whole table to Excel as an archive type format.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "Ted Koch" <tkoch77@...>
To: vantage@yahoogroups.com
Sent: Monday, April 22, 2013 10:54:33 AM
Subject: Re: [Vantage] Exporting from the Change Log



You could create a BAQ and right click the results grid to export to excel.

________________________________
From: supertico05 < mvissuet@... >
To: vantage@yahoogroups.com
Sent: Monday, April 22, 2013 11:43 AM
Subject: [Vantage] Exporting from the Change Log


Does anyone have an easy way on how to export the data from the change log?

We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.

When we try to connect to the table using ODBC we get errors.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo ! Groups Links

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





[Non-text portions of this message have been removed]
7
> When we try to connect to the table using ODBC we get errors.
Like the other post suggested, an Export BAQ might be a good route.

Just curious though, what errors you are seeing? Progress?
I only wonder because I've never had any trouble connecting to ChgLog.




--- In vantage@yahoogroups.com, "supertico05" <mvissuet@...> wrote:
>
> Does anyone have an easy way on how to export the data from the change log?
>
> We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.
>
> When we try to connect to the table using ODBC we get errors.
>
8
We get the error:

Syntax error in SQL statement at or about 'TimeStamp, Chglog_0.DCDUserID, Chglog_0.)


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Monday, April 22, 2013 9:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Exporting from the Change Log



> When we try to connect to the table using ODBC we get errors.
Like the other post suggested, an Export BAQ might be a good route.

Just curious though, what errors you are seeing? Progress?
I only wonder because I've never had any trouble connecting to ChgLog.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "supertico05" <mvissuet@...<mailto:mvissuet@...>> wrote:
>
> Does anyone have an easy way on how to export the data from the change log?
>
> We are planning on purging the data in the change log, however, before we purge it, we want to export it to a excel file or text file.
>
> When we try to connect to the table using ODBC we get errors.
>



[Non-text portions of this message have been removed]
9
What's your SQL query? I've never had a problem hitting this table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marco Vissuet
Sent: Monday, April 22, 2013 4:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Exporting from the Change Log





We get the error:

Syntax error in SQL statement at or about 'TimeStamp, Chglog_0.DCDUserID,
Chglog_0.)

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@... <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@... <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of b_ordway
Sent: Monday, April 22, 2013 9:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Exporting from the Change Log

> When we try to connect to the table using ODBC we get errors.
Like the other post suggested, an Export BAQ might be a good route.

Just curious though, what errors you are seeing? Progress?
I only wonder because I've never had any trouble connecting to ChgLog.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "supertico05" <mvissuet@...
<mailto:mvissuet@...%3cmailto:mvissuet@...> <mailto:mvissuet@...>> wrote:
>
> Does anyone have an easy way on how to export the data from the change
log?
>
> We are planning on purging the data in the change log, however, before we
purge it, we want to export it to a excel file or text file.
>
> When we try to connect to the table using ODBC we get errors.
>

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





[Non-text portions of this message have been removed]
10
It's a progress database, so it's just through ODBC...
The only table being called is the change log table... we get the error regardless of what field(s) we try to call.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Monday, April 22, 2013 2:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Exporting from the Change Log



What's your SQL query? I've never had a problem hitting this table.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Marco Vissuet
Sent: Monday, April 22, 2013 4:52 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Exporting from the Change Log

We get the error:

Syntax error in SQL statement at or about 'TimeStamp, Chglog_0.DCDUserID,
Chglog_0.)

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com> <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@...<mailto:marcov%40pacificcontours.com> <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

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 b_ordway
Sent: Monday, April 22, 2013 9:51 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Exporting from the Change Log

> When we try to connect to the table using ODBC we get errors.
Like the other post suggested, an Export BAQ might be a good route.

Just curious though, what errors you are seeing? Progress?
I only wonder because I've never had any trouble connecting to ChgLog.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "supertico05" <mvissuet@...
<mailto:mvissuet@...%3cmailto:mvissuet@...<mailto:mvissuet@...%0b%3cmailto:mvissuet@...%3cmailto:mvissuet@...>> <mailto:mvissuet@...>> wrote:
>
> Does anyone have an easy way on how to export the data from the change
log?
>
> We are planning on purging the data in the change log, however, before we
purge it, we want to export it to a excel file or text file.
>
> When we try to connect to the table using ODBC we get errors.
>

[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]
11
We have Progress and we do not have SQL.



I just linked the ChgLog table using ODBC connection in Microsoft Access
with no problems.



Do you think there might be corrupt data?







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marco Vissuet
Sent: Monday, April 22, 2013 2:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Exporting from the Change Log





It's a progress database, so it's just through ODBC...
The only table being called is the change log table... we get the error
regardless of what field(s) we try to call.

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@... <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@... <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Vic Drecchio
Sent: Monday, April 22, 2013 2:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Exporting from the Change Log

What's your SQL query? I've never had a problem hitting this table.

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
Marco Vissuet
Sent: Monday, April 22, 2013 4:52 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Exporting from the Change Log

We get the error:

Syntax error in SQL statement at or about 'TimeStamp, Chglog_0.DCDUserID,
Chglog_0.)

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@... <mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@... <mailto:marcov%40pacificcontours.com>
<mailto:marcov%40pacificcontours.com> <mailto:marcov%40pacificcontours.com>
>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

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 b_ordway
Sent: Monday, April 22, 2013 9:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Exporting from the Change Log

> When we try to connect to the table using ODBC we get errors.
Like the other post suggested, an Export BAQ might be a good route.

Just curious though, what errors you are seeing? Progress?
I only wonder because I've never had any trouble connecting to ChgLog.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "supertico05" <mvissuet@...
<mailto:mvissuet@...%0b%3cmailto:mvissuet@...%3cmailto:mvissuet@...%3cmailto
:mvissuet@...%0b%3cmailto:mvissuet@...%3cmailto:mvissuet@...>
<mailto:mvissuet@...%3cmailto:mvissuet@...<mailto:mvissuet@...%0b%3cmailto:m
vissuet@...%3cmailto:mvissuet@...>> <mailto:mvissuet@...>> wrote:
>
> Does anyone have an easy way on how to export the data from the change
log?
>
> We are planning on purging the data in the change log, however, before we
purge it, we want to export it to a excel file or text file.
>
> When we try to connect to the table using ODBC we get errors.
>

[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]