Complete the Use Based Rent Breakpoint Import Spreadsheet

• System Administrator access to the Import Data page.

• Download a new copy of the import spreadsheet to ensure system changes are captured and to avoid carrying over errors from previous data imports.

• Give your spreadsheet a unique name so that you can track changes.

• Plan large uploads (more than 2,000 rows) after normal business hours.

• Test the import in TRAIN before importing to PRODUCTION

• Do not change column header names

• Do not add new sheets to the spreadsheet

• Do not change the name of the spreadsheet tab, unless instructed to do so

• Hide columns you do not plan to use, but do not delete them

• Ensure the file extension of the import file matches the file type of a supported import file format such as XLS, XLSX, and XML.

• To clear a field that currently contains a value in the system, type Null.

• To skip entering a value in a field, leave the field in the spreadsheet blank.

• Ensure all data exactly matches to avoid the system creating records with incorrect data. For example, contract names must include the same number of spaces.

• Entering data on first available row after the header.

• Avoid using special characters such as quotes and percentage signs

• Enter dates in MM/DD/YYYY format.

• To create a record, type FALSE in the Update Only column. To update a record, type TRUE in the Update Only column.

• To enter multiple values for column headers with an asterisk * at the end, ensure each value is separated by a comma.

To download the use based rent breakpoint import spreadsheet:

1. Click Admin in the toolbar in the upper-right corner of the window.

   The System Administrator Dashboard page opens.

2. Click Import Data link in the Company Administration column.

   The Import Data page opens.

3. Select the Spreadsheets tab.

   The Spreadsheets page opens.

4. Select the Use Based Rent Breakpoint spreadsheet from the Download Spreadsheet Templates field.

5. Click Download.

   The system prompts you to save or open a Microsoft Excel file.

6. Save the Excel file in a place on your computer where you will be able to find it, and give it a distinctive name.

To enter your data in the spreadsheet:

1. Open the spreadsheet in a spreadsheet editor.

2. Use the Field Definitions section below as a reference for what data to enter in each column.

3. Enter your data in the appropriate columns.

   Make sure to save frequently, to avoid accidentally losing your progress.

4. Review the data to ensure its accuracy.

5. Save the spreadsheet.

The following table contains definitions for each field in the import spreadsheet. If you have questions about these fields, please contact your Accruent representative or Accruent Support.

These are generic procedures that are common across all or multiple areas of Lucernex. As such, these procedures do not call out specific navigation to the page.

To import data:

1. Click Import Data.

   This displays in the Actions menu on the right side of the page.

   The Upload Spreadsheet window opens.

2. Click Download Spreadsheet if you need to download a spreadsheet for import.

   The spreadsheet downloads.

3. Complete the spreadsheet.

4. Save the spreadsheet with a unique title, so that you can identify it for tracking purposes.

5. Click Browse in the Upload Spreadsheet window.

   An upload dialog box opens.

6. Select the spreadsheet you saved in step 4.

7. Do one of the following:

   • If you are doing a test import of your data in TRAIN, select the Continue till the end option.

     This will import the entire spreadsheet, with the exception of the lines that have errors. The system will give you a summary of the lines that had errors once the import is complete.

   • If you are importing your data in PRODUCTION, select the On first error option.

     This will stop the import if the system encounters an error, and the system will inform you which line had the error. You can then fix your import, remove the lines that have already been imported, and then re-import the spreadsheet.

8. Click Import.

   The import starts.

   The import completes. A window with a summary of the results of your import displays.

9. Click Close.

   The window closes. A dialog box opens, asking if you want to reload the page.

10. Click Yes.

    The page refreshes. Your new data appears on the page.