Load budgets files

Gobierto Budgets module implements a couple of Rake tasks to load CSV files with budgets data in Elastic Search.

Loading Gobierto format CSV data files

Log into the server where Gobierto is hosted (you can use it even in your computer for the development environment) and call this rake task with the csv file path as the only argument:

rails gobierto_budgets:data:import_gobierto_budgets_data[csv_path]

The file may raise errors calling the task if the code contains non numerical chars. At the end returns a summary with the number of records updated.

Loading Sicalwin format data files

Log into the server where Gobierto is hosted (you can use it even in your computer for the development environment) and call this rake task with the csv file path as the only argument:

rails gobierto_budgets:data:import_gobierto_budgets_sicalwin[csv_path,organization_id,year]

Where:

csv_path is the absolute path to the CSV file
organization_id is value of the field configured in the site as organization ID (it's usually the INE code)
year is the year of the data in numeric format with four digits (YYYY, i.e 2021)

The file may raise errors calling the task if the code contains non numerical chars. At the end returns a summary with the number of records updated.

Loading CSV with custom categories hierarchy

For importing custom categories, because they are organization specific, you must indicate which is the site domain and the path to the CSV:

rails gobierto_budgets:custom_categories:import_gobierto_budgets_data[site_domain,csv_path]

This CSV is documented here