lagoausente

Creating a browsable, searchable copy of long threads
« on: April 05, 2007, 12:37:02 PM »
:oops:   I cannot find the way to drag down the cells on excell to get the list of URL!!
  I´m feeling quite stupid really.   :?
Absent lake.



lagoausente

Creating a browsable, searchable copy of long threads
« Reply #2 on: April 05, 2007, 01:17:26 PM »
I come from there, he explains all about the firebox and Scrapbook, but just tells the excell is "dead easy", but I don´t know how to do it.
Absent lake.

nerd

Creating a browsable, searchable copy of long threads
« Reply #3 on: April 05, 2007, 08:15:06 PM »
I don't understand your question?

lagoausente

Creating a browsable, searchable copy of long threads
« Reply #4 on: April 05, 2007, 10:29:26 PM »
He takes the address: http://www.groupdiy.com/index.php?topic=15373&postdays=0&postorder=asc&start=0
 Then tells that the next page will be

 http://www.groupdiy.com/index.php?topic=15373&postdays=0&postorder=asc&start=15

 so is the same address, increasing by 15..
 start=0
 start=15
 start=30

 He tells that with Excell, gets quickly the 59 address of the hole thread, instead of being writing manually each one. That´s what I don´t  know how to do.
Absent lake.

moogah

Creating a browsable, searchable copy of long threads
« Reply #5 on: April 05, 2007, 10:41:15 PM »
In excel place the mouse in the lower right corner of the cell then drag down the colum to auto fill cells.  Excel will read the values in the cells and try to continue any sequence that it sees.  ie:

if the first cell is zero and you drag it down all the other cells will be zero too.  If the first cell is 1 and the second cell is 2 then excel with increment by 1.  if the first cell ends in 0 and the second cell ends in 15 then excel will count by 15.

Ptownkid

Creating a browsable, searchable copy of long threads
« Reply #6 on: April 06, 2007, 12:18:12 AM »
Moogah is right, that will work...however I completely fail to see how having each page as a link makes anything any easier.

What is the point of this?

lagoausente

Creating a browsable, searchable copy of long threads
« Reply #7 on: April 06, 2007, 08:02:25 AM »
Quote from: "moogah"
In excel place the mouse in the lower right corner of the cell then drag down the colum to auto fill cells.  Excel will read the values in the cells and try to continue any sequence that it sees.  ie:

if the first cell is zero and you drag it down all the other cells will be zero too.  If the first cell is 1 and the second cell is 2 then excel with increment by 1.  if the first cell ends in 0 and the second cell ends in 15 then excel will count by 15.


   :thumb:   Thanks guy!  . At first Excell was increasning by one, even I had 0, 15, 30.   Just have to first select the three cells before the drag down.  When putting the mouse on the lower right corner it appears a cross. Now works!!  :cool:
Absent lake.

moogah

Creating a browsable, searchable copy of long threads
« Reply #8 on: April 06, 2007, 12:46:13 PM »
ptown, this is for using with the scrapbook plugin for firefox which will download a series of websites to your local machine and then lets you search through them...

or do I misunderstand what you are asking?

originalmusician

Creating a browsable, searchable copy of long threads
« Reply #9 on: April 07, 2007, 12:27:59 AM »
Maybe this is stating the obvious, but I find that using Google usually works better for me than scrapbook. I just go to Google.com, click on Advanced Search, type in the search string info, and restrict the search to the domain groupdiy.com. This allows me to refine my searches to exact detail and requires very little thought or effort on my part.


lagoausente

Creating a browsable, searchable copy of long threads
« Reply #10 on: April 07, 2007, 06:42:53 AM »
Quote from: "originalmusician"
Maybe this is stating the obvious, but I find that using Google usually works better for me than scrapbook. I just go to Google.com, click on Advanced Search, type in the search string info, and restrict the search to the domain groupdiy.com. This allows me to refine my searches to exact detail and requires very little thought or effort on my part.


 I think that the Scarpbood method may be more useful to search within a thread.
  I have tried the google one now, but even I putted a thread address, the results are all over prodigy threads.
Absent lake.

originalmusician

Creating a browsable, searchable copy of long threads
« Reply #11 on: April 07, 2007, 12:02:09 PM »
Quote from: "lagoausente"
I think that the Scarpbood method may be more useful to search within a thread.
  I have tried the google one now, but even I putted a thread address, the results are all over prodigy threads.


I totally agree. If you only want to search a single thread, the scrapbook is the way to go as Google allows you to limit the search to domain, but not to a single thread. So with Google, you have to be very creative with your search strings and don't always get what you want. So I use both types of searches depending on the situation. But I find that if I'm building a project and in need of serious info and using scrapbook, I have to load to entire meta in order to get me to where I need to go. The problem is that I'm too lazy to do that if I'm not seriously stuck  :grin:

lagoausente

Creating a browsable, searchable copy of long threads
« Reply #12 on: April 07, 2007, 12:31:22 PM »
Quote
I have to load to entire meta in order to get me to where I need to go. The problem is that I'm too lazy to do that if I'm not seriously stuck Very Happy


 where is the work on loading the entire meta?
Absent lake.

originalmusician

Creating a browsable, searchable copy of long threads
« Reply #13 on: April 07, 2007, 03:53:46 PM »
Quote from: "lagoausente"

 where is the work on loading the entire meta?


Maybe I just haven't found a good way yet as I just started using scrapbook not too long ago. I can autoload the whole thing, but it is not searchable that way (or is it). Otherwise, I've been loading it one thread at a time. I've only done that for one meta though, as I thought it was a lot of work. If anybody else has a better way, I'd appreciate knowing  :?:

lagoausente

Creating a browsable, searchable copy of long threads
« Reply #14 on: April 07, 2007, 06:35:37 PM »
Quote
I can autoload the whole thing, but it is not searchable that way (or is it). Otherwise, I've been loading it one thread at a time. I've only done that for one meta though, as I thought it was a lot of work. If anybody else has a better way, I'd appreciate knowing Question


 I´m not sure, haven´t tried yet the whole process, but I think that on the web explains how to search all over one thread, I´ll have to check that.
Absent lake.


 

Related Topics

  Subject / Started by Replies Last post
0 Replies
1381 Views
Last post May 30, 2005, 05:26:47 PM
by rodabod
6 Replies
1529 Views
Last post September 12, 2005, 02:36:19 AM
by Butterylicious
10 Replies
2725 Views
Last post December 31, 2006, 12:10:59 PM
by EZ81
4 Replies
2763 Views
Last post February 24, 2008, 11:33:28 AM
by Andre