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