Sorry, i will try to explain myself further. English is not my primary language.
We user a number to identify our assets (with some exceptions that gives me trouble). To better classify our assets, we use the format device-location-id, so i am able to search only printers for example, without needing a custom field (which in reality i also am using). So i search for "imp-mar" which gives me all printers in our MAR branch. That gives me imp-mar-18273, imp-mar-37293... Suppose i want to update the custom field that holds the printer's location. Since the import won't magically associate MAR with "Oficina Principal", i search for all imp-mar assets and then just update the custom field with a bulk update. The issue i experienced is the following: Step 1: search for "imp-mar" Step 2: press "bulk update" Step 3: change the custom field Result: all assets with imp-mar in its name gets renamed to imp-mar, losing the number, unless i remember to delete the "name" field with the search i just did. Changing the status of the asset to "deleted" just hides the assets, but doesn't delete them from the database! Therefore i went to the manual route... If you want me to file a bug i will happily do so. I don't have a production server, i just have my development server and hoping to promote to production once i finish some issues. That means i haven't made a recurring backup just yet. But the three tables you mentioned actually were the one i needed, so i did the following. -Installed phpmyadmin -Created a new table with one column, and imported a csv with just that one column, containing the id's of the assets i wanted to prune off the database. -delete from Groups where domain like '%Asset%' and instance in (select activo from activo); -delete from ObjectCustomFieldValues where ObjectType like '%Asset%' and ObjectId in (select activo from activo); -delete from Transactions where ObjectType like '%Asset%' and ObjectId in (select activo from activo); Thanks!! -- View this message in context: http://requesttracker.8502.n7.nabble.com/Issue-when-deleting-Assets-and-recreating-with-roles-tp58863p58865.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training November 4 & 5 Los Angeles http://bestpractical.com/training
