|
|
Hello
is there any way to automate backing up the BCM 2007 database, to
produce .sbb files?
I do it every day manually, by clicking menu Business Contact Manager ->
Dataase Tools -> Manage Database -> Backup Database
I was trying to do SQL backup, but I didn't succeed (problems with
restore, all clients had to resynchronize and I got multiple entries in
database, which was not good :( ).
Are there any ready-to-use-scripts, external (free) programs, or I am
forced into using some self made automation/scripting tools?
--
--- Piotr Kierklo ---
Systems Engineer at World IT Systems
-- piotr.kierklo[ at ]worlditsystems.com --
|
|
Of course it sounds trivial but presume that macro recorder like KeyText or
AutoMate could perform this task - basically they simply make mouse clicks
for you. It's dirty approach, but since Softies do not offer anything
better...
|
|
On May 10, 6:09 am, Piotr Kierklo <""piotr.kierklo.
\"[ at ]at[ at ].worlditsystems.com"> wrote:
[Quoted Text] > Hello
>
> is there any way to automate backing up the BCM 2007 database, to
> produce .sbb files?
> I do it every day manually, by clicking menu Business Contact Manager ->
> Dataase Tools -> Manage Database -> Backup Database
>
> I was trying to do SQL backup, but I didn't succeed (problems with
> restore, all clients had to resynchronize and I got multiple entries in
> database, which was not good :( ).
>
> Are there any ready-to-use-scripts, external (free) programs, or I am
> forced into using some self made automation/scripting tools?
>
> --
> --- Piotr Kierklo ---
> Systems Engineer at World IT Systems
> -- piotr.kier...[ at ]worlditsystems.com --
The BCM backup is just a SQL backup copied into a zip folder with some
xml metadata. BCM does disconnect all the shared database clients
before doing backups and restores though, which may explain the
results you saw using SQL backup.
|
|
good explanation but doesn't look like useful tip in response to a problem :)
|
|
This is a multi-part message in MIME format.
--------------050903090905050309000802
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
OK, for all of you who also have the same problem.
I used AutoHotKey tool (http://www.autohotkey.com):
[Quoted Text] > AutoHotkey is a free, open-source utility for Windows. With it, you can:
>
> * Automate almost anything by sending keystrokes and mouse clicks. You can write a mouse or keyboard macro by hand or use the macro recorder.
> * Create hotkeys for keyboard, joystick, and mouse. Virtually any key, button, or combination can become a hotkey.
> * Expand abbreviations as you type them. For example, typing "btw" can automatically produce "by the way".
> * Create custom data-entry forms, user interfaces, and menu bars. See GUI for details.
> * Remap keys and buttons on your keyboard, joystick, and mouse.
> * Respond to signals from hand-held remote controls via the WinLIRC client script.
> * Run existing AutoIt v2 scripts and enhance them with new capabilities.
> * Convert any script into an EXE file that can be run on computers that don't have AutoHotkey installed.
I run the attached script (backup.bcm.ahk) from Scheduled Tasks, once
per day. Then I copy the backup file over SSH using Putty SCP and key
authentication to another host for backup safety.
Although I am having some problems when the console locks down after a
period of inactivity (the opened Outlook window cannot be activated, and
you have to activate it manually, which spoils the whole idea of
AUTOMATED backups) I have solved that by disabling automatic console
locking. And now I don't have to remember about manually backup up BCM
database every day.
--
--- Piotr Kierklo ---
Systems Engineer at World IT Systems
-- piotr.kie....[ at ]worlditsystems.com --
--------------050903090905050309000802
Content-Type: text/plain;
name="backup.bcm.ahk"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="backup.bcm.ahk"
UnVuLCBDOlxQcm9ncmFtIEZpbGVzXE1pY3Jvc29mdCBPZmZpY2VcT2ZmaWNlMTJcT1VUTE9P
Sy5FWEUNCldpbldhaXQsIE91dGxvb2sgVG9kYXkgLSBNaWNyb3NvZnQgT3V0bG9vaywgQnVz
aW5lc3MgQ29udGFjdCBNYW4NCklmV2luTm90QWN0aXZlLCBPdXRsb29rIFRvZGF5IC0gTWlj
cm9zb2Z0IE91dGxvb2ssIEJ1c2luZXNzIENvbnRhY3QgTWFuLCBXaW5BY3RpdmF0ZSwgT3V0
bG9vayBUb2RheSAtIE1pY3Jvc29mdCBPdXRsb29rLCBCdXNpbmVzcyBDb250YWN0IE1hbg0K
V2luV2FpdEFjdGl2ZSwgT3V0bG9vayBUb2RheQ0KU2VuZCwge0FMVERPV059b3tBTFRVUH1k
bQ0KV2luV2FpdCwgTWFuYWdlIERhdGFiYXNlLCAmQmFjayBVcCBEYXRhYmFzZS4uLg0KSWZX
aW5Ob3RBY3RpdmUsIE1hbmFnZSBEYXRhYmFzZSwgJkJhY2sgVXAgRGF0YWJhc2UuLi4sIFdp
bkFjdGl2YXRlLCBNYW5hZ2UgRGF0YWJhc2UsICZCYWNrIFVwIERhdGFiYXNlLi4uDQpXaW5X
YWl0QWN0aXZlLCBNYW5hZ2UgRGF0YWJhc2UsICZCYWNrIFVwIERhdGFiYXNlLi4uDQpTZW5k
LCB7QUxURE9XTn1ie0FMVFVQfQ0KV2luV2FpdCwgRGF0YWJhc2UgQmFja3VwLCBUbyBiYWNr
IHVwIGFsbCBvZiB5bw0KSWZXaW5Ob3RBY3RpdmUsIERhdGFiYXNlIEJhY2t1cCwgVG8gYmFj
ayB1cCBhbGwgb2YgeW8sIFdpbkFjdGl2YXRlLCBEYXRhYmFzZSBCYWNrdXAsIFRvIGJhY2sg
dXAgYWxsIG9mIHlvDQpXaW5XYWl0QWN0aXZlLCBEYXRhYmFzZSBCYWNrdXAsIFRvIGJhY2sg
dXAgYWxsIG9mIHlvDQpTZW5kLCB7QUxURE9XTn1ie0FMVFVQfQ0KV2luV2FpdCwgQmFja3Vw
LCBTYXZlIGFzICZ0eXBlOg0KSWZXaW5Ob3RBY3RpdmUsIEJhY2t1cCwgU2F2ZSBhcyAmdHlw
ZTosIFdpbkFjdGl2YXRlLCBCYWNrdXAsIFNhdmUgYXMgJnR5cGU6DQpXaW5XYWl0QWN0aXZl
LCBCYWNrdXAsIFNhdmUgYXMgJnR5cGU6DQpTZW5kLCB7U0hJRlRET1dOfW1zc3tTSElGVFVQ
fW1hbGx7U0hJRlRET1dOfWJ7U0hJRlRVUH11c2luZXNzLSVBX1lZWVklLSVBX01NJS0lQV9E
RCVfYXV0b3tFTlRFUn0NCldpbldhaXQsIERhdGFiYXNlIEJhY2t1cCwgDQpJZldpbk5vdEFj
dGl2ZSwgRGF0YWJhc2UgQmFja3VwLCAsIFdpbkFjdGl2YXRlLCBEYXRhYmFzZSBCYWNrdXAs
IA0KV2luV2FpdEFjdGl2ZSwgRGF0YWJhc2UgQmFja3VwLCANClNlbmQsIHtBTFRET1dOfW97
QUxUVVB9e0VOVEVSfQ0KV2luV2FpdCwgQnVzaW5lc3MgQ29udGFjdCBNYW5hZ2VyIGZvciBP
dXRsb29rLCBPSw0KSWZXaW5Ob3RBY3RpdmUsIEJ1c2luZXNzIENvbnRhY3QgTWFuYWdlciBm
b3IgT3V0bG9vaywgT0ssIFdpbkFjdGl2YXRlLCBCdXNpbmVzcyBDb250YWN0IE1hbmFnZXIg
Zm9yIE91dGxvb2ssIE9LDQpXaW5XYWl0QWN0aXZlLCBCdXNpbmVzcyBDb250YWN0IE1hbmFn
ZXIgZm9yIE91dGxvb2ssIE9LDQpTZW5kLCB7QUxURE9XTn1ve0FMVFVQfXtFTlRFU2VuZCwg
e0FMVERPV059b3tBTFRVUH17RU5URVJ9DQpXaW5XYWl0LCBNYW5hZ2UgRGF0YWJhc2UsICZC
YWNrIFVwIERhdGFiYXNlLi4uDQpJZldpbk5vdEFjdGl2ZSwgTWFuYWdlIERhdGFiYXNlLCAm
QmFjayBVcCBEYXRhYmFzZS4uLiwgV2luQWN0aXZhdGUsIE1hbmFnZSBEYXRhYmFzZSwgJkJh
Y2sgVXAgRGF0YWJhc2UuLi4NCldpbldhaXRBY3RpdmUsIE1hbmFnZSBEYXRhYmFzZSwgJkJh
Y2sgVXAgRGF0YWJhc2UuLi4NClNlbmQsIHtFTlRFUn0NClNlbmQsIHtBTFRET1dOfWN7QUxU
VVB9DQpXaW5XYWl0LCBPdXRsb29rIFRvZGF5IC0gTWljcm9zb2Z0IE91dGxvb2ssIEJ1c2lu
ZXNzIENvbnRhY3QgTWFuDQpJZldpbk5vdEFjdGl2ZSwgT3V0bG9vayBUb2RheSAtIE1pY3Jv
c29mdCBPdXRsb29rLCBCdXNpbmVzcyBDb250YWN0IE1hbiwgV2luQWN0aXZhdGUsIE91dGxv
b2sgVG9kYXkgLSBNaWNyb3NvZnQgT3V0bG9vaywgQnVzaW5lc3MgQ29udGFjdCBNYW4NCldp
bldhaXRBY3RpdmUsIE91dGxvb2sgVG9kYXkgLSBNaWNyb3NvZnQgT3V0bG9vaywgQnVzaW5l
c3MgQ29udGFjdCBNYW4NClNlbmQsIHtBTFRET1dOfWZ7QUxUVVB9eA0K
--------------050903090905050309000802--
|
|
Okay, now that I can create a backup file, how would I restore it if I
needed to?
--
Neil
"Piotr Kierklo" <piotr.kier....[ at ]worlditsystems.com> wrote in message
news:465E82B4.1030800[ at ]worlditsystems.com...
[Quoted Text] > OK, for all of you who also have the same problem. > > I used AutoHotKey tool ( http://www.autohotkey.com):> >> AutoHotkey is a free, open-source utility for Windows. With it, you can: >> >> * Automate almost anything by sending keystrokes and mouse clicks. >> You can write a mouse or keyboard macro by hand or use the macro >> recorder. >> * Create hotkeys for keyboard, joystick, and mouse. Virtually any >> key, button, or combination can become a hotkey. >> * Expand abbreviations as you type them. For example, typing "btw" >> can automatically produce "by the way". >> * Create custom data-entry forms, user interfaces, and menu bars. See >> GUI for details. >> * Remap keys and buttons on your keyboard, joystick, and mouse. >> * Respond to signals from hand-held remote controls via the WinLIRC >> client script. >> * Run existing AutoIt v2 scripts and enhance them with new >> capabilities. >> * Convert any script into an EXE file that can be run on computers >> that don't have AutoHotkey installed. > > I run the attached script (backup.bcm.ahk) from Scheduled Tasks, once > per day. Then I copy the backup file over SSH using Putty SCP and key > authentication to another host for backup safety. > > Although I am having some problems when the console locks down after a > period of inactivity (the opened Outlook window cannot be activated, and > you have to activate it manually, which spoils the whole idea of > AUTOMATED backups) I have solved that by disabling automatic console > locking. And now I don't have to remember about manually backup up BCM > database every day. > > > -- > --- Piotr Kierklo --- > Systems Engineer at World IT Systems > -- piotr.kie....[ at ]worlditsystems.com -- >
--------------------------------------------------------------------------------
> Run, C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE
> WinWait, Outlook Today - Microsoft Outlook, Business Contact Man
> IfWinNotActive, Outlook Today - Microsoft Outlook, Business Contact Man,
> WinActivate, Outlook Today - Microsoft Outlook, Business Contact Man
> WinWaitActive, Outlook Today
> Send, {ALTDOWN}o{ALTUP}dm
> WinWait, Manage Database, &Back Up Database...
> IfWinNotActive, Manage Database, &Back Up Database..., WinActivate, Manage
> Database, &Back Up Database...
> WinWaitActive, Manage Database, &Back Up Database...
> Send, {ALTDOWN}b{ALTUP}
> WinWait, Database Backup, To back up all of yo
> IfWinNotActive, Database Backup, To back up all of yo, WinActivate,
> Database Backup, To back up all of yo
> WinWaitActive, Database Backup, To back up all of yo
> Send, {ALTDOWN}b{ALTUP}
> WinWait, Backup, Save as &type:
> IfWinNotActive, Backup, Save as &type:, WinActivate, Backup, Save as
> &type:
> WinWaitActive, Backup, Save as &type:
> Send,
> {SHIFTDOWN}mss{SHIFTUP}mall{SHIFTDOWN}b{SHIFTUP}usiness-%A_YYYY%-%A_MM%-%A_DD%_auto{ENTER}
> WinWait, Database Backup,
> IfWinNotActive, Database Backup, , WinActivate, Database Backup,
> WinWaitActive, Database Backup,
> Send, {ALTDOWN}o{ALTUP}{ENTER}
> WinWait, Business Contact Manager for Outlook, OK
> IfWinNotActive, Business Contact Manager for Outlook, OK, WinActivate,
> Business Contact Manager for Outlook, OK
> WinWaitActive, Business Contact Manager for Outlook, OK
> Send, {ALTDOWN}o{ALTUP}{ENTESend, {ALTDOWN}o{ALTUP}{ENTER}
> WinWait, Manage Database, &Back Up Database...
> IfWinNotActive, Manage Database, &Back Up Database..., WinActivate, Manage
> Database, &Back Up Database...
> WinWaitActive, Manage Database, &Back Up Database...
> Send, {ENTER}
> Send, {ALTDOWN}c{ALTUP}
> WinWait, Outlook Today - Microsoft Outlook, Business Contact Man
> IfWinNotActive, Outlook Today - Microsoft Outlook, Business Contact Man,
> WinActivate, Outlook Today - Microsoft Outlook, Business Contact Man
> WinWaitActive, Outlook Today - Microsoft Outlook, Business Contact Man
> Send, {ALTDOWN}f{ALTUP}x
>
|
|
|
[Quoted Text] > Okay, now that I can create a backup file, how would I restore it if I
> needed to?
There is no automation script for that:)
In fact, since this action is invoked usually once and requires your
assistance, you do it manually by:
From main menu bar select
Business Contact Manager -> Database Tools -> Manage Database
then click "Restore Database" button
then select backup .sbb file and proceed.
--
--- Piotr Kierklo ---
Systems Engineer at World IT Systems
-- piotr.kie....[ at ]worlditsystems.com --
|
|
|