About the Overrides File

A bulk override of multiple records can be done using just two files: Your data file in csv format and the task file. This task can be used to extend your periods beyond an existing table if you want to add additional data to an already existing record.

The Overrides.csv file is in composite format and lists the Record Name (for example, the Item Number) and the Date (in any consistent format across the columns) when a number should be replaced.

Example of Overrides.csv File from Excel

Item Number	12/1/2020	1/1/2021	2/1/2021	3/1/2021	4/1/2021	5/1/2021
100-00001	76000	80000	40000	40000	75000	35000
100-00002	480	37	750	40	40	950
100-00003	150	75	150	100	80	230
100-00004	44000	92000	46000	115000	57500	115000
100-00005	550	450	225	225	500	850

Is converted to:

Item Number,12/1/2020,1/1/2021,2/1/2021,3/1/2021,4/1/2021,5/1/2021
100-00001,76000,80000,40000,40000,75000,35000
100-00002,480,37,750,40,40,950
100-00003,150,75,150,100,80,230
100-00004,44000,92000,46000,115000,57500,115000
100-00005,550,450,225,225,500,850

- The Import Overrides.tsk file uses just the TASK line to call the Import Overloads.dsb file during the import process.

Once the tsk file has been added, it is added to the Administration screen and is run just like any other import.