Data Import Layout

The Data Import Layout form creates the file needed to do a data import. The data import is created from the layout. See the attached file DataImportLayoutDoc.docx for specifics on using the layout document exported by this form.

The import file is saved as an XML file for the import back into myAvatar (through the Data Import form).

Import a form layout from an XML file.

• Use the Data Import form to import the formatted data file into myAvatar .

Prerequisites:

The form must not contain any of the following:

• Programmer overrides

• Workflow management functionality

• Caseload management functionality

• *Client picture object

• *Binary storage tables (signatures, pictures)

*RADplus 2018 Update 95 adds support for importing images via Data Import, for Signature or Picture (JPG) field types defined in Table Definition.

• Avatar supports images in either jpg or png formats (other formats, such as gif and bmp, are not currently supported)

• To import, the image data must be encoded in base64 format. 

• The image data should be placed inside tags, within the tag for the table element.

  • For example, if a modeled table has a signature field with the field name signature_1, the import file would contain the following:    

    ivb/9j/VAA...(the rest of the image data would be here)

Please note that if the form has a Multi Iteration Table, Excel can not be used as data import tool.  

1. Go to: RADplus Utilities > Database Management

2. Select the Data Import Layout form.
   The Select myAvatar Form screen displays.

3. In the {{AVSolutionSuite}} Form Name/ID field, enter the form ID, click Ok.

4. Select Download Data Import Layout.
   A Save dialog displays. Navigate to the location to store the file, click Save.