Changing Asset ID's
Outcomes: Gain an understanding of how to change Asset ID's in myData.
Changing a single Asset ID
- If an Asset ID is changed a user can expect both documents and photos for the asset to no longer be accessible, however, this is easily fixable as myData is following the below path structure:
- {MyData Shared Directory Path}\Documents\{System Asset category name}\AssetID\{files}
- {MyData Shared Directory Path}\Photos\{System Asset category name}\AssetID\{files}
- A user just needs to browse to the myData share directory and rename the Asset ID folder from the old ID to the new ID.
- All other related data like Associations, Work Management, MDList data will remain attached to the asset due to internal id's.
Bulk changing Asset ID's
- First, a user cannot bulk change Asset IS's using the data exchange.
- Changes must be done in consultation with an Assetic team member who will create a SQL script.
- As per the single change, folders will need to rename.
- With excel you can generate a batch command (sample below) to help accomplish this in bulk.
- move /Y {MyData Shared Directory Path}\Documents\{System Asset category name}\OldAssetID {MyData Shared Directory Path}\Documents\{System Asset category name}\NewAssetID
- move /Y {MyData Shared Directory Path}\Photos\{System Asset category name}\OldAssetID {MyData Shared Directory Path}\Photos\{System Asset category name}\NewAssetID
Changing Asset ID's to myData autonumbering
- Similar to bulk changes where Assetic can generate SQL and Batch scripts to make the move seamless, please contact your account manager for pricing.
