Digest Number 1105

Please remove me from Vantage digest posts.
Thanks Dana Barth

vantage@egroups.com wrote:

> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
> ------------------------------------------------------------------------
>
> There are 25 messages in this issue.
>
> Topics in this digest:
>
> 1. RE: Report Builder
> From: "Kathy Hambleton" <kbh@...>
> 2. Report Builder
> From: "Charles Metcalf" <chuck_metcalf@...>
> 3. Re: Changing Costing Methods
> From: "Steve Ashton" <steve_universal@...>
> 4. RE: Report Builder
> From: "Jim Stetter" <jimstetter@...>
> 5. Re: Report Builder
> From: "calvin" <calvin@...>
> 6. test
> From: "Michael Newey" <michael@...>
> 7. copying a database
> From: "Reilly, Rhonda" <rreilly@...>
> 8. Re: copying a database
> From: "calvin" <calvin@...>
> 9. Re: copying a database
> From: "Jim MacMillan" <jimmac@...>
> 10. Crystal Reports v8.0
> From: "Wendy Bowen (Pursche)" <wpursche@...>
> 11. Getting Data Out of Vantage
> From: "Danny Spell" <danny.spell@...>
> 12. RE: Crystal Reports v8.0
> From: "Eddy, Warren" <warren.eddy@...>
> 13. RE: copying a database
> From: Brian Boyes <brianb@...>
> 14. RE: Crystal Reports v8.0
> From: "Gitzlaff, Christopher" <cgitzlaff@...>
> 15. Re: Crystal Reports v8.0
> From: rgors <rgors@...>
> 16. Re: copying a database
> From: Wayne Cox <wmc@...>
> 17. Re: Crystal Reports v8.0
> From: "Wendy Bowen (Pursche)" <wpursche@...>
> 18. Re: copying a database
> From: William Colls <william@...>
> 19. Re: copying a database
> From: "Jim MacMillan" <jimmac@...>
> 20. RE: Crystal Reports v8.0
> From: Jill Seath <JillSeath@...>
> 21. Re: Crystal Reports v8.0
> From: "Troy Funte" <tfunte@...>
> 22. Report Builder link help
> From: "amfab" <amfab@...>
> 23. Re: Crystal Reports v8.0
> From: "Tim Care" <ecfmis@...>
> 24. RE: Report Builder link help
> From: "Terry Williams" <tlw@...>
> 25. New file uploaded to vantage
> From: <vantage@egroups.com>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 1
> Date: Fri, 12 Jan 2001 08:18:50 -0500
> From: "Kathy Hambleton" <kbh@...>
> Subject: RE: Report Builder
>
> That report would certainly help me. Could you post it or send it to me
> directly?
>
> Thanks,
> Kathy Hambleton
> Electron Energy Corporation
> 717-898-2294
> kbh@...
>
> -----Original Message-----
> From: Lydia Coffman [mailto:lcoffman@...]
> Sent: Thursday, January 11, 2001 5:23 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> Charles:
>
> I have a report that shows a summary of the status of each op and assembly
> on a job. Would that help you?
>
> Lydia
> lcoffman@...
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 2
> Date: Fri, 12 Jan 2001 13:35:21 -0000
> From: "Charles Metcalf" <chuck_metcalf@...>
> Subject: Report Builder
>
> I cannot remember who pointed me in this direction, but it really
> helped. Now I have another question. This formula "SUBSTRING
> (MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
> MemoText field to the first carriage return. How would the formula be
> revised to skip the text before the first carriage return and then
> print the text after the first carriage return
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 3
> Date: Fri, 12 Jan 2001 08:46:01 -0500
> From: "Steve Ashton" <steve_universal@...>
> Subject: Re: Changing Costing Methods
>
> Inquire about the Vantage Tool called Master File Import/Export/Copy Utility from Custom Programming. It will allow you to export the Part Master File and open it as an xls file, so that you can use the replace function to mass-change "A" with "S". You can then use the utility to import the modified file back.
>
> Our consultant wrote us a lengthy email detailing this and other methods, and the pro's and con's of each method. (The above method does not leave an audit trail.) For more information, contact Ann Bollmeier at abollmeier@...
>
> ----- Original Message -----
> From: Denise Brown
> To: vantage@egroups.com
> Sent: Wednesday, January 10, 2001 9:10 AM
> Subject: [Vantage] Changing Costing Methods
>
> We're running Vantage 4.0, and currently have our purchased parts set
> up using Average costing and everything else is set to Standard
> costing. We want to change to using Standard for everything. I'm
> told that to accomplish this, we'll need to go into each part
> individually that we want to change, and zero out the quantities,
> change the costing method, and then add the quantity back in. Does
> anyone know of an easier way to do this?
> Thanks!
> Denise Brown
>
> eGroups Sponsor
>
> Click here for Business information
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
>
> [Non-text portions of this message have been removed]
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 4
> Date: Fri, 12 Jan 2001 08:50:28 -0500
> From: "Jim Stetter" <jimstetter@...>
> Subject: RE: Report Builder
>
> Chuck,
>
> To extract the text after the first carriage return:
>
> SUBSTRING(MemoText, INDEX(MemoText, CHR(10))+1, LENGTH(MemoText))"
>
> Regards
> Jim Stetter
> -----Original Message-----
> From: Charles Metcalf [mailto:chuck_metcalf@...]
> Sent: Friday, January 12, 2001 8:35 AM
> To: vantage@egroups.com
> Subject: [Vantage] Report Builder
>
> I cannot remember who pointed me in this direction, but it really
> helped. Now I have another question. This formula "SUBSTRING
> (MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
> MemoText field to the first carriage return. How would the formula be
> revised to skip the text before the first carriage return and then
> print the text after the first carriage return
>
> [Non-text portions of this message have been removed]
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 5
> Date: Fri, 12 Jan 2001 07:54:44 -0600
> From: "calvin" <calvin@...>
> Subject: Re: Report Builder
>
> Charles -
>
> Create two calculated fields
> The first field extracts the portion from position 1 to the first carriage
> return.
>
> cfFirstPart = "SUBSTRING(MemoText, 1, INDEX(MemoText, CHR(10)))"
>
> The second field extract the portion from the 1st character after the 1st
> carriage return to the second carriage return.
>
> cfSecondPart = "SUBSTRING(MemoText, (INDEX(MemoText, CHR(10)) + 1),
> INDEX(MemoText, CHR(10), 2))"
>
> HTH,
> Calvin
>
> ----- Original Message -----
> From: Charles Metcalf <chuck_metcalf@...>
> To: <vantage@egroups.com>
> Sent: Friday, January 12, 2001 7:35 AM
> Subject: [Vantage] Report Builder
>
> > I cannot remember who pointed me in this direction, but it really
> > helped. Now I have another question. This formula "SUBSTRING
> > (MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
> > MemoText field to the first carriage return. How would the formula be
> > revised to skip the text before the first carriage return and then
> > print the text after the first carriage return
> >
> >
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 6
> Date: Fri, 12 Jan 2001 09:09:47 -0500
> From: "Michael Newey" <michael@...>
> Subject: test
>
> test
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 7
> Date: Fri, 12 Jan 2001 08:42:47 -0600
> From: "Reilly, Rhonda" <rreilly@...>
> Subject: copying a database
>
> I have read before that when you want to make a quick copy of a database
> that you shutdown the database in procontrol and copy the db and the bi
> files. My question is. Do I have to shut down procontrol. I have one
> database I need to copy but want to leave the others running. So can I just
> shut down the one I want to copy.
>
> Thanks
> Rhonda
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 8
> Date: Fri, 12 Jan 2001 08:47:57 -0600
> From: "calvin" <calvin@...>
> Subject: Re: copying a database
>
> Rhonda -
>
> Yes.
> Just stop the database that you wish to copy.
>
> calvin
>
> ----- Original Message -----
> From: Reilly, Rhonda <rreilly@...>
> To: <vantage@egroups.com>
> Sent: Friday, January 12, 2001 8:42 AM
> Subject: [Vantage] copying a database
>
> >
> > I have read before that when you want to make a quick copy of a database
> > that you shutdown the database in procontrol and copy the db and the bi
> > files. My question is. Do I have to shut down procontrol. I have one
> > database I need to copy but want to leave the others running. So can I
> just
> > shut down the one I want to copy.
> >
> > Thanks
> > Rhonda
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 9
> Date: Fri, 12 Jan 2001 07:43:35 -0700
> From: "Jim MacMillan" <jimmac@...>
> Subject: Re: copying a database
>
> Rhonda,
>
> I copy my database many times throughout the day and never shut the database
> down. In fact users are in the database when I copy it. I have never had
> any problems doing it this way.
>
> Jim MacMillan
> System Administrator
> Sales/Marketing
> Scientific Dimensions
> 800-523-6180
> jimmac@...
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 10
> Date: Fri, 12 Jan 2001 10:00:46 -0500
> From: "Wendy Bowen (Pursche)" <wpursche@...>
> Subject: Crystal Reports v8.0
>
> Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the eManufacturing upgrade. Do I need the Standard, Professional, or Developer's edition? Currently, I have the standard edition for customizing. I'm assuming that the Standard 8.0 is the same?
>
> Wendy Bowen (Pursche)
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@...
>
> [Non-text portions of this message have been removed]
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 11
> Date: Fri, 12 Jan 2001 15:13:46 -0000
> From: "Danny Spell" <danny.spell@...>
> Subject: Getting Data Out of Vantage
>
> What is the best way to get data out of Vantage? I need an automated
> way of pulling data of multiple Vantage/Progress DBs into an Access
> DB.
>
> Thanks
> -- Danny
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 12
> Date: Fri, 12 Jan 2001 09:13:11 -0600
> From: "Eddy, Warren" <warren.eddy@...>
> Subject: RE: Crystal Reports v8.0
>
> Wendy;
>
> When I bought (not using yet) CR v8.0, I was told, the differences between
> the 3 are:
>
> Standard is single user
>
> Professional I believe gives you 5 licenses and more functionality
>
> Developer Provides the greatest functionality, more
> programming and the multiple users
>
> This isn't necessarily total fact but the best that I have. We have found
> the best pricing from a mail order place called Programmers Paradise. Web
> site is programmersparadise.com.
>
> Warren R. Eddy
>
> Information Services Manager
>
> National Tube Form, LLC
>
> An Excaliber Company
>
> e-mail - Warren.Eddy@...
>
> phone - 219 478-2363 ext 217
>
> fax - 219 478-1043
>
> -----Original Message-----
> From: Wendy Bowen (Pursche
>
> [mailto:wpursche@...]
> Sent: Friday, January 12, 2001 10:01 AM
> To: Vantage egroups list
> Subject: [Vantage] Crystal Reports v8.0
>
> Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the
> eManufacturing upgrade. Do I need the Standard, Professional, or
> Developer's edition? Currently, I have the standard edition for
> customizing. I'm assuming that the Standard 8.0 is the same?
>
> Wendy Bowen (Pursche)
>
> Network Administrator
>
> Schmald Tool & Die, Inc.
>
> (810) 743-1600 ext.323
>
> wpursche@...
>
> [Non-text portions of this message have been removed]
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
>
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 13
> Date: Fri, 12 Jan 2001 10:17:30 -0500
> From: Brian Boyes <brianb@...>
> Subject: RE: copying a database
>
> > I copy my database many times throughout the day and never
> > shut the database
> > down.
> This is just a question and is not meant to be a criticism, but
> theoretically, is there any chance that you could wind up with a corrupted
> database doing it this way? For example, if the system was in the middle of
> a transaction when you did the copy?
>
> It figure its usually safer (although slower) to make an online backup and
> restore it.
>
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 14
> Date: Fri, 12 Jan 2001 09:22:28 -0600
> From: "Gitzlaff, Christopher" <cgitzlaff@...>
> Subject: RE: Crystal Reports v8.0
>
> Warren,
>
> Standard and Professional are both single user licenses. Standard works
> fine for modifying the custom reports in Vantage. If you want to do reports
> directly from the Progress database via ODBC, you need the Professional
> version. ODBC access isn't available in the Standard Version. I'm not sure
> what else they added in the Developer version.
>
> Christopher Gitzlaff
> Manager - Information Systems & Technology
> Major Industries, Inc.
> 715.842.4616
> cgitzlaff@...
>
> -----Original Message-----
> From: Eddy, Warren [mailto:warren.eddy@...]
> Sent: Friday, January 12, 2001 9:13 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Crystal Reports v8.0
>
> Wendy;
>
> When I bought (not using yet) CR v8.0, I was told, the differences between
> the 3 are:
>
> Standard is single user
>
> Professional I believe gives you 5 licenses and more functionality
>
> Developer Provides the greatest functionality, more
> programming and the multiple users
>
> This isn't necessarily total fact but the best that I have. We have found
> the best pricing from a mail order place called Programmers Paradise. Web
> site is programmersparadise.com.
>
> Warren R. Eddy
>
> Information Services Manager
>
> National Tube Form, LLC
>
> An Excaliber Company
>
> e-mail - Warren.Eddy@...
>
> phone - 219 478-2363 ext 217
>
> fax - 219 478-1043
>
> -----Original Message-----
> From: Wendy Bowen (Pursche
>
> [mailto:wpursche@...]
> Sent: Friday, January 12, 2001 10:01 AM
> To: Vantage egroups list
> Subject: [Vantage] Crystal Reports v8.0
>
> Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the
> eManufacturing upgrade. Do I need the Standard, Professional, or
> Developer's edition? Currently, I have the standard edition for
> customizing. I'm assuming that the Standard 8.0 is the same?
>
> Wendy Bowen (Pursche)
>
> Network Administrator
>
> Schmald Tool & Die, Inc.
>
> (810) 743-1600 ext.323
>
> wpursche@...
>
> [Non-text portions of this message have been removed]
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
>
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 15
> Date: Fri, 12 Jan 2001 10:25:40 -0500
> From: rgors <rgors@...>
> Subject: Re: Crystal Reports v8.0
>
> The Pro version works peachy...in an apples-to-oranges sort of way.
>
> Rick Gors
> MR/MMIS
> Osco
>
> "Wendy Bowen (Pursche)" wrote:
> >
> > Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the eManufacturing upgrade. Do I need the Standard, Professional, or Developer's edition? Currently, I have the standard edition for customizing. I'm assuming that the Standard 8.0 is the same?
> >
> > Wendy Bowen (Pursche)
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@...
> >
> > [Non-text portions of this message have been removed]
> >
> > We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 16
> Date: Fri, 12 Jan 2001 10:27:20 -0500
> From: Wayne Cox <wmc@...>
> Subject: Re: copying a database
>
> At 09:43 AM 1/12/2001 , you wrote:
> >I copy my database many times throughout the day and never shut the database
> >down. In fact users are in the database when I copy it. I have never had
> >any problems doing it this way.
>
> Jim, I'm no Progress expert, but I find it really hard to believe that that
> is a guaranteed accurate and safe way of copying the data. At best, I
> suspect the database server has to process the copy as if the system had
> crashed, or other wise been improperly shutdown. Have you checked the .LG
> file after restarting to see how it handled it? Recovery and fault
> tolerance are part of the product, but I wouldn't want to rely on them if
> that were my only backup!
>
> If you're just taking snapshots to have a reporting or training database,
> and it seems to be working, then there's no harm done. But I hope you're
> doing your actual backups "by the book."
>
> -Wayne Cox
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 17
> Date: Fri, 12 Jan 2001 10:24:44 -0500
> From: "Wendy Bowen (Pursche)" <wpursche@...>
> Subject: Re: Crystal Reports v8.0
>
> Hmmm, it looks like we will just get the standard again. I would like to
> get the Professional so we could integrate the Progress ODBC driver but I
> know I have to end up getting the cheaper version anyway!
>
> Thanks!
>
> Wendy Bowen (Pursche)
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@...
>
> ----- Original Message -----
> From: Gitzlaff, Christopher <cgitzlaff@...>
> To: <vantage@egroups.com>
> Sent: Friday, January 12, 2001 10:22 AM
> Subject: RE: [Vantage] Crystal Reports v8.0
>
> > Warren,
> >
> > Standard and Professional are both single user licenses. Standard works
> > fine for modifying the custom reports in Vantage. If you want to do
> reports
> > directly from the Progress database via ODBC, you need the Professional
> > version. ODBC access isn't available in the Standard Version. I'm not
> sure
> > what else they added in the Developer version.
> >
> > Christopher Gitzlaff
> > Manager - Information Systems & Technology
> > Major Industries, Inc.
> > 715.842.4616
> > cgitzlaff@...
> >
> >
> > -----Original Message-----
> > From: Eddy, Warren [mailto:warren.eddy@...]
> > Sent: Friday, January 12, 2001 9:13 AM
> > To: 'vantage@egroups.com'
> > Subject: RE: [Vantage] Crystal Reports v8.0
> >
> >
> > Wendy;
> >
> > When I bought (not using yet) CR v8.0, I was told, the differences between
> > the 3 are:
> >
> > Standard is single user
> >
> > Professional I believe gives you 5 licenses and more functionality
> >
> > Developer Provides the greatest functionality, more
> > programming and the multiple users
> >
> >
> >
> > This isn't necessarily total fact but the best that I have. We have found
> > the best pricing from a mail order place called Programmers Paradise. Web
> > site is programmersparadise.com.
> >
> >
> >
> > Warren R. Eddy
> >
> > Information Services Manager
> >
> > National Tube Form, LLC
> >
> > An Excaliber Company
> >
> > e-mail - Warren.Eddy@...
> >
> > phone - 219 478-2363 ext 217
> >
> > fax - 219 478-1043
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Wendy Bowen (Pursche
> >
> > [mailto:wpursche@...]
> > Sent: Friday, January 12, 2001 10:01 AM
> > To: Vantage egroups list
> > Subject: [Vantage] Crystal Reports v8.0
> >
> >
> > Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the
> > eManufacturing upgrade. Do I need the Standard, Professional, or
> > Developer's edition? Currently, I have the standard edition for
> > customizing. I'm assuming that the Standard 8.0 is the same?
> >
> >
> >
> > Wendy Bowen (Pursche)
> >
> > Network Administrator
> >
> > Schmald Tool & Die, Inc.
> >
> > (810) 743-1600 ext.323
> >
> > wpursche@...
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> > please go to the following link: http://www.egroups.com/files/vantage/
> >
> > (Note: If this link does not work for you the first time you try it, go
> to
> > www.egroups.com, login and be sure to save your password, choose My
> Groups,
> > choose Vantage, then choose Files. If you save the password, the link
> above
> > will work the next time you try it.)
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> > please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to
> > www.egroups.com, login and be sure to save your password, choose My
> Groups,
> > choose Vantage, then choose Files. If you save the password, the link
> above
> > will work the next time you try it.)
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 18
> Date: Fri, 12 Jan 2001 10:36:05 -0500
> From: William Colls <william@...>
> Subject: Re: copying a database
>
> Yes, if you have a large database that has a very high write activity.
>
> However, in many cases, after copying a running database using an OS copy utility, when you start the copy, progress will see it as a crashed data base, and go through a crash recovery.
>
> Also note: this discussion only applies to a single volume progress V8 data base. Multi volume data bases (V8 or V9) have special rules; all V9 databases are multi volume.
>
> Brian Boyes wrote:
>
> > > I copy my database many times throughout the day and never
> > > shut the database
> > > down.
> > This is just a question and is not meant to be a criticism, but
> > theoretically, is there any chance that you could wind up with a corrupted
> > database doing it this way? For example, if the system was in the middle of
> > a transaction when you did the copy?
> >
> > It figure its usually safer (although slower) to make an online backup and
> > restore it.
> >
> > Brian Boyes,
> > Systems Administrator,
> > Precision Resource Canada Ltd.
> > <http://www.precisionresource.com>
> > <mailto:brianb@...>
> >
> > We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
>
> --
> /* ============================================================== */
>
> William E. Colls Tel 613 591 0079
> PROComputer Systems Fax 613 591 3924
> 67 Willow Glen Dr www.procomsys.com
> Kanata Ontario Canada PEG Member 1998051404
>
> Specialists in Progress Software development since 1985
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 19
> Date: Fri, 12 Jan 2001 08:29:05 -0700
> From: "Jim MacMillan" <jimmac@...>
> Subject: Re: copying a database
>
> Brian,
>
> There have been instances when I have taken this copied database and put it
> into the test database and have had users do testing to learn something in
> Vantage. We are still learning the potential of Vantage and find this to be
> a great way to learn. I have yet to get any errors when running the
> prostrct utility to restore the database this way. Maybe I am lucky so far
> and you are correct, but it seems to be working for me. I also should point
> out I dont depend on this for my backup, its merely for other occasions. I
> am sorry I should have included that part in my first email.
>
> Sorry for the confusion
>
> Jim MacMillan
> System Administrator
> Sales/Marketing
> Scientific Dimensions
> 800-523-6180
> jimmac@...
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 20
> Date: Fri, 12 Jan 2001 16:41:49 -0000
> From: Jill Seath <JillSeath@...>
> Subject: RE: Crystal Reports v8.0
>
> We ugraded to 8 professional by choice, but no one said it was essential
> Sophie
>
> > -----Original Message-----
> > From: Wendy Bowen (Pursche) [SMTP:wpursche@...]
> > Sent: 12 January 2001 15:01
> > To: Vantage egroups list
> > Subject: [Vantage] Crystal Reports v8.0
> >
> > Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for
> > the eManufacturing upgrade. Do I need the Standard, Professional, or
> > Developer's edition? Currently, I have the standard edition for
> > customizing. I'm assuming that the Standard 8.0 is the same?
> >
> > Wendy Bowen (Pursche)
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@...
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > eGroups Sponsor
> > Click Here!
> > <http://rd.yahoo.com/M=169066.1281467.2883016.2/D=egroupmail/S=1700007
> > 183:N/A=560434/*http://cgi.timeinc.net/cgi-bin/magsubs/cc/subs/ecompan
> > ynowcc1?EFFORTKEY=ECAAQQ1>
> >
> > We no longer allow attachments to files. To access/share Report
> > Files, please go to the following link:
> > <http://www.egroups.com/files/vantage/>
> > (Note: If this link does not work for you the first time you try it,
> > go to www.egroups.com, login and be sure to save your password, choose
> > My Groups, choose Vantage, then choose Files. If you save the
> > password, the link above will work the next time you try it.)
> >
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 21
> Date: Fri, 12 Jan 2001 10:47:31 -0800
> From: "Troy Funte" <tfunte@...>
> Subject: Re: Crystal Reports v8.0
>
> If you plan to customize reports much, you'll want the Professional version. It also includes the Web Component Server for giving people better access to reports, but that part needs a separate machine.
>
> You can do some powerful things with Crystal Professional, though.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Wendy Bowen (Pursche)
> To: vantage@egroups.com
> Sent: Friday, January 12, 2001 7:24 AM
> Subject: Re: [Vantage] Crystal Reports v8.0
>
> Hmmm, it looks like we will just get the standard again. I would like to
> get the Professional so we could integrate the Progress ODBC driver but I
> know I have to end up getting the cheaper version anyway!
>
> Thanks!
>
> Wendy Bowen (Pursche)
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@...
>
> ----- Original Message -----
> From: Gitzlaff, Christopher <cgitzlaff@...>
> To: <vantage@egroups.com>
> Sent: Friday, January 12, 2001 10:22 AM
> Subject: RE: [Vantage] Crystal Reports v8.0
>
> > Warren,
> >
> > Standard and Professional are both single user licenses. Standard works
> > fine for modifying the custom reports in Vantage. If you want to do
> reports
> > directly from the Progress database via ODBC, you need the Professional
> > version. ODBC access isn't available in the Standard Version. I'm not
> sure
> > what else they added in the Developer version.
> >
> > Christopher Gitzlaff
> > Manager - Information Systems & Technology
> > Major Industries, Inc.
> > 715.842.4616
> > cgitzlaff@...
> >
> >
> > -----Original Message-----
> > From: Eddy, Warren [mailto:warren.eddy@...]
> > Sent: Friday, January 12, 2001 9:13 AM
> > To: 'vantage@egroups.com'
> > Subject: RE: [Vantage] Crystal Reports v8.0
> >
> >
> > Wendy;
> >
> > When I bought (not using yet) CR v8.0, I was told, the differences between
> > the 3 are:
> >
> > Standard is single user
> >
> > Professional I believe gives you 5 licenses and more functionality
> >
> > Developer Provides the greatest functionality, more
> > programming and the multiple users
> >
> >
> >
> > This isn't necessarily total fact but the best that I have. We have found
> > the best pricing from a mail order place called Programmers Paradise. Web
> > site is programmersparadise.com.
> >
> >
> >
> > Warren R. Eddy
> >
> > Information Services Manager
> >
> > National Tube Form, LLC
> >
> > An Excaliber Company
> >
> > e-mail - Warren.Eddy@...
> >
> > phone - 219 478-2363 ext 217
> >
> > fax - 219 478-1043
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Wendy Bowen (Pursche
> >
> > [mailto:wpursche@...]
> > Sent: Friday, January 12, 2001 10:01 AM
> > To: Vantage egroups list
> > Subject: [Vantage] Crystal Reports v8.0
> >
> >
> > Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the
> > eManufacturing upgrade. Do I need the Standard, Professional, or
> > Developer's edition? Currently, I have the standard edition for
> > customizing. I'm assuming that the Standard 8.0 is the same?
> >
> >
> >
> > Wendy Bowen (Pursche)
> >
> > Network Administrator
> >
> > Schmald Tool & Die, Inc.
> >
> > (810) 743-1600 ext.323
> >
> > wpursche@...
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> > please go to the following link: http://www.egroups.com/files/vantage/
> >
> > (Note: If this link does not work for you the first time you try it, go
> to
> > www.egroups.com, login and be sure to save your password, choose My
> Groups,
> > choose Vantage, then choose Files. If you save the password, the link
> above
> > will work the next time you try it.)
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> > please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to
> > www.egroups.com, login and be sure to save your password, choose My
> Groups,
> > choose Vantage, then choose Files. If you save the password, the link
> above
> > will work the next time you try it.)
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
>
> eGroups Sponsor
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
>
> [Non-text portions of this message have been removed]
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 22
> Date: Fri, 12 Jan 2001 11:00:32 -0500
> From: "amfab" <amfab@...>
> Subject: Report Builder link help
>
> I have constructed a report in Report Builder that calculates Estimated vs. Actual costs for labor, burden, mtl, subcontract with totals for jobs which I can get from the JobAsmbl table, which runs fine. I also have to add to this report the actual price charged to the customer which I am trying to pull from the InvcDtl table. The route I have taken is to link (JobAsmbl-JobHead joining with Company & JobNum, I've tried Inner and Left), then (JobHead-JobProd joining with Company & JobNum, I've tried Inner and Left), then (JobProd-InvcDtl joining with Company & OrderNum & OrderLine & OrderRelNum, Left). You should know that we ship from Inventory, not from the Job, and that we sometimes link multiple orders to a job. The filter I am using is JobAsmbl.Company Matches "AMFAB-1" and JobAsmbl.JobNum begins "016" and JobHead.JobCompletionDate>=01/01/2001. I don't want to use the JobNum begins "016" filter, but I can't get it to run at all without it. When this JobNum filter is used and it does run, it appears I am getting the correct data and pricing needed from InvcDtl, but the filter is keeping me from getting all the jobs. If I change that line to JobNum begins "01", it takes forever to run and the first page prints landscape as it should, but the additional pages print portrait with missing and spaced data. I know I'm close to getting what I want, but I obviously need to find another route. I'm pretty good with the formulas, but the joins get the best of me sometimes. If you know a better place to find the actual price, or can suggest better joins and links please let me know. My primary data is in JobAsmbl and InvcDtl tables. The only data I am using in the report from JobHead is the JobCompletion Date, but I could get by with ShipDate in InvcDtl instead if I have to give up the JobHead table.. JobProd is only there for the link.
> Thanks in advance for your input!
> Ann Harrell
> AMFAB
> amfab@...
>
> [Non-text portions of this message have been removed]
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 23
> Date: Fri, 12 Jan 2001 11:09:35 -0500
> From: "Tim Care" <ecfmis@...>
> Subject: Re: Crystal Reports v8.0
>
> In preparation for eMfg, we just upgraded ours to version 8,
> and got the professional version. The upgrade price is
> about $155 from Insight.com. I'm sure it's probably
> similar from other suppliers. For the upgrade price difference,
> you may just want to look at getting the Professional to have
> features you may want in the future.
>
> Tim Care
> Electro Chemical Finishing
>
> ----- Original Message -----
> From: "Wendy Bowen (Pursche)" <wpursche@...>
> To: "Vantage egroups list" <vantage@egroups.com>
> Sent: Friday, January 12, 2001 10:00 AM
> Subject: [Vantage] Crystal Reports v8.0
>
> > Hi everyone! I'm going to purchase the new Crystal Reports v8.0 for the
> eManufacturing upgrade. Do I need the Standard, Professional, or
> Developer's edition? Currently, I have the standard edition for
> customizing. I'm assuming that the Standard 8.0 is the same?
> >
> > Wendy Bowen (Pursche)
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@...
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 24
> Date: Fri, 12 Jan 2001 12:30:29 -0500
> From: "Terry Williams" <tlw@...>
> Subject: RE: Report Builder link help
>
> Ann:
> After all your blood, sweat and tears you may want to try Sarah's report
> she put on egroups a day or so ago. It begins with the Job cost
> information. You probably could join the InvcDtl file to that with out much
> trouble.
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
> Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
> www.chipsco.com
>
> -----Original Message-----
> From: amfab [mailto:amfab@...]
> Sent: Friday, January 12, 2001 11:01 AM
> To: vantage egroups
> Subject: [Vantage] Report Builder link help
>
> I have constructed a report in Report Builder that calculates Estimated vs.
> Actual costs for labor, burden, mtl, subcontract with totals for jobs which
> I can get from the JobAsmbl table, which runs fine. I also have to add to
> this report the actual price charged to the customer which I am trying to
> pull from the InvcDtl table. The route I have taken is to link
> (JobAsmbl-JobHead joining with Company & JobNum, I've tried Inner and Left),
> then (JobHead-JobProd joining with Company & JobNum, I've tried Inner and
> Left), then (JobProd-InvcDtl joining with Company & OrderNum & OrderLine &
> OrderRelNum, Left). You should know that we ship from Inventory, not from
> the Job, and that we sometimes link multiple orders to a job. The filter I
> am using is JobAsmbl.Company Matches "AMFAB-1" and JobAsmbl.JobNum begins
> "016" and JobHead.JobCompletionDate>=01/01/2001. I don't want to use the
> JobNum begins "016" filter, but I can't get it to run at all without it.
> When this JobNum filter is used and it does run, it appears I am getting the
> correct data and pricing needed from InvcDtl, but the filter is keeping me
> from getting all the jobs. If I change that line to JobNum begins "01", it
> takes forever to run and the first page prints landscape as it should, but
> the additional pages print portrait with missing and spaced data. I know
> I'm close to getting what I want, but I obviously need to find another
> route. I'm pretty good with the formulas, but the joins get the best of me
> sometimes. If you know a better place to find the actual price, or can
> suggest better joins and links please let me know. My primary data is in
> JobAsmbl and InvcDtl tables. The only data I am using in the report from
> JobHead is the JobCompletion Date, but I could get by with ShipDate in
> InvcDtl instead if I have to give up the JobHead table.. JobProd is only
> there for the link.
> Thanks in advance for your input!
> Ann Harrell
> AMFAB
> amfab@...
>
> [Non-text portions of this message have been removed]
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 25
> Date: 12 Jan 2001 17:44:49 -0000
> From: <vantage@egroups.com>
> Subject: New file uploaded to vantage
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the vantage
> group.
>
> File : /Crystal 8 Comparison Information.pdf
> Uploaded by : kbarry@...
> Description : Crystal 8 Version Comparison Information
>
> You can access this file at the URL
>
> http://www.egroups.com/files/vantage/Crystal+8+Comparison+Information%2Epdf
>
> To learn more about eGroups file sharing, please visit
>
> http://www.egroups.com/help/files.html
>
> Regards,
>
> kbarry@...
>
>
> ________________________________________________________________________
> ________________________________________________________________________