Solved

Creating a database of links

Posted on 2013-06-10
7
240 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 28

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
Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

 
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 28

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 28

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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

718 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