Web Wiz Guide's Site Searcher Script modified as a file content indexer to produce pipe-delimited csv output

THANK-YOU to Vladimir Miho for his logging script that creates the csv file from the output: http://planet-source-code.com/vb/scripts/showcode.asp?lngWId=4&txtCodeId=8911

I used the search script to index the content of html horse pedigree files with pipe-delimited csv output. I imported the csv files
into Access and now have the file contents in my pedigrees database and database-searchable, which is faster and
less server intensive.

The idea was to get the text content of the html files entered into my database. You see, my community pedigree files collection consists mostly of html files. It was easy enough to get basic information about each file entered into the Access database, such as file size, date uploaded, file name, and so on. What I really wanted in the database was the CONTENT of each file. This is because if I used a file system object search script like Web Wiz Guide's, to search the content of the files, it just took too long to grind through about 650 (and growing) files. By getting the file contents into the Access database, searches of the content are therefore greatly speeded up, especially for our community members who have slow computers or who are on dialup.

View another example: pipe-delimited csv formatted text file.
Here is an example of the pipe-delimited csv formatted results that the script gave me:

I used pipe delimiters to make csv format.
I made the search input text box hidden and made the value an asterisk "*" because that is traditional for wildcard.  I removed the code that would show if no results were found, so that by default, the script shows everything it reads.

 I used the variable intNumFilesShown as the primary key for each record when imported into Access.
The script will simultaneously and automatically
create a csv file from the output.

Html and carriage returns and line feeds and blank spaces are filtered out.

I used it to index just under 700 pedigree html files. It took quite a while for the script to grind through that many files. When I index files again, I will set the script to index only the new files. If you have a large number of files, you may want to set the script to do only a certain number at a time...I would have to study up on how to make it work that way. Maybe you can tell me how. :)

I would be grateful for suggestions on how to improve this, or if someone else would take the idea and improve it.

I spent HOURS putting this script together. Now that it is done, I think the idea is fairly "simple" but I had to learn how to do some stuff I didn't know how to do before. If you use this script or find it helpful, I would appreciate a rating on www.aspin.com, or send me an email to let me know how you're using it. (As usual, donations to my paypal account are an excellent sign of appreciation.) --Lil

GET CODE

Rated: by Aspin.com users What do you think? 5 Stars4 Stars3 Stars2 Stars1 Star

 

ASP Examples Menu (below*) Active Server Pages | ASP | Scripts | Tutorials | Code | Web Programming | Examples Active Server Pages ASP code examples, tutorials, and snippets for use in Programming interactive websites. NOTE: Recently changed hosting and url so some demos aren't working now because I haven't updated pathing; if you find omissions or errors let me know.

* Multiple records per row with paging Display multiple records per row Get ID of newly inserted record, Classic ASP, Access Database Javascript timer with ASP to keep track of time expired until login expires / timeout session is up Multiple Javascript event functions triggered from single form onsubmit Get Querystring key names along with querystring variables ASP Youtube Downloader  Version FOUR All ASP code. Allows user client side downloads of Youtube videos. You have the option to allow files to be saved directly to your site also. ASP/PHP video downloader (Works better than ASP for large files) Use ASP to dynamically parse a Youtube XML playlist to render to html. Zip up an archive file of your site for backup if you need to restore website with ASP and free Zip Component. Zip all files in a folder into an archive or backup file dynamically by specific file extension. Sanitize or clean price cost field for database insertion or display. Javascript image dimensions and image file size preview. Put recordset into array, assign keys to the records then use record associated with specific array key as a variable elsewhere. Access Database Interface Generator Wizard to read your table and field names and to create a table display. Combining dropdown selection box menu with dynamic ASP database page. How to redirect user to original page they tried to view before logging, after they are logged in. Previous/Current/Next Records, or Buddy Ring Script Custom ASP 404 page not found error script sends visitors to virtual folders ASP Example: Combine ASP with Javascript for popup windows dynamically sized to image dimensions. ASP Example: How to use ASPJPEG to create thumbnails Click for free Highly recommended thumbnailer for which you don't need Server access ASPjpeg: How to re-scale aspect ratio of thumbnails by height instead of width. ASP Example: What if your host has an older version of ASPJPEG that doesn't support gifs? Using inline frames as "dynamic includes" (offline for updating) Select Count Distinct Records for Access Database Upload Image to folder and insert filename into database Get date in such a way that it can be made part of a file name Isolate a file name away from its path or extension or strip a path from a file name or strip characters from database field User-customized on-the-fly stylesheet css files Enhanced Page Hits Counter (also counts downloads and menu link hits) Loop through array and compare to string with select case Aphabetical Paging for your ASP scripts Web Wiz Guide's Site Searcher Script modified as a file content indexer Let Users Select How Many Records to View Access Database for your PayPal IPN scripts Miscellaneous collected code You don't have to be a genius, just persistent, to write original Active Server Pages scripts Software Recommendation: bare_bones_no_bells_and_whistles_asp_code_generator_database_interface_maker --Lil at gmail.com