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 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. |