Solved

Creating a database of links

Posted on 2013-06-10
7
233 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
Comment Utility
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 26

Author Comment

by:Thomas Zucker-Scharff
Comment Utility
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
Comment Utility
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 13

Assisted Solution

by:sameer2010
sameer2010 earned 200 total points
Comment Utility
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 26

Author Comment

by:Thomas Zucker-Scharff
Comment Utility
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
Comment Utility
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 26

Author Closing Comment

by:Thomas Zucker-Scharff
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now