on 04-17-2008 12:41 PM
Hello SDNers!
I'm looking for an innovative idea on how to mass-delete qualified links. I want to delete all the qualified links to a specific non-qualifier from many records at once. Idealy the scenario would be to search on a specific qualifier, and be able to select all records and delete that qualified value from them. Data Manager can't do this, obviously.
The closest I managed to get was to delete all the values in the qualified link using an import, but that's not enough, I need to delete the links completely.
Before I turn to the APIs, anyone has an idea?
Thanks
Alon
Hi,
Please follow the steps below:
1. Export the repository schema.
2. Delete the Qualified table or Qualifiers from the main repository.
3. Import the schema file on the existing repository by selecting Import Repository Schema option.
4. It will display the comparison chart between the two repositories,select the Qualified table name or the Qualifiers that you have deleted from the original repository.
Though the approach is bit vague but it works
Reward if found useful
Regards,
Jitesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Alon,
You should be able to accomplish this with an export and import.
1. Select the qualified record you want to delete using the search parameters
2. Export out the records with this qualified field - it should only export out the qualified record that you have selected in your search parameter
3. Import this file with the Import Manager
4. Map the qualified table name in the source to the destination
5. Right click on the destination field name and select "Select Qualified Update > Update"
6. A new dialog box will appear
7. For new links select "Skip"
8. For existing links scroll down and select "Delete"
9. When the file imports it should delete all instances of that qualified record
That was a quick explanation. Let me know if you need more detail.
Regards,
Tim
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.