SS> Maintenance > Import Configuration
Import Configuration
Summary
The Import Configuration tool is used to set up an import file format in Springbrook that matches an export file you would like to import. For example, an organization that outsources garbage collection could set up an import file that matches the file the garbage contractor generates for billing. This would allow a UB Billing Clerk to import the contractor's billing data directly into the UB Adjustments and Fees process.
Step by Step
1 View the existing configurations.
2 Create or modify an import file configuration.
- The Import File Configuration Maintenance window is used to create a new import file configuration.
- Enter a unique Name for the new import configuration.
- This is a required field and is limited to 40 alphanumeric characters.
- Select a Definition from the drop-down list. This will determine where the import file will be used.
- Import configuration definitions are created by Springbrook and are designed to import data into specific processes. As more Springbrook processes are exposed to the Import Configuration tool, they will be made available in the Definition drop-down list.
- Once a Definition is selected, the Description and Properties fields will automatically populate with the associated details.
- Select a Type for the import file from the drop-down list.
- Select Delimited to create a delimited import file that displays the included data fields in rows separated by a specified delimiter character.
- Use the Delimiter field below to enter the delimiter character that will be used to separate fields on each line. This will be determined by the delimiter used in the file you are attempting to import. Commas are the most commonly used delimiters.
- Select Fixed Width to create an import file that displays the included data fields in rows with specified width and padding values for each field.
- The Delimiter field will be disabled if Fixed Width is selected.
- The Skip Lines field is used to force the application to ignore one or more lines at the top of the import file. This is useful if the file you are attempting to import a file includes a header row.
- This must be a non-negative value between 0 and 100.
- Check the Default toggle to save the new configuration as the default import file configuration.
- Only one import file configuration can be marked as Default.
- Once the import file configuration is complete, click the Export icon
to export the file configuration so it can be shared with other Springbrook users.
3 Complete the Properties tab.
- The Properties tab is used to set up which of the available properties will be included in the import file configuration and how those properties will be organized.
- Select a property in the Available Properties section and click the Add icon
drop-down menu and select Add Property to add it to the import file.
- Once a property has been added to the Selected Properties section, it can be edited in the Options section.
- Specify a Position for the selected property.
- Properties will automatically be placed in the last position as they are added. When the value is edited in the Position field, the Selected Properties will update to display the new property position.
- Each property must occupy a different position. If two properties share the same position value, an error will occur when the import file configuration is saved.
- When creating a fixed width import file, the Width field will display below the Position field. This field is used to specify the width of a property.
- Fixed width import files use a combination of property position and property width to determine how properties are displayed. For example, if Property A is in position 1 and has a width of 5, Property B must have a position value of at least 6 in order to prevent overlap. If Property B is in position 6 and has a width of 4, Property C must have a position value of at least 10.
- Because of this relationship, setting the width values for each property before adding the next property is suggested.
- The Multiplier field is used to set a recalculation multiplier for the selected property.
- For example, if a third-party file is exported without using decimals, that export file will display a dollar value of $57.25 as 5725. In order to import that value into Springbrook properly, the multiplier would need to be set to 0.01, thereby recalculating 5725 as 57.25 in Springbrook.
- This field will only be enabled for decimal and integer properties.
- The Rounding Place field is used to specify which decimal place will be rounded.
- For example, if 2 is entered in this field, a decimal value of 25.926 will be rounded to 25.93.
- This field will only be enabled for decimal values.
- The Trim Mode field is used specify how white space should be removed from the text field. Start and End will remove this space from the beginning and the end of the field respectively. Both will remove the white space from both the beginning and the end. Any white space that does not fall at the beginning or end of the text field value will not be removed.
- This field will only be enabled for text field properties, such as account number or fee code.
- The Prefix and Postfix fields are used to add a prefix or a postfix value to the selected property upon import.
- Only string values can be appended with a prefix or postfix. The prefix or postfix value cannot exceed 10 characters.
- Set up optional property constants for the import file. These properties, and the constant specified for the property, will be included in every record in the import.
- Select a property in the Available Properties section and click the Add icon
drop-down menu and select Add Constant to add it to the Selected Constants section. - Once a property is added to the Selected Constants section, the Constant value must be specified before the configuration is saved.
- For example, when creating an AR-specific import file for the CR Cash Receipts process, you could select the SubSystem property and set the constant value to "AR" in order for that column to display on every included record.
4 Complete the Mapping tab.
7 Track any changes made to the import file configuration.
- Click the Audit Trail icon
to open the Audit Trail window.
- Use the Search Criteria section to sort the displayed audit history.
- The Audit Trail section will provide details about any changes made to an import file configuration record including the date of the change, type of change made, user that made the change, and data table that was edited.