topic Re: Exporting filtered queue export using automateC in Digital Exchange

Exporting filtered queue export using automateC

sarathgnair — Wed, 18 May 2022 21:48:00 GMT

Hi There,

I was trying to extract the queue report of all the processes based on a filter (monthly,weekly).
Currently the below expression is working perfectly and i am able to extract the fulle report.

"/exportqueue"&""""&[I_Exports Folder] & Replace(Replace(Replace([Queue Names.Queue Name],"/",""),"/","),"","") & "Export.csv" & "" &"/queuename" & """" & [Queue Names.Queue Name] & """" & "/user" & [User] & " " & [Password]

But i need to export the queue based on a filter.
I have tried creating a filter in the queue and edited the above expression to add /queuefilter appliedFilterName , but its giving me a syntax error.

can someone help me out in this.

Regards,
Sarath

------------------------------
Sarath Gopinath
------------------------------

RE: Exporting filtered queue export using automateC

devneetmohanty07 — Thu, 19 May 2022 00:18:00 GMT

Hi Sarath,

The export query filter that I've used on my machine is as follows:

AutomateC /exportqueue "{FILE_PATH}" /queuename "{QUEUE_NAME}" /user "{USER_NAME}" "{PASSWORD}" /queuefilter "{FILTERNAME}"

In my case, the File path is: C:\Users\DevneetMohanty\Documents\Export.csv, queue name is: New Orders and the filter name is Weekly

I took a look over your expression and found that you were missing double quotes, spaces and also 'AutomateC' keyword at the very beginning:

I updated your expression as follows:

"AutomateC /exportqueue " & """" &[I_Exports Folder] & Replace(Replace(Replace([Queue Names.Queue Name],"/",""),"/",""),"","") & "Export.csv" & """" &" /queuename " & """" & [Queue Names.Queue Name] & """" & " /user " & """" & [User] & """" & " " & """" & [Password] & """" & " /queuefilter " & """" & [Filter Name] & """"

You can see that upon evaluating the above calculation I am getting the following result:

And if I execute the text that got generated as a part of the evaluation, I get the below output from CMD:

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Exporting filtered queue export using automateC

sarathgnair — Fri, 20 May 2022 02:30:00 GMT

Hi Devneet,

Thank you so much for the response.

I tried the logic you provided and its working fine.

Thanks again.
Regards,
Sarath

------------------------------
Sarath Gopinath
------------------------------

RE: Exporting filtered queue export using automateC

devneetmohanty07 — Fri, 20 May 2022 05:49:00 GMT

Hi Sarath,

Thanks for sharing your doubts with the community. Glad your issue got resolved 🙂

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

Re: Exporting filtered queue export using automateC

Neel1 — Fri, 11 Oct 2024 12:00:13 GMT

i have a similar question so using this thread .

is there any way we can feed date range as switch while exporting the Queue data. i tried to look for this in AutomateC command line page but could not find .