OK, thanks - I've done .p from buttons I guess - forgot I had one that calculates material based on length/width/gauge and a "factor" and populates main screen. So that part ought to be easy enough. Main worry would be finding "minimum" job date to use to populate the part field. Are these scripts capable of sorting? Or in selecting records are they capable of just retrieving "first" record?
On the other hand I may not need to do this after all. I've figured out how to make a sales report with RB that filters on the minimum job date (pre-pass aggregated) to select only parts where the first job was after a given date. Never used an aggregated value in a filter before.
No problem on the VBFORM thoughts. Interesting ideas. With the customization changes in 6.0/6.1 VBFORM stuff and buttons will be even more powerful.
-Todd C
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, December 03, 2003 3:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
Scripts meaning the .p (procedure) files, there are examples included with
vantage under your \vantage\vbp folder. Look at CalcShipmentWV.p to learn
some of the syntax. Vantage help shows how to execute from a VBForm Button.
This is basic progress programming, if you are not comfortable with it your
macro/manual metheds may be the way to go.
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, December 03, 2003 3:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
Thanks Patrick but I'm lost...what kind of "script"? I'm not super familiar
even with Access or VBFORM buttons for that matter and I'm not sure what a
"script" is. Thanks, -Todd C.
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, December 03, 2003 3:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
I have a theory I would like to add.
It appears to me if you create a script that is ran with a VBFORM button
doesn't this utilize the database write triggers? My tests show that if I
create a script to change the NEEDBY dates by subtracting off the transit
time on order releases and run the script with a VBFORM button. The order
change log picks up the changes, so I figure the write triggers are getting
utilized.
So in your case Todd create the script with a VBFORM Button, put it on the
VBFORMs say under the company table where no one else can get to it, see if
each part change is captured in the change log, you will have to add the
VBFORM field to the change log in version 5.2 or higher. You will not skip
the write triggers and also log the event.
What do you think?
Patrick
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, December 03, 2003 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] User Field - Bulk Loading
OK, I know it is a big no-no but is there much (or any) danger in using
Access and ODBC to bulk load user fields? These are not otherwise validated
anywhere and I don't think would involve any triggers issues (right?). What
I would like to do is update the Date3 field on the Part table with the
earliest job booked date (also a user field on JobHead). New sales
compensation plan for 2004 and beyond is for sales people to "own" parts and
get credit for sales for four years from the first job booking date for the
part. New parts will have this entered but I would like to update Part
table for all existing parts rather than have to have someone enter them.
Or, I have Ground Control but have never used it. Would the safety of using
that outweigh the learning curve? I would have to create some sort of set
of commands from an RB report right?
Thanks in advance for any opinions or suggestions.
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
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/
Yahoo! Groups Sponsor
ADVERTISEMENT
< http://rd.yahoo.com/SIG=12c0r6bff/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1070573611/A=1853618/R=0/* http://www.netflix.com/Def
ault?mqso=60178338&partid=4116732> click here
< http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=946498411>
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 the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
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/
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12csn4l7g/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1070574714/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1853619/rand=432211055>
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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
On the other hand I may not need to do this after all. I've figured out how to make a sales report with RB that filters on the minimum job date (pre-pass aggregated) to select only parts where the first job was after a given date. Never used an aggregated value in a filter before.
No problem on the VBFORM thoughts. Interesting ideas. With the customization changes in 6.0/6.1 VBFORM stuff and buttons will be even more powerful.
-Todd C
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, December 03, 2003 3:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
Scripts meaning the .p (procedure) files, there are examples included with
vantage under your \vantage\vbp folder. Look at CalcShipmentWV.p to learn
some of the syntax. Vantage help shows how to execute from a VBForm Button.
This is basic progress programming, if you are not comfortable with it your
macro/manual metheds may be the way to go.
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, December 03, 2003 3:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
Thanks Patrick but I'm lost...what kind of "script"? I'm not super familiar
even with Access or VBFORM buttons for that matter and I'm not sure what a
"script" is. Thanks, -Todd C.
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, December 03, 2003 3:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User Field - Bulk Loading
I have a theory I would like to add.
It appears to me if you create a script that is ran with a VBFORM button
doesn't this utilize the database write triggers? My tests show that if I
create a script to change the NEEDBY dates by subtracting off the transit
time on order releases and run the script with a VBFORM button. The order
change log picks up the changes, so I figure the write triggers are getting
utilized.
So in your case Todd create the script with a VBFORM Button, put it on the
VBFORMs say under the company table where no one else can get to it, see if
each part change is captured in the change log, you will have to add the
VBFORM field to the change log in version 5.2 or higher. You will not skip
the write triggers and also log the event.
What do you think?
Patrick
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, December 03, 2003 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] User Field - Bulk Loading
OK, I know it is a big no-no but is there much (or any) danger in using
Access and ODBC to bulk load user fields? These are not otherwise validated
anywhere and I don't think would involve any triggers issues (right?). What
I would like to do is update the Date3 field on the Part table with the
earliest job booked date (also a user field on JobHead). New sales
compensation plan for 2004 and beyond is for sales people to "own" parts and
get credit for sales for four years from the first job booking date for the
part. New parts will have this entered but I would like to update Part
table for all existing parts rather than have to have someone enter them.
Or, I have Ground Control but have never used it. Would the safety of using
that outweigh the learning curve? I would have to create some sort of set
of commands from an RB report right?
Thanks in advance for any opinions or suggestions.
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
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/
Yahoo! Groups Sponsor
ADVERTISEMENT
< http://rd.yahoo.com/SIG=12c0r6bff/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1070573611/A=1853618/R=0/* http://www.netflix.com/Def
ault?mqso=60178338&partid=4116732> click here
< http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=946498411>
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 the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
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/
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12csn4l7g/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1070574714/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1853619/rand=432211055>
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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]