Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 06-06-2008, 09:49 PM   #1
Baseband Member
PseudoEvolution's Avatar
Join Date: Aug 2006
Posts: 40
Default TSV/CSV Database

So I am not looking for an actual script (I can make that myself), but just an idea for how this task should be completed.

There are 10+ TSV files (tab separated value files). I can probably convert them to CSV if needed using a simple script.

Each TSV file has about 10,000 lines.

Each TSV file has 4 columns: name, city, ID, and filepath.

Each ID number has a .tif image file associated with it. So if the ID in the spreadsheet is 123456, there is a .tif image named 123456.tif located in the images folder.

The filepath is the same for everything, it just points to the images folder.

Now the task here is to make all of these images easily findable by "normal" people so they can simply insert a name/id/city in to some kind of interface OR navigate to sub categories and find the corresponding lines along with a link to the image for those lines. This would be local, not through a web server; however, HTML is an option.

I was thinking of just compiling them all in to one big spreadsheet, then using OpenOffice's/Excel's hyperlink feature to create a link to the image.

Do you think this would be sufficient enough? I have heard there are upwards of 300,000 lines and well over 10gb of data, so linking each line by hand is not an option.

If there is an automated way to do it, I would love to have some kind of HTML page(s) with a list of these lines (alphabetically?) that contains a link to the corresponding image. Searchable would be nice too, but I think that would require a web server.

The biggest thing here is finding the best way to manage each line of the files so that a user can click a link and bring up the image.

Any ideas or further questions?
PseudoEvolution is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 01:12 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0