> 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

These integrations methods pass authorized SRI invoice Invoices, SRI Annulments, Deposits and Credit Notes. However, for Colombian farms, we overrule the authorized status of the invoices.

## 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FyTw1hGrJGpaQRaSfJSys%2FScreenshot%202023-02-21%20at%2021.08.59.png?alt=media&amp;token=fff55811-c93a-4f93-99ac-d60dfd614379" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FRwbPbYVIrUaUGbxNqnO3%2FScreenshot%202023-02-22%20at%2011.32.03.png?alt=media&amp;token=6cdbb21e-304c-4af8-8604-381e3a57da3d" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FfGmE5CkvCgecE0wNb1e3%2FScreenshot%202023-02-22%20at%2011.33.19.png?alt=media&amp;token=a05c6b36-2753-46d0-938f-2d104cbfe7cb" alt=""><figcaption><p>URL Credits Added APIKEY</p></figcaption></figure>

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

![](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FZLUr2A9shevKIxYM3AaM%2Fimage.png?alt=media\&token=a7ce6890-d11e-41d0-84af-38889f078710)

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FsvsFrs1lb2Fu6o2jTvGH%2FScreenshot%202023-02-22%20at%2010.10.38.png?alt=media&amp;token=1500a60e-928a-43f2-944f-fb0c5d3cc0e3" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FS7iY8jmwc9j1bitlmPhL%2FScreen%20Shot%202023-02-22%20at%2009.33.04.png?alt=media&amp;token=2cfe9d3e-c20f-4147-b859-83a5613ee170" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FaWymUgt1zZpOFFU6zswD%2FScreen%20Shot%202023-02-22%20at%2009.44.41.png?alt=media&amp;token=7dc0ec8c-04e6-40da-849d-9e75deef8fd1" alt=""><figcaption></figcaption></figure> <figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FeLILmXrvD0qR0pFrfxxk%2FScreen%20Shot%202023-02-22%20at%2009.44.50.png?alt=media&amp;token=9ac50509-be8b-43d1-bcbd-b2c9e030fc54" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FGuTe1i9rPmrqIPN1w2w8%2FScreenshot%202023-02-22%20at%2010.16.04.png?alt=media&amp;token=9e6324b6-6c50-480e-bd93-1a43364fc161" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FEoCHRyeFWz5TVYl4t9pV%2FScreenshot%202023-02-22%20at%2010.18.54.png?alt=media&amp;token=dd41b188-46f9-4d64-b20d-e190e513401e" 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>" %}

![](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FJ2ceczgwrL6OYdx7YJFN%2Fimage.png?alt=media\&token=ff068f20-0d74-4de2-8993-6bc839ad4d98)

{% 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FfvwQ2bYqxLGQmtVjmY1E%2FScreenshot%202023-02-22%20at%2010.19.40.png?alt=media&amp;token=02b72c7e-ad61-4eb1-83b0-6a678dde9dfa" 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="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FM8A4QBNumjyk6akfZMWG%2FScreenshot%202023-02-22%20at%2011.24.30.png?alt=media&amp;token=18ad83c7-0423-4e62-996b-c936d36fe693" 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 %}