oops.... one thing I just noticed, replace the "cur-comp" on the for query
with your actual "company id". when the export runs from in Vantage, it has
a value for cur-comp. other than that, it should work just fine.
-----Original Message-----
From: Podlin, Michael [mailto:
michael.podlin@...]
Sent: Tuesday, July 29, 2003 2:45 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Automatically Running an Export with the NT
Schedul er
Taking the AR Aging export out of Vantage as the example:
-----------------------------------------
/* this opens a file for the export data */
output to c:\example.txt.
/* this was cut and pasted out of the export utility query tab */
for each InvcHead Where InvcHead.Company = cur-comp
and InvcHead.InvoiceBal <> 0.00 no-lock,
each Customer Where Customer.Company = InvcHead.Company
and Customer.CustNum = InvcHead.CustNum no-lock
By Customer.CustID
By InvcHead.InvoiceNum:
/* this section writes the data to the file (field names taken form the
export utility fields tab) */
put unformatted Customer.Name.
put unformatted ",". /* replace the comma with what you want to use as the
delimiter */
put unformatted InvcHead.InvoiceNum.
put unformatted ",".
put unformatted InvcHead.InvoiceDate.
put unformatted ",".
put unformatted InvcHead.InvoiceAmt.
put unformatted ",".
put unformatted InvcHead.DueDate.
put unformatted ",".
put unformatted InvcHead.InvoiceBal.
put unformatted ",".
put unformatted Customer.PhoneNum skip. /* last field, include a skip to
jump to next line */
end. /* end the for query */
output close. /* close the file */
quit. /* quit the program */
-----------------------------------------------
if the above was saved as a example.p file, then you could copy your
vantage.vtg file to a example.vtg file and edit the mainmenu.w and replace
it with the example.p. then schedule an event to run
"f:\vantage\vantage.exe f:\vantage\example.vtg" hope this helps.
mike
-----Original Message-----
From: Todd Gilbert [mailto:
todd@...]
Sent: Tuesday, July 29, 2003 2:09 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Automatically Running an Export with the NT
Schedul er
Mike,
Can you give an example of how such a procedure would read for a given
export?
Thanks,
Todd Gilbert
-----Original Message-----
From: Podlin, Michael [mailto:
michael.podlin@...]
Sent: Tuesday, July 29, 2003 12:06 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Automatically Running an Export with the NT Schedul
er
You could just write the export functions as .p files/procedures in any text
editor like notepad, and then just use the Windows scheduler to execute the
full Vantage command line using your .p file for the -p parameter at a
specific time of day. This would be a zero cost solution.
-----Original Message-----
From:
michael.j.moloney@...
[mailto:
michael.j.moloney@...]
Sent: Tuesday, July 29, 2003 1:42 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Automatically Running an Export with the NT
Scheduler
I spoke to Epicor Support and they recommended using WinBatch
(www.WinBatch.com) for this. Is anyone else using this or another product
like it?
Thanks:
Mike Moloney
Todd Gilbert
<Todd@altairusa To: Michael J.
Moloney/USWIN01/Power/ALSTOM@GA
.com> cc:
Subject: RE: [Vantage]
Automatically Running an Export with the NT
Schedul er
07/29/2003
11:41 AM
Mike,
If you hear of anything offlist, I'd be very interested. We have several
exports that are run daily.
Thanks,
Todd Gilbert
Altair Technologies, Inc.
-----Original Message-----
From:
michael.j.moloney@...
[mailto:
michael.j.moloney@...]
Sent: Tuesday, July 29, 2003 7:44 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Automatically Running an Export with the NT
Scheduler
Hello group:
Does anyone know of a way to run the exports automatically using the
NT
Scheduler? We need to run one of the exports daily and would like to
automate this process.
Thanks in advance:
Mike Moloney
CONFIDENTIALITY : This e-mail and any attachments are confidential and
may
be privileged. If you are not a named recipient, please notify the
sender
immediately and do not disclose the contents to another person, use it
for
any purpose or store or copy the information in any medium.
Yahoo! Groups Sponsor
ADVERTISEMENT
(Embedded image moved to file: pic21787.gif)
(Embedded image moved to file: pic02156.gif)
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.
CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person,
use it for any purpose or store or copy the information in any medium.
[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>
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
<
http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=17050071
83:HM/A=1663535/R=0/SIG=11ps6rfef/*
http://www.ediets.com/start.cfm?code=3050
4&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egroupmai
l/S=:HM/A=1663535/rand=429496503>
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]
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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/