You can get data from XML, JSON and simple text files, or you can query from an SQL database (only MySQL is supported currently).
Direct read of Excel files is not supported, please export it first to XML or text.

You can simply drag and drop an XML or JSON into your compound.
You'll get the data in the form of a Collection value in Aximmetry. Please watch this video on the Collection data type:

https://youtu.be/XbQcChdIEOo?t=213

(the video uses a JSON file, but XML is handled exactly the same way).

---------------------------------------------------------

To use SQL you have to add an SQL Database module and one or more SQL Query modules:

For the database specify the URL user/password and schema name:

For each Query module specify an SQL query:

You can repeat the query anytime with the Query trigger, or you can setup a repeating Automatic Query using an arbitrary Interval.

The output is a Collection value containing a subcollection for each returned row.
You can select the rows for e.g. with a Subcollection module using the name Row and a row index starting from zero:

To read a simple text file add a Text File module (or simply drag and drop a .txt file into your compound).
It will output the whole file (or its selected rows) as a Text value which can be processed with the several text processing modules.

For e.g. if the file contains a comma-separated list of items you can retrieve one or more items by using the Text Slice module.
You set comma as the Separator and specify a Start Index as the index of the element you need:

Also you can split the text into lines by using the Line Separ property.
For e.g. if you are interested in the second line:

Suppose you want to retrieve a number which is the third element of the second row, you can reach it by combining the two above:

In the next release there will be a module for listing the files in a folder.

Until then you can use a separate text file that lists all the text file names.

thats agood news but what about xlsx files supporting do you have plans for supporting these files?
its common to use excel files to generate several type of charts for example Pie Chart

Currently we do not have plans for that, maybe in the future.

Hi,

I'm not able to find the "SQL Database" module nor any "SQL *" module.

Maybe it's because I'm using the community edition ?

Thanks

Hi,
Yes, it's only available from the Professional Edition.