File definitions-fields-number of records

Yahoo Archive
1
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
2
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
3
Go into the Progress Tool called "Data Dictionary" and look under menu
item "Database" - "Reports". Make sure the tool is hooked up to a
Vantage database -- works alot better this way. ; )

And you might want to be careful which reports you send to the printer.

Jeff Lewis

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of amfabllc
Sent: Wednesday, September 28, 2005 9: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


[Non-text portions of this message have been removed]
4
I have generated some good reports here, Thank you. (I already have
a report that shows the size of each file extent in the db folder.)
The final thing I would like to try to get is how many records AMFAB
has in each table. Is that even possible?

Thanks much!
Ann Rohyans
AMFAB
574-264-4431
amfab@...

--- In vantage@yahoogroups.com, "Jeff Lewis" <jeff@h...> wrote:
> Go into the Progress Tool called "Data Dictionary" and look under
menu
> item "Database" - "Reports". Make sure the tool is hooked up to a
> Vantage database -- works alot better this way. ; )
>
> And you might want to be careful which reports you send to the
printer.
>
> Jeff Lewis
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of amfabllc
> Sent: Wednesday, September 28, 2005 9: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
>
>
> [Non-text portions of this message have been removed]
5
I was interested in this so I wrote a program to list each table,
field and record count. The dialog lets you choose which table to
start and end with.

I am about to upload the source code to the file section.

If you or anyone wishes to run it, I would suggest linking it to your
training database. I would think it would take a few hours to run
for all.

If questions, email ldrew@..., and I'll respond this
evening.

Good luck,
Lonnie

--- In vantage@yahoogroups.com, "amfabllc" <amfab@a...> wrote:
> I have generated some good reports here, Thank you. (I already
have
> a report that shows the size of each file extent in the db folder.)
> The final thing I would like to try to get is how many records
AMFAB
> has in each table. Is that even possible?
>
> Thanks much!
> Ann Rohyans
> AMFAB
> 574-264-4431
> amfab@a...
>
> --- In vantage@yahoogroups.com, "Jeff Lewis" <jeff@h...> wrote:
> > Go into the Progress Tool called "Data Dictionary" and look under
> menu
> > item "Database" - "Reports". Make sure the tool is hooked up to
a
> > Vantage database -- works alot better this way. ; )
> >
> > And you might want to be careful which reports you send to the
> printer.
> >
> > Jeff Lewis
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of amfabllc
> > Sent: Wednesday, September 28, 2005 9: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
> >
> >
> > [Non-text portions of this message have been removed]
6
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