Results 1 to 4 of 4
  1. #1
    Join Date
    September 27th, 2006
    Arrow Help: I want to build pages for some (but not all) records in my database.
    How do I do this?

    I have a master Excel Database with lots of records, being updated constantly. I want to use Web Merge to build pages for the most recently added records, but not all.

    Seems like it should be so simple - to build pages from, for example, rows 79-85 of the database.

    Is it right in front of my face and I'm not seeing it?


    So A Newbie
    Last edited by ecouv; September 27th, 2006 at 03:15 PM. Reason: smiley not working

  2. #2
    Resident Genius and Staunch Capitalist Leader's Avatar
    Join Date
    January 18th, 2005
    Simplest solution I know of, is to make a new spreadsheet using only the records you want and then run WM off of that.

    As long as you can easily find the desired records in the big spreadsheet, it should be easy to copy/paste 'em into the new one.

  3. #3
    ABW Veteran Mr. Sal's Avatar
    Join Date
    January 18th, 2005
    Seems like it should be so simple - to build pages from, for example, rows 79-85 of the database.
    I have a big datafeed that I only use two categories, so after I sort the feed categories with Excel, I just select those two categories and copy and paste it to a blank notepad file, then I name that notepad file whatever.txt and use that file on WebMerge or PHP.

    So you can select the rows 79-85 of the database and do something similar, there might be an easier way, but that way works fine for me so far.

  4. #4
    Join Date
    June 22nd, 2005

    I think there is another way that may be used for updating selected pages. I did not try it and I am giving this solution as ideas come to me, in real time.

    1/ Add a column/a field in your datafeed.
    2/ Name it as you like (i.e. Update)
    3/ Empty this column
    4/ Select lines to update with a char in "update" field - say "X"
    5/ Completely enclose your template with an "WM if" [WM-If WM-Field: Update = X]Your template[/WM-If]

    [WM-If WM-Field: Update = X]
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">


    <meta http-equiv="content-type" content="text/html;charset=iso-8859-1">

    <div>Template body</div>

    I think this works. Try it and let un know.

    Do not forget to NOT generate index in that case.

    If you use WM to add some new pages, it will also work but you'll have to update manually your indexes (or do a full generation).

    My two cents


  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Delete records from the database using Date()
    By akinak in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: February 5th, 2009, 04:50 PM
  2. Large amount of records into multiple pages
    By Ms Woodtick in forum WebMerge (
    Replies: 1
    Last Post: June 13th, 2004, 11:07 AM
  3. inspiration to build more pages
    By Vinny O'Hare in forum Midnight Cafe'
    Replies: 4
    Last Post: February 27th, 2004, 04:37 PM
  4. Don't build item pages in GoCollect
    By loxly in forum Scripts
    Replies: 2
    Last Post: February 26th, 2004, 11:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts