Pre-defined Settings



Automating Synchronization Using Command Lines Settings

WinSales Version: All

Revision Date: 4/3/02

Support Document: supp023

Problem: How can I set up WinSales Synchronization to automatically occur at specified times.

Solution: You can automate WinSales Synchonriation using a command line on a shortcut to the Synchronization program. WinSales Synchronization will then use the command line to determine how frequently to wake up and synchronize the database.

Setting up the Shortcut: Create a shortcut on the desktop to the WSSYNCHRONIZE.EXE (WSSYNC.EXE in 3.x/4.x) file located in C:\PROGRAM FILES\WINSALES\ (C:\WINSALES in 3.x/4.x). Once the shortcut is created, right click on the icon and note the target.

Pre-defined Command Line Settings: You may pre-define the database, user and interval used by the NetSync program. For the Command Line, include the name of the program file, followed by one or more of the parameters described below:

/db=name The name of the database file. This is a fully qualified file and path name. If you are using a SQL Server database you would insert the SQL_Database_Name@SQL_Server_Name

/user=name The name of a WinSales user linked to the database site.

/pass=password The name user’s WinSales password (/pass is only in WinSales 5.0, there is no password required for the command line in 3.2/4.x)

/interval=n The number of minutes, hours or days between synchronization runs. Place the letter "m", "h" or "d" after the number, to indicate minutes, hours or days, respectively. Zero causes NetSync to execute once, then the program displays the screen log waiting for user to exit.

/exit When present, NetSync terminates after execution. Can be used only when a zero interval (or no interval) is specified.

/minutes=n1,n2... List of minute numbers in which NetSync may execute. If not specified, NetSync will execute in any minute of the hour. Minutes are specified as 0 through 59. More than one minute may be specified by separating each with a comma (no spaces are permitted in the list).

/hours=n1,n2... List of hour numbers in which NetSync may execute. If not specified, NetSync will execute in any hour of the day. Hours are specified as 0 through 23. More than one hour may be specified by separating each with a comma (no spaces are permitted in the list).

/days=n1,n2... List of day numbers or weekday abbreviations (or a combination of the two) on which NetSync may execute. If not specified, NetSync will execute on any day. Day numbers are specified as 1 through 31. Weekday abbreviations are specified as Sun through Sat. More than one day may be specified by separating each with a comma. No spaces are permitted in the list.

/wait If present, NetSync does not execute immediately when the program starts, but instead waits according to /interval, /hours and /minutes.

Example 1 – WinSales 5.0 Access database:

“c:\program files\winsales\wssynchronize.exe” /db=c:\program files\winsales\data\demo.wsd /user=admin /pass=admin /interval=30m

This example conducts synchronization for the demo.wsd database, located in the c:\program files\winsales\data path, every 30 minutes. The user named "Admin" is tied to the remote sync site that this database represents, and is authorized to perform synchronizations for this database. The first sync will occur immediately when the program is started.

Example 2 – WinSales 5.0 Access database:

“c:\program files\winsales\wssynchronize.exe” /db=c:\program files\winsales\data\demo.wsd /user=admin /pass=admin /interval=1h /hours=9,10,11,12,13,14,15,16,17,18 /days=Tue,Thu, /minutes=0 /wait

This example conducts synchronizations for the demo.wsd database, located in the c:\winsales\data path, every hour, at the top of the hour (minute 0), but only from 9:00am through 6:00pm (18:00 hours), and only on Tuesdays, Thursdays or on the first of the month. The user "Admin" is tied to the remote sync "site" that this database represents, and is authorized to perform synchronizations for this database. The first sync will not occur immediately when the program is started, but when the top of the next hour occurs within the hours listed.

Example 3 – WinSales 5.0 SQL database:

“c:\program files\winsales\wssynchronize.exe” /db=wssqldb@sql_server_name /user=admin /pass=admin /interval=30m

This example conducts synchronization for the WSSQLDB database, located on the SQL Server sql_server_name every 30 minutes as the user Admin.

Example 3 – WinSales 4.0 Access database:

“c:\winsales\wssync.exe” /db=c:\winsales\data\demo.wsd /user=admin /interval=30m

This example conducts synchronization for the demo.wsd database, located in the c:\winsales\data path, every 30 minutes. The user named "Admin" is tied to the remote sync site that this database represents, and is authorized to perform synchronizations for this database. The first sync will occur immediately when the program is started.

-----------------------

Silent Partner, Ltd

425-831-7915

support@



................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download