# Venture

## Method 1 - Excel File (CSV File)

This method generate an excel file (CSV) with the columns provided by Venture.

{% hint style="warning" %}
This method currently does not support deposit migrations, if thats wished: that has to be asked to Venture to add/develop. That means, if this method is chosen, all deposits have to be applied manually 2x (in Unosof and in Venture). 
{% endhint %}

The nice thing about this method, is that it's easy to manage, at the end of the month (when the month is closed), it's possible to migrate a static result over and it gives a lot of control to avoid any differences between UNOSOF and Venture. \
Also this migration method is "light", a CSV file is a not a heavy migration file to generate. That keeps UNOSOF up and running smooth vs a web service (depends on how its configured ofourse) that calls all our data every hour. 

### Create Token

a) Generate an API key in admin

Go to ADMIN section on the system 

<https://yourfarmname.unosof.com/index.cfm?event=LocalSalesTax.Form>

<figure><img src="/files/of9mzwj4LJ2KpidIY0Kc" alt=""><figcaption><p>Generate and Save an API KEY</p></figcaption></figure>

b) Paste that api key to the end of the link with the following string: ***\&apikey***=439b5631-6e12-4464-b390-0044573c5abc

c) The venture files LINK are below for this method. The date should be entry in MM-DD-YYYY format.

### Venture Invoices CSV&#x20;

Invoices: <https://farm.unosof.com/index.cfm?event=Venture.MCH&dt_start=10-01-2020&dt_end=10-31-2020>

#### INVOICES:

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Venture.MCH&dt_start=10-01-2020&dt_end=10-31-2020&apikey=439b5631-6e12-4464-b390-0044573c5abc>" %}

<figure><img src="/files/F2xyFXU8v4u4eZch2zvh" alt=""><figcaption><p>URL added the APIKEY</p></figcaption></figure>

### Venture C/N & D/N CSV

Credits: <https://farm.unosof.com/index.cfm?event=Credits.JsonM&dt_start=10-01-2020&dt_end=10-31-2020>

d) The venture files run with the API key generated (or given by your Farm)

#### CREDITS:

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Credits.JsonM&dt_start=10-01-2020&dt_end=10-3&apikey=439b5631-6e12-4464-b390-0044573c5abc>" %}

<figure><img src="/files/Yv7OusPrrXmqO1YCIf3X" alt=""><figcaption><p>URL Credits Added APIKEY</p></figcaption></figure>

The excel (CSV file) are downloaded after ran the link

![](/files/BNK9N9ZPnnikKT7SZX2s)

Shows the Columns provided by Venture for this method, as a example show like this

<figure><img src="/files/9sC2rxWhBi9RE1nBw9vW" alt=""><figcaption><p>CSV file</p></figcaption></figure>

####

## Method 2 - JSON File  - Single Specie (Roses)

This method works online JSON file for pass in a webservice

### Venture Invoices JSON

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Venture.JSON&dt_start=01-27-2021&dt_end=01-27-2021&bo_show=1&apikey=6c040017-46a1-4ded-945d-fc591aeac83>" %}

{% hint style="info" %}
We recommend to generate this file in Firefox, for a straight clear JSON format view.&#x20;
{% endhint %}

<figure><img src="/files/ly6F9Meqm0cHFdalKvcz" alt=""><figcaption></figcaption></figure>

#### Venture Invoices CSV Zona

{% embed url="<https://farm.unosof.com/index.cfm?event=Venture.JSON&dt_start=10-27-2021&dt_end=10-27-2021&bo_show=1&apikey=6c040017-46a1-4ded-945d-fc591aeac830>" %}

Contents a separation and calculation by specie and farm:

<div><figure><img src="/files/Tp5WDbz8gEknMIea1ho1" alt=""><figcaption></figcaption></figure> <figure><img src="/files/G9MPXWzPypDMsvucnv3W" alt=""><figcaption></figcaption></figure></div>

Show a total of 116.00, and the composition is:

SPRAY ROSES FRESCAS CALIDAD EXPORTACION TALLOS 60CM

According to the SRI XML:

<figure><img src="/files/MbSAzul8F80JQ9Wt4kgF" alt=""><figcaption><p>XML By Specie / Lenght </p></figcaption></figure>

This same information is shown in the JSON migration link/file separated by spaces, lengths.&#x20;

{% hint style="info" %}
Some farms, with to see the results per farm. it's possible to add, but this does bring other complexities. dividing 0.01 cross 2 farms is 0.01 for both farms,... that 1 penny too much. To avoid that from happening, we'd like to work with more decimals, but still... rounding can cause problems.
{% endhint %}

### Venture Deposits JSON

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Deposits.JSON&dt_start=09-05-2016&dt_end=09-05-2016>" %}

<figure><img src="/files/0DajNcO10aNrux1Es1Iy" alt=""><figcaption></figcaption></figure>

&#x20;

## Method 3 - Excel file to Upload in Venture Directly

This method is used in Ecoroses

File is showed for download with this link

{% embed url="<https://ecoroses.unosof.com/index.cfm?Event=Venture.TXT&apikey=ce53c182-b70c-4a60-9638-7f5333458bd8&dt_end=02-15-2021&dt_start=02-01-2021>" %}

![](/files/Gv1aVhh9AbSEtOn9zLHV)

{% hint style="info" %}
Important: The Customer in UNOSOF should be have the Venture customer code for made the integration. This code shows in the first column CLIENTE
{% endhint %}

The file contents columns specified by venture to upload in the module called VENTAS FLOR or VENTAS GENERAL. Can be different and depend on the farm

<figure><img src="/files/RLRqcuAdVMbeXeqyotyW" alt=""><figcaption><p>File to Upload Directly to venture</p></figcaption></figure>

## METHOD 4 - TXT to Upload Directly

This Method visualice online the preview of the data, next you can download the file to a TXT File

{% hint style="info" %}
Important: The Customer in UNOSOF should be have the Venture customer code for made the integration. This code shows in the first column codigo\_cli
{% endhint %}

{% embed url="<https://farm.unosof.com/index.cfm?event=Venture.AGF&dt_start=12-31-2021&dt_end=12-31-2021&tx_apikey=7b08e68e-8832-474a-afbb-b3f93d7f8141&bo_debug=1>" %}

<figure><img src="/files/VVZjt9lMeVuoaZnT9IzU" alt=""><figcaption><p>Online Data View</p></figcaption></figure>

## ADDITIONAL LINKS to Migrate Specific Data

We have additional links to show and migrate Data as:

#### CARGO AGENCIES

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Cargo.JSON>" %}
JSON - Cargo Agencies link
{% endembed %}

#### AIRLINES

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Airline.JSON>" %}
JSON - Airlines Link
{% endembed %}

#### PLAN DE CUENTAS / Accounts

{% embed url="<https://yourfarm.unosof.com/index.cfm?event=Account.JSON>" %}
JSON - Accounts Link
{% endembed %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://manual.unosofbooks.com/integrations-api/accounting-migration-files/venture.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.