Policy number lookup - offline standalone application

$10-30 USD

Terminado

Publicado

hace más de 9 años

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 6978617

Información sobre el proyecto

11 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

4,9

(133 comentarios)

6,7

11 freelancers están ofertando un promedio de $59 USD por este trabajo

@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 en 1 día

5,0

(552 comentarios)

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 en 1 día

4,9

(147 comentarios)

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 en 1 día

5,0

(52 comentarios)

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 en 2 días

4,9

(142 comentarios)

6,0

@clickcubes

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

$59 USD en 5 días

4,9

(34 comentarios)

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 en 1 día

4,8

(98 comentarios)

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 en 2 días

5,0

(3 comentarios)

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 en 3 días

5,0

(4 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día