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”: “”
}
]
}