Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Archiving data

Good Evening people! With the lack of a true UCCX interface, I have a bodged process that outputs the data from the Cisco Phones to a SQL table on another server.  However, it only gives you a singl...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Are you using this connector?

 

 

"so I was wondering if there is a way to stop the data writing on an existing row when the date does not match what is there already and make it jump to a new row?"

Your problem has nothing to do with the connector, this involves data update problems.

In Power BI, M and DAX is used to transform and model, so maybe you can try to use SQL to achieve it.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No, I'm not, the Cisco system is 32bit and that connector is only 64bit. Through a bit of gouing around the houses, a utility converts the data to SQL and then the one line is sent out as a csv to a folder on another server. So all I have is the csv which gets overwritten every 5 seconds, until 23:59:59, then it resets for the new day.

The plan at the moment is to get our data warehouse to make a SQL table that picks up these csvs after 6pm after the helpdesk is closed, and build up the history that way, but I was looking for a solution not involving a third party, which just complicated this mess even more.