Announcement

Collapse
No announcement yet.

Toolkit #64 lasturl / clear database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Toolkit #64 lasturl / clear database

    Since the move to the apps store, I am not finding the steps to visit pages to manually clear the database entries created by lasturl. I believe it was a category page, search page and plst page, but I was thinking there was one more.

    Yes, I know it clears expired entries after so many times via the trim token, but I'd like to know how to do it manually as well.

    Thanks,

    Jamie
    Jamie Donaldson
    JSDVS Web Design / Development
    Web Design | Web Development | E-commerce Design & Integration

    #2
    Re: Toolkit #64 lasturl / clear database

    Okay, so if I had a brain, I'd be dangerous. It wasn't the lasturl, it was footsteps in toolkit that I want to manually clear the database entries.

    I can't change the title of the thread, so here's hoping for the steps to do it manually...

    Thanks,

    Jamie
    Jamie Donaldson
    JSDVS Web Design / Development
    Web Design | Web Development | E-commerce Design & Integration

    Comment


      #3
      Re: Toolkit #64 lasturl / clear database

      Im not sure the exact method you are referring to but the footsteps.dbf file should be tied to the "Module Cleanup" checkbox when deleting expired baskets from the admin. When you run this, it should perform other module cleanup functions including clearing out this file.
      Brennan Heyde
      VP Product
      Miva, Inc.
      [email protected]
      https://www.miva.com

      Comment


        #4
        Re: Toolkit #64 lasturl / clear database

        footsteps.dbf relates to the Mini basket module and is cleaned with the cleanup routine you described. The toolkit uses a different database, TKShopMore. It is run with a token. Per the doc:

        <mvt:item name="toolkit" param="trim" />
        This token will trim expired entries about 1 out of 100 times that this screen displays in your store.

        Pick a screen in your store that you want it to run periodically (1/100 of that page's load). I wouldn't put it on the SFNT as that would be too frequent. Perhaps the CTGY or PROD page. Put it near the end of the page template. By doing this it runs automatically rather than relying on the store owner to run the basket delete/clean up routine as was needed in the mini basket.
        Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
        Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
        Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
        Facebook http://www.facebook.com/EmporiumPlus
        Twitter http://twitter.com/emporiumplus

        Comment


          #5
          Re: Toolkit #64 lasturl / clear database

          I do have the trim token, so I'll go with that. Just thought there was a manual way listed by going through certain pages. But, the token should be more than enough.

          Thanks for your responses Bill and Brennan.

          Jamie
          Jamie Donaldson
          JSDVS Web Design / Development
          Web Design | Web Development | E-commerce Design & Integration

          Comment


            #6
            Re: Toolkit #64 lasturl / clear database

            You can always check the number of records of the s01_TKShopMore (46) database. In the reports section of the Tool Kit, there is a form for Database Structure. If you put in your store's database name, it lists all of the databases in your store. It tells you the field names and type. But it also tells you how many records are in the database. Just after the database name you will see a parenthesis with a number in it. In the example above, there are 46 records. If that were a gazillion, you might want to put the trim token on a more frequently hit page. You just need to know your store's database name. As example it might be mm5_yourstorecode, where you put your actual store code.
            Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
            Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
            Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
            Facebook http://www.facebook.com/EmporiumPlus
            Twitter http://twitter.com/emporiumplus

            Comment


              #7
              Re: Toolkit #64 lasturl / clear database

              Originally posted by wcw View Post
              You can always check the number of records of the s01_TKShopMore (46) database. In the reports section of the Tool Kit, there is a form for Database Structure. If you put in your store's database name, it lists all of the databases in your store. It tells you the field names and type. But it also tells you how many records are in the database. Just after the database name you will see a parenthesis with a number in it. In the example above, there are 46 records. If that were a gazillion, you might want to put the trim token on a more frequently hit page. You just need to know your store's database name. As example it might be mm5_yourstorecode, where you put your actual store code.
              Thanks Bill! This will help!

              Jamie
              Jamie Donaldson
              JSDVS Web Design / Development
              Web Design | Web Development | E-commerce Design & Integration

              Comment

              Working...
              X