How do I prepare an import template?
A mapping template stores the correspondence between the columns of your file and the ERP fields. You prepare it once and reuse it every time a file with the same format arrives. It is also what a scheduled import needs to work by itself.
What exactly is a template?
A mapping template is a list of assignments: for each field of the target, which column of the file (or which calculation) fills it in. Nothing more. It doesn’t store the file or the data.
Each template belongs to a single target. A Customers template is no use for Items: when you choose another target, the fields change.
Templates are shared between all the companies in the same programme. If you prepare the template ‘Head office customers’ in one company, you also see it from the others.
How do I save a new template?
- Go to Management › Data import.
- In Target, choose the import type.
- In Data source, load a sample file with the same columns the following ones will have. Without a file loaded, the columns drop-down is empty.
- In Mapping, assign each field to its column or write its expression.
- In the Save mapping as template box, type a name and click Save.
The template is left selected in the Template drop-down. From then on, choosing it puts that mapping back exactly as it was, and if the template belongs to another target the wizard also changes the target.
To remove it, select it and click Delete template.
What are the predefined templates?
When the wizard is opened for the first time, the programme seeds a set of factory templates for the formats of other common business management programmes. They appear in the drop-down with the suffix (predefined).
Today they come ready for:
- FacturaPlus: items and customers.
- FactuSOL: items.
- Sage 50: customers.
- Powergest: customers, suppliers, sales agents, items and web catalogue.
The predefined ones can’t be deleted or overwritten: the Delete template button doesn’t appear when one is selected. The column names they bring are the usual ones for each programme, but each installation exports with small variations. If your file uses another name, load the predefined template, correct the assignments that fail and save it with a name of your own: that way you have yours without touching the factory one.
When do I need an expression rather than just choosing the column?
The Column drop-down covers the normal case: one field, one column. The Expression column is for everything else, and it is always available even if you have chosen a column in the drop-down (choosing a column writes the expression [NombreDeLaColumna] for you).
Typical cases:
- Joining columns:
[Nombre] + " " + [Apellidos]. - Taking the VAT off a price:
[TotalConIva] / (1 + [Iva]/100). - Fixed value for all rows:
"ES"in the Pais field. - Filling in what is missing:
[Nombre] ?? [RazonSocial]. - Deciding according to the data:
[Saldo] > 0 ? "Cobro" : "Pago".
The check is immediate: if the expression mentions a column that isn’t in the loaded file, the box turns red with the name that doesn’t belong. With the box in red, the import stops before writing anything.
The full syntax —functions, conditions, dates, texts— is in the expressions manual.
How do I control the date and decimal format?
In general you don’t need to: the programme recognises dates by itself in the usual Spanish and international formats (31/12/2026, 2026-12-31, 20261231) and decides the decimal separator by looking at which is the last sign in the figure, so it understands both 1.234,56 and 1,234.56.
When the file is ambiguous —figures like 1,234, which can be one thousand two hundred and thirty-four or one point two three four— you have to tell it. Date and number fields accept a format pattern that is saved together with the assignment in the template.
Cells that Excel already stores as a date or a number are taken as they are, without interpreting text: that is the safest route when the source is a spreadsheet.
A detail that saves trouble with codes: the direct assignment [Columna] keeps the original value, so a code like 0001 isn’t turned into 1.
See also: Import customers from an Excel file · Schedule a recurring import · Expressions manual