Opportunity to exchange data between informational systems is very important. Different systems can "understand" each other if they use the same data format. In the particular case "format" means the way structured information (from the database, for example) is represented as a text, that can be saved to a file or sent via internet.

The most common data formats are:
  • JSON - the most effective and comfortable way to represent structured information as a text,
  • XML - a little bit older, longer and more complicated format, but also suits very well,
  • CSV - represents data as a table. It's not very suitable for deep and complicated data structures, but it's comfortable to export and import to spreadsheet programs (like Excel). You can open a .csv file in your spreadsheet program or save a table in CSV format and export it to an informational system.


Data import and export in Arbometa

Arbometa's main idea is effective structuring of information, database, code etc. As information is structured, it's very simple to organize data import and export. There are many different opportunities to import data - you can do it regularly and automatically or manually, via internet or through files etc. As to export, you can decide what information you would like to share with whom.

You can use all common formats - JSON, XML and CSV. You can also export charts as a picture (JPEG or PNG formats).


How we made this example

  1. We've created a node "GDP, Gini, education" with 5 fields: country, year, GDP, Gini and spending on education. How to create a node.
  2. Added a preview of bubble chart type to the node.
  3. Added the year filter to the preview (filters explained).
  4. We had two files with data in CSV format. In one file there were GDP and Gini index per country and year. In the second - % of GDP spent on education per country and year.
  5. Created two imports - one for each data file.
  6. Automatically generated programming code.
  7. Imported data from the files.
  8. Made some minor modifications to the design.


Related topics

How to create a node
Bubble chart
Filters explained
About our software development approach



Year:



Data import example - GDP dependence from Gini index and education spending

Click here to get data in JSON format


Data export example - GDP dependence from Gini index and education spending
We use cookies. Life without cookies would be terrible, that's why we use them. If you don't agree, you can have problems while visiting the site.