Accessing CSV file from another Program like Powershell

Hi

Could some please help , I tied everything an nothing works.

I have a uivison macro that extracts data from website, store data into a csv file. How do I access the file from another program let’s say Powershell :

Here is my script, all works till I get to the part where Powershell would access the csv file, nothing happens:

Thank you for your assistance

{
  "Name": "getImprintName",
  "CreationDate": "2025-6-24",
  "Commands": [
    {
      "Command": "comment",
      "Target": "Start script",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "fast",
      "Value": "!replayspeed",
      "Description": ""
    },
    {
      "Command": "csvReadArray",
      "Target": "coin.csv",
      "Value": "arrCoins",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "return Number(1)",
      "Value": "currentLine",
      "Description": ""
    },
    {
      "Command": "if_v2",
      "Target": "${currentLine} == 1",
      "Value": "",
      "Description": "Add header only once"
    },
    {
      "Command": "store",
      "Target": "Date Updated, WIP Number, Title, Error",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "csvSave",
      "Target": "C:\\\\Users\\\\kmt7455\\\\Documents\\\\Automation 2025\\\\powershell\\\\datasource\\\\imprint_list.csv",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "while_v2",
      "Target": "${currentLine} <= ${!csvReadMaxRow}",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "open",
      "Target": "https://www.",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "${currentLine}",
      "Value": "!csvReadLineNumber",
      "Description": ""
    },
    {
      "Command": "csvRead",
      "Target": "coin.csv",
      "Value": "currentCoin",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "//*[@id=\"isbn\"]",
      "Value": "${!COL1}",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "//*[@id=\"butt_isbn\"]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "storeValue",
      "Target": "//*[@id=\"WIP\"]",
      "Value": "myWIP",
      "Description": ""
    },
    {
      "Command": "if_v2",
      "Target": "${myWIP}==\"\"",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "Not Found",
      "Value": "myWIP",
      "Description": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "storeText",
      "Target": "//table/tbody/tr[td[contains(translate(text(), 'IMP', 'imp'), 'imp')]]/td[3]",
      "Value": "column3Value",
      "Description": ""
    },
    {
      "Command": "if_v2",
      "Target": "${column3Value} != \"\"",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "${column3Value}",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "${myWIP}",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "storeText",
      "Target": "//table/tbody/tr[td[contains(translate(text(), 'IMP', 'imp'), 'imp')]]/td[1]",
      "Value": "column1Value",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "return ${column1Value}.indexOf(${myWIP}) === 0",
      "Value": "isImprintMatch",
      "Description": ""
    },
    {
      "Command": "if_v2",
      "Target": "${isImprintMatch} == true",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "${column1Value}",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "else",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "Not Found",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "csvSave",
      "Target": "C:\\\\Users\\\\kmt7455\\\\Documents\\\\Automation 2025\\\\powershell\\\\datasource\\\\imprint_list.csv",
      "Value": "!csvLine",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "return ${currentLine} + 1",
      "Value": "currentLine",
      "Description": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "echo",
      "Target": "Done!",
      "Value": "#shownotification",
      "Description": ""
    },
    {
      "Command": "XRunAndWait",
      "Target": "C:\\\\Users\\\\kmt7455\\\\Documents\\\\Automation 2025\\\\powershell\\\\RunOpenPDFs.bat",
      "Value": "",
      "Description": ""
    }
  ]
}

Good question. In the default mode, CSV files are stored inside the web browser’s local storage.

Solution: Switch Ui.Vision to hard-drive storage mode.

In hard-drive mode csvRead and csvSave read and save directly to files, instead of using the browser local storage.