Export Queue data from orchestrator and open in convenient format in excel

News Vote on Tutorials
,
1

Hi everyone.

I created a project to open the data downloaded from Queude in a convenient format in Excel.

1-Firstly export queue data.

The image shows the Queues section of a monitoring dashboard, highlighting the "Download Queue Data" button. (Captioned by AI)
The image shows the Queues section of a monitoring dashboard, highlighting the "Download Queue Data" button. (Captioned by AI)1712×472 34.9 KB

2-Run to project.
3-Result: Each column separated
This image shows an open Excel spreadsheet named "KontrolEdilecekQueueExceli_16.12.2024 13-55.xlsx" with columns and data visible. (Captioned by AI)
This image shows an open Excel spreadsheet named "KontrolEdilecekQueueExceli_16.12.2024 13-55.xlsx" with columns and data visible. (Captioned by AI)930×471 119 KB

Project files:
QueueExcelSeperate_V2.xaml (21.3 KB)

Regard. :slight_smile:

2

I’m not sure this counts as a tutorial as there is no explanation of ‘how’ to use your code and it contains alot of hard coded values so it won’t just run natively.

Furthermore, the report exported from the Orchestrator already works perfectly in Excel and formats better natively than the one you show in your screenshot as that one has bad headers.

If you download it and just open it in Excel directly you get this, so the purpose of your code / tutorial isn’t clear as I cannot see what problem you are trying to solve?

A spreadsheet displays task management data with columns for status, revision, reference, exception, deadline, priority, robot, postpone, start and end times, transactions, and ancestor info. (Captioned by AI)
A spreadsheet displays task management data with columns for status, revision, reference, exception, deadline, priority, robot, postpone, start and end times, transactions, and ancestor info. (Captioned by AI)804×387 9.02 KB

1 Like
3

Hi, @Jon_Smith

Yes it is work. But while .csv . This topic I open with .xlsx.

4

I assume you mean .csv rather than .cls

My comment above stands though, this is not a tutorial and I dont see why, if you need the data, you dont just open the .csv in Excel as that is natively supported and then save as an .xlsx, as I mentioned above the headers are lost on your current version.

I’m not saying you shouldnt share your code, but if you do it in the tutorials section then I feel you should write an explanation of what the use case is, how your code works and how others can use it. I dont feel you did those things and so it doesnt belong in the tutorials section.

5

It make automatically. You don’t need open and save as different format each time.

6

Like I said, it doesn’t work though and you don’t explain how to use your code and it loses the headers.

If its a tutorial please explain it.