Can I update data from every spreadsheet tab

The spreadsheets that you use for creating and updating data are organized into tabs. Each spreadsheet tab represents an intermediate loading form (sometimes also referred to as a staging form) that the Data Management utility uses later, during the data load job, to validate the data before promoting it to the application forms.

You can create new data using any tab on any spreadsheet. However, you can only update existing data from some of the tabs.

For example, when working with Foundation data, you cannot update data from the following People spreadsheet tabs. You can use these tabs only to create data.

Spreadsheet	Tab - Create data only
People	CTM_LoadPeoplePermissionGroups
	CTM_LoadSupportGroupAssociation

Note

When working from the CTM_People tab, you also are unable to update an existing People record to add Unrestricted Access to a person's list of permissions.

The tables in the following sections list tabs from which you can update data:

Create and update data

The following tables list the spreadsheet tabs from which you can update different data types.

Process data

The following table lists the tabs from which you can update Process data.

Spreadsheet	Tab - Create and update data
Process_ Setup_Knowledge	RKM_LoadVisibilityGrpMappng

Transactional data

The following table lists the tabs from which you can update Transactional data.

Spreadsheet	Tab - Create and update data
Transactional_Knowledge	RKM_LoadPrblmSolnTemplate_Join
	RKM_LoadKnownErrTemplate_Join
	RKM_LoadReferenceTemplate_Join
	RKM_LoadHowToTemplate_Join
	RKM_LoadAssociations

Create data only

The following is a list of forms from in which can only create data. You cannot update data in these forms.