Solved

Creating a database of links

Posted on 2013-06-10
7
237 Views
Last Modified: 2013-06-14
My wife wants to create a database of links for her various different classes.  She is a university instructor.  She keeps a word file full of categorized URLs, which she uses in her classes.  She only uses some in each class.  I know I could easily make his into a database, but I'm wondering if someone has already done this - I don't want to recreate the wheel.
0
Comment
Question by:Thomas Zucker-Scharff
  • 3
  • 3
7 Comments
 
LVL 23

Expert Comment

by:nemws1
ID: 39236188
I would think something like http://delicio.us/ is what you want to use.

She just needs to tag each saved bookmark accordingly, like "classes" and "XY320", then search for these tags when teaching class "XY320".
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 39236617
thought  of that but she wants something standalone that can generate reports based on the attributes of each link.  delicious might work otherwise.   also she would like to be able to import an existing word file.
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39236643
The import is a tall order. Even with Delicio.us, you need to add the tags and there's no easy way of doing that that I know of.

Bit.ly does URL tracking and graphing. She might need to generate bit.ly urls for all her other urls, but she can track the usage of her links then.

Eve if she's got 100+ links, it wouldn't take more than a couple hours to do all this setup.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 13

Assisted Solution

by:sameer2010
sameer2010 earned 200 total points
ID: 39237074
How about putting it into a simple xls having columns to identify categories and links?

E.g. Category1, Category2, Category3, Link, Other Related Categories i.e. 3 prominent categories per link and all other go to Others. You can change this to suit your needs.

Excel would be light, very easy to maintain, found across devices.
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 39237887
Already started trying the excel solution. She isn't comfortable with using delicious.  Started to develop an app on the ipad.
0
 
LVL 23

Accepted Solution

by:
nemws1 earned 300 total points
ID: 39237904
Delicio.us too open? (you can make your links all private, but then they are hard to share with others).

I teach as well (and work at a University as well), so I'm just curious.  It sounds like she's put a lot of work into generating this list of links and wants to more easily maintain and share it.  That screams 'web-based solution'.  An iPad app *has* to be 10x more work than using an online solution and 10x less-usable (not everybody can afford one or wants to use an Apple product).  Maybe one of these (although Delicio.us is in this list) would be usable:

http://lifehacker.com/5540019/five-best-bookmark-management-tools

Or maybe a home-brew solution - if you're willing to develop an iPad app, maybe you'd be willing to develop a PHP/web-based app instead?
0
 
LVL 27

Author Closing Comment

by:Thomas Zucker-Scharff
ID: 39248834
Thanks for all the feedback.  I haven't gotten back to you because I felt this was unresolved.  Thanks for the suggestions, I loved the lifehacker article and I used the idea of putting it into a spreadsheet to convert to spreadsheet then to database.  I'm creating a database for her to enter the info (almost done).
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question