#Sqlitemanager exporting search results code

It involved copying the column with the key cells into BlueGriffon HTML editor WYSIWYG window which did a good job of capturing the HTML code that Google Sheets formulas could not access, then Notepad++ to help isolate the lines with the wanted URLs, then the command-line SQLite3 to import the HTML into a database I had created with SQLite Studio (could have been any SQLite manager) and then my go-to SQLiteSpy to process the imported table and copied its results to the Google Sheet. I kluged together a process to get the links to Topics in the Forums.

On Thu, at 02:18 PM, Tom Holden wrote: I've run into a problem extracting the URLs of the links to the topics and wondering if there any gurus who might have a technique. Trying to extract the first URL in the cell (the topic URL). If anyone wants a crack, I can share a sample spreadsheet with you. I don't know if the underlying code will get transported by Groups.io but it looks good in preview. in Discussion Started by Witterly, 1 2 Last Post by TomH, in RootsMagic Wish List Started by zhangrau, Last Post by Jerry Bryan, Ĭhristening gets included as a 'Basic Event' when. Source Templates duplicated on drag-n-drop, no tool for m. I pasted results right into Google Sheets and the key cell with URLs looks like this: Shareable CD From a Named Group in RootsMagic Wish List Started by Jerry Bryan, Last Post by Renee Zamora, I've run into a problem extracting the URLs of the links to the topics and wondering if there any gurus who might have a technique. There could be more found using the term 'wishlist' or 'wish-list' or the phrase 'wish list' but probably too many topics with 'wish' and 'list'. I've pulled some 1500 possible 'enhancement requests' (really topics that contain one of those words in any post under the topic and the other in any post in the same topic) and copied them into a spreadsheet. Good posts are on-topic, have definitive subjects, don't stray, are succinct, have short signatures, and trim all but essential quotes. Any volunteers? - Tom Holden ve3meo List Administrator. I've already converted the couple of dozen links on the SQLite Tools for RootsMagic site from the Forums to The Wayback Machine's capture.

#Sqlitemanager exporting search results archive

If the Forums are shut down for good, then the Internet Archive is the last resort. And ascertaining whether one is fulfilled or not. Then there's the even bigger challenge of retrieving the text and images that go with them, possibly spread across multiple posts. Perhaps a script could put the slug on the same row so they would sort and filter as pairs.

#Sqlitemanager exporting search results full

Might get there by restricting the search over successive date ranges that don't quite hit the limit for results This Google Search reports about 689 results at 10 per page - 69 pages to copy and paste and not as full a potential set of results as the Forums search suggests! Takes 2 rows per hit but could be filtered to show just the title and hyperlink which are the bare necessities. That suggests there could be ~3000 results if unlimited. However, it gave only 164 hits which barely got into the B's. The RootsMagic Forums Search is not very sophisticated but the results are nicely formatted and can be copied to a spreadsheet. The results are not encouraging - it would be a daunting task. So I looked into how one might extract that info before it is too late. We've often wished for a log of enhancement requests and the recent downtime of the RootsMagic Forums alarmed us that even that record might be lost forever.