Sign in to follow this  
Followers 0
SlimShady

Website Database

89 posts in this topic

#1 ·  Posted (edited)

Since a couple of months I wanted a small database that stores websites I was searching for.

Example: You're searching on Google for a certain error message and only found one result.

It's a pain in the b*tt if you would add that in the favorites folder,

if you're (like me) never filter/sort that folder, you will never find it easily.

Unless you have a database with rare websites and even favorites organised in categories.

With the ability (ofcourse) to search.

I created a script that organises such a database.

This script can:

  • Add categories (in categories)
  • Add links (items) in (sub)categories
  • Add the title that's used by the websites you're importing (from favorites)
  • Add the keywords that are used by the websites you're importing (from favorites)
  • Delete links in (sub)categories
  • Delete (sub)categories
  • Edit links in (sub)categories
  • Export a certain (sub)category to HTML or export them to a folder as favorites
  • Export all categories with subcategories including all links to HTML or export them to a folder as favorites
  • Import/Export favorites (with subfolders, only one level down)
  • Rename a (sub)category
  • Search through database using multiple keywords
  • Show all (sub)categories
  • Show all links (items) in a certain (sub)category
  • Update titles and keywords from all the links (per category, item or everything)
Changed:
  • May 17th: Import/Export favorites
  • May 18th: Changed the contents of the command box
  • Added support for mailto links and FTP sites
  • May 19th: Fixed some small stuff
  • Changed the way the database imports favorites (should fix all problems with importing)
  • When you have to choose category, the inputbox will automatically adjust itself to the contents
  • May 21st: Added full-support for multi-level categorising, importing and exporting.

    (only one subfolder/subcategory allowed)

  • May 26th: Added sorting alphabetically (categories and items)
  • Changed the way the links and categories are used. (Read my notes below)
  • May 27th: Fixed the validate function
  • May 30th: Added ability to extract the title from the website you're importing

    Added ability to extract the keywords from the website you're importing

    Added ability to search through the database using multiple keywords

    And something I forgot...

  • May 31st: Update titles and keywords from all the links (per category, item or everything)

    Existing keywords won't be overwritten. They'll be pasted behind the new keywords.

  • June 4th: finished creating the Gui version
  • June 5th: Fixed many, many bugs

    Created a zip file with both versions

    Created a readme file with alot of info.

    Disabled resize ability.

    fixed problem: When searching using multiple words, it may show the same item more than once.

    I forgot to re-add the sort feature.

    the main window will now be hidden when an inputbox is shown

    When a category is empty, the listboxes will be emptied

    Update function didn't work

    Changed the search function a bit

ToDo-list:
  • ...
I've uploaded the zip file with both versions:

http://www.autoitscript.com/fileman/users/public/SlimShady/WebsiteDB.zip

NOTE:

Importing favorites

If you have a folder2 in folder1, folder2 will be a category underneath the category 'favorites' ('favorites' will be in your locale).

Exporting (to favorites)

Every sub-category will be placed under the main category.

You will see the subcategories when you want to add/edit/delete categories.

You can't add categories in a sub-category, so don't.

I added the ability to sort everything alphabetically (once) using a simple commandline argument:

sort

You have to use the latest beta of AutoIt for this verison.

http://www.autoitscript.com/forum/index.php?showtopic=23823

Have fun!

Edited by SlimShady

Share this post


Link to post
Share on other sites



#3 ·  Posted (edited)

I've got at this moment over 500 links located in my favorite-folder.

If I didn't got a system there, (categorized them) then it, sure as hell, would be extremely

hard to find the exact link that I was searching for.. :lol:

I'm gonna test your script out, when I'm returning home from school tomorrow...for ever ! :D

(No, I didn't say that I was gonna test your script forever.. :))

Thanks for sharing, by the way !

EDIT : Spelling mistake.. :huh2:

Edited by Helge

Share this post


Link to post
Share on other sites

No problem. Pleasure is all mine.

I like AutoIt. I'm using it 2 months now and I find it very easy to work with.

It's much more advanced than VBScript.

The string functions and the INI functions are very nice.

Share this post


Link to post
Share on other sites

It looks complex, but it's not really.

I just made functions for many things so I can use them in other parts of the script.

And I used alot of IFs at the beginning.

I thought I was going to make 3 basic functions:

Add, Delete, Show. But because I was going to create dynamic categories, I had to create more.

I will change those many IFs into a Select...Case statement.

Share this post


Link to post
Share on other sites

WOW!!! This script is amazing man. Great job.


-Brett

Share this post


Link to post
Share on other sites

Updated! See first post.

Share this post


Link to post
Share on other sites

Very nice program

:D


We have enough youth. How about a fountain of SMART?

Share this post


Link to post
Share on other sites

Very nice program

:huh2:

Thank you :D

Updated. See first post.

Share this post


Link to post
Share on other sites

Updated once again.

Share this post


Link to post
Share on other sites

Very cute :huh2:

How about an Import feature: MSIE can export favourites as HTML .. which you can then read and populate into your INI file :D

Share this post


Link to post
Share on other sites

How about an Import feature: MSIE can export favourites as HTML .. which you can then read and populate into your INI file  :D

Now theres an idea. I like it ... I like it ALOT

:huh2:


We have enough youth. How about a fountain of SMART?

Share this post


Link to post
Share on other sites

Ok, it's a challenge.....

Surprise, surprise! I managed to import all favorites into the database,

with the filename (without the extension) as the description.

I'm now implementing a way to "export to folder".

You can start organising your favorites folder.

Within 2 hours you'll be able to import all your favorites in a few seconds!

Share this post


Link to post
Share on other sites

I've done it. You can now import/export favorites!

See first post!

If something doesn't work the way it should, please post here.

Thank you.

Share this post


Link to post
Share on other sites

Updated it once again.

Share this post


Link to post
Share on other sites

#16 ·  Posted (edited)

This looks very interesting. However when I ran it:

1- The input box was too short vertically, it looked OK at 400

2- It allowed me to add a category "Srch"

3 I was not allowed to add any item to the Srch category. I tried 'www.google.com', 'asdfg', '123' and a few others I'll leave to the imagination. In all cases the error message was approx. that I had entered invalid characters and was not allowed to use the '|' char. In fact I entered only valid URL characters.

Gene

PS. I'm running Win98se and MSIE 6 SP1 and all other availble updates.

Edited by Gene

[font="Verdana"]Thanks for the response.Gene[/font]Yes, I know the punctuation is not right...

Share this post


Link to post
Share on other sites

#17 ·  Posted (edited)

Did you include "http://" in front of the url?

You should do that.

I don't understand, because I added 10 categories and many links with no problems at the moment.

Can you please write step-by-step what you did?

So I can fix it.

Updated again. (fixed export to html)

Edited by SlimShady

Share this post


Link to post
Share on other sites

Did you include "http://" in front of the url?

You should do that.

I don't understand, because I added 10 categories and many links with no problems at the moment.

Can you please write step-by-step what you did?

So I can fix it.

Updated again. (fixed export to html)

It worked OK when I added http://. Since most URLs will start with that, why not offer it as the default? That would also help people note the difference when it is an ftp://. It appears you assumed that URLs would be pasted in (correctly in most instances), but some percentage will be typed in.

The menuing might be easier and quicker to use if it looked more like:

;== Begin Example =======

Enter an option...

ADD/EDIT/DELETE:

a0 Add Category

a1 Edit a Category

a2 Delete a Category

a3 Add URL item

a4 Edit a URL Item

a5 Delete a URL item

IMPORT/EXPORT:

b0 Import all URLs from Favorites

b1 Export all URLs from all categories

b2 Export a specific category

SEARCH:

c0 Find a specific string in the database

;== End Example =======

This only requires 2 keys to select an item (spelling doesn't count). It allows for up to 36+ items in any menu grouping.

Gene

PS. You could assign Hot Keys for menuing instead or too. Just be consistent

PPS. This would be an excellent opportunity for you to move into the GUI arena...


[font="Verdana"]Thanks for the response.Gene[/font]Yes, I know the punctuation is not right...

Share this post


Link to post
Share on other sites

#19 ·  Posted (edited)

Nice to have some feedback. I'll definitely use your suggestions.

I prefer hotkeys only when a script is running longer than 5 mins.

I will not add that.

After adding your suggestions I will be working with AutoIt Gui.

Things I'm gonna do:

- Update the error dialog when an URL has a incorrect syntax

- Add FTP and mailto: compatibility

- Update the command dialog

Edited by SlimShady

Share this post


Link to post
Share on other sites

#20 ·  Posted (edited)

Updated!

Do you have an idea how the GUI should look like for this program?

(Anyone can reply to this question)

Until then I'll be playing with Visual Basic.......

Edited by SlimShady

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0