How to export queue by command lines

[hantao]

I have got a command about exporting queue data as following:

"C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe" /sso /queuename 'Queue_2xxx' /queuefilter 'xxx' /exportqueue 'C:\test\queuelist.csv'

but, received a exception:

Login failed: Blue Prism user is not associated with a current Windows account.

how can i add a windows account to BluePrism ?

[Neel1]

@hantao - if you are not using SSO . can you try with switch / user / password

i am able to export the Queue Data with /sso switch

No queue filter specified: exporting all queue items without filtering
Exporting queue data ...
... Report written - C:\TEMP\abc.csv
Done

C:\Program Files\Blue Prism Limited\Blue Prism Automate>

[Nandhakumar]

Hi @hantao ,

yes, i'm able to export queue items with below command line without filter using /sso. But facing a different issue when tried using /user /password as below.

SSO:
"C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe" /sso /queuename "Queuename" /queuefilter "" /exportqueue "C:\Users\queuelist.csv"

Non SSO:

"C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe" /user "xxxxxx" /password "xxxxx" /queuename "Generic Exception Report" /queuefilter "" /exportqueue "C:\Temp\queuelist.csv"

error: Invalid command-line argument '/user'

[sarathnair]

Hi @hantao  @Nandhakumar  If you are using sso you can export using this command.

If you are using a non sso, you need to make sure the user id which you have logged in to export the reports should have access to export reports in blue prism. and you can use the below logic for this in blue prism.

Argument : " /exportqueue " & """" &[Exports] & [Queue.Queue Name] & "_Export.csv" & """" &" /queuename " & """" & [Queue.Queue Name] & """" & " /sso "  &  " /queuefilter " & """" & [Filter] & """"

Application : "C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe"

Regards,

Sarath

[Nandhakumar]

Hi @sarathnair ,

Yes, the id which im using has the access to export. i'm able to export the report via SSO but getting the error for Non SSO.

Thanks,

Nandha

[naveed_raza]

@sarathnair 

can you please share dummy data/value of each data item from this 

Argument : " /exportqueue " & """" &[Exports] & [Queue.Queue Name] & "_Export.csv" & """" &" /queuename " & """" & [Queue.Queue Name] & """" & " /sso "  &  " /queuefilter " & """" & [Filter] & """"

[david.l.morris]

I see this was necro'd, but I think the answer to the non-SSO error is pretty simple so I figured I'd respond.

@Nandhakumar You probably already figured this out by now, but the issue in your Non SSO command is that it should be like this: /user myusername mypassword. There is no switch called /password, at least not used for this command anyway. So it should be the switch of "/user" followed by the username followed by the password.

[Michael_S]

Locked: Thread Necromancy. If you are impacted by this issue, please start a new discussion. Thank you!