We have one excel file provided to us daily by a vendor which contains information that we manually need to review on a daily basis. Many times, our data team is unable to get through the entire spreadsheet before the next day's spreadsheet arrives. We need a solution using php, that accomplishes the following:
Import a "starting" csv and "add" csv. The code will compare do the following:
Remove certain records from the "add" csv that don't pertain to us
Compare it to the "starting" csv and append records to it that have not been "acted" upon in the "starting" csv.
Provide an new "CSV" that has any non-worked records appended, but none that have been "worked" duplicated.
Ideally, we would not use any database to accomplish this task. More discussion may be required for you to provide a final quote, however I am looking for initial quotes and time estimates.
Will send samples of csv file to interested candidates.