Archiving data

[Anonymous]

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 single row of data for that day, as at midnight it wipes it all out and starts again. I have imported the data, as I am performing steps that stop me using a direct link, so I was wondering, is it possible to archive the data at some point before midnight, so that I can start to build it up and build reports around it?  The first field of the row is the start time, 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?

Or could I do a flow to write the data to a SQL table for archive purposes?

[v-lionel-msft]

Hi @Anonymous ,

"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."

Did you mean that because Power BI does not have a UCCX interface, so you transfer data to SQL tables and then connect?

There are two ways here, one is to use a custom connector .

And the other is to find a way in your data source, as long as the data source can archive the data, you can get what you want in Power BI.

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]

Hi Lionel,  I say true interface, because there is a beta Informix interface, but it only appears to do 64bit, while Cisco is only 32bit. So BI throws an error.

[v-lionel-msft]

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]

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.

[Greg_Deckler]

This sounds more like a SQL question to me. My SQL skills are not super powerful but seems like you would do an INSERT into the SQL table each time so that you would build up rows of data in your SQL table?