- This topic has 13 replies, 6 voices, and was last updated 5 years, 1 month ago by
.
-
Topic
-
We are currently running Cloverleaf 5.7 rev 2 on Windows 2008 servers. We have a couple of batch files & a tcl script that was provided by McKesson to cyclesave the smat files daily and save them into a folder.
We are trying to upgrade to Cloverleaf 19.1 from Infor on Windows 2016 servers. The batch files fail. The setroot and setsite commands will not work.
We don’t want to do the smat files by size, but by each day, so the auto archive in the 19.1 will not work for us.
Does anyone have a process to do this daily?
-
Replies
-
-
I don’t know if 19.1 supports the old .idx and .msg files. If it does is that what you intend to use? Otherwise, there was some code ‘hcicyclesmatdb’ that I currently make use of on version 6.1.2.0. I think it still exists on Clovertech. All files now get stored in processes/<processname>/SmatHistory. I use a combination of the configuration with much set to unlimited and then use cron to cycle like done previously. I will be setting up a 19.1 server shortly and putting it through it paces….
FYI… I never put production over to the SQLite db’s on account of some issues with the version we are on….But would like to finish getting cutover to smatdb files.
-
-
-
-
-
-
-
-
-
We have scripts run weekly, for each process, for each site (with an exclude list), that cycle saves each thread, and then collects all Smat DBs – per thread – that are in SmatHistory and concatenates them into one file called <SmatDB_name>_Back7.
We first move the previous Back7 file to a different file system for archiving, and that version is purged after a specified time, by another script. We have an enterprise backup utility that can restore purged SmatDBs.
Basically each Smat DB will have a ‘Back7’ version in SmatHistory, which represents the previous week. And maybe we don’t have to go to all this trouble. But the original intent was to limit the space used in our main, operational file system by only keeping the current and the previous week’s SmatDB. We found that 90% of our SmatDB searches are satisfied by the current and the previous week’s SmatDB file. So that is why these are the only two versions kept under the local process.
With recent updates allowing softlinks to other locations, we may not need all of this movement. But it sure is quick and easy to find what we want.
These scripts have borrowed a lot of code from previous postings here. Let me know if anyone is interested in looking at these scripts.
Peter Heggie
-
-
-
here ya go, should be attached to this post.
its nothing special. i think most of this comes with CL by default? but slightly modified. it isnt for 19.1, but still shows as example. you’ll call the cycle_save.bat from task manager.
hope this helps..
**edit… clovertech isn’t allowing the .bat and another file to be uploaded. i’ve zipped it up and trying again..
-
- You must be logged in to reply to this topic.
