You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

The following file formats are supported for manual import in BellaDati:

  • CSV (plain text files)
  • Microsoft Excel (XLS, XLSX) - Office 2003 - 2016 (previous versions not guaranteed)
  • XML files
  • ZIP files (containing one or more supported file formats above)

To import file:

  • Go to the Data Set page
  • Select Import data
  • Choose Data file in Inport type
  • Select appropriate Data file format

After selecting the data file, you need to wait until the file is uploaded.

 

 

Please note, that default maximum file size to import is 20MB. BellaDati Unlimited or BellaDati On-Premise may have different file size limits. You can compress the file size when importing it in a ZIP archive (see below).

Importing from CSV

When you are importing from CSV, please continue directly to Import settings page.

Importing from Microsoft Excel

After uploading XLS/XLSX file you will be prompted to select the desired spreadsheet list.

List selection will not appear when your Excel spreadsheet contains only single list.

 

Importing from XML

In the XML importing guide, you will be prompted to select the row tag, which represents repeatable data sentence. The following example illustrates it on XML file containing employees:

<employees>
	<employee>
		<name>Jan</name>
		<surname>Novak</surname>
	</employee>
	<employee>
		<name>Petr</name>
		<surname>Novak</surname>
	</employee>
        ...
</employees>

In this case, the row tag is <employee>.

 

 

  1. Row tag: Select repeating tag in XML structure. Check extracted content in the preview on the left.
  2. Optionally, you can add custom columns repeatedly: Select items and/or attributes when XML structure is not straightforward.

You can use the xPath syntax for the custom columns definition. For more info proceed to tutorial with example, how custom columns can be set.

 

Importing from ZIP

Importing data compressed as ZIP archive represents a effective way how to reduce imported file size and also upload times significantly. It can contain the following file formats:

  • Plain text (CSV)
  • Microsoft Excel (XLS, XLSX)
  • XML

Please follow corresponding chapters above to continue importing Microsoft Excel or XML file formats.

New data set will not be created until the import process will have been successfully completed.

Next Steps

  • No labels