> For the complete documentation index, see [llms.txt](https://manual.unosofbooks.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://manual.unosofbooks.com/integrations-api/accounting-migration-files/venture.md).

# 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 %}