Blue Prism Product

Dear All,

I have an issue with the OLEDB Excel Connection. 
My source Excel file contains columns with where the datatype can be different, like in columns B and C.
When I use the Get Collection action for OLEDB in the result collection I lose data (a,b,c in the last 3 rows), because the datatype for column B is number instead of text.
I changed the "TypeGuessRows" registry from 8 to 0, and the "ImportMixedTypes" registry from "Majority Type" to "Text".
I also added True flag to the "Treating Data As Text" in the Set connection OLEDB action.

Could you please help, how can I set Blue Prism not to define the datatype of a column based on the first few rows?
Thank you.

------------------------------
Erika Papp
RPA Specialist
Winformatics
Europe/Budapest
------------------------------

We always add & "" to every column to ensure everything arrives in BP as a STRING.

------------------------------
Clive Barnard
Intelligent Automation Solution Architect
TJX Europe
Europe/London
------------------------------

Original Message:
Sent: 03-24-2020 10:40
From: Erika Papp
Subject: OLEDB Excel connections - mixed type columns

Dear All,

I have an issue with the OLEDB Excel Connection. 
My source Excel file contains columns with where the datatype can be different, like in columns B and C.

When I use the Get Collection action for OLEDB in the result collection I lose data (a,b,c in the last 3 rows), because the datatype for column B is number instead of text.
I changed the "TypeGuessRows" registry from 8 to 0, and the "ImportMixedTypes" registry from "Majority Type" to "Text".
I also added True flag to the "Treating Data As Text" in the Set connection OLEDB action.

Could you please help, how can I set Blue Prism not to define the datatype of a column based on the first few rows?

Thank you.

------------------------------
Erika Papp
RPA Specialist
Winformatics
Europe/Budapest
------------------------------

Could you please help me where and when should I add the &"" to the columns? Thank you.

------------------------------
Erika Papp
RPA Specialist
Winformatics
Europe/Budapest
------------------------------

Original Message:
Sent: 03-24-2020 10:52
From: Clive Barnard
Subject: OLEDB Excel connections - mixed type columns

We always add & "" to every column to ensure everything arrives in BP as a STRING.

------------------------------
Clive Barnard
Intelligent Automation Solution Architect
TJX Europe
Europe/London

Original Message:
Sent: 03-24-2020 10:40
From: Erika Papp
Subject: OLEDB Excel connections - mixed type columns

Dear All,

I have an issue with the OLEDB Excel Connection. 
My source Excel file contains columns with where the datatype can be different, like in columns B and C.

When I use the Get Collection action for OLEDB in the result collection I lose data (a,b,c in the last 3 rows), because the datatype for column B is number instead of text.
I changed the "TypeGuessRows" registry from 8 to 0, and the "ImportMixedTypes" registry from "Majority Type" to "Text".
I also added True flag to the "Treating Data As Text" in the Set connection OLEDB action.

Could you please help, how can I set Blue Prism not to define the datatype of a column based on the first few rows?

Thank you.

------------------------------
Erika Papp
RPA Specialist
Winformatics
Europe/Budapest
------------------------------

OK, slightly crossed wires and a better explaination:

We us SQL to extract the