Removal of the used url from the csv file


#1

I have a simple code that opens the address and writes a message:

{
“Name”: “Makro”,
“CreationDate”: “2018-12-9”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “url-list.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “${!col1}”,
“Value”: “”
},
{
“Command”: “pause”,
“Target”: “5000”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “link=NAPISZ DO MNIE”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=form_message”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=form_message”,
“Value”: “my message”
},
{
“Command”: “clickAndWait”,
“Target”: “id=form_save”,
“Value”: “”
},
{
“Command”: “pause”,
“Target”: “5000”,
“Value”: “”
}
]
}

I want the program to remove the already used url from the csv file (url-list.csv) and save it.
I tried to use csvSave, but it does not work ;(.


#2

You can not modify an existing CSV file with csvSave, except append to it.

Solution: Create a new CSV where you store all used URLs, and then remove them manually (or with an external script).

When reading data, you can also start at a certain CSV line number (e. g. 12) with !csvReadLineNumber:

Store | 12 | !csvReadLineNumber