We are doing import of data using import specification and excel data.
For example; we have column B as "id", Column "C" Name etc.
Let us say we have imported 1000s of rows using above spec.
After seeing the data in views, we decided to modify the Column "C" Name alone different value and update the data.
Since it is more number of rows it is practically very time consuming to update in the app (Class instances..)
Can we re-import data so that it utilize the ID column and update the value in column "C" Name (with out re-inserting duplicate records?)
Updating data after 1st import using import utility
Hi Rajaraman,
yes you can do this.
If you look at the Launchpad Import Specification, you will see example worksheets (what we typically call catalogue worksheets) that import instances based on a "ByID" match mode (see screenshot below).
When a column is defined as the ID column (in your example and the screenshot above, this would be column B) and the match mode is ByID, the Import Utility will always try to find an existing instance in the repository of the given class (in the example below, this would be an instance of Group_Actor) with an external ID matching the value in column B. It is only if no such instance can be found that a new instance would be created. If an instance is found matching the ID, then any values captured in other columns will be applied as updates to that instance (e.g. name in column C, description in column D, etc).
In addition, the Import Utility allows you to select/deselect the worksheets that you wish to import as well as a specific range of rows to import in a given worksheet (see screenshot below).
Regards,
Jason
yes you can do this.
If you look at the Launchpad Import Specification, you will see example worksheets (what we typically call catalogue worksheets) that import instances based on a "ByID" match mode (see screenshot below).
When a column is defined as the ID column (in your example and the screenshot above, this would be column B) and the match mode is ByID, the Import Utility will always try to find an existing instance in the repository of the given class (in the example below, this would be an instance of Group_Actor) with an external ID matching the value in column B. It is only if no such instance can be found that a new instance would be created. If an instance is found matching the ID, then any values captured in other columns will be applied as updates to that instance (e.g. name in column C, description in column D, etc).
In addition, the Import Utility allows you to select/deselect the worksheets that you wish to import as well as a specific range of rows to import in a given worksheet (see screenshot below).
Regards,
Jason
You do not have the required permissions to view the files attached to this post.
