upCampo x Solinftec Integration

What is it?

The integration between upCampo and Solinftec uses the data generated by the machines (via Solinftec) to automatically feed the work orders inside the upCampo platform.

Solinftec is a solution focused mainly on monitoring farm machinery, providing accurate, automated data on the activities carried out in the field. However, its view of the farm operation as a whole is more superficial.

upCampo, on the other hand, specializes in complete management of the farm operation, including activities, crews, products and cost control. That is why the integration is essential: it lets the hectares worked and the machines used be entered automatically in the work orders, making control easier and the information more reliable.

First steps of the integration

1. ID mapping (De/Para)

You need to map the identifiers (IDs) between the platforms — a process known as "de/para" (from/to) — so that the synced data is correctly interpreted and assigned inside upCampo.

2. Fleet

In upCampo:

Go to Fleet > Fleet / Facility. In each machine's record there is a field called ID Fab, where you enter the matching Solinftec identifier.

In Solinftec:

The mapping is done based on the Cadastro > Grupo de Equipamentos > Equipamentos menu.

3. Fields

In upCampo:

Go to Crops > Field. Each field has a tab called "Integrations", where you enter the ID of the matching field in Solinftec.

In Solinftec:

The exact location may vary; it is usually under Cadastro > Talhões or in menus related to the area structure.

→ You need to check with Solinftec support, because the customer often has no direct access to that screen — Solinftec's own team usually does this area mapping.

4. Operations

In upCampo:

a) Go to Operations > Operations to register and configure the operation types to be integrated. Specific field: Code.

b) In the activity type record there is a tab called "Operations" — you need to link the matching operation in that tab.

In Solinftec:

The mapping is done based on the Cadastro > Operação > Operação menu.

5. Employees

In upCampo:

Go to Operations > Employee/Operator to register and configure. Specific field: Integration ID.

In Solinftec:

The mapping is done based on the Cadastro > Funcionários > Funcionários menu.

6. Team

In upCampo:

Go to Operations > Team to register and configure. Specific field: Integration ID.

In Solinftec:

The mapping is done based on the Cadastro > Equipe menu.

✅ Integration summary

Item	upCampo	Solinftec
Fleet	Fleet > Fleet / Facility (ID Fab)	Cadastro > Grupo de Equipamentos > Equipamentos
Fields	Crops > Field > Integrations tab	Cadastro > Talhões (confirm with Solinftec support)
Operations	Operations > Operations (Code) + Activity Type > Operations tab	Cadastro > Operação > Operação
Employees	Operations > Employee/Operator (Integration ID)	Cadastro > Funcionários > Funcionários
Team	Operations > Team (Integration ID)	Cadastro > Equipe

🔧 Technical side of the integration

The integration between upCampo and Solinftec runs automatically through a service that runs continuously on the server.

1. Authentication

To consume Solinftec data, you need an Access Token and a Password, which Solinftec itself provides to the customer.

2. Node.js service: servicoSolinftec

In the upCampo environment there is a Node.js service called servicoSolinftec, responsible for running the whole process of collecting and preparing the data for the integration.

This service runs the following steps:

Access Token generation

Method: geraTokenSolinfitec
Uses the stored credentials to obtain a valid access token for the Solinftec API.

Solinftec API call

The service calls the API with a date filter:
Start date: 00:00 of the current day
End date: 23:59 of the same day

Inserting the data into the HISSOL table

The data received is processed and turned into INSERT commands for the HISSOL table (Request History).
The insert is done right after processing.

3. Processing via procedure: INTEGRACAO_SOLINFTEC

In parallel, there is a backend process (scheduled to run every X minutes) that checks and processes the data just inserted into the HISSOL table.

Details:

Procedure run: [INTEGRACAO_SOLINFTEC]
What the procedure does:
- Selects the HISSOL records
- Looks up the ID mappings already registered in the following tables:
  - Equipment
  - Operations
  - Employees
  - Team
  - Fields
- Identifies the work order that matches the data coming from Solinftec
- On success, records the information in the work order
- On failure (e.g.: missing mapping or inconsistent data), records the error in the PROINT table (Integration Problems)

🧩 Technical flow summary

[servicoSolinftec - Node.js] ↓ geraTokenSolinfitec ↓ API call (00:00 - 23:59 of the day) ↓ Data inserted into the HISSOL table [Scheduled job] ↓ Runs the INTEGRACAO_SOLINFTEC procedure ↓ Validates the mappings ↓ Updates Work Orders (or) ↓ Records failures in the PROINT table

✅ Integration validation steps

After configuring all the mappings (de/para) and making the technical adjustments on the server, you need to validate that the integration is working correctly.

Follow the steps below to check it:

1. Run the service manually

Run the servicoSolinftec service manually (from the terminal or via PM2).
The service will generate the token, query the day's data and insert the records into the HISSOL table.

2. Check the HISSOL table

Go to the database and check that the records were correctly inserted into the HISSOL table (Request History).
The data should contain information such as: date, equipment, operation, area worked, etc.

3. Wait for automatic processing

Wait for the automatic job to run the INTEGRACAO_SOLINFTEC procedure.
This may take a few minutes, depending on the configured frequency.

4. Check the PROINT table

If there are mapping failures or errors in the data received, they are recorded in the PROINT table (Integration Problems).
Check whether there are records in that table.
If there are, fix the missing mappings (Equipment, Field, Team, etc.).
After the fix, the system can reprocess automatically or when the service runs again.

5. Confirm in upCampo

Go to the Operations > Work Order menu in the upCampo platform.
Confirm that the data coming from Solinftec was correctly inserted and linked to the work orders:
- Machines used
- Area worked
- Crew involved
- Operation type

📝 Note: an implementation checklist is available in another article.

❓ Frequently asked questions

What is the upCampo–Solinftec integration for?

To use the data generated by the machines, captured by Solinftec, to automatically feed upCampo's work orders. That way the hectares worked and the machines used are entered without typing, which makes the information more reliable.

Why integrate instead of using just one of the systems?

Because they cover different layers: Solinftec focuses on monitoring farm machinery, with accurate, automated field data; upCampo specializes in complete management of the operation — activities, crews, products and costs.

What is the de/para (from/to) mapping?

It is the correspondence between the identifiers of the two platforms. Without this "de/para" configured, the synced data is not correctly interpreted or assigned inside upCampo. The mapping covers fleet, fields, operations, employees and teams.