It should be non at all. The only references I have made to the Vantage
database are to the following fields which should never change. If epicor
was to ever change these fields it would mean almost a total recodeing of
vantage. I dont see that ever happening. It would be such a nightmare to
change one of these field names that I dont think a programmer would try it.
If it would change, it would be a simple find/replace in the source code in
Visual Basic.
In fact, they way I have it set up now makes fixing it really simple. I use
SQL Server's functionality as a "Linked" server to communicate with the
Progress Database directly. This means I dont have to set up an ODBC driver
for progress on every client workstation. I set up one SQL Server DSN. I
just create views in SQL Server that look like this.
This is with a linked server named PROGRESS
SELECT Orderhed.CustNum, Orderhed.OrderNum, dbo.Customer.Name
FROM OPENQUERY(Progress, 'select * from pub.orderhed') Orderhed
INNER JOIN dbo.Customer ON Orderhed.CustNum = dbo.Customer.CustNum
Vantage Fields I have used in my App:
part.partnum
jobhead.jobnum, jobhead.partnum
orderhed.Ordernum, orderhed.custnum
rmahead.rmanum
pohead.ponum
customer.custnum, customer.custname
vendor.vendornum, vendor.name
-----Original Message-----
From: Mike Gilchrist [mailto:mikeg.ptc@...]
Sent: Thursday, November 07, 2002 3:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic--Document Management
Leonard,
Wow, that's quite a mouthful. Sounds like you have been busy. I think that
if you ever let the source code out of your control someone would try to
sell it! How much work do you have to do at upgrade time?
Mike Gilchrist
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Thursday, November 07, 2002 11:28 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Off Topic--Document Management
We have written our own document management program that interfaces to
Vantage. We have been using it for about 8 months. As of yesterday we
have 15GB of data for 230,000 documents in the system. So far, none have
come up missing. (Knock on wood)
It allows you to scan a document by Part Number, Job Number, Sales Order
Number, Customer, Vendor PO Number and Other. When you choose other, you
can then choose sub types that a user can enter. This saves me from adding
additional groups programmatically. The program has advanced document
scanning functions. It also allows you to attach non-scanned files to those
same groups (Such as drawings or excel files). We use another program
called Document Tracker to view, e-mail and export the files. You have the
ability to copy scanned documents from one group to another with the click
of a mouse. So if you have scanned a document, such as a CERT, for one job
you can copy it to another very easily without having to rescan it. When you
link/scan a document to a Job number it also automatically links that file
to the relevant Part. The file or scanned document is renamed the part
number and the seq number. For example. If I scan part xyz-6534 it would
become xyz-6534-1.tif. The next would be xyz-6534-2.tif and so on. We use
Fujitsu ScanPartner 600C and 620C document scanners. I think we have 8 of
them now. Very fast with automatic document feeders. The QA department
needed to stamp allot of documents so I also developed an secure program for
the inspectors. They are able to bring up a document and place their
inspection stamp anywhere on the document. It also places a date stamp just
under their inspection stamp. We scanned each of their stamps and secured
them so that each time you go into the application it prompts for a
Inspector password.
We looked at several applications to do all this and couldn't find any that
didn't cost a small fortune. Most didn't integrate into Vantage.
The original application was written in Access 2000. I am rolling out a new
version this week in Visual Basic 6.0 that has allot of new functionality.
We us SQL Server 2000 for the backend but MS Access would work just as well.
I am willing to give anyone source code/compiled application at no cost as
long as you don't resell it. You would need someone with a little VB
experience to bring it online. You would also need to purchase the Active X
Controls that I used to scan if you plan on making any changes to the
application.
You can see a few screen shots at www.ktcorp.com/vantage
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: melmike13 [mailto:mikeg.ptc@...]
Sent: Thursday, November 07, 2002 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Off Topic--Document Management
Hi All,
Is anyone using a document management system? I am looking for some
success stories to help me in my justification. After looking at 5
or 6 systems I am just about sold on LaserFiche.
Thanks,
Mike Gilchrist
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 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/
database are to the following fields which should never change. If epicor
was to ever change these fields it would mean almost a total recodeing of
vantage. I dont see that ever happening. It would be such a nightmare to
change one of these field names that I dont think a programmer would try it.
If it would change, it would be a simple find/replace in the source code in
Visual Basic.
In fact, they way I have it set up now makes fixing it really simple. I use
SQL Server's functionality as a "Linked" server to communicate with the
Progress Database directly. This means I dont have to set up an ODBC driver
for progress on every client workstation. I set up one SQL Server DSN. I
just create views in SQL Server that look like this.
This is with a linked server named PROGRESS
SELECT Orderhed.CustNum, Orderhed.OrderNum, dbo.Customer.Name
FROM OPENQUERY(Progress, 'select * from pub.orderhed') Orderhed
INNER JOIN dbo.Customer ON Orderhed.CustNum = dbo.Customer.CustNum
Vantage Fields I have used in my App:
part.partnum
jobhead.jobnum, jobhead.partnum
orderhed.Ordernum, orderhed.custnum
rmahead.rmanum
pohead.ponum
customer.custnum, customer.custname
vendor.vendornum, vendor.name
-----Original Message-----
From: Mike Gilchrist [mailto:mikeg.ptc@...]
Sent: Thursday, November 07, 2002 3:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Off Topic--Document Management
Leonard,
Wow, that's quite a mouthful. Sounds like you have been busy. I think that
if you ever let the source code out of your control someone would try to
sell it! How much work do you have to do at upgrade time?
Mike Gilchrist
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Thursday, November 07, 2002 11:28 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Off Topic--Document Management
We have written our own document management program that interfaces to
Vantage. We have been using it for about 8 months. As of yesterday we
have 15GB of data for 230,000 documents in the system. So far, none have
come up missing. (Knock on wood)
It allows you to scan a document by Part Number, Job Number, Sales Order
Number, Customer, Vendor PO Number and Other. When you choose other, you
can then choose sub types that a user can enter. This saves me from adding
additional groups programmatically. The program has advanced document
scanning functions. It also allows you to attach non-scanned files to those
same groups (Such as drawings or excel files). We use another program
called Document Tracker to view, e-mail and export the files. You have the
ability to copy scanned documents from one group to another with the click
of a mouse. So if you have scanned a document, such as a CERT, for one job
you can copy it to another very easily without having to rescan it. When you
link/scan a document to a Job number it also automatically links that file
to the relevant Part. The file or scanned document is renamed the part
number and the seq number. For example. If I scan part xyz-6534 it would
become xyz-6534-1.tif. The next would be xyz-6534-2.tif and so on. We use
Fujitsu ScanPartner 600C and 620C document scanners. I think we have 8 of
them now. Very fast with automatic document feeders. The QA department
needed to stamp allot of documents so I also developed an secure program for
the inspectors. They are able to bring up a document and place their
inspection stamp anywhere on the document. It also places a date stamp just
under their inspection stamp. We scanned each of their stamps and secured
them so that each time you go into the application it prompts for a
Inspector password.
We looked at several applications to do all this and couldn't find any that
didn't cost a small fortune. Most didn't integrate into Vantage.
The original application was written in Access 2000. I am rolling out a new
version this week in Visual Basic 6.0 that has allot of new functionality.
We us SQL Server 2000 for the backend but MS Access would work just as well.
I am willing to give anyone source code/compiled application at no cost as
long as you don't resell it. You would need someone with a little VB
experience to bring it online. You would also need to purchase the Active X
Controls that I used to scan if you plan on making any changes to the
application.
You can see a few screen shots at www.ktcorp.com/vantage
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: melmike13 [mailto:mikeg.ptc@...]
Sent: Thursday, November 07, 2002 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Off Topic--Document Management
Hi All,
Is anyone using a document management system? I am looking for some
success stories to help me in my justification. After looking at 5
or 6 systems I am just about sold on LaserFiche.
Thanks,
Mike Gilchrist
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 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/