Please be sure that the only columns being saved to the CSV file are the following three in this order::
All date formats are as follows: YYYYMMDDhhmm, or MM/DD/YYYY hh:mm
RECPOS_ID or METER_ID,
DATETIME,
VALUE
Please use the following format for importing the Adjustment Factors Period CSV file:
All date formats are as follows: MM/DD/YYYY
PeriodID,
MeterID,
SiteID,
BeginDate (MM/DD/YYYY),
EndDate (MM/DD/YYYY),
EndReason,
FMTF Meeting Date (MM/DD/YYYY),
Comment,
Initial Condition,
Potential
Please use the following format for importing the Dye Test Standards CSV file:
All date formats are as follows: MM/DD/YYYY
Alias,
TestID,
Time (HH:mm:ss),
Qdye,
Qmeter,
RSS,
ActivePaths,
Comment
Please use the following format for importing the Dye Test Comments CSV file:
All date formats are as follows: MM/DD/YYYY
TestID, SiteID, Date (MM/DD/YYYY), ActivePaths, PoorTestCond, SatisfactoryOp, InitialCond, TestComment, FMTF_accepted, TimeAdj_M_vs_F, M_vs_F_Comment, TimeAdj_TT, TA_TT_Comment, DyeInj_RC, DyeInj_RC_Comment, F_and_T_RC, FT_RC_Comment, SSI_TL, SSI_TL_Comment, SSI_RC, SSI_RC_Comment, SC_Reg, SC_Reg_Comment, SC_Spread, SC_Spread_Comment, SC_Absorb, SC_Absorb_Comment, SS_Cond, SS_Cond_Comment, CDM_Conclusions, FMT_Recom, FMTF_Date (MM/DD/YYYY), DyeInj_RC_YN, F_RC, T_RC_YN, T_RC_Comment, SC_Reg_YN, MeterData_Quality_Comment
Please use the following format for importing the Dry Weather Classification Data CSV file:
All date formats are as follows: MM/DD/YYYY
DWC_Date (MM/DD/YYYY),
METHOD1 (1=Yes, 0=No),
METHOD2,
METHOD3
Make sure to enter the meter ID or Alias in the comments, so we know which meter to apply the accusonic data too!
The filename of the CSV file (along with the meter ID or alias) determines which columns are used.
Binary (PDF, PNG, JPG) or ASCII (XML, CSV, TXT)
Currently limited to users with admin access