Flexible Upload of Data from Microsoft Excel 
Flexible Upload of Data from Microsoft Excel
Use
You can load as much plan, transaction or master data as you wish from a Microsoft Excel sheet into one or more aspects of the EC-EIS or EC-BP.
Integration
To execute a flexible upload you require the data transfer tools.
Prerequisites
You must have created one or more sender structures, whose fields correspond to the cells of the file to be loaded. The Microsoft Excel files must be saved in TXT or CSV format.
Features
In Customizing you define which areas of the sheet are to be loaded into EC-EIS/EC-BP and which cells are to be assigned to the fields of the sender structure(s). This data description only has to be stored once for similarly structured files, for example, monthly reports.
With the upload you can load data from a single file or from the files of an entire path. If you load data from several files simultaneously, the system creates certain files on your PC. These are overwritten with each upload.
Before you execute the first flexible upload for all the files of a path, check that you do not have any files on your PC in this path called dir_file.TXT or dir_file.BAT. If this is the case, you should rename the existing files, otherwise they will be overwritten.
As with importing a file, you enter the decimal display, the date format and the separator for CSV files. The tabulator is expected as the separator with TXT files.
If you choose the field Test run, no data will be written to the database.