Export Utility

Yahoo Archive
1
Did you try matches instead of contains. contains is only used for fields
that are defined as word indexes.

art Sgroi

-----Original Message-----
From: Michael Benedict [mailto:mbenedict@...]
Sent: Tuesday, September 09, 2003 4:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export Utility


Does anyone now the syntax in the export utility to select where a field
contains a certain data string? i.e. part description contains door. I
tried '*door*' but no luck.

Thanks in advance,

Michael Benedict
IS Manager
Crestview Aerospace Corp.



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=392547281>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Is there any way to either run a particular export utility routine from the
favorites bar? Either directly or via a program interface executed from an
item on the bar. Also, does anyone know where or how the export routines
are stored? Can exports be automated to run on a regular basis (such as
nightly)? If possible I would like users not to have access to the whole
list of exports.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
I run nightly exports using a macro utility called "Ground Control". It basically stores keystrokes, plus has a sort of programming language, can switch windows. It's on the Yahoo files section and is shareware. Registristration is $30. I believe others have recommended another macro utility that they like better than Ground Control as well, if anyone would care to comment.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Tuesday, June 19, 2001 10:37 AM
Subject: [Vantage] Export Utility


Is there any way to either run a particular export utility routine from the
favorites bar? Either directly or via a program interface executed from an
item on the bar. Also, does anyone know where or how the export routines
are stored? Can exports be automated to run on a regular basis (such as
nightly)? If possible I would like users not to have access to the whole
list of exports.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


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


Yahoo! Groups Sponsor



To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
The only solution within Progress I know that might be able to facilitate
this is Mike Podlins automated export.

If you have an ODBC Connection, and a little bit of visual basic knowledge,
it is fairly simple to set up an automated export system. We will probably
doing something like that when we upgrade to v5. Of course, securing the
ODBC connection to individual tables is not practical.

With Crystal, using either compiled reports or web based reports, you can do
an export to various formats. This requires ODBC, though.

The most secure solution is probably to setup web based crystal reports, so
there is only one ODBC connection, and that connection is not accessible by
the end user running reports.

I will probably setting up an automated ODBC query export program in the
next few months in Visual Basic, which will save the exports to protected
directories on the network. The program, when finished, will reside on the
server or on a locked down workstation. By eliminating the user on the ODBC
workstation, you greatly reduce the security risk.

Let me know if you have any questions.

Best Regards,

Thaddeus Jacobs
Assistant LAN Technologist / Vantage Support
Kinematic Automation, Inc
mailto:tjacobs@...












-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, June 19, 2001 9:37 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Export Utility


Is there any way to either run a particular export utility routine from the
favorites bar? Either directly or via a program interface executed from an
item on the bar. Also, does anyone know where or how the export routines
are stored? Can exports be automated to run on a regular basis (such as
nightly)? If possible I would like users not to have access to the whole
list of exports.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


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


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
This sounds cool. A heck of a lot simpler than visual basic ODBC query
statements.
~thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, June 19, 2001 10:18 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Export Utility


I run nightly exports using a macro utility called "Ground Control". It
basically stores keystrokes, plus has a sort of programming language, can
switch windows. It's on the Yahoo files section and is shareware.
Registristration is $30. I believe others have recommended another macro
utility that they like better than Ground Control as well, if anyone would
care to comment.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Tuesday, June 19, 2001 10:37 AM
Subject: [Vantage] Export Utility


Is there any way to either run a particular export utility routine from
the
favorites bar? Either directly or via a program interface executed from
an
item on the bar. Also, does anyone know where or how the export routines
are stored? Can exports be automated to run on a regular basis (such as
nightly)? If possible I would like users not to have access to the whole
list of exports.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


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


Yahoo! Groups Sponsor



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
At 10:37 AM 6/19/2001 , you wrote:
>Is there any way to either run a particular export utility routine from the
>favorites bar? Either directly or via a program interface executed from an
>item on the bar. Also, does anyone know where or how the export routines
>are stored? Can exports be automated to run on a regular basis (such as

Which version of Vantage are ya' on? I found a really cool quirk in 3.0 -
one time an export crashed, and I found it left an auto-generated Progress
dot-P source code file in VntgWork. With a little more playing, I found
the .P file wasn't deleted till the end of the export. Introducing a
little extra delay, like exporting to floppy, gives you plenty of time to
grab a copy.

From there, you could make a menu or favorite item to it, to allow users
to run exports without granting access to the whole utility, or even get
fancy and mod the program to prompt for data, so they don't have to
directly edit 4GL queries.

Then we updated to Vantage 4.0 last month. There are a bunch of nice
enhancements to the export utility. But - I haven't been able to grab any
source code from it :( Either it deletes the .P promptly after compiling
it, or avoids creating it altogether. As an added annoyance, it neglects
to clean up a .R file (compiled object code) adding to the persistent
clutter in \VntgWork.

Write me off-list if you'd like a sample of the code.

-Wayne Cox
7
Todd,
Do you have the EBI module? It allows you to create a batch startup
file. Here is what the Vantage HELP says about it:

"Running exports and refreshing data sets can be very time-consuming —
for both the user and the system. It is highly recommended that data
sets be refreshed when there is little or no activity in Vantage
(such as at night or on the weekend). To facilitate this, Vantage
allows you to create a Batch Startup File (a .vtg file), with which
you can schedule exports and data set refreshes using either the
Windows Task Scheduler or the SQL Server Job Agent. The EBI Log will
record all of the activity performed, as well as any error messages
generated while the batch is being processed."

While we haven't used this yet, it appears as though you can schedule
any export. Here is the syntax of our batch.vtg file:

[Vantage Startup]
Executable=Y:\Progress\bin\prowin32.exe
Database=Y:\Vantage\db\vantage
IniFile=Y:\Vantage\vantage.ini
ParameterFile=Y:\Vantage\db\Vantage.pf
ConnectOptions=-N TCP -H quake -S vantage
TempDirectory=C:\Vntgwork
StartupProcedure=mainmenu.w
OtherParameters=-rand 2 -q -basekey ini
MenuOption=sv\svi60-bg.p
VantageLogin=XXXXX/XXXXXXXXXXXXX
TaskList=Y:\Vantage\batch.vtg
[TaskList]
Task1=Exports~047
Task2=Exports~031

This shows it will run Export ID 047 and 031. Be sure to use your own
login and password! Even though the password is encrypted, I have X'd
mine out in the example above.

Hope this helps.
--- In vantage@y..., Thad Jacobs <tjacobs@k...> wrote:
> This sounds cool. A heck of a lot simpler than visual basic ODBC
query
> statements.
> ~thaddeus
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@e...]
> Sent: Tuesday, June 19, 2001 10:18 AM
> To: vantage@y...
> Subject: Re: [Vantage] Export Utility
>
>
> I run nightly exports using a macro utility called "Ground
Control". It
> basically stores keystrokes, plus has a sort of programming
language, can
> switch windows. It's on the Yahoo files section and is shareware.
> Registristration is $30. I believe others have recommended another
macro
> utility that they like better than Ground Control as well, if
anyone would
> care to comment.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Todd Caughey
> To: 'vantage@y...'
> Sent: Tuesday, June 19, 2001 10:37 AM
> Subject: [Vantage] Export Utility
>
>
> Is there any way to either run a particular export utility
routine from
> the
> favorites bar? Either directly or via a program interface
executed from
> an
> item on the bar. Also, does anyone know where or how the export
routines
> are stored? Can exports be automated to run on a regular basis
(such as
> nightly)? If possible I would like users not to have access to
the whole
> list of exports.
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/