Policy number lookup - offline standalone application

$10-30 USD

Completed

Posted

over 9 years ago

$10-30 USD

Paid on delivery

I have a dataset of 2.5million records (id, reference) stored in comma separated text file, Each ID is associated with 1 of 5 references. e.g. 1B3242MK,A 2C003212KL,S L001DH728,A I have a web version of a tool using php and MySQL that when you type in an id will return a web address based on the reference. eg. A,[login to view URL] C,[login to view URL] L,[login to view URL] R,[login to view URL] S,[login to view URL] What I need is a standalone version for offline use. I had set up an excel spreadsheet where the user enters the ID and is return the URL via a VLOOKUP in a VLOOKUP but unfortunately excel will only handle 1,048,000 rows and at the moment the dataset is 2.5million rows (and 30Mb). The application should not 'install' anything into the client PC. The data is likely to be updated quarterly so this will need to be reusable. Please explain how you will approach the solution rather than simply say you can do it as I do not have time to waste - otherwise I'd google a solution!

Excel

MySQL

PHP

Software Architecture

XML

Project ID: 6978617

About the project

11 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@zExcel

Hi, I can write a macro in Excel that will overcome the 1048576 row limitation Let me know if you're ready to start .....................................................................................

$50 USD in 1 day

4.9

(133 reviews)

6.7

11 freelancers are bidding on average $59 USD for this job

@rajeshsonisl

Hello! With 99% completion rate, 740 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni

$105 USD in 1 day

5.0

(552 reviews)

7.6

@quickprogexpert

Hello, I can write a Perl application that will handle the csv file as a database. Perl has library to handle this. I will provide a simple GUI and have it compiled it into an exe, and need to be deployed on any windows machine with a dll. Perl need not be installed. Please get back for further discussions. Thanks, Shweta

$100 USD in 1 day

4.9

(147 reviews)

6.4

@maverick44000

Hi. Simply spread the data across multiple sheets and use a VBA script to find look up value. Its pretty simple. Please discuss if you are interested. Regards.

$40 USD in 1 day

5.0

(52 reviews)

6.4

@DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

$100 USD in 2 days

4.9

(142 reviews)

6.0

@clickcubes

PREFERRED FREELANCER -------- Windows and web based application developer -------- Highly quality output based work. ----- PM to discuss. Regards, Nick

$59 USD in 5 days

4.9

(34 reviews)

5.7

@expertatwork

we can code a c# application to parse through your csv file and populate the values.... please reply with your huge excel file.... thank you...

$35 USD in 1 day

4.8

(98 reviews)

5.4

@augustogus

Good evening, I'd use Delphi and codebase dbf database. it's the fastest way to do a look up in a dataset; then a simple form with an input box and a button. on enter the Id I lookup the reference then if you wish I'd launch the browser to that web address. Please accept my best regards Augusto Pellis

$56 USD in 2 days

5.0

(3 reviews)

3.1

@macroPOL

Hello, I think I can do the project. I would like to write a macro that reads the data to excel sheet - split the file into parts, and write in columns. The first part of the data in columns "A - B", another in columns "D -E", etc. This way you can bypass the limitation of the number of rows in excel. The second macro should search for data in the worksheet. If you have any questions I will be happy to answer. Best Regards Jan Krzyzak

$39 USD in 3 days

5.0

(4 reviews)

2.6

@voty

Hello, Not really a good idea to use Excel for 2.5mil records dataset I would say. The data should definitely be stored in some kind of database. I can build a simple Java application. It will use sqlite database as a storage area for your dataset. Then no problem to lookup the reference as you need it. For the quarterly updates, there will be an option to import or update the data from the CSV file. Or it can import the data directly from MySql database if you prefer. The application will work on Windows/Linux (and possibly MAC). No installation required as Java is part of any standard Windows/Linux desktop. Cheers, David.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@shadowedvaca

I have worked extensively in Excel specializing in VBA and automated data transformation for 10 years. I have completed many tasks just like this at my prior employeer. My process here would be to design a excel book that picks up the list and stores it using an array and then loops thru the array on demand to return results. I will include a button to refresh the data file on demand so when you get an update while you have the spreadsheet open, you need only to push a button to pull the new data into the code. If you have questions on my approach, let me know. I would be happy to speak more on this if you need.

$35 USD in 1 day