Ok, we're working with a vendor on a site redesign at work, and one of the things we want to add is a functionality that allows us to automatically update certain datapoints on the site.
We want to have a .csv file FTP'd from a service provider containing a number of data points. We need a program to take those data points and copy each of them to the appropriate cell in a new row on the database. We then need the site to detect that a new row exists, and refresh to display values from that particular row rather than the previous row.
So, for example, say the site currently displays Value A, Value B, and Value C. A new .csv file comes in, and creates a new row on the database containing Value D, Value E, and Value F. We'd expect the website to update so that it also now shows Value D, E, and F, even though A, B, and C are still saved to the prior row on the database. This update would happen once a day, business days only. Over and above this we would also want the ability to have users of the website export the entire database as either .xlsx or .csv.
How much work would this take to write and integrate on a website? My gut sense is "not much," and that this is pretty basic SQL (probably) as far as integration goes, but we all know that, despite all my tireless hours spent updating and fixing this site, I'm also blessed with the coding aptitude of your average medium-rare steak, so I wanted a sanity check.
(and this thread is likely to get referenced in internal discussions at my employer, so please refrain from our usual shenanigans so I don't have to clean it up in case anyone wants to see it )
IMO, $100 job if you just want a quick perl script to monitor the FTP folder and do it on the fly. Multiply that cost x10 if you want it done in C++ or PHP.