Terminé

Policy number lookup - offline standalone application

I have a dataset of [url removed, login to view] 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,[url removed, login to view]

C,[url removed, login to view]

L,[url removed, login to view]

R,[url removed, login to view]

S,[url removed, login to view]

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 [url removed, login to view] 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!

Compétences : Excel, MySQL, PHP, Architecture Logicielle, XML

en voir plus : spreadsheet to web application, n is a number, i need the number to twitter, google lookup spreadsheet, Vlookup, standalone, excel vlookup, excel solution to return, facebook web based application, standalone data, standalone web, web lookup excel, vlookup mysql, excel vlookup mysql, php mysql web based spreadsheet, text offline, number lookup, standalone application, application based twitter, standalone php application

Concernant l'employeur :
( 29 commentaires ) Burnham on Sea, United Kingdom

Nº du projet : #6978617

Décerné à:

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 .....................................................................................

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(133 Commentaires)
6.7

11 freelance font une offre moyenne de $59 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(552 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(147 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(52 Commentaires)
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?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(142 Commentaires)
6.0
clickcubes

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(34 Commentaires)
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...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(98 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
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 col Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 bo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0