Donotadd, delete or modify yellow columns because Backstage need to ''recognize'' them in order to process your excel file
Follow the existing cell formats, especially the date format and do not insert formulas in cells because Backstage needs the original cell format for ''recognizing'' data. If wrong cell formats were input, the excel file couldn't be imported successfully
You must follow the Leave Type code, Shift code, roster code, Organization/Department code or any code that have been set in the system for ''recognizing'' data.
You can delete the column "ApplicantName", "AssociateName" and "RosterName" in the excel file as the system can "recognize" the applicant number, placement number, and roster code.
To prevent affect or duplicate the existing data/records, you can just input the data you need to update and delete the existing records, other unused columns, and excel sheets when updating the placement and applicant profile. e.g if you need to update the Education in the applicant profile, you can delete other excel sheets and the existing records. You can just input the new record and import it into the system. Otherwise, the records would be duplicated.
Now you can bulk delete the supervisor by putting "Y" in the column "Delete".
Other than the Supervisor, now the records/data cannot be deleted through excel import. It only enables you to add or overwrite the records. You need to delete the records manually or seek our help for bulk delete.
Article is closed for comments.