SlimShady Posted May 14, 2004 Share Posted May 14, 2004 (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)categoriesAdd 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)categoriesDelete (sub)categoriesEdit links in (sub)categoriesExport a certain (sub)category to HTML or export them to a folder as favoritesExport all categories with subcategories including all links to HTML or export them to a folder as favoritesImport/Export favorites (with subfolders, only one level down)Rename a (sub)categorySearch through database using multiple keywordsShow all (sub)categoriesShow all links (items) in a certain (sub)categoryUpdate titles and keywords from all the links (per category, item or everything)Changed:May 17th: Import/Export favoritesMay 18th: Changed the contents of the command boxAdded support for mailto links and FTP sitesMay 19th: Fixed some small stuffChanged 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 contentsMay 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 functionMay 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 versionJune 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 bitToDo-list:...I've uploaded the zip file with both versions:http://www.autoitscript.com/fileman/users/public/SlimShady/WebsiteDB.zipNOTE:Importing favoritesIf 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:sortYou have to use the latest beta of AutoIt for this verison.http://www.autoitscript.com/forum/index.php?showtopic=23823 Have fun! Edited June 25, 2006 by SlimShady Link to comment Share on other sites More sharing options...
Administrators Jon Posted May 14, 2004 Administrators Share Posted May 14, 2004 If a year ago I'd seen the sort of code that AutoIt3 would be running (complexity wise) I would have been very scared and not started at all Deployment Blog:Â https://www.autoitconsulting.com/site/blog/ SCCM SDK Programming:Â https://www.autoitconsulting.com/site/sccm-sdk/ Link to comment Share on other sites More sharing options...
Helge Posted May 14, 2004 Share Posted May 14, 2004 (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 extremelyhard to find the exact link that I was searching for.. I'm gonna test your script out, when I'm returning home from school tomorrow...for ever ! (No, I didn't say that I was gonna test your script forever.. )Thanks for sharing, by the way !EDIT : Spelling mistake.. Edited May 14, 2004 by Helge Link to comment Share on other sites More sharing options...
SlimShady Posted May 14, 2004 Author Share Posted May 14, 2004 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. Link to comment Share on other sites More sharing options...
SlimShady Posted May 14, 2004 Author Share Posted May 14, 2004 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. Link to comment Share on other sites More sharing options...
brett Posted May 14, 2004 Share Posted May 14, 2004 WOW!!! This script is amazing man. Great job. -Brett Link to comment Share on other sites More sharing options...
SlimShady Posted May 15, 2004 Author Share Posted May 15, 2004 Updated! See first post. Link to comment Share on other sites More sharing options...
sykes Posted May 15, 2004 Share Posted May 15, 2004 Very nice program We have enough youth. How about a fountain of SMART? Link to comment Share on other sites More sharing options...
SlimShady Posted May 15, 2004 Author Share Posted May 15, 2004 Very nice program Thank you Updated. See first post. Link to comment Share on other sites More sharing options...
SlimShady Posted May 16, 2004 Author Share Posted May 16, 2004 Updated once again. Link to comment Share on other sites More sharing options...
trids Posted May 17, 2004 Share Posted May 17, 2004 Very cute How about an Import feature: MSIE can export favourites as HTML .. which you can then read and populate into your INI file Link to comment Share on other sites More sharing options...
sykes Posted May 17, 2004 Share Posted May 17, 2004 How about an Import feature: MSIE can export favourites as HTML .. which you can then read and populate into your INI file Now theres an idea. I like it ... I like it ALOT We have enough youth. How about a fountain of SMART? Link to comment Share on other sites More sharing options...
SlimShady Posted May 17, 2004 Author Share Posted May 17, 2004 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! Link to comment Share on other sites More sharing options...
SlimShady Posted May 17, 2004 Author Share Posted May 17, 2004 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. Link to comment Share on other sites More sharing options...
SlimShady Posted May 17, 2004 Author Share Posted May 17, 2004 Updated it once again. Link to comment Share on other sites More sharing options...
Gene Posted May 18, 2004 Share Posted May 18, 2004 (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 May 18, 2004 by Gene [font="Verdana"]Thanks for the response.Gene[/font]Yes, I know the punctuation is not right... Link to comment Share on other sites More sharing options...
SlimShady Posted May 18, 2004 Author Share Posted May 18, 2004 (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 May 18, 2004 by SlimShady Link to comment Share on other sites More sharing options...
Gene Posted May 18, 2004 Share Posted May 18, 2004 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 Categorya1 Edit a Categorya2 Delete a Categorya3 Add URL itema4 Edit a URL Itema5 Delete a URL itemIMPORT/EXPORT:b0 Import all URLs from Favoritesb1 Export all URLs from all categoriesb2 Export a specific categorySEARCH: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.GenePS. You could assign Hot Keys for menuing instead or too. Just be consistentPPS. 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... Link to comment Share on other sites More sharing options...
SlimShady Posted May 18, 2004 Author Share Posted May 18, 2004 (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 May 18, 2004 by SlimShady Link to comment Share on other sites More sharing options...
SlimShady Posted May 18, 2004 Author Share Posted May 18, 2004 (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 May 18, 2004 by SlimShady Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now