Retroactive Data Not Displaying

Web based, multi-user, Telephone Management System with budget management and barring control

Moderators: Leon van Heerden, Luanda_Junzi, Belinda Frick, Lee Hendricks

Retroactive Data Not Displaying

Postby ross.innes » Fri Sep 05, 2014 10:00 am

Hi Support,

The client requires that older data be imported into TNG. Although I'm trying to import records from 2011 (as they are included in the Master.csv) the requirement is that only the past few months are displayed. (Update: The client just phoned and suggested I cut down the Master.csv from 2011-2014 to Dec 2013 - Now, will this help?)

Upon install, the Master.csv was renamed to Master.csv.tnginstall. Thereafter TNG was registered/activated.

I then "merged" the legacy Master.csv and the new Master.csv for import by TNG:
Code: Select all
cat Master.csv >> Master.csv.tnginstall && mv Master.csv Master.csv.2014.09.03 && mv Master.csv.tnginstall Master.csv


As per the attached logs (password protected for client's security) it appears that all records were extracted from the Master.csv and are loaded on subsequent restarts of tng (as detailed in the logs).

However, all reports display as blank even though live logging is populated.

PS.

I did notice while writing this post that in the attached logs this error is noted on the second day:
Code: Select all
2014-09-03 17:05:37:121 [1.1.1.11] - AMI Exception:ParseCDRRecordToTNGFormat (- ["","","","","","","","","","","","","","","","","",""[10]]): '' is not a valid date and time.
You do not have the required permissions to view the files attached to this post.
ross.innes
 
Posts: 1
Joined: Wed Oct 30, 2013 2:21 pm

Re: Retroactive Data Not Displaying

Postby Belinda Frick » Fri Nov 21, 2014 11:58 pm

Belinda Frick
 
Posts: 3808
Joined: Fri Nov 12, 2010 4:25 pm


Return to TNG

Who is online

Users browsing this forum: No registered users and 1 guest