Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Key file rebuild Utility creating *.old backup files in SAGE 100 STD

Wayne Schulz

Wayne Schulz03-05-2021 10:37

  • 1.  Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-02-2021 12:13
    So it looks like starting in SAGE 100 STD v2017, when you use the Key File Rebuild Utility the system creates a backup file and adds ABCMMDDYYxxxxxxxx.OLD to the end of the file name. This backup file is created before the Utility runs and that's a good thing. ABC = USER Code. It also looks like if you perform the Key File Rebuild Utility multiple times a new backup file with ABCMMDDYYxxxxxxx.OLD is saved.  
    If you are working with large Customer History files or Inventory Transaction files, you can chew up some significant server disk space. Good way to quickly get the attention of an IT technician monitoring the server..
    Is there a setting in SAGE 100 STD to limit the number of backup copies saved from using the Key File Rebuild Utility? Is there a tool in SAGE to delete these files *.OLD when the data corruption problem is solved and to regain the server disk space?

    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    616-813-8887 - mike@mcdcpa.com
    ------------------------------


  • 2.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-02-2021 12:19
    Nothing in Sage.  I think I remember some batch files to do this posted in 90-Minds previously, but I just do it manually.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-02-2021 21:43
    @RobertWood posted a very nice CleanTemps.bat a long time ago. It would suit this purpose very well.

    ---------------------------------
    Alnoor Cassim


    Email: alnoor@asifocus.com
    Ph: 949-689-9887
    Orange County, CA
    ---------------------------------



    Original Message


  • 4.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-03-2021 07:49
    Edited by Jeff Schwenk 03-03-2021 08:02
      |   view attached
    @Alnoor Cassim - Great memory!!!  Change the extension to bat to run..  The file date on the BAT file is 6/12/2012.  An oldie but goodie!  Thanks @Robert Wood

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)

    txt
    CleanTemps.txt   1 KB 1 version
    Original Message


  • 5.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-03-2021 11:06
    Edited by Robert Wood 03-03-2021 11:06
    That was one of those late Saturday night team efforts.

    It also cleans out old worktables that didn't get deleted properly
    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


  • 6.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-03-2021 11:18
    Thank you 90Minds team (Kevin, Alnoor, Jeff and Robert) Fun with .bat files to make your life easier.

    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    616-813-8887 - mike@mcdcpa.com
    ------------------------------

    Original Message


  • 7.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:04
    Hey Jeff....could you also see if you can find the utility to schedule rebuild of sort files???? I have been looking all over.....

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 8.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:12
    Sounds like an idea for the MOD squad.  Need to talk it up today.  I would like to see a mod squad community where members can post suggestion which would give the Mod Members a sense of what quick wins are important to the group.  I would love a utility to clear zero quantity cost ties that have value hanging ......

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 9.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:18
    If we're drifting to ideas for the MOD Squad, I'd suggest UDF decimal precision be increased beyond 3.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 10.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:27
    That's not exactly how the Mod Squad works.

    They take low hanging fruit issues and design a recommended solution for Sage to then implement. They harvest the issues from the 90 Minds community. 

    -
    Robert C. Wood



    Original Message


  • 11.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:36
    Edited by Wayne Schulz 03-05-2021 11:25


  • 12.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:31
    @Lourdes Sobrino if I recall correctly, that never got developed. It was discussed and tinkered with but I don't think anything happened with it. Maybe @Alnoor Cassim or @Marcos DeLuna remembers better than I do since they were part of that conversation.​​​

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


  • 13.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:37
    Edited by Wayne Schulz 03-05-2021 11:25


  • 14.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:40
    @Wayne Schulz - Or they can just download the file from my earlier thread post above.....​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 15.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 10:47
    But what ARE the low hanging fruit issues @Robert Wood?  Are they just things that this select group thinks about?  Does the group actually have to do the leg work for Sage and code the solution for them.  Why not have a community where the membership can add their two cents for issues?  Others can then post comment which would give the Squad a sense of importance.  FWIW, a couple of the recent ideas implemented weren't even on the radar for my clients.  They were good ideas.  But I digress from the root thought of the thread.  And yes, @Wayne Schulz - It is the idea web site with a different coat of paint.
    ​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 16.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 11:01
    I logged into the Ideas site the other day and looked through that list. There was a feature I was looking for.

    @Jeff Schwenk so far, the Mod Squad has had plenty to filter through. And for now, at least, the Mod Squad has requested we not open up a community for suggestions. If you have a favorite member of the Mod Squad, send them your suggestions.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


  • 17.  RE: Key file rebuild Utility creating *.old backup files in SAGE 100 STD

    Posted 03-05-2021 11:25
    Sorry I’m on mobile with is absolutely terrible for viewing discussions.

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------



    Original Message


Related Content