Configuring Billing To Milan

Billing To Milan is able to provide both wide-ranging support for billing and accounting systems and unparalleled customization through the use of SQL scripts.

Billing To Milan currently recognizes the following seven scripts:

Script Name	Function
MatterInput.sql	Creates and updates workspaces
BillingActivity.sql	Adds workspace shortcuts to users' My Matters in WorkSite based on the number of hours billed for a particular matter.
ArchiveInput.sql	Moves or archives workspaces from one WorkSite library to another
SubscriptionInput.sql	Creates a subscription for a specified user to the My Matters of another WorkSite user
MoveDocumentInput.sql	Moves documents within the same library
PolicyInput.sql	Creates policies to apply ethical walls using Security Center
PolicyInputEx.sql	Creates policies to apply ethical walls using Policy Center

Examples scripts are provided in C:\Program Files\Prosperoware.Milan\billingtomilan\SQL.

Note: All scripts require some customization before they can be successfully used.

Connection Strings

Before running Billing To Milan, you must create a connection string for each SQL script that you intend to use. If you run Billing To Milan without any command line options, it will look for a connection string named Billing; if no such connection string exists, Billing To Milan will return an error. In order for Billing To Milan to be able to create Provisioning Service jobs, a properly configured MatterInput or BillingActivity script must also exist in C:\Program Files\Prosperoware.Milan\billingtomilan\SQL.

The following table lists the connection string names Billing To Milan looks for when running each script.

Script	Connection String Name
MatterInput	Billing
BillingActivity	Billing
ArchiveInput	Archive
SubscriptionInput	Security
PolicyInput	PolicyInput
PolicyInputEx	PolicyInputEx

The above connection strings can be configured in Administration → Application Configuration → Connection Strings.

Additional Settings

See Billing to Milan in the appendix for a complete list of application settings related to Billing To Milan