akkash
1
Hi I have list of shortened url . I just need to open link and write the final links in csv and save file
any body can help please ??
I’m able to open links 
but not able to save the each url to csv and then save the file
{
“Name”: “pin”,
“CreationDate”: “2020-8-2”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “book2.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “{!col1}",
"Value": ""
},
{
"Command": "storeEval",
"Target": "var string = \"{!col1}”; var stripped = string.replace(/[^A-Za-z0-9]/g, ‘’); stripped;",
“Value”: “alphanumericonly”
},
{
“Command”: “csvSave”,
“Target”: “links”,
“Value”: “”
},
{
“Command”: “localStorageExport”,
“Target”: “links.csv”,
“Value”: “”
}
]
}
any help please
After you opened the url and load the final url you can save it with this command
{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},
After you save ${MyUrl} in csv
akkash
3
thanks for replying but I got error after add the command
There are errors in the source
any recomandation ?
What error ?
Post complete macro code and complete log
Thanks
akkash
5
thanks
{
“Name”: “pin”,
“CreationDate”: “2020-8-3”,
“Commands”: [
{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},
]
}
Unexpected token ‘“’ at 10:1
“Command”: “executeScript”,
^
{
“Name”: “pin”,
“CreationDate”: “2020-8-3”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “book2.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “{!col1}",
"Value": ""
},
{
"Command": "storeEval",
"Target": "var string = \"{!col1}”; var stripped = string.replace(/[^A-Za-z0-9]/g, ‘’); stripped;",
“Value”: “alphanumericonly”
}
{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},
]
}
Unexpected token ‘{’ at 20:5
I will realy appriciate if you can write the whole map I just have links in csv need open click links write final links and save all in csv file
thanks in advance
Your code is wrong, you must create a code reading docs command
https://ui.vision/rpa/docs
Latest command do not require ,
storeEval is deprecated, remove it and use update command.
before create a macro you must study the docs with all command and not copy and paste command codes otherwise you have errors.
How can i save to csv just the domain names from the entire url? Note that the domains are random…Please help.
Use split function and save the part you need
Here example