Cliff,
Thanks, I knew I was close.
Patrick
---Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Cliff Drumeller
Sent: Tuesday, October 04, 2005 5:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT - 6.1 Personalization
Patrick
You were almost right on.
Proutil db-name -C tabanalys >stats.wri
This will dump you results into a text file.
Cliff
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lydia Coffman
Sent: Tuesday, October 04, 2005 1:46 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] OT - 6.1 Personalization
Hi...
Has anyone out there found a way to resize columns and get it to stay?
I
have several screens that "save settings" doesn't save a resized column (G/L
Account tracker -- drill down to the Journal entry view for a fiscal
period)-- and personalization doesn't ask for column size, only column
order. Will I have to do this in customization?
Thanks,
Lydia
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, October 04, 2005 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] File definitions-fields-number of records
Ann,
There is a progress command you can run to get the number of records in each
table.
I forget what the command was but you should be able to call Epicor and get
it.
It is used to display the scatter factor for each table in determining
weather or not to do a dump and load. On of the first columns of the output
is the number of records per table.
Ask tech support for one of the dump and load experts and ask to see the
scatter factor for each table is. I remember you can run the command on a
live database. I will keep searching my records for the syntax of the
command it was something like.
Proutil db-name -C tabanalys
Try it on your training database to be safe.
Patrick Winter
Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
8.5.3.975
RECORD BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
-Record Size (B)- ---Fragments---
Scatter
Table Records Size Min Max Mean Count Factor
Factor
PUB.ABCCode 5 166.0B 28 35 33 5 1.0
1.0
PUB.AgingRptFmt 6 743.0B 123 125 123 6 1.0
1.0
PUB.AlertGroup 1 60.0B 60 60 60 1 1.0
1.0
PUB.AlertLog 0 0.0B 0 0 0 0 0.0
0.0
PUB.AlertQue 0 0.0B 0 0 0 0 0.0
0.0
PUB.AllocPri 0 0.0B 0 0 0 0 0.0
0.0
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sarah.vareschi@...
Sent: Tuesday, October 04, 2005 1:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] File definitions-fields-number of records
Data dictionary will give you: "File definitions - a listing of each file,
the fields contained in the file". You can save it electronically to a pdf
and send it to them.
As far as # of records in each table, I do not know of a file that will do
this (although that doesn't mean there isn't one). Do they really need to
know # of records in every table or only the active records that you would
have to transfer? You would probably need to run reports on your tables to
come up with this. Same thing for open orders, po's and jobs, would need to
run a report to determine.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
amfabllc
Sent: Wednesday, September 28, 2005 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] File definitions-fields-number of records
Our mother company has requested that I supply them with the following
information for future data conversion estimated costs to another ERP
system. We are doing as much as possible to stay on Vantage (we have 10
years of history on it). I will continue to work towards a Vantage upgrade
and barcoding until I have been told that we must make the change.
Management at our facility is backing Vantage.
Regardless, I need to supply them with the information in a timely manner.
Our DB is over 4 GB. I was hoping someone could point me in the right
direction to find the information they are requesting.
Possibly the tables to use in Report Builder or which reports out of data
dictionary - what will supply me with information and record counts from the
actual data in our db.
Information requested: "File definitions - a listing of each file, the
fields contained in the file, and the number of records. Also I need the
average length of an open order and an open PO. We want to determine what
files we'll electronically convert, which ones we may key, and how we'll
handle the transaction files such as open orders."
All help is greatly appreciated - online or off - you are welcome to call
me.
Thanks!
Ann Rohyans
AMFAB
574-264-4431
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
SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A> Database
mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw> Online
database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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]
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
Thanks, I knew I was close.
Patrick
---Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Cliff Drumeller
Sent: Tuesday, October 04, 2005 5:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT - 6.1 Personalization
Patrick
You were almost right on.
Proutil db-name -C tabanalys >stats.wri
This will dump you results into a text file.
Cliff
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lydia Coffman
Sent: Tuesday, October 04, 2005 1:46 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] OT - 6.1 Personalization
Hi...
Has anyone out there found a way to resize columns and get it to stay?
I
have several screens that "save settings" doesn't save a resized column (G/L
Account tracker -- drill down to the Journal entry view for a fiscal
period)-- and personalization doesn't ask for column size, only column
order. Will I have to do this in customization?
Thanks,
Lydia
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, October 04, 2005 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] File definitions-fields-number of records
Ann,
There is a progress command you can run to get the number of records in each
table.
I forget what the command was but you should be able to call Epicor and get
it.
It is used to display the scatter factor for each table in determining
weather or not to do a dump and load. On of the first columns of the output
is the number of records per table.
Ask tech support for one of the dump and load experts and ask to see the
scatter factor for each table is. I remember you can run the command on a
live database. I will keep searching my records for the syntax of the
command it was something like.
Proutil db-name -C tabanalys
Try it on your training database to be safe.
Patrick Winter
Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
8.5.3.975
RECORD BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
-Record Size (B)- ---Fragments---
Scatter
Table Records Size Min Max Mean Count Factor
Factor
PUB.ABCCode 5 166.0B 28 35 33 5 1.0
1.0
PUB.AgingRptFmt 6 743.0B 123 125 123 6 1.0
1.0
PUB.AlertGroup 1 60.0B 60 60 60 1 1.0
1.0
PUB.AlertLog 0 0.0B 0 0 0 0 0.0
0.0
PUB.AlertQue 0 0.0B 0 0 0 0 0.0
0.0
PUB.AllocPri 0 0.0B 0 0 0 0 0.0
0.0
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sarah.vareschi@...
Sent: Tuesday, October 04, 2005 1:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] File definitions-fields-number of records
Data dictionary will give you: "File definitions - a listing of each file,
the fields contained in the file". You can save it electronically to a pdf
and send it to them.
As far as # of records in each table, I do not know of a file that will do
this (although that doesn't mean there isn't one). Do they really need to
know # of records in every table or only the active records that you would
have to transfer? You would probably need to run reports on your tables to
come up with this. Same thing for open orders, po's and jobs, would need to
run a report to determine.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
amfabllc
Sent: Wednesday, September 28, 2005 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] File definitions-fields-number of records
Our mother company has requested that I supply them with the following
information for future data conversion estimated costs to another ERP
system. We are doing as much as possible to stay on Vantage (we have 10
years of history on it). I will continue to work towards a Vantage upgrade
and barcoding until I have been told that we must make the change.
Management at our facility is backing Vantage.
Regardless, I need to supply them with the information in a timely manner.
Our DB is over 4 GB. I was hoping someone could point me in the right
direction to find the information they are requesting.
Possibly the tables to use in Report Builder or which reports out of data
dictionary - what will supply me with information and record counts from the
actual data in our db.
Information requested: "File definitions - a listing of each file, the
fields contained in the file, and the number of records. Also I need the
average length of an open order and an open PO. We want to determine what
files we'll electronically convert, which ones we may key, and how we'll
handle the transaction files such as open orders."
All help is greatly appreciated - online or off - you are welcome to call
me.
Thanks!
Ann Rohyans
AMFAB
574-264-4431
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
SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A> Database
mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw> Online
database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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]
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