The purpose of the project is to import data from external data source (txt file) to Redmine application.
Business Requirements
- Daily importing data from txt file to the indicated task in Redmine project.
- Importing data to custom field that can be tracked/analyzed in Redmine reports.
The structure of the data in the source file
Source file is always available at the same address [login to view URL]
The data file contains 3 information for four days:
today: [recording satus], [date ], [ amount ]
today -1d: [recording satus], [date ], [ amount ]
today -2d: [recording satus], [date ], [ amount ]
today -3d: [recording satus], [date ], [ amount ]
Example:
0.20140408 , dad
1,20140407,2815
1,20140406,1
1.20140405 , cc5
Recording status in the field of [0,1] means that the counter for the day is closed. If 1 then we know that amount will not change and can be downloaded . If 0 then we know that amount will change.
The date in the format YYYYMMDD
Amount is an integer indicator of daily production in encrypted form. The cryptogram is a ( daily production * 8) + 3 In addition, the number is written in hexadecimal . Example: for daily production 1340 it will be (1340 * 8) +3 = 10723 and hex 29E3.