9. FAQ: File Upload¶
9.1. What is the format of the production data file upload ?¶
Upload data need to have a specific format and has to be uploaded as ascii-formatted file (e.g. csv-format). The format structure is “datetime,production_value”.
Note
The file has to contain a datetime and the value separated by a comma. Note, in the datetime date and time is separated with a space, while the value is separated with a comma form the datetime.
The format definition is:
YYYY/MM/DD HH:MM,PRODUCTION_VALUE YYYY/MM/DD HH:MM,PRODUCTION_VALUE YYYY/MM/DD HH:MM,PRODUCTION_VALUE ...
The data has to be provided as floating point numbers with a minimum of 1 decimal. Decimals must be separated with a ”.” (commas are not allowed).
Note
Zero values also must have a minimum of 1 decimal. Otherwise the file will be rejected by the system.
The following shows an example of the correct format:
2013/01/01 00:00,35.11 2013/01/01 01:00,28.39 2013/01/01 02:00,27.002013/01/01 03:00,0.0 ...
If the format is ok, the bar in the middle will gradually show the progress of the upload and display “success”, once the upload bar has arrived at 100%. At this stage, the data has been uploaded correct and is now stored in the database and is accessible in all applications. If this indication does not appear, your file has not been added to the database.
A yellow box above the selection will provide feedback, if the data could not be uploaded because of wrong format, a missing selection of a curve to choose etc.
9.2. Can I upload measurements and make them visible at the interface?¶
Yes, you can upload files containing measurement data into the forecast interface. Click on File Upload 1 in the top menu (tools), and there select Production data as File type 2.
Then select the location 3, forecast variable 4 and curve name 5 into which the file’s data should be inserted. You may also define the time zone 6 for the time values. You can choose the curves u1-u4 as destination curves.
Select a file 7 and start the upload. After the upload finished successfully, you can open the Forecast Interface, select the same location and forecast variable (as 3 4), and then display your selected data curve (as 5).
9.3. What do I have to do, if I have uploaded production data with the normal upload facility ?¶
If you would like to upload a file with production data, you have to make sure to check the box Production data before uploading the file.
See also
Uploading measurement data.
9.4. Which data format is used for the download and upload?¶
Download data is available as:
- csv-format,
- Excel 5-format,
- Excel 2007-format and
- XML-format.
Upload data has to be configured in a specific way in csv format.
9.5. Can I modify or use own data to fill into the additional lines f1-f4, u1-u4 and how can I do that?¶
- No you can not modify lines f1-f4 because f1 represents the optimal forecast and f2-f4 special characteristics.
- How is the definition of the Optimal Forecast ?
But you can fill your own data into u1-u4 curves, either by uploading a file, or by calculating a new curve based on existing curves.
On the other hand, you can use the Curve Calculation interface. The curve calculation interface allows to compile a curve based multiple existing curves. See here for an explanation.
9.6. How do I create a new forecast curve from other curves that I uploded?¶
You can fill your own data into u1-u4 curves, either by uploading a file, or by calculating a new curve based on existing curves.
How to fill in data by uploading a file is explained here.
On the other hand, you can use the Curve Calculation interface. The curve calculation interface allows to compile a curve based multiple existing curves. See here for an explanation.