Billing To Milan > Billing to Milan's SQL Scripts > ArchiveInput

ArchiveInput

Billing To Milan uses the ArchiveInput script to move or copy workspaces from one database to another.

Required Fields

Field Name Description
ClientID Client alias value
ClientName Client description
MatterID Matter alias value
MatterName Matter description
Server WorkSite server (DMS) name
Database Name of source WorkSite database in which workspace currently resides.
TargetDatabase Name of the WorkSite database to which Milan will move the specified workspace.
WorkspaceName Naming convention for workspaces; may be built in query using multiple field variable combinations such as ClientID, MatterID, and MatterName.

Note: If the TargetDatabase is on a different server, you must specify the name of the server hosting the database in the application setting target-dms.

Optional Fields

Field Names Description
FlatspaceFilingFolder The name of an existing folder to which flatspace documents should be filed when a workspace does not have a folder with a matching Class value.
DeleteOption
Specifies what to do with documents in the source database after they have been copied to the target database.
Value Action
0 Leave
1 Add to recycle bin
2 Mark as record
3 Delete after move
RetainNumber
Specifies what document number to assign to documents in the target database.
Value Action
0 Assign new document numbers.
1 Retain original document numbers.
2 Retain original document numbers when the document number does not already exist in the target database.

The following fields are all binary options. To enable an option, set the field to 1; otherwise, set the field to 0.

Field Names Description
CheckedOutDocumentsOption Unlock checked out documents before moving a workspace.
EnableDisableUser Enable WorkSite users disabled in the target database if they are associated with the workspace content; create metadata values in the target database if they are associated with the workspace content but do not already exist.
FlatspaceFiling Move flatspace documents in the source database if their client and matter numbers match those of the workspaces being moved.
MultipleReferenceOption Move documents with multiple references in WorkSite if their client and matter numbers match those of the workspace in which they reside. If not enabled, documents with multiple references are not moved.
Shortcut Update shortcuts to moved workspaces in users' My Matters lists. If not enabled, the shortcuts are removed.
SkipSanityCheck Skip the preflight check, which verifies whether documents are checked out or if disabled user accounts exist.
skipethicalwallgroups Do not apply existing ethical walls (i.e., Z groups) after moving workspaces.