Configuration Backups and Migrations Guide
Backing up and exporting the Lucernex configuration files is a process that provides the ability to restore configurations after a monthly Train refresh or migration to Production. Below are the individual steps explaining what files that should be considered for export.
Before Starting
Be sure to perform these actions prior to you or another individual exporting data from your firm:
-
If you will be having another individual perform exports, review the Manage Export Configuration Security page.
-
Create a backup folder where you will save your exported XML files.
We recommend the following naming convention:
-
Folder Naming: Client Name + Date Stamp + Version Number
-
Example: Lucernex 1-1-2019 v1
The version number is used to document multiple exports on the same day
-
-
File Naming: Client Name + Spacer + Tab Name + (report type, optional) + Number of files
-
Example: Lucernex - Summary Pages (5)
-
Example: Lucernex - Reports – Integrations (4)
-
Example: Lucernex - Other -Exchange Rates
-
-
Best Practices
-
Always import from the bottom-up, or the parts before the whole.
Here are three examples you may encounter:
-
Do not import a Budget Summary page until you have imported the Budget Template and Budget Types.
-
Do not import a Work Flow until you have imported the Schedules and Forms that are referenced in the Work Flow.
-
For page layout imports, import list layouts, then sub pages, then summary page layouts.
-
-
Append the prefix LxDev to the name of all of your configured templates.
This prefix is used to identify items that need to be exported before a Train refresh. Once you export and import the item into Production, you will remove LxDev from the name. This rule applies to items such as page layouts, forms, templates, and so on.
The reason you want to append this identifier to your templates is to prevent naming conflicts when you re-import into Production.
-
Be cautious when using the Export All.
While it makes exporting files easier, using this can have unintended consequences. Since the generated XML file contains all of the configuration files of the types listed on that page in the system, importing the file might introduce new configurations or override existing configurations.
For example, on the Export Configuration > Others tab, you can export user class security, exchange rates, CPI data, and fiscal period data, amongst other records. Imagine that you made modifications to the data on this page but you decided to exclude the changes made to your user security. If you clicked the Export All button and you imported the configuration into Production, you would overwrite your user security settings in Production.
-
Make note of formulas used in your forms and budget summary pages prior to export.
When you re-import, the record IDs assigned to the components of your forms and budget summary pages will change. This means that you will need to have to adjust any math formulas in your forms and budget summary pages.
-
As soon as a custom configuration is approved, import it to your production environment.
This will reduce your reconfiguration effort when train refreshes occur.
Export Your Configuration
Exporting your configuration is a process that can take multiple steps depending upon the records you have configured.
Most of your records will be exported from the Export Configuration page, with the exception of:
-
user-defined fields, which are exported from the Manage Data Fields page,
-
budget summary pages, which are exported from the Manage Budget Summary Page page, and
-
dashboard reports, which are exported from the Manage Dashboard Reports page.
Export Configuration Checklist
Download a PDF version of this checklist..
-
Summary Pages
-
Sub Pages
-
List Pages
-
Forms
-
Reports
-
Custom Reports
-
Lx Integrations
-
Lx Out of the Box
-
Sales Letter
-
-
Templates
-
Budget Templates
-
Folder Templates
-
Task Templates
Note:These are your schedule templates.
-
Workflows
-
-
Others
-
Budget Column Types
Your budget views will be exported in the same file as your budget types.
-
CPI
-
CustomCodeTable
These are your drop-down fields.
-
Exchange Rates
-
Fiscal Period
This is your fiscal calendar.
-
Report Folders
-
User Class Security
-
-
User-Defined Fields
Your user-defined fields are exported from the Manage Data Fields page.
-
Budget Summary Pages
Your budget summary pages are exported from the Manage Budget Summary Page page of the System Administrator Dashboard.
-
Dashboard Reports
Your dashboard reports are exported from the Manage Dashboard Reports page of the System Administrator Dashboard.
Export Configuration
Review Before Starting before exporting.
-
Export Configuration for the records you want to export.
-
Download a Budget Summary Page if your company uses budgets.
Import Your Configuration
You may begin importing once the Train refresh has finished or when you are ready to import your configurations from Train to Production. When importing configuration files there may be warning messages.
These warning messages are often returned when you import a "parent" item before importing its "child", such as when importing reports before importing the report folder templates. In this scenario, the reports are imported, but are saved to the Unspecified folder.
Import Configuration Checklist
Download a PDF version of this checklist.
We recommend exporting your configuration in a specific sequence, in order to reduce the likelihood of errors. Import your records in the following order:
-
User-Defined Fields
Since your other records may have user-defined fields built into them, you need to ensure that these data fields are imported first.
-
Budget items. These items must be imported in the following order:
-
Budget Templates
-
Budget Types
-
Your budget views will be exported in the same file as your budget types.
-
There will always be warnings when your budget columns contain formulas.
-
-
Budget Summary Pages
-
-
Folder Templates
-
Task Templates
These are your schedule templates.
-
Drop-Down Fields
These are contained within the Others > CustomCodeTable file.
-
Page Layouts
-
List Pages
-
Sub Pages
-
Summary Pages
-
-
Forms
Note:There will be errors related to your math fields.
-
Workflow Templates
-
Others
-
CPI
-
Exchange Rates
-
Fiscal Period
This is your fiscal calendar.
-
Report Folders
-
-
Reports
-
Custom Reports
-
Lx Integrations
-
Lx Out of the Box
-
Sales Letter
Important!Only Lucernex Administrators—that is, an administrative user employed at Accruent—can import reports that include custom Java filters. If you come across this error, contact your representative at Accruent.
If you have composite reports, import the reports that are included in the composite report first. Then, import the composite report.
-
-
Dashboard Reports
-
User Class Security
Import Configuration Procedures
To import your configuration, follow the procedures on the Import Data page.
Manual Reconfiguration
Certain items cannot be exported and must be recreated from screen shots, upload spreadsheets, or your configuration workbook. Once these items have been moved into production, they will be automatically copied over to your train environment with each Train Refresh.
Once these items are approved, they should be created in / uploaded to your production environment immediately to avoid these manual steps.
-
Binder Templates: To record your binder template configurations:
-
Follow the Navigate to the Binder Documents Tab procedures.
-
Select a template from the Binder Template field.
-
Take a screen shot of the documents in your template.
-
Upload the screen shot to the Refresh folder in the Lx firm.
-
Repeat steps 2 - 4 for any other binder templates.
-
-
Milestone Timeline: To record your milestone timeline:
-
Follow the Navigate to the Manage Milestone Timeline Page procedures.
-
Take a screen shot of each page of your milestones.
There may be multiple pages.
-
Paste the screen shots in the Milestones tab of your Configuration Workbook.
-
Save your Configuration Workbook.
-
-
Members / Contacts: Members and contacts should be stored in the Configuration Workbook and loaded via spreadsheet. The upload spreadsheet must be re-loaded after each refresh.
-
Org Charts: Org Chart data must live in the Configuration Workbook and must be reconfigured after every refresh.
-
Formulas: Take note of any formulas used in your summary pages and forms. Update all formulas in summary pages and forms.
If you are unsure which summary pages and forms have formulas:
-
Open each layout.
-
Click Formula button
in the field cells in the layout.
-
Check for errors in the Mathematical Operations Builder.
-
Files You Do Not Need to Export or Import
There are some records that come out-of-the-box when you begin using Lucernex. The rule of thumb for exporting your configuration is that you should only export your custom-configured items. Please review the Export Configuration Checklist section below for a list of items you should consider exporting.
Please note that the following records are out-of-the-box, and should not be exported unless you have modified them in some way:
-
Forms
-
Completed Maintenance
-
Conversation
-
Issue
-
OFC
-
Proposed Change
-
RFI
-
-
Others
-
CPI
If you have not entered CPI records into the system, you do not need to export this file.
-