Find Jobs
Hire Freelancers

Data Sorter/Exporter

$250-750 NZD

Closed
Posted about 6 years ago

$250-750 NZD

Paid on delivery
We build Fuel Management Systems and are producing a system that is not connected to our cloud platform. We are wanting a small application built to run on Windows. Preferable an EXE that we can store on a flash drive with other files. My engineers are to busy with projects to complete this one so we are outsourcing it. Basically we have twoCSV files. 1) One is a list of users with Names, ID Numbers and access rights etc. This is used to download information to our field units by our handheld controller (Essentially a flash drive) . All info except the User Names are loaded to the field module. 2) The second is a file that is downloaded from the field unit, this is a list of transactions, which has the user ID numbers but no names. What we want to do is take the second file, match the User IDs with the User Names in the first file, delete any duplicate transactions and produce and Ecxel spreadsheet with the results that so the User Name, User ID and some other information. (System ID) taken from a third CSV file. My thinking is that we keep this application on the flash drive and automatically detect the two files (they will have fixed file names) from the same flash drive, will perform the task then open an excel spread sheet of the result. This could even run automatically when the flash drive is plugged in so the user does not have to do anything. A small .ini file may be used to set perimeters like the file names or final file extension, maybe even if it auto runs or not etc.
Project ID: 16669938

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $416 NZD for this job
User Avatar
Hello, I have the good knowledge of Data Sorter/Exporter. I have more than 5 years of experience in Excel, Software Development, Windows Desktop. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$600 NZD in 10 days
4.9 (327 reviews)
7.9
7.9
User Avatar
Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
$250 NZD in 4 days
4.9 (436 reviews)
7.5
7.5
User Avatar
Dear Employer, I'm ready to work on automatically detect the two files from the same flash drive, perform the task then open an excel spread sheet of the result project. Relevant Skills Excel, VBA Milestones 231 NZD - project requirements done and delivered 231 NZD - last milestone after full checking and testing I read through the job details carefully and I am sure that I can do the project.
$463 NZD in 6 days
5.0 (119 reviews)
6.5
6.5
User Avatar
- Can get the first file with Name, ID and Number and access rights comparted with the second file having the list of transactions. - Based on the matching userid, delete the duplicate transactions and have the consolidate file generated. - The simple way is to run with a button click, if it needs to autodeduct need to have the same filenames and can make it to run searching in the particular location. - Can disucss. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
$250 NZD in 3 days
4.7 (48 reviews)
6.0
6.0
User Avatar
Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on Crypto Currency, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendly Interface And Clear Algorithm Will Encourage Your Project. I want a long term relationship with you. Thank you and best regards!
$666 NZD in 10 days
4.9 (13 reviews)
5.7
5.7
User Avatar
I can develop windows application in C# for desktop and will provide the source code as well. Just send me the sample input files and output file format you like to have and consider it is done. I have over 10+ Years of experience working with desktop application. Let me know and we can get this started and finish it as a whole in no time at all. Thanks
$250 NZD in 10 days
5.0 (12 reviews)
4.8
4.8
User Avatar
Hi there, I could develop a Windows .NET C# console application which can read/save/modify CSV files and starts when flash drive is plugged. This would be a simple EXE file and maybe a settings file or so. Development takes days and I'd need sample CSV to test the app and make sure it works as expected.
$500 NZD in 10 days
5.0 (3 reviews)
3.5
3.5
User Avatar
Hi, let me build this executable for you. I can write it in Java or pure EXE file if needed, so you can run anywhere. The program will merge both files following your instructions and outuput the results to another file. Please send me examples of the 2 csv files. Thanks
$250 NZD in 2 days
5.0 (1 review)
3.3
3.3
User Avatar
Hi. Please see my profile for samples. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$250 NZD in 3 days
4.3 (11 reviews)
3.4
3.4
User Avatar
Hi, my name is Andrew, British programmer (30 years experience). Your project should be straight forward, and I would be very happy to write it for you. Recently I've done a lot of work with CSV files and data sorting - I can provide links to these should you want to have a look at them. One area of the project that needs clarification is how free from error are the CSV files? obviously you make a point that there could be duplicate transactions, this is no problem as these can be filtered out. I would write a small .exe file that would fit on a usb flash drive, together with an auto run file (.ini) which would invoke the program when the drive is inserted, after that everything would be automated so the user does not have to do anything, i.e. the drive is inserted, the program runs, sorts the data and opens Excel with the new CSV file displayed. I have written many different types of programs over the years from basic automated systems to registry editors - and I always aim to get the program right the first time around. Would it be possible to have a sample of the two CSV files? as I will need to know the order of the data fields. I can supply links and references to you should you require them, and I'm available to start on this right away. About myself: I first learnt to program in Assembly, moved on to COBOL and then on to windows programming, and I now have 30 years experience and love every minute of it. Please feel free to contact me here, thanks, Andrew.
$444 NZD in 7 days
4.3 (2 reviews)
3.4
3.4
User Avatar
I'm a software developer from the U.S. with ample experience parsing and handling csv data. I could write a simple java application by today to get your simple task done, or write an executable if that's what you strongly prefer. I'd be happy to get this knocked out for you! If you have any questions or concerns, don't hesitate to shoot me a message! Thanks, Adam
$333 NZD in 1 day
5.0 (1 review)
2.2
2.2
User Avatar
Hello, I will make you the sorter as per your specifications, but I'll need to first assess the actual csv files and maybe even for you to describe how you deal with this process right now. That is all. Cheers.
$566 NZD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can create a simple application to aggregate your csv files based on primary keys. The only concern I have is not understanding what you mean by Auto run on the thumb drive. I need more clarification on this requirements before I can accept your job. Thank you
$333 NZD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked for more than 18 years as department secretary abroad and have enough experince in all office works, data entry typing exams and quizzes, textbooks and other related office works.
$611 NZD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day! Have gone through your requirement and understand that you need a simple and portable .EXE file which can merge and generate a new Xls/CSV sheet from two separate Xls sheets by matching "User Id" field. This is very much possible to do with zero faults with the aid of .NET technologies. But in case of auto-run feature from a USB, WIN10 is blocking auto-run feature by default as a security measure. Hence suggesting to develop the program as a service which keeps searching for the USB drives for a specific signature file and if found, it will read the content of the file for required file names and will continue the operation. I am very much interested in your project and have more than 10 years of experience in .NET technologies. Hope to hear soon.
$250 NZD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 NZD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please assign, will provide the solution immediately. Available now for quick turnaround. Reach me now.
$250 NZD in 6 days
0.0 (0 reviews)
0.8
0.8
User Avatar
I have 15+ years of experience in software development. I can provide good solution for your requirement.
$555 NZD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NEW ZEALAND
Tauranga, New Zealand
5.0
1
Member since Mar 22, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.