It is very important to maintain the data correctly in order for the Opcenter to give a desirable output.
Mentioned below are some guidelines to which if followed correctly will help to maintain correct data in the files. :
- Refrain from using symbols like Comma (,), hyphen (-), back slash(/), inverted commas (‘’) as an input as it is not allowed in APS Opcenter.
- The sequence of columns should not be changed.
Any additional columns should not be added in CSV files until and unless it is very important. If required, kindly inform the respective consultant as it requires changes in the configuration too. - The first row should not be empty.
Column header should be mentioned in the first row. - Do not only delete data from rows.
Instead delete entire rows using the delete function. (Use the delete rows function in excel and not delete content) - Do not rename any file.
If at all it is required to, kindly inform the respective consultant as it requires changes in the configuration too. - Ensure that the files are saved in a proper format.
Saving the files in a format which is not supported by APS Opcenter may lead to data being not imported correctly. - The data in the files must be in the format as mentioned in the column name.
For example – If the format for the dates is DD-MM-YYYY, then the data should be in the same format. If the data is maintained in DD.MM.YYYY format, then it will cause an error and the data will not be imported into APS Opcenter. - The cells in the files should not be blank and data in correct and valid format should be filled in the cells.