ISSUE:
Historical Data upload to FM-CPCB server.
Reason:
Case - 1 The device is changed due to Central CPCB guidelines.
Case - 2 The vendor is changed due to some reason.
Solution:
To resolve this issue follow the below-mentioned steps.
Step 1:
Case - 1 - Download the .cvs file from the FM-CPCB server.
Report>>Data Import Report or Station Report
Generate data as per the requirement:
Example:
Select Year : 2020
Interval :15 Minutes
Function: Average
Data View: Normal Data
Select Parameters: As per requirement
Case - 2 - Please request data from the customer in the same format as shown below..
Check the file format of the Report in CSV file, It must be in the "yyyy-mm-dd hh:mm: ss"
Only the header and data are present in the file. Other information is not allowed.
Remove Highlighted part from .csv file.
Instend of header use timestamp,NO,,SOX, as shown in screenshot
If a file format is incorrect then the .csv file is moved to an invalid file.
Attach file for reference
Step 2:
add the below-mentioned metadata key
*FILEPROCESSORTYPE,AIPL
*FILE BASED,D:/Program Files/Apache Software *Foundation/Tomcat7.0/web apps/enviroconnect/APUpload/Historicaldata/Stack_1
(Make a folder in Historical data as per the Device Name)
UNIQUE KEY, STACK
UNIQUE KEY must be same as file same in above folder STACK
Step 3:
Change the start address
Ex, timestamp,NOx,,SO2,,
NOx Start address =1 & SO2 start address =3 (Start address 2 is for flag)
EX,timestamp,NOx,SO2,
NOx Start address =1 & SO2 start address =2
Step 4:
Take access to the FM-CPCB server.
Put downloaded .csv file in file-based path.
(FILEBASED,D:/Program Files/Apache Software *Foundation/Tomcat7.0/webapps/enviroconnect/APUpload/Historicaldata/Stack_1 )
After 5-sec file will be fetched. or file is removed.
If a file format is correct then data will reflect on the server.
If a file format is incorrect then the .csv file is moved to an invalid file.
Note -
1. If a file contains variable more than 1, then it's value should not be NA replace it with blank (No space, No 0).
2. If device contains variable more than 1 and we need to upload only 1 variable then other variables start address should not be 0.