hexagon logo

Delete a part from database

How can I delete one part from the database?
  • How can I delete one part from the database?

    Use the DPEditor.

    VIEW ~ PARTS ~ (select the one from the drop-down) ~ DELETE
  • Use the DPEditor.

    VIEW ~ PARTS ~ (select the one from the drop-down) ~ DELETE



    Hi Matt,

    When selecting as stated I get the Parts Records Menu > In the Part Name field it shows the Database file names. I am not able to see the individual parts within the database. Tryed read DB and nothing. Did I miss something?
  • According to help this is how its done and I can't see the individual parts. WTF
    They appear in Datapage and print fine??

    The beatings continue
  • According to help this is how its done and I can't see the individual parts. WTF
    They appear in Datapage and print fine??

    The beatings continue

    1) Open DPEditor.
    2) Click on VIEW
    3) Click on PARTS

    You get a pop-up, "PART RECORDS"
    There is a drop-down for PART NAME. Use it to find the part you want to DELETE from the database, click on DELETE at the bottom-right of the pop-up.

    That is how you delete PARTS from the database.

    This is where the "term" proble is. Did you want to DELETE a PART from teh database (the entire thing) OR did you want to delete a TRANSACTION from the database? This would be a single (NOT PART) set of data that represents a single (or multiple) set of data from a check made by Pcdmis?

    To delete a TRANSACTION:
    1) Open DPEditor
    2) Click on VIEW
    3) Click on DATA VALUES and DATA VALUES (you'll see!)
    4) Select the PART from teh drop-down list
    5) Click on SELECT ALL for BOTH the VARIABLES and TRANSACTIONS
    6) Click on OK

    You will then get a "excel" looking kind of pop up. The transactions are listed on the left, the variables across the top. Find teh TRANSACTION you wish to delete (or more than one transaction). They are stored by DATE/TIME. Once you have clicked on the TRANSACTION, click on EDIT ~ DELETE ~ SELECTED TRANSACTIONS.

    Then, a pop-up will come up and ask "ARE YOU SURE YOU WANT TO DELETE...." tell it YES TO ALL or you will ahve to tell it YES for each and every variable in the PART file.

    WORD OF WARNING! Either COPY the entire database FIRST or do an ASCII DUMP of the PART first just in case you screw up which one you delete.
  • Do you want to delete a part or a transaction?
  • 1) Open DPEditor.
    2) Click on VIEW
    3) Click on PARTS

    You get a pop-up, "PART RECORDS"
    There is a drop-down for PART NAME. Use it to find the part you want to DELETE from the database, click on DELETE at the bottom-right of the pop-up.

    That is how you delete PARTS from the database.

    This is where the "term" proble is. Did you want to DELETE a PART from teh database (the entire thing) OR did you want to delete a TRANSACTION from the database? This would be a single (NOT PART) set of data that represents a single (or multiple) set of data from a check made by Pcdmis?

    To delete a TRANSACTION:
    1) Open DPEditor
    2) Click on VIEW
    3) Click on DATA VALUES and DATA VALUES (you'll see!)
    4) Select the PART from teh drop-down list
    5) Click on SELECT ALL for BOTH the VARIABLES and TRANSACTIONS
    6) Click on OK

    You will then get a "excel" looking kind of pop up. The transactions are listed on the left, the variables across the top. Find teh TRANSACTION you wish to delete (or more than one transaction). They are stored by DATE/TIME. Once you have clicked on the TRANSACTION, click on EDIT ~ DELETE ~ SELECTED TRANSACTIONS.

    Then, a pop-up will come up and ask "ARE YOU SURE YOU WANT TO DELETE...." tell it YES TO ALL or you will ahve to tell it YES for each and every variable in the PART file.

    WORD OF WARNING! Either COPY the entire database FIRST or do an ASCII DUMP of the PART first just in case you screw up which one you delete.


    Whoo Doggie > Thats a mouth full > Thanks Matt ~ Got it ~ Yes I guess I did not use the appropriate Terminology > Wanted to remove one transaction >
    Thanks Again
  • Put in wiki. Matt you are definately really good at simple and direct instructions.
  • 1) Open DPEditor.
    2) Click on VIEW
    3) Click on PARTS

    You get a pop-up, "PART RECORDS"
    There is a drop-down for PART NAME. Use it to find the part you want to DELETE from the database, click on DELETE at the bottom-right of the pop-up.

    That is how you delete PARTS from the database.

    This is where the "term" proble is. Did you want to DELETE a PART from teh database (the entire thing) OR did you want to delete a TRANSACTION from the database? This would be a single (NOT PART) set of data that represents a single (or multiple) set of data from a check made by Pcdmis?

    To delete a TRANSACTION:
    1) Open DPEditor
    2) Click on VIEW
    3) Click on DATA VALUES and DATA VALUES (you'll see!)
    4) Select the PART from teh drop-down list
    5) Click on SELECT ALL for BOTH the VARIABLES and TRANSACTIONS
    6) Click on OK

    You will then get a "excel" looking kind of pop up. The transactions are listed on the left, the variables across the top. Find teh TRANSACTION you wish to delete (or more than one transaction). They are stored by DATE/TIME. Once you have clicked on the TRANSACTION, click on EDIT ~ DELETE ~ SELECTED TRANSACTIONS.

    Then, a pop-up will come up and ask "ARE YOU SURE YOU WANT TO DELETE...." tell it YES TO ALL or you will ahve to tell it YES for each and every variable in the PART file.

    WORD OF WARNING! Either COPY the entire database FIRST or do an ASCII DUMP of the PART first just in case you screw up which one you delete.



    OK I understand how to Delete a part or complete set of parts from DataPage.
    How would I change the database a set of parts are in to another newly created database.
    What I want to do is this-
    When I started saving to datapage, I just put in the regular datapage code I always use. I now have created seperate databases (folders inside datapage) for each set of parts. I have op1, op2, op3, ect folders now. I want to take the info from the main database and put it in the appropriet folders.
    Any thought on how this is done?
  • OK I understand how to Delete a part or complete set of parts from DataPage.
    How would I change the database a set of parts are in to another newly created database.
    What I want to do is this-
    When I started saving to datapage, I just put in the regular datapage code I always use. I now have created seperate databases (folders inside datapage) for each set of parts. I have op1, op2, op3, ect folders now. I want to take the info from the main database and put it in the appropriet folders.
    Any thought on how this is done?

    ASCII Archive the parts/transactions you want to move to a new database. This is done in DPEditor.

    DATABASE ~ ASCII Archive ~ DUMP

    You then get a menu, simply click on LIST DB and it will list all the parts. You can then select which one(s) you want to "dump" (it will NOT remove any data from the database). You can then select some of the transactions from the part or just let it dump all of them. Name a file, it has it's own default extension, but it will not put it on the end of the name by itself (STUPID!), so I just use my own, .ARC (for archive). Then simply do the same to pull it into the new database, except you use LOAD instead of dump.