All the ones staring with "DATAPG6" are needed (ignore case differences). Just remember, do NOT delete any files while someone is using/updating the database. All programs which use the database should be closed.
Went and deleted all of the .bdu, then as I try to open datapage and datapage editor I get this error several times each the it will finally let me in but the .bdu are back in my folder.
If I leave the .dbu in the data folder then I seem to be good to go. I will print this out there TKING and try this when production slows down. But thanks for the responce.
If I leave the .dbu in the data folder then I seem to be good to go. I will print this out there TKING and try this when production slows down. But thanks for the responce.
These are ALL that will be in existance when you make a new database. I have ONE single DBU file in the working database directory.
IF you are getting "errors", you may need to CLEAN OUT your database. Datapage does NOT delete anything from a database. Parts, transactions, data values, NOTHING ever gets deleted, it just gets "blocked" so that Datapage can no longer see it.
1) Make a copy of the existing database
2) Open DPEditor, do an ASCII dump of the database
3) Make a new database and open it
4) Do an ASCII load of the DUMP file
5) Move all the files from the new database to the old location so that your Pcdmis paths are not screwed up.
I do this every 3-6 months, copy all database files to a dated directory, ASCII dump all "old stuff" and delete it from the database, ASCII dump all remaining data (as a single file), copy a blank database to the working directory, ASCII load the dumped data and I now have a CLEAN database.
Don't ever think your info is not important, just cause you a
state fan does not mean we don't like you or value your 1.99 cents. I think you have answers for most of the problems people ask on here. They may not like it, but tuff SH**. You have helped me to many times.
Don't ever think your info is not important, just cause you a state fan does not mean we don't like you or value your 1.99 cents. I think you have answers for most of the problems people ask on here. They may not like it, but tuff SH**. You have helped me to many times.
Amazing when you think about it. If you mention STATE (football, baseball, etc.) people ALL AROUND the county know you are talking about MICHIGAN STATE (THE university of Michigan) when each and every state in the country has it's own state university. Guess it just goes to show how "special" a place it really is!
These are ALL that will be in existance when you make a new database. I have ONE single DBU file in the working database directory.
IF you are getting "errors", you may need to CLEAN OUT your database. Datapage does NOT delete anything from a database. Parts, transactions, data values, NOTHING ever gets deleted, it just gets "blocked" so that Datapage can no longer see it.
1) Make a copy of the existing database 2) Open DPEditor, do an ASCII dump of the database 3) Make a new database and open it 4) Do an ASCII load of the DUMP file 5) Move all the files from the new database to the old location so that your Pcdmis paths are not screwed up.
I do this every 3-6 months, copy all database files to a dated directory, ASCII dump all "old stuff" and delete it from the database, ASCII dump all remaining data (as a single file), copy a blank database to the working directory, ASCII load the dumped data and I now have a CLEAN database.
Not understanding or seeing how you dumping the "old stuff" and then dumping the remaining stuff.
Not understanding or seeing how you dumping the "old stuff" and then dumping the remaining stuff.
For ARCHIVING purposes...
ANY "PARTS" that you no longer run, but wish to save the data for, do an ASCII dump of those parts, then "delete" the parts from the database. Deleting only "hides" the data, but Datapage will NOT use it, save it, or even "remember" that it is there, all it does is stay in the database, taking up room, it will never get over-written. Here's something I put together on this:
Clean up Datapage database Datapage does NOT even delete any data or parts that you tell it to. It simply hides the data and makes it unreadable. This would not be a big problem except for the fact that none of that data will ever get written over, so your database gets bigger and bigger and bigger. To clean out the database of all old (hidden, deleted, gone) data, do this:
1) Locate the directory where the databse is. 2) Copy all the file that are there into a subdirectory (I will use the current date for the sub-directory name) 3) Open DPEditor (Datapage Editor) 4) Click on DATABASE (top-left corner) 5) Click on ASCII Archive ~ DUMP 6) In the pop-up window, click on List DB. It will then let you view a list of ALL un-deleted parts in the database 7) Click on any and all that you want to remaine in the database (don't click on those that you want left out from the new database) 8 ) Enter a file name in the box for 'Enter the File Name'. This will be the file that will hold all the data from the database, use an 8.3 name format (12345678.123) 9) Click on DUMP.
When it is done processing, the process-pop-up will show COMPLETE, then you click on COMPLETE. Then cancel out of the DUMP window and CLOSE DPEditor
You now have an ASCII archive of ALL the data you want to save and move to the new database.
Go back to the directory where the database files were (where you copied the files to a subdirectory)
Delete ALL files (but not the sub directories, JUSt the files!)
Open DPEditor again.
At this point, you will probably get an error message saying that the database could not be found. Simply cancel the error or close it, which ever it needs
Now, you need to make a NEW database
1) Click on DATABASE 2) Click on NEW 3) In the pop-up, enter the full path to where the database was, or you can BROWSE for it. You MUST use the same path as it was before, OR none of your program will send the data to the right place and you will get a headache 4) Once you have the correct path for the database entered, click OK to create the new database. 5) Click on DATABASE 6) Click on ASCII Archive ~ LOAD 7) Enter in the name of the file you created in STEP 8 above 8 ) Click on LOAD 9) When it is done processing, you will have loaded all the data you save (including transactions and variable sets) into the new database.
You should NOW have a 'clean' database to work with, without any hidden data that you have previously deleted.
Back to the State comment, ok. you live near lansing and guessing you a big 10,11 or is it 12 fan now. Your personnel opinion what conference from top to bottom is the toughest. Be honest
Back to the State comment, ok. you live near lansing and guessing you a big 10,11 or is it 12 fan now. Your personnel opinion what conference from top to bottom is the toughest. Be honest
OPINION, well, OPINION does not necessarily mean fact....
BIG-10 is the best, meanest, toughest, hardest, bestest there is.
