For documents of type Text or Microsoft Excel, you can initialize the fields for a record. To initialize record fields for:

  • A Text document, use a connector of type Azure file storage and an input file of type TXT. The fields are initialized based on the header-line setup in the TXT file.
  • A Microsoft Excel document, use a connector of type Azure file storage and an input file of type XLSX. The fields are initialized based on the header-line setup in the XLSX file.

When the initialization is finished, review and complete the properties of the initialized fields. Usually, during review, you do not add fields. However, you can remove the not needed fields.


Standard procedure

1. Click Connectivity studio Integration Design.
2. Click the Documents tab.
3. In the list, find and select the desired document of type Text or Microsoft Excel.
4. Click Edit.
5. In the Records section, in the Record list, find and select the desired record.
6. Click Initialize.
7. To initialize, you can only use a connector of type Azure file storage.
By default, the default Azure file storage connector that is defined for the project, is selected.
You can select another Azure file storage connector.
  On the dialog, in the Connector field, enter or select a value.
8. Select the input file for the initialization.
If the document type is:
- Text, select a file of type TXT.
- Microsoft Excel, select a file of type XLSX.
  In the File name field, enter or select a value.
9. Click OK.
10. Close the page.

Provide feedback