Mapping Schema Editor is used to add, remove, rename, and re-arrange column definitions in a Mapping or Mapping Lookup and save upload the changes to the pasPortal.

 

Opening the Mapping Schema Editor will display a data grid with the columns Original Column Name and New Column Name.  All existing columns that are not required will be listed in the order they appear in the mapping or mapping lookup.  You may perform several operations in the editor.

 

•Add Column - In order to add a new column, select the empty row at the bottom of the grid and begin typing in the New Column Name cell.  Once you are finished, you may click away or press enter to commit the changes.  The new column will be added to the data grid, and the Original Column Name will be blank, indicating this is a brand new column.  If the column name is invalid, you will be forced to enter a new column name.

 

•Rename Column - In order to rename a column, find the column you want to rename and begin typing in the New Column Name cell.  Once you are finished, you may click away or press enter to commit the changes.  The New Column Name will update, leaving the Original Column Name as it originally was.  If this was an existing column, all mapping data associated with the column will be maintained under the new column name.  If the column name is invalid, you will be forced to enter a new column name.

 

•Delete Column - To delete a column, select the row handle to highlight the entire row representing the column, and press delete on the keyboard.  If the column can be removed, you will be asked to confirm the deletion.  Deleting a column will erase all mapping data associated with the column.

 

•Change Column Order - In order to change the order of a mapping column, click and hold the row handle for the column you want to move, and drag the row to the position you want the column to be relocated.

 

Once the columns have been edited, clicking the Save button will permanently apply changes to the lookup in the pasPortal.

 

Note - Altering an existing mapping or mapping lookup can break existing integrations.  Removing columns can result in a loss of data.  Use caution before editing a mapping or mapping lookup that is currently in use.

 

Copyright © 2024 pasUnity, Inc.

 

Send comments on this topic.

Created with an evaluation copy of HelpSmith.
To remove this notice, you should purchase the full version of the product.