Home → Guides :: Trumpet Publisher for Sharefile → Printer Friendly Version
Trumpet Publisher is a tool that is included in the Assemblage application. Therefore, you must install the full version of Assemblage, but you will be licensed to utilize the Trumpet Publisher tool only.
Assemblage itself runs only on user desktops (or as a simple published app) - there are no services installed or changes made to the file server except for the creation of a shared network folder.
During installation, the Assemblage executable and configuration files are installed to a network drive.
Assemblage should be installed to a network drive accessible by those in the firm who will need to use the software (e.g. X:\Assemblage). This does not need a dedicated network drive, and can be installed to an existing location. This network drive should have enough disk capacity to hold all the content that will be included in your report packages.
1) Download and save the Assemblage Installer file provided to you via email
2) Double click on the installer executable to run the Installation Wizard
3) Click "Next" at the Welcome window
4) Read the Software License Agreement and select "I Agree"
5) Select "Browse" and locate the network location (drive letter) to which you wish to install Assemblage
6) Select "Install"
7) Navigate to X:\Assemblage (where "X" is the network drive to which Assemblage is installed) and double click on the Assemblage executable file (assemblage.exe) to launch
8) If Assemblage prompts you to install a Java runtime, follow the prompts (this is a one time installation that will be done on each workstation as the user launches for the first time)
8) When prompted, copy and paste the license number provided to you via email
9) Click "OK"
Assemblage should now be installed on your network.
Â
Assemblage often utilizes a firm's existing SQL Databases to collate various pieces of content. Trumpet establishes those connections via Windows authenticated connections.
This configuration is available from the main Assemblage application, Tools->Preferences, Database connections:
You can have multiple Database connections
To add a database connection, select "Add"
When the "Add..." window opens, provide a Connection name (typically the name of the software):
The Connection URL field should be completed as follows:
jdbc:jtds:sqlserver://<servername>/<databasename>;instance=<instancename>
Where you replace the "<servername>" with the actual server name, <databasename> with the actual database name and <instancename> with the actual instance name
If your SQL server requires SSL encryption, you will need to add ssl=required to the end of your Connection URL.
e.g. jdbc:jtds:sqlserver://SRV2014/JUNXURE;instance=JUNXURE;ssl=required
e.g. jdbc:jtds:sqlserver://SRV2014/PC;instance=PORTFOLIOCENTER;ssl=required
If you have a set user that you would like to set for accessing the Database you can add the following to the string:
";user=<username>;password=<password>"
e.g. jdbc:jtds:sqlserver://<servername>/<databasename>;instance=<instancename>;user=<username>;password=<password>
To ensure that you have access to the appropriate database, select "Test Connection"
If your connection is set properly, you will see the a green check, along with the dialog that says "Successful connection made!"
The first step in utilizing the Trumpet Publisher it to clear the content of the reports generated from your last reporting period.
To do so, navigate to X:\Assemblage\Workspace\Trumpet Publisher Project\Publisher In\
(where "X" is the network drive to which Assemblage is installed)
and delete the pdf files from the last reporting period.
Generate the content you wish to publish using your saved Batch Print Job or Saved Job in Presentation Studio.
This should place the content in the X:\Assemblage\Workspace\Trumpet Publisher Project\Publisher In\ folder (where "X" is the network drive to which Assemblage is installed).
Note:Â The location in which you generate your reports should not matter as long as the file path is equivalent to that which you utilized during your set up.