Blue Prism University

last person joined: 5 hours ago 

A Community to discuss and learn more about Blue Prism University and certification.
Expand all | Collapse all

Foundation training - consolidation exercise, linking file to data item.

Jump to Best Answer
  • 1.  Foundation training - consolidation exercise, linking file to data item.

    Posted 11-26-2020 06:56

    Good afternoon, everyone!
    I am doing consolidation exercises of foundation training and am trying to create process as described in the slides.


    File excel (Orders.csv) will be the input of this process. But how can I insert the file path inside data item?



    ------------------------------
    Federico Mauri
    ------------------------------


  • 2.  RE: Foundation training - consolidation exercise, linking file to data item.
    Best Answer

    Posted 11-26-2020 09:24
    Edited by Jhogel Ponne 12-11-2020 13:25
    Hi! Federico M. 

    In the Action Open Worbook in the input parameters: 

    handle: Data Item [Handle] (This value is obtained from the Action Create Instance Parameters output)
    File name: Data Item [File Path] (The value is file path example: C:\Orders.csv)

    If you want to change the path of the Data Item File Path, you can open it and change the Initial Value (Data Properties) with the new path and click the Ok button to save the changes

    I hope this help!!

    Cheers
    Action Properties Open Workbook

    Data Properties Data Item File Path


    ------------------------------
    Jhogel Ponne
    Senior RPA
    Ernst & Young
    America/Panama
    ------------------------------



  • 3.  RE: Foundation training - consolidation exercise, linking file to data item.

    Posted 11-26-2020 09:24
    Hi Federico

    Not sure I truly understand your question, but if your excel file is residing on a different path on your computer, just shift right click on your folder and copy as path. You can then open the data item and change the path in the "current value" field.


    Hope this helps

    ------------------------------
    Rup Joshi
    ------------------------------



Share