Upload File in Rooms

User can insert, update, delete data using the Upload feature.

The Upload procedure will parse the upload file row by row and it will perform a specific action on data present in the row as follows:

• “Room Name” column contains the key value for a Room.
• “Operation Type” column value will be used to execute Room delete operation.
• Insert a new Room in case data in the row specify a Room that is not already present in the system.
• Update an existing Room using data in the row.
  • Delete an existing Room if the “Operation Type” column value is “D”. If the Room name specify a not existing Room, then a Message Pop up will appear after the Upload procedure execution. (see below).

  

• For each row with “Operation Type” column value equals to “D”, before “Save changes”, the system will show the rows marked for delete with a “(DELETED)” in the room name filed.

Room Data before the upload:

Example of Upload file: