Policy number lookup - offline standalone application

$10-30 USD

Concluído

Publicado

há mais de 9 anos

$10-30 USD

Pago na 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 do Projeto: 6978617

Sobre o projeto

11 propostas

Projeto remoto

Ativo há 9 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido 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 em 1 dia

4,9

(133 avaliações)

6,7

11 freelancers estão ofertando em média $59 USD for esse trabalho

@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 em 1 dia

5,0

(552 avaliações)

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 em 1 dia

4,9

(147 avaliações)

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 em 1 dia

5,0

(52 avaliações)

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 em 2 dias

4,9

(142 avaliações)

6,0

@clickcubes

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

$59 USD em 5 dias

4,9

(34 avaliações)

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 em 1 dia

4,8

(98 avaliações)

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 em 2 dias

5,0

(3 avaliações)

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 em 3 dias

5,0

(4 avaliações)

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 em 1 dia

0,0

(0 avaliações)

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 em 1 dia