Import data files can be generated from OnBase Studio export, a third-party application, or manually. If you are using a file from a third-party application or are creating a file manually, specific syntax in expected. The export file must consist of a base node named <export>.This <export> node must contain at least one parent tag that denotes the beginning of a list of objects (example: <Departments>). This parent tag must consist of at least one child object with the chosen attributes as attributes of that node (example: <Department>). The following is an example of a valid import file:
<?xml version="1.0" encoding="utf-8"?><export><Department><Department Name="Technical Support" Manager="William Taft" Date="3/29/2012 12:00:00 AM" /><Department Name="Human Resources" Manager="Sarah Adams" Date="3/29/2012 12:00:00 AM" /><Department Name="Finance" Manager="Jane Harper" Date="4/17/2014 12:00:00 AM" /><Department Name="Development" Manager="John Adams" Date="2/11/2013 5:00:00 AM" /></Department></export>
All attribute names in your file should match to an attribute in the class you are importing into. Each row within a key value column must have data in it.
XML files that format attributes as child nodes of object nodes are also supported. The following is an example:
<?xml version="1.0" encoding="utf-8"?>
<export>
<Department>
<Department>
<Name>Technical Support</Name>
<Manager>William Taft</Manager>
<Date>3/29/2012 12:00:00 AM</Date>
</Department>
<Department>
<Name>Human Resources</Name>
<Manager>Sarah Adams</Manager>
<Date>3/29/2012 12:00:00 AM</Date> />
</Department>
<Department>
<Name>Finance</Name>
<Manager>Jane Harper</Manager>
<Date>4/17/2014 12:00:00 AM</Date>
</Department>
<Department>
<Name>Development</Name>
<Manager>John Adams</Manager>
<Date>2/11/2013 5:00:00 AM</Date>
</Department>
</Department>
</export>