Compare files to previous day's files and report differences
$30-250 USD
Paid on delivery
I receive (via email) files every day from 3 different manufacturers. These files contain SKUS, inventory levels, costs, and other product information. 3 samples attached (2 are csv, 1 is xls) All 3 have different layouts.
I need an automated report of everything that has changed in each file when compared to the previously received file (at the SKU level)
For example, if I receive the file "Inventory_Forecast_UPC" today and "ModelNumber" (aka SKU) ACR4 has Availability of 24, then tomorrow I received the file and the Availability is 23, I need a report (preferably emailed to me) that shows this change.
The report could be xls or text, output like this:
ModelNumber,Changed Field Name,Previous Value, Current Value
ACR4,Available,24,23
Or it could show the previous days' row and the updated row like this:
ACR4 24 0 879297006350
ACR4 23 0 879297006350
I also need to know which items are in the file that were not in the previous day's file.
so if today there is no row for model number ACR4, but tomorrow there is a row with the model number, I need to know it was added to the fill.
I also need to know what items were removed from the file.
Many of you asked for the other files - I'm not sure why they didn't load initially. Adding them now.
I need this to be automated if possible. Not a local program I have to run manually.
Project ID: #15058061
About the project
34 freelancers are bidding on average $204 for this job
Hello, My name is Jay and I am Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of More
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
Hi I can see a csv file only. No xlsx files attached. Could you please send me via chat? Relevant Skills and Experience Excel Proposed Milestones $250 USD - Estimate
Hi. I checked the csv file with the data. Here is my suggestion. I will write a program which you can run on windows and will check your email. It will download the file, read it, track changes etc. Relevant Skills a More
1 sample file attached (not 3). I can set up a solution such that you can import 2 files & the macro would generate a Removed items list, Added items list & discrepancy (same item different Qty) list. Update: Review More
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex More
hi, I am interested to develop a script that can generate a report from csv and excel file from different source. Please consider my bid and let me start with the job. Relevant Skills and Experience c#,.net,php,mysql More
Greetings, I'm a software developer with vast experience. If you wish, I could create a Windows application which takes as input, these 3 files and produces your desired output? Relevant Skills and Experience 25 year More
I believe that my bid is sufficient to finish the project on time with all the requirements already met. I have thoroughly read the project description and I can guarantee I can handle this one. Relevant Skills and Ex More
Hello, I graduated from Boston University USA. I have a lot of experience with report creating in excel with all the details. I never miss work and always deliver on time. - Detail Oriented, as handled many sens More
Hi there, I have read the details and checked attached csv file. Its an easy job for me. I can create a desktop to run in background forever or manually to email differences. Message me, Relevant Skills and Experience More
Hi, i am experienced writer Relevant Skills and Experience I have done many projects related your task Proposed Milestones $200 USD - milestone sure, i can do it and contact with me for more detail.