AMI Exception:ParseCDRRecordToTNGFormat ...not.. valid date

[Belinda Frick]

My TNG for Asterisk is not loading calls and have parse errors in the log file:

• AMI Exception:ParseCDRRecordToTNGFormat ... is not a valid date and time
  
  Refer date example in the forum post: Sample of Asterisk CSV input file for TNG
  
  Also see: TNG: Asterisk output configuration required
  
  
• This can be a output format issue, for example:
  
  TNG is having trouble parsing the CSV records because it has embedded quotes and commas (i.e. the delimiting is not correct).
  
  For example, a normal record has the fields "lastapp", "lastdata", and "start time" as:
  "Dial","SIP/9165,30,tr","2012-03-26 16:24:26"
  
  The problem records have:
  "Dial","Local/0113927114@from-internal,"",tr","2012-04-03 10:11:10"
  
  Note that lastdata is "Local/0113927114@from-internal,"",tr"
  
  TNG then thinks the starting time is ",tr".
  
  NOTE: TNG up to version 1.0.7.7 does not cater for this format. Currently no update is also available to cater for it - as of 20120403.
  
  Suggestion: Format your Asterisk output to not use double qoute without the closing double quote. This causes incorrect delimiting.