Blue Prism Product

 View Only
last person joined: 9 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  CSV field name not matching

    Posted 02-28-2023 17:54


    Im attempting to build an automation where a csv file is downloaded and then its saved into a collection and then sent to a work queue to be worked.

    This CSV file has lots of unwanted data in it and the only data i need for the automation is the employee numbers which all sit under the first column which has a header of 'Employee Number'.

    My issue is when i run the process it populates the all the field names on csv but its saving the 'Employee Number' field as 'Employee Number' .. i have no idea why its putting those symbols before Employee Number and this is in turn not returning any of the employee number current values as its looking for Employee Number but has captured it as Employee Number

    See below - CSV file - field name shows as Employee Number

    Collection field name shows as

    is it because the CSV has a cursor at the very start of that Employee Number heading? and if so how do you get it so it doesn't have the cursor or how do you programme it so it doesn't incorporate that '' at the start.

    Thanks in advance to anyone who can help me!


    Frankie Legg

  • 2.  RE: CSV field name not matching

    Posted 03-01-2023 06:17

    Hi @Frankie Legg 

    Can you also let us know what action you are using from which business object (VBO) exactly? The reason for such an error is not using the proper file encoding type as it seems to me form your screenshot. The cursor won't have anything to do with it as I particularly suppose you are using some sort of a VB .NET code in the business object that you are using rather than spying notepad.

    I can suggest one way to try if that helps. You can go inside the 'File Management' business object and go to the action 'Read All Text From File' and then in the code stage make the modification which I have highlighted once:

    NOTE: I would recommend to create a duplicate copy of the File Management business object and make the changes there and use that so that you don't mess up the original business object if it used by some other bot in your environment.

    Your updated code should look like below:

       If File.Exists(File_Name) Then
       	Dim sr As New StreamReader(File_Name,System.Text.Encoding.ASCII)
       	Text = sr.ReadToEnd
       	Success = True
       	Message = ""
          Throw New ApplicationException("The file at " & File_Name & " does not exist")
       End If
    Catch e As Exception
    	Success = False
    	Message = e.Message
    End Try​

    Here, I have just added an extra parameter called as 'System.Text.Encoding.ASCII' which will try to change the encoding format while reading your text file so that proper text can be identified. If this parameter does not work, feel free to experiment with some other parameters as each file differs from one another. Some of the encodings which can be used are: 'System.Text.Encoding.Default', 'System.Text.Encoding.UTF8', 'System.Text.Encoding.UTF16'

    More information can also be found at the following website: How to use character encoding classes in .NET | Microsoft Learn

    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

    Devneet Mohanty
    Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
    WonderBotz India Pvt. Ltd.
    Blue Prism Community MVP | Blue Prism 7x Certified Professional


  • 3.  RE: CSV field name not matching

    Posted 03-01-2023 14:42

    Thank you very much for your detailed response - i will keep this in mind for future builds as we have since resolved the issue .

    Frankie Legg

  • 4.  RE: CSV field name not matching
    Best Answer

    Posted 03-01-2023 09:35

    Hi @Frankie Legg 

    I have encountered a similar issue once. My csv file was in UTF-8 format. Below approach resolved my issue.

    1.  Read data from a formatted csv file and store it in a text data item. Utility - File Management-->Read All Text From File
    2. Save the text data item obtained from step1 to a new csv file. Utility - File Management-->Write Text to File
    3. Now read the data from new csv file to a collection. Utility - File Management-->Get CSV Text As Collection

    You can try implementing this logic and see if it is of any help.

    Sonam Sharma
    Manager, Blue Prism

  • 5.  RE: CSV field name not matching

    Posted 03-01-2023 14:41

    thank you so much - we have followed the steps you suggested and this is now working ! 

    Frankie Legg

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements


Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.