I need a desktop software/script to fill data on my website from a csv file.
There are 4 columns in the csv file - name, description, country and url.
There are 4 fields on my site - name, description, country and [url removed, login to view] country field, it needs to be selected, not empty field to fill like other fields, I need the software to be able to select the [url removed, login to view] country field, in my csv, it contains either AU or Australia, I want it to be able to select australia when ever it sees AU or Australia, and also, if there is comma and more than 1 country, it will select more than 1 country.I think my site uses 3 country code format AUS for Australia, maybe we need to first convert all the country code from 2 code (AU), 3 code (AUS) and full name (Australia) to the 3 code format first, then the script/software can run.
It's pretty simple software.
I have low budget and I need it asap.