software needed to: download a file, then use it to modify a .csv database file, then upload the newly modified .csv file. Platform: Windows XP/Office.
*need entry areas for entered data.
1. at a certain time: ftp, using a password, to download the price and inventory update file.
2. using the entered name of the price column, and an entered formula, if there is a price in the price field of the record, modify the price according to this formula.
3 .then using the entered name of the model number column, use the model number field to match the correct record(s), and overwrite the modified price into all the records' price fields in an entered/named database file, and also overwrite the inventory fields in it using the entered inventory column name.
4. using the entered name of the over-ride price column, have an over-ride price option(using a checkbox to turn on or off), where the over-ride price and its own entered formula, is used instead of the price if there is a price in the over-ride field.
5. at a certain time, ftp upload the updated database file using a password.