Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

An AppleScript to monitor Entourage database growth Apps
As a user of Entourage for newsgroup access, I like to keep an eye on the size of the database to make sure it doesn't grow too big. When I think it's too big, I empty the newsgroup caches and rebuild the database. I wrote an AppleScript that will keep an eye on the size of the database for me. It sends an email (via Entourage) to let me know when it's gotten too big.

The scheduling period is up to you. Personally, I have Entourage scheduled to run the script on Startup and every day at 1am (since I tend to leave my Mac on 24/7). But note that if you never rebuild your database, the script will continue to notify you, so you probably don't want it to run too often!
    •    
  • Currently 3.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (3 votes cast)
 
[10,662 views]  

An AppleScript to monitor Entourage database growth | 3 comments | Create New Account
Click here to return to the 'An AppleScript to monitor Entourage database growth' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Another way ...
Authored by: mshmgi on Mar 25, '04 11:27:14PM

Here is another way to do this. If you desire, change the "10240" to your size limit is (10240 = 10 MB).

When the database gets too big, a text document will open with a friendly reminder to rebuild the database.

You can easily set up a cron job to run the shell script at any interval desired.
=============================
#!/bin/bash
x=`du -sk ~/Documents/Microsoft\ User\ Data/Office\ X\ Identities/Main\ Identity/Database`
for n in $x; do
if [ $n -gt 10240 ]; then
echo "Rebuild the Entourage Database ($n KB)" > ./.msg.txt
open ./.msg.txt
sleep 5
fi
rm ./.msg.txt
exit
done
=============================

BEWARE OF LINE BREAKS IN YOUR BROWSER!!!



[ Reply to This | # ]
Another way ...
Authored by: spfolly on Mar 26, '04 10:05:21AM

What happens if the user is not logged in?

With my script, I've said you can schedule it in Entourage which would imply you have to be logged in anyway.

I've realised some improvements can be made though - for example, yourShortUserName is redundant because the databasePath can be made up from

(path to documents folder) as string & "Microsoft User Data....."



Thanks for the feedback anyway!



[ Reply to This | # ]
Automate Entourage's database rebuilding
Authored by: Gnarlodious on Mar 28, '04 11:02:41PM
Compact Database --reminds you what button to push
 tell application "Finder"
   activate
   tell application "Microsoft Entourage" to quit
   open folder "Applications:Microsoft Office X:" of the startup disk
   select file "Applications:Microsoft Office X:Microsoft Entourage" of the startup disk
   display dialog ¬
      "With caps lock off, hold down \"opt\" key and restart Entourage"
end tell 
Delete old databases
  set identitiesPath to ((path to home folder) ¬
   & "Library:Microsoft User Data:Office X Identities:" as string)

tell application "Finder"
   set identityList to every folder of folder identitiesPath
   repeat with ThisIdentity in identityList
      delete (every file of ThisIdentity whose creator type is "OPIM" and ¬
         file type is in {"OEDB", "OECl"} and name starts with "Old")
   end repeat
   open ThisIdentity
end tell 


• Gnarlie's Applescript page

[ Reply to This | # ]