Find Jobs
Hire Freelancers

Format and put full-text searchable database online

€30-250 EUR

Completed
Posted over 9 years ago

€30-250 EUR

Paid on delivery
Our non-profit organization wants to put 280,000 listings of historical information for people online, already exists in FM (or tab-sep TXT) format as a flat database, fields Full Name (also fields for last, first and maiden), date of birth (year of birth already in field for searches), place of birth, street address, building floor or institution name, district, city, *marker as Holocaust victim. Entire file as TXT doc is just under 30mb. Want to format it as relational if necessary (every field has many same items) and get it working the best way possible for minimum server load. Sample file of 1000 entries for estimate is attached as .TAB file UTF-8 text encoding, 1st entry is field names. We need to be set up so that we can occasionally make corrections to the data with minimal technical know-how. Deadline ASAP, no later than October 24... soon! Please email me for estimates, and please do not make a bid if you are not 100% sure about the deadline.
Project ID: 6561797

About the project

13 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
Hi, Thanks for inviting me to bid on your project. I have a few questions for you. I had a look at your sample data and it seems to me that the file is already organized as a a relational table would be. I'm not sure what you mean by "every field has many same items) could you please clarify? Is it that the same family name for instance appears several times on different records? If this is the case they should be separate records because they represent different people. In any case I could just add a unique numeric ID for each record. I understand German so I understand the column names however I.m not sure what the institution represents. Would you want to have the full name as a separate column? it's redundant with the other ones in my opinion. What does the * mean after the date of birth? Do you already have a MySQL database setup? Is it local or on a server? How would you make changes? Are you familiar with phpMyAdmin? If not you may want to setup a website that would allow to display, edit. search and list records based on criteria. I could setup a simple (just for this purpose) Joomla site for you for an additional 250 EUR. Do not hesitate if you have any questions. I look forward to hearing from [login to view URL] start working on your project. Regards. Xav.
€250 EUR in 10 days
4.9 (6 reviews)
5.9
5.9
13 freelancers are bidding on average €222 EUR for this job
User Avatar
Hi, Just to make sure I understand. You want to have this exported to a relational database, like MySQL. Then have an interface where you can edit any of the records. Also add or delete records if necessary. And you also want a page where a search can be done and proper records will be displayed. Let me know if the above are correct. The October 24 deadline won't be an issue at all. Thanks Renan
€250 EUR in 7 days
4.9 (150 reviews)
6.5
6.5
User Avatar
Hello, I am database expert and interested in this project. I have checked requirements, tab file and deadline. I will complete it within one week. Please communicate to discuss further. Regards Anshu
€252 EUR in 7 days
4.6 (27 reviews)
4.5
4.5
User Avatar
Hi, I will import the data into database and then provide you with internet explorer based application wherein user will be able to do wild search with all fields. and if required can also provide option to update certain field from portal.. feel free to write to me for any clarification. regards, Ananya
€222 EUR in 5 days
5.0 (2 reviews)
2.1
2.1
User Avatar
I work daily with databases with more than 40M rows, so organize 280m wont be a problem and i can organize the search to be with the best performance.
€133 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have total of 20 years of experience, Including 14 years as Oracle DBA. Proficient in ITIL processes and service Delivery. Have managed remotely 1200 Oracle Instances for different customers(45) which had a size ranging from 50 GB to 12 TB. Done migration project from Ms SQL to Oracle for a telecom company in Afghanistan. Also can support Ms SQL database environments.
€250 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I can do this for you! I can insert in mysql database from the text file and do a searchable php script online to search in mysql. I did a similar project recently for 6.000 address contacts informations from a text with 13 fileds searchable in the php script. Regards.
€200 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, This is a very doable project. I have been able to view the columns in Excel. There are a few character encoding issues which can be fixed. Aside of that the columns can be converted to table data which can then be queried for information and stylized for presentation in your website. What are the different formats that your current database allows you to save the data in. If you would like to work with me, please contact me with this informtion, All questions are welcome. Thanks Deb
€200 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Fri, 10 Oct 2014 17:44:34 +0530 Please detail on operating system version and on services to run on the web-host. SQLite may be a better option for your needs. CGI backend required for connecting to database.. If already online, can check status.
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€233 EUR in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Berlin, Germany
5.0
1
Payment method verified
Member since Oct 7, 2014

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.