SQLite Data Fetch Script
Budget: $30 – $250 USD
We need a small script that will extract 4 fields from a password protected SQLite database, create a csv file and then upload it to a FTP server.
It also needs to be a config file of some type where we can add the following;
- Path to database
- Password to database
- FTP information (server, username,password, port, csv path and destination path)
- In the config file the system also needs to write the timestamp on last exectution.
The timestamp will update every time the script/file is run, and we will use that to only extract the fields in the database that is edited after that date/time.
(Since the database contain 15k lines, we only want to export the ones that have been created or edited since it was last run)
It also needs to be a config file of some type where we can add the following;
- Path to database
- Password to database
- FTP information (server, username,password, port, csv path and destination path)
- In the config file the system also needs to write the timestamp on last exectution.
The timestamp will update every time the script/file is run, and we will use that to only extract the fields in the database that is edited after that date/time.
(Since the database contain 15k lines, we only want to export the ones that have been created or edited since it was last run)