The first step in the data import process is to complete the Excel spreadsheet templates with the location, organization, contact, and resource data you want to import. Download the templates and fill each of them out following the guidelines below.
Image: Templates are available to download from the Series25 Data Import Tool
For specific instructions on importing partition preferences for use with Schedule25 Optimizer, see Importing Organization Partition Preferences.
When filling out the spreadsheets, don't delete any of the columns, If you choose not to provide data in a particular column, that's fine, but don't delete the column itself.
In addition, don't relabel any of the spreadsheet worksheets or columns.
You can add columns after the standard columns in each worksheet for custom attributes you want to import. See Custom Attribute Guidelines below.
These general guidelines are basic to a successful import:
The Data Import Tool lets you import custom attribute master definitions for locations, resources, contacts, and organizations, and enter a value for each custom attribute appropriate to its relevant object. You can list the custom attributes in the appropriate worksheet, or they may already be present in your Series25 database in which case you don't have to fill out the custom attribute worksheet.
25Live uses the following attributes:
|Type of data||Attribute Type||Spreadsheet Format|
|Short text||S||Maximum 80 characters|
|Unlimited text||X||No maximum|
|Integer||N||Whole number without a decimal point|
|Floating point||F||Number with a decimal point|
|Date and time||E||MM/DD/YYYY hh:mm|
|URL||R||Include http:// or https:// at the beginning|
|Boolean||B||True/False, T/F, Y/N|
|Contact||3||Work email address|
|Image||I||N/A - Do not upload images using this spreadsheet|
These instructions only apply if you're importing new custom attributes that are not yet in your Series25 database.
For each custom attribute, enter the appropriate Attribute Type as indicated in the table above:
Here’s an example of custom attribute master definitions listed in the Location Custom Attributes worksheet:
For each location, resource, organization, or contact to which an attribute applies, make the appropriate entry based on the Spreadsheet Format in the table above.
Here’s an example of three custom attribute entries for a location in the Location worksheet:
The import looks for a custom attribute to match any column in an object worksheet (such as “Location”) with a column header label not predefined in the corresponding Excel template. The import continues even when the Data Import Tool is unable to match a column heading to either the corresponding Custom Attributes worksheet or a Custom Attributes master definition in 25Live. The affected objects are imported without the unmatched data element.