Hey All,
I had an interesting requirement lately to export blue prism work queue data to csv, and save on a network share...
So I've written a batch file that does that, but noticed that there is one annoying limitation:
The filter by default limits the export to whatever is set on the "Rows Per Page" field.
Now in this particular scenario this is sufficient... however, what if I would have a larger queue?
I can't find anything documented about this anywhere 😕
Does anybody know can this be changed somehow? or is this a hard limitation?
Oh, and Ideally I want to avoid having to build a process just for this.
I know this can be done via the work queue reporting process from DX... but it's too much effort for something that should be simple.
FYI - for the interested people, batch file below:
@echo off
setlocal enabledelayedexpansion
:: ==============================================================================
:: CONFIGURATION PARAMETERS
:: ==============================================================================
:: FIXED: Removed the accidental duplicate quote before C:\
set "BP_PATH=C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe"
:: Blue Prism Queue Name and Saved Filter Name
set "QUEUE_NAME=WorkQueueNameGoesHere"
set "QUEUE_FILTER=QueueFilternameGoesHere"
set "FILENAME_PREFIX=FileNamePrefixGoesHere"
:: Target output directory
set "TARGET_DIR=OutputDirectoryPathGoesHere"
:: Generate a stable YYYY-MM-DD timestamp independent of Windows locale settings
for /f "tokens=*" %%i in ('powershell -NoProfile -Command "Get-Date -Format 'yyyy-MM-dd HH-mm'"') do set "TODAY=%%i"
:: Define full export file path (saves as a .csv report)
set "EXPORT_FILE=%TARGET_DIR%\%FILENAME_PREFIX% - %TODAY%.csv"
:: ==============================================================================
:: EXECUTION
:: ==============================================================================
echo Verifying target directory existence...
if not exist "%TARGET_DIR%" (
echo Directory does not exist. Creating: "%TARGET_DIR%"
mkdir "%TARGET_DIR%"
)
echo.
echo Starting Blue Prism Queue Export...
echo Queue Name: %QUEUE_NAME%
echo Queue Filter: %QUEUE_FILTER%
echo Target File: %EXPORT_FILE%
echo.
:: --- AUTHENTICATION METHOD ---
:: Ideally should be done via credential store, but for smaller deployments this is fine
"%BP_PATH%" /user USERNAME PASSWORD /queuename "%QUEUE_NAME%" /queuefilter "%QUEUE_FILTER%" /exportqueue "%EXPORT_FILE%"
:: FIXED: Using GOTO instead of () blocks to prevent parenthesis from crashing the script
if %ERRORLEVEL% equ 0 goto :success
goto :failed
:success
echo.
echo [SUCCESS] Queue data exported successfully to: "%EXPORT_FILE%"
goto :end
:failed
echo.
echo [ERROR] Export failed with exit code %ERRORLEVEL%.
echo Please verify that the saved filter "%QUEUE_FILTER%" exists in the Control Room and that your credentials are valid.
goto :end
:end
echo.
