Decipher

 View Only
last person joined: 11 hours ago 

A community for Blue Prism Decipher users.

  • 1.  Validation list with ODBC and Excel

    Posted 11-29-2023 13:29

    Hi,

    I see in Batch types there is a setting called Validation lists which allows to use Odbc to connect to database. In my case I want to use Excel file.  I use following connection string: 

    Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=C:\Users\JMarkowski\Desktop\test.xlsx;

    When I test connection, it says it's successful, however when I go to document form definition I don't see there any data. 

    Does anyone have experience with using Excel file for creating Validation list and Dynamic list? 



    ------------------------------
    Jakub Markowski
    ------------------------------


  • 2.  RE: Validation list with ODBC and Excel

    Posted 12-05-2023 11:56

    I've never used validation lists (not used the BP product for about 6 years) - but have used OLEDB to interface with Excel a number of times.
    The way that I did it that always worked was to use the Data - OLEDB interface object (it is available on the digital exchange) and follow the old OLEDB guide that can be found here:  Blue Prism - Data OLEDB

    If BP have now built OLEDB into the core product I am not sure why,  there was a perfectly easy to use way of doing it with the object and lots of more useful things on the product backlog that have been outstanding for years.




  • 3.  RE: Validation list with ODBC and Excel

    Posted 12-05-2023 15:10

    Hi @Jakub Markowski

    Try changing your connection to string to Provider=Microsoft.ACE.OLEDB.12.0;Data Source=+ File_Path +;Extended Properties='Excel 12.0;HDR=YES;' 

    I havent used validation lists in BP before but thats how i would normally connect to an excel file using OLEDB.



    ------------------------------
    Michael ONeil
    Technical Lead developer
    NTTData
    Europe/London
    ------------------------------



  • 4.  RE: Validation list with ODBC and Excel
    Best Answer

    Posted 12-05-2023 15:12

    Hi All,

    Decipher doesn't currently support the use of OLEDB to connect to an Excel  or csv file.

    The ODBC connector is for connecting to databases only, at this time.

    Thanks



    ------------------------------
    Ben Lyons
    Senior Product Specialist - Decipher
    SS&C Blue Prism
    UK based
    ------------------------------



Welcome to the Blue Prism Decipher Community

Blue Prism Decipher IDP is Intelligent Document Processing for Blue Prism RPA. This is a community for Decipher users to get support and discuss the implementation and usage of product.

This community has been set up so that we continue to work closely with our Decipher users, both new and established. As our members join, we will be using this community to share information, and also hope this will allow all members to discuss ideas and issues around Decipher.

Decipher IDP Resources

Download DecipherProduct Help

FAQs

Decipher IDP is a Blue Prism product for Intelligent Document Processing. It allows organizations to easily extract, analyse and understand data from a range of documents whether these are PDFs, email attachments, or even scanned paperwork.
Decipher IDP is currently available without additional cost to Blue Prism customers with Production or Business-Critical support.
Please contact your Blue Prism Account Manager or Customer Success Director for information on accessing Decipher. They will be able to request a license key which is required to be able to install Decipher IDP.
Yes, a trial version is available for Blue Prism customers. Please contact your Blue Prism Account Manager or Customer Success Director for information on accessing Decipher. We are planning to offer a trial version available for download from our DX later this year.
All documentation for Decipher IDP is available online on BP DOCS.
An extended FAQ can be found here.
Decipher IDP is currently available for Blue Prism Enterprise customer for on-premise installation.