Billing To Milan > Billing to Milan's SQL Scripts > Working with Billing To Milan's SQL Scripts

Working with Billing To Milan's SQL Scripts

By default, Billing To Milan looks for scripts in C:\Program Files\Prosperoware.Milan\billingtomilan\SQL, which contains example files for each script type. To edit the included scripts, open the SQL file in Microsoft SQL Server Management Studio or your preferred text editor.

Tip: Since all Billing To Milan scripts rely solely on SELECT statements, you are free to execute your edited scripts through Microsoft SQL Server Management Studio to verify that they return the expected results before using them with Billing To Milan.

Note: When Billing to Milan executes any of the following queries, it replaces '{0}' with the date and time that it last ran, less one day. The actual time stamp value is saved in C:\Program Files\Prosperoware.Milan\billingtoMilan\data\timestamp.xml in UTC format, which Billing To Milan adjusts for during the replacement process.

Script Types

Script Name Used For
MatterInput Creating and updating workspaces based on data from a billing or accounting system.
BillingActivity Adding shortcuts to users' My Matters based on their billed hours.
SubscriptionInput Subscribing users to other users' My Matters.
ArchiveInput Moving or copying workspaces from one database to another.
PolicyInput Creating Security Center policies.
PolicyInputEx Creating Policy Center policies.