Ground Control

Yahoo Archive
1
If I told ya I'd have to kill ya. All 900 or so.



Hint: Microsoft threw one heck of a party Tuesday night and I thought I
saw a couple of our Epicor people much happier than I'm used to seeing
them.



Sue



-----Original Message-----
From: Rick Gors [mailto:rgors@...]
Sent: Friday, October 29, 2004 12:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control



Ohhhhhhhhhhh!!!!!!!!

Details...We stuck at homers need details!!!!

It'll stay between all 900 of us.....

RG


Yes, but remember what happens in Vegas stays in Vegas.




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



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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129ssb4in/M=315388.5543473.6613715.3001176/
D=groups/S=1705007183:HM/EXP=1099163244/A=2372354/R=0/SIG=12id813k2/*htt
ps:/www.orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F210
04SS>


<http://us.adserver.yahoo.com/l?M=315388.5543473.6613715.3001176/D=group
s/S=:HM/A=2372354/rand=906497784>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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
I would like to thank the list members who directed me to the Ground Control
macro utility. I don't think any Vantage installation should be without it.
I use to have dos2win which is outdated. Ground Control not only scripts
keys but has IF and WHILE logic. It can also read from a text file. I am
creating a Tooling BOM and have over 20,000 parts to enter. My data entry
person went from 100 per day to 500 by using Ground Control key scripts I
created in about 2 hours. If your converting to Vantage, or doing any type
of data loading it would be worth your time and the $39.95 investment.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A
3
Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


[Non-text portions of this message have been removed]
4
Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


[Non-text portions of this message have been removed]
5
I have only used odbc to write reports. Is there anything I should no about
populating a remote table?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, March 25, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


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



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/links
Yahoo! Groups Links
6
You could use your ODBC connection and MS-Access to modify fields via a
query. Do the changes in a test database first and see if there are any
issues. I use Access and ODBC to complement Vantage EDI's shortcomings. I
upload orders with Vantage-EDI from a partner, yet I have to capture the end
user part number for each order line. I use Access to create an 850 document
with our partner's information to be uploaded into Vantage using the EDI
module, and with the same information, I modify with a query the Order,
Pick, Packing Slip, and Invoice fields to show the end customer part number
for each order line - 60 order lines avg. per day.

My suggestion is do these updates in your test database, check for
functionality (no corruptions, etc.) and then do it in your live database.
If you were to use ground control to change a memo field, it will take quite
a while. ODBC could fix this in a matter of minutes. Something to consider
too is the change log. If you want to keep track of the changes, then you
will be better off using ground control.

You could contact me off line to get more details. I use both ODBC and
Ground Control for a lot of projects.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 2:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control

I have only used odbc to write reports. Is there anything I should no about
populating a remote table?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, March 25, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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/>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
>
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
>
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


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



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>
Yahoo! Groups Links








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>



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


[Non-text portions of this message have been removed]
7
You can not update a Comment Field via ODBC. You can't even read it. The field is over 3000 Characters. The Merant ODBC Driver doesnt handle that well.
Thanks
Jeremy


-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 3:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


I have only used odbc to write reports. Is there anything I should no about
populating a remote table?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, March 25, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


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



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/links
Yahoo! Groups Links








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/links
Yahoo! Groups Links
8
I would like to have an example as well.

I assume that you can point it towards the training database for
testing.



Thanks,



John Mansfield

General Sheet Metal





-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 2:28 PM
To: Vantage
Subject: [Vantage] Ground Control




Does anyone have a Ground Control macro that updates part comments from
and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egrou
pweb/S=:HM/A=1945638/rand=223637444>





[Non-text portions of this message have been removed]
9
I actually got it to update, but I only tried manually entering data in one
record. I did get a few errors because the field was too large though.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Thursday, March 25, 2004 6:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


You can not update a Comment Field via ODBC. You can't even read it. The
field is over 3000 Characters. The Merant ODBC Driver doesnt handle that
well.
Thanks
Jeremy


-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 3:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


I have only used odbc to write reports. Is there anything I should no about
populating a remote table?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, March 25, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


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



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/links
Yahoo! Groups Links








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/links
Yahoo! Groups Links








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/links
Yahoo! Groups Links
10
Once one record in the batch returned exceeds 3000 Characters you will no longer be able to access the field for any record. This has long been a frustration for me. I am always dumping data to temp files directly from Progress to avoid this issue. This is an ODBC problem I might have excepted in 1995 but not in 2003. From what I understand, its intercompany feuding between Progress and the original Progress ODBC Driver maker Merant. They went their separate ways and now we are stuck with an ODBC Driver from Progress 9.1A.
Jeremy


-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Friday, March 26, 2004 8:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


I actually got it to update, but I only tried manually entering data in one
record. I did get a few errors because the field was too large though.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Thursday, March 25, 2004 6:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


You can not update a Comment Field via ODBC. You can't even read it. The
field is over 3000 Characters. The Merant ODBC Driver doesnt handle that
well.
Thanks
Jeremy


-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 3:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


I have only used odbc to write reports. Is there anything I should no about
populating a remote table?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, March 25, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ground Control


Part comments could be updated using ODBC. Try in a test database first.

Mario Aguirre
Lakin General

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Thursday, March 25, 2004 1:28 PM
To: Vantage
Subject: [Vantage] Ground Control

Does anyone have a Ground Control macro that updates part comments from and
excel file.

At a minimum, something to get me started.

Thanks in advance.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cdh2js8/M=267637.4673018.5833253.1261774/D=egroup
web/S=1705007183:HM/EXP=1080329275/A=1945638/R=0/SIG=11tq357ai/*http:/www.ne
tflix.com/Default?mqso=60178383&partid=4673018> click here


<http://us.adserver.yahoo.com/l?M=267637.4673018.5833253.1261774/D=egroupweb
/S=:HM/A=1945638/rand=223637444>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


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



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/links
Yahoo! Groups Links








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/links
Yahoo! Groups Links








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/links
Yahoo! Groups Links









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/links
Yahoo! Groups Links
11
I know I have read numerous postings about Vantage users using Ground Control to run reports at night, and various other uses. With Ground Control can you setup new scripts by copying actual keyboard/mouse moves? I have a demo download and don't see a function that will let you do this.

Any help would be appreciated.

Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)
12
yes, you can unfortunately I am do not know how, I have a programmer do it
for me. We use it to make mass changes to the database.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Paul Pachniak [mailto:paul.pachniak@...]
Sent: Tuesday, June 08, 2004 10:32 AM
To: Vantage Group List (E-mail)
Subject: [Vantage] Ground Control


I know I have read numerous postings about Vantage users using Ground
Control to run reports at night, and various other uses. With Ground
Control can you setup new scripts by copying actual keyboard/mouse moves? I
have a demo download and don't see a function that will let you do this.

Any help would be appreciated.

Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)



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/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129pfga03/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086791544/A=2164338/R=0/SIG=11ed4vqbv/*http://www.netf
lix.com/Default?mqso=60183349> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164338/rand=397666121>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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

These are the commands that I use to move the mouse. Unfortunately, I have
to use both in my computer, one to move and the other one to click,
otherwise it will not do it for me (even if I put a delay in front and
after). So I use both and seem to do it very quickly. They are in the left
pane of the screen. Since you are starting, expand all options in this pane
until you get familiar with it. I usually open another ground control and
copy / paste what I need. Get familiar with the send key Insert, Alt+0, etc.
These are Vantage shortcuts that save a lot of mouse movement (i.e. Add a
customer, open the customer window and send the Insert key to add a
customer).

MouseMoveTo(72,483)
MouseLeftButton(Click,72,483)

Good luck!

Mario Aguirre
Lakin General

-----Original Message-----
From: Paul Pachniak [mailto:paul.pachniak@...]
Sent: Tuesday, June 08, 2004 9:32 AM
To: Vantage Group List (E-mail)
Subject: [Vantage] Ground Control

I know I have read numerous postings about Vantage users using Ground
Control to run reports at night, and various other uses. With Ground
Control can you setup new scripts by copying actual keyboard/mouse moves? I
have a demo download and don't see a function that will let you do this.

Any help would be appreciated.

Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)



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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=129pfga03/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086791544/A=2164338/R=0/SIG=11ed4vqbv/*http:/www.netfl
ix.com/Default?mqso=60183349> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164338/rand=397666121>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


[Non-text portions of this message have been removed]
14
I prefer AutoIT version 3. http://www.hiddensoft.com/

I have written a script to convert all the report builder database connection parameters that everyone encounters during upgrades and moves.

It generates a log that show how long each report and each library took, along with the messages encountered during the conversion.
The text is nice to have, because when the connections are made your report can convert without adjustments, convert with automatic adjustments (usually a numeric field width) - these are just Warnings, then there are Errors - where it is unable to convert without manually adjusting something within report builder.

I've been considering making this and other scripts (actually compiled executables) available but I'm not sure if there would be any interest.

Charles
----- Original Message -----
From: Paul Pachniak
To: Vantage Group List (E-mail)
Sent: Tuesday, June 08, 2004 10:32 AM
Subject: [Vantage] Ground Control


I know I have read numerous postings about Vantage users using Ground Control to run reports at night, and various other uses. With Ground Control can you setup new scripts by copying actual keyboard/mouse moves? I have a demo download and don't see a function that will let you do this.

Any help would be appreciated.

Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)



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/links


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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




[Non-text portions of this message have been removed]
15
I use AutoIT as well to automate the running of various programs and
schedule them on a separate PC to run. I also use it for the Purchase
Requisition system to run programs that email users that they have
requisitions to approve, to alert them that their requisition has been
converted to a PO, and to management if there is a requisition over $500
being sent through.
Kristine Pollard
American Turned Products

-----Original Message-----
From: HPN Charles Paluska [mailto:cpaluska@...]
Sent: Tuesday, June 08, 2004 1:23 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Ground Control

I prefer AutoIT version 3. http://www.hiddensoft.com/

I have written a script to convert all the report builder database
connection parameters that everyone encounters during upgrades and
moves.

It generates a log that show how long each report and each library took,
along with the messages encountered during the conversion.
The text is nice to have, because when the connections are made your
report can convert without adjustments, convert with automatic
adjustments (usually a numeric field width) - these are just Warnings,
then there are Errors - where it is unable to convert without manually
adjusting something within report builder.

I've been considering making this and other scripts (actually compiled
executables) available but I'm not sure if there would be any interest.

Charles
----- Original Message -----
From: Paul Pachniak
To: Vantage Group List (E-mail)
Sent: Tuesday, June 08, 2004 10:32 AM
Subject: [Vantage] Ground Control


I know I have read numerous postings about Vantage users using Ground
Control to run reports at night, and various other uses. With Ground
Control can you setup new scripts by copying actual keyboard/mouse
moves? I have a demo download and don't see a function that will let
you do this.

Any help would be appreciated.

Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)



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/links


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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




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




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/links
Yahoo! Groups Links
16
Who makes this product? Is it free? I am looking to automate reports at night. Is this the correct product to use or is there something better?

Thanks

Juliet Martin
Systems Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1119
17
AutoIT is free - open source - you can download and fool around with the code if things get a little slow around the office. Or just download and go.

I like it - It takes a little (very little) getting used to, excellent help with small code samples, website even has user forum - programming is very Pascal like. Biggest issue I have is there isn't a great way to capture an image of an area of the display for comparison purposes.

You can even compile your scripts into EXE files and password encrypt them.

I think I'm AutoIT's biggest fan.

I'm working on another set of scripts for taking scanned bar code data and automatically entering the information into an inventory screen. Along with simultaneously entering it into a different (Un-Vantage) program. All scans - no retyping - just a click - no typos.

I've used it with AS/400's client sessions (MAPICS & BPCS) and automating my investment selection and charting.

The only thing I havent' figured out yet is how to get it to mow the lawn and do laundry.

Charles




----- Original Message -----
From: Juliet Martin
To: vantage@yahoogroups.com
Sent: Wednesday, June 09, 2004 5:21 PM
Subject: [Vantage] Ground Control


Who makes this product? Is it free? I am looking to automate reports at night. Is this the correct product to use or is there something better?

Thanks

Juliet Martin
Systems Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1119



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/links


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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




[Non-text portions of this message have been removed]
18
Does anyone have a ground control macro that I can review that gets
around the vantage menu. Specifically I need to open vantage then have
a report run automatically.

Thanks for any help
Rhonda

Rhonda Reilly
Information Resource Manager
Energy Cranes LLC.
985.893.1818
985.893.1879 fax
19
Hi all,

I know this has been asked before, but can someone direct me to the web
site for Ground Control?



Thanks,



Marilyn Fairchild

Systems Administrator

Pickwick Manufacturing Services







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

Ground Control is offered by Acrasoft - their website is www.acrasoft.com.

It's $40.

Their latest licensing agreement is much more restrictive then the one with
the ancient copy I have.

Just a note - AutoIT is 100% free.

Charles

----- Original Message -----
From: "Marilyn Fairchild" <mfairchild@...>
To: "'Vantage (Vantage List)'" <vantage@yahoogroups.com>
Sent: Wednesday, September 22, 2004 6:05 PM
Subject: [Vantage] Ground Control


> Hi all,
>
> I know this has been asked before, but can someone direct me to the web
> site for Ground Control?
>
>
>
> Thanks,
>
>
>
> Marilyn Fairchild
>
> Systems Administrator
>
> Pickwick Manufacturing Services
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> 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/links
> Yahoo! Groups Links
>
>
>
>
>