Compare files to previous day's files and report differences

Lukket Lagt ut 6 år siden Betales ved levering
Lukket Betales ved levering

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.

Coding Databehandling Eposthåndtering Excel Programming

Prosjekt-ID: #15058061

Om prosjektet

34 bud Eksternt prosjekt Aktiv 6 år siden

34 frilansere byr i gjennomsnitt $204 for denne jobben

jaylancer43

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 Mer

$200 USD på 3 dager
(842 Omtaler)
9.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I can add code so that you can do this task multiple times in the future. Relevant Skills and Experience Mer

$160 USD på 3 dager
(419 Omtaler)
8.2
schoudhary1553

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 Mer

$250 USD på 2 dager
(486 Omtaler)
8.4
P0L

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.

$250 USD på 5 dager
(489 Omtaler)
8.0
Khurramz

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

$250 USD på 5 dager
(406 Omtaler)
7.8
TonmoyRoy111

A proposal has not yet been provided

$200 USD på 3 dager
(489 Omtaler)
7.4
Attractionnet

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 Mer

$133 USD på 3 dager
(151 Omtaler)
6.8
ksriniravi

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 Mer

$100 USD på 2 dager
(220 Omtaler)
7.0
avinav606lx

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 Mer

$40 USD på 2 dager
(168 Omtaler)
6.5
KavTan

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html Relevant Skills and Experien Mer

$250 USD på 5 dager
(54 Omtaler)
6.3
aminbros

A proposal has not yet been provided

$377 USD på 3 dager
(14 Omtaler)
5.6
prakashmondal

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 Mer

$250 USD på 10 dager
(14 Omtaler)
4.7
novepi1

Hi, How exactly you want to run this program? Is it supposed to be a desktop or web application running on a server? By the way, there's only 1 file is attached, 2 of them missing. Relevant Skills and Experience auto Mer

$200 USD på 3 dager
(5 Omtaler)
4.5
NewHorizons2016

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 Mer

$200 USD på 3 dager
(5 Omtaler)
4.6
jonathanpradas

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 Mer

$100 USD på 3 dager
(20 Omtaler)
4.7
furqanahmed55

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 Mer

$250 USD på 1 dag
(8 Omtaler)
5.0
prakash2813

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 Mer

$300 USD på 3 dager
(11 Omtaler)
4.4
asad090

Hey there, i would like to discuss with you about the project please allow me to speak with you. Thanks. Relevant Skills and Experience Data Processing, Email Handling, Excel, Programming Proposed Milestones $100 USD Mer

$100 USD på 7 dager
(7 Omtaler)
4.2
mcfarhat

hey there, we can create a PHP script for you that, when fed the 2 files, it would be able to compare both and then send you the changes/missing items, via email if needed Relevant Skills and Experience we have 13+ ye Mer

$500 USD på 3 dager
(3 Omtaler)
3.9
swift555

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.

$200 USD på 3 dager
(3 Omtaler)
3.4