Online help

Neem contact met ons op als u vragen hebt

Automatic import »
How to import your data automatically?

Translate this page to

Bezig met laden...

To benefit from this interface, use a script that will send every night (for example), or several times a day, your open items, customers, users (optional) and contacts (optional) files to our server.

This program must send CSV or TXT files (semicolon separated file in the POST data) using the identifiers, addresses and syntaxes below:

Login to your account via our API

To log in, use this login and password:

Address / URL:

https://account.mydsomanager.com/api/

You must be logged in to view this information

Example « Headers »

POST ...
...
Authorization: You must be logged in to view this information
...

Importopties

Use these options only if you need them:

Parameter	API	Beschrijving
encoding	all	Bestandsformaat Possible values: UTF-8 (standaard), ISO-8859-1, ...
clear_items_not_modified	items	Clear automatically items? Possible values: true:« STOCK » mode → I import systematically all open items (invoices, credit notes, various operations ... not yet paid and cleared). In this case, if an item is present in an import day 'D' but not anymore in the next one at 'D 1', MY DSO MANAGER will clear it automatically. false:« DELTA » mode → I prefer to make partial imports (not necessarily all open items) and I indicate to MY DSO MANAGER the items which are paid and cleared either by clearing them manually in the statement of account in the customer sheet, or by making imports of items cleared with the field 'Payment date' filled with the date of the clearance of the items. Standaard: false
replace_users_association	users	Replace clients/users associations of add only new clients/users associations? Possible values: 0 of 1 Standaard: 0

Example « Headers » en « Data »

POST /api/items?encoding=UTF-8&clear_items_not_modified=true HTTP/1.1
...

data...

Add and modify your items (invoices, credit notes, ...)

Address / URL: https://account.mydsomanager.com/api/items

Use SSL to secure your connections

Columns syntax of the CSV file:

Kolommen	Beschrijving
client_code *	Bedrijfscode
item_amount_initial	Initiel bedrag ex. BTW
item_amount_initial_inc_tax *	Initiel bedrag incl. BTW Example / Possible values: 1200 1 200,00 1200.00123 ...
item_amount_remaining	Restant bedrag ex. BTW
item_amount_remaining_inc_tax	Restant bedrag incl. BTW
item_business_case	Betreft
item_currency	Valuta Example: EUR, USD, ...
item_date_due *	Vervaldatum Datum formaat: YYYY-MM-DD
item_date_issue *	Uitgiftedatum Datum formaat: YYYY-MM-DD
item_date_order	Datum opdracht Datum formaat: YYYY-MM-DD
item_date_payment	Betaaldatum Datum formaat: YYYY-MM-DD
item_erp_type	ERP-artikeltype
item_file_number	File nr
item_number *	Boeking nr.
item_order_number	PO nr
item_sales_administrative	Verkoopmedewerker
item_sales_manager	Verkoopmanager
item_type *	Artikel type Possible values: AVO, DPA, FAC, ODI, RGL, TRT
item_unique_key	Uniek artikelnummer

Example « Headers » en « Data »

POST /api/items HTTP/1.1
Host: account.mydsomanager.com
...
Authorization: You must be logged in to view this information
...

"item_type";"item_number";"client_code";"item_date_issue";"item_date_issue";"item_amount_initial_inc_tax";"item_currency"
"FAC";"00000123";"C0001";"2025-12-05";"2025-12-12";"6 580,10";"USD"
...

Verplichte kolommen : client_code + item_type + item_number + item_date_issue + item_date_due + item_amount_initial_inc_tax

Add and modify your customers data

Address / URL: https://account.mydsomanager.com/api/clients

Use SSL to secure your connections

Columns syntax of the CSV file:

Kolommen	Beschrijving
client_address_city	Adres (Plaats)
client_address_country	Adres (Land)
client_address_postbox	Adres (Postbus)
client_address_state	Adres (Staat / Provincie)
client_address_street	Adres (Straat)
client_address_street_line2	Adres (Straat Lijn 2)
client_address_street_line3	Adres (Straat Lijn 3)
client_address_street_number	Adres (n° Straat)
client_address_zip	Adres (Postcode)
client_blocked	Account geblokkeerd (Ja / Nee) Possible values: 0, 1 (standaard: 0 <=> Nee)
client_blocked_date	Account geblokkeerd / Datum Datum formaat: YYYY-MM-DD
client_business_line	Markt
client_business_name *	Bedrijfsnaam
client_code *	Bedrijfscode
client_comments	Opmerkingen
client_commercial_email	Verkoopmedewerker / E-mail
client_commercial_fax	Verkoopmedewerker / Fax
client_commercial_firstname	Verkoopmedewerker / Voornaam
client_commercial_lastname	Verkoopmedewerker / Achternaam
client_commercial_matricule	Verkoopmedewerker / ID-nummer
client_commercial_phone	Verkoopmedewerker / Telefoon
client_commercial_phone_cell	Verkoopmedewerker / Mobiele telefoon
client_credit_limit	Risico / Kredietlimiet
client_email	E-mail
client_fax	Fax
client_group	Groepen List of customer groups separated by commas
client_guarantee_insurer	Risico / Garantie van de verzekeraar
client_guarantee_insurer_reference	Risico / Referentie verzekeraar
client_guarantee_score	Risico / Score
client_guarantee_temporary	Risico / Tijdelijke garantie
client_guarantee_temporary_date_end	Risico / Tijdelijke garantie / Einddatum
client_guarantee_temporary_date_start	Risico / Tijdelijke garantie / Startdatum
client_guarantee_type	Risico / Type garantie
client_guarantees_currency	Risico / Valuta van garanties
client_id	Wettelijk identificatienummer
client_order_backlog	Orderportefeuille
client_others_guarantees	Risico / Andere garanties
client_payment_mean	Betalingsmiddel
client_payment_term	Betalingstermijn
client_phone	Telefoon
client_phone_cell	Mobiele telefoon
client_siret	Siret (for French companies)
client_trading_name	Handelsnaam
client_unique_key	Uniek klantnummer
client_url	Website
client_vat	BTW-nummer

Example « Headers » en « Data »

POST /api/clients HTTP/1.1
Host: account.mydsomanager.com
...
Authorization: You must be logged in to view this information
...

"client_business_name";"client_code";"client_id";"client_address_country"
"My company";"C0001";"FR12345678";"France"
...

Verplichte kolommen : client_code + client_business_name

Add contacts to your customers

Address / URL: https://account.mydsomanager.com/api/contacts

Use SSL to secure your connections

Columns syntax of the CSV file:

Kolommen	Beschrijving
client_code *	Bedrijfscode
contact_collection	Contactpersoon voor incasso (Ja / Nee) Possible values: 0, 1 (standaard: 0 <=> Nee)
contact_comments	Opmerkingen
contact_email	E-mail
contact_email_copy_collection_auto	E-mail in kopie in de automatische e-mails (Ja / Nee) Possible values: 0, 1 (standaard: 0 <=> Nee)
contact_fax	Fax
contact_firstname	Voornaam
contact_lastname *	Achternaam
contact_phone	Telefoon
contact_phone_cell	Mobiele telefoon
contact_role	Functie Possible values: accounting: Accountant buyer: Inkoper company: Bedrijf manager: Leidinggevende other: Andere (standaard)
contact_title	Titel (Dhr, mevrouw ...)
contact_unique_key	Uniek contactpersoonnummer

Example « Headers » en « Data »

POST /api/contacts HTTP/1.1
Host: account.mydsomanager.com
...
Authorization: You must be logged in to view this information
...

"contact_firstname";"contact_lastname";"contact_role";"client_code"
"Mike";"Jackson";"other";"C0001"
...

Verplichte kolommen : client_code + contact_lastname

Associate users with your customers

Address / URL: https://account.mydsomanager.com/api/users

Use SSL to secure your connections

Columns syntax of the CSV file:

Kolommen	Beschrijving
client_code *	Bedrijfscode
user_email	E-mail
user_firstname	Voornaam
user_lastname *	Achternaam
user_matricule	ID-nummer

Example « Headers » en « Data »

POST /api/users HTTP/1.1
Host: account.mydsomanager.com
...
Authorization: You must be logged in to view this information
...

"user_firstname";"user_lastname";"client_code"
"John";"Roy";"C0001"
...

Verplichte kolommen : client_code + user_lastname

If you want, you can use the path "/apiPutFiles/" to import the files asynchronously.

Return data

After performing the POST of these data MY DSO MANAGER will process immediately and will respond if there was an error or how much data has been added and updated.

This response will be in JSON format and returns the following information:

Veld	Beschrijving
success	Indicates if the import was done successfully Possible values: true, false
error_code	Error code (if there was an error) Possible values: ACCESS_DENIED, CSV_EMPTY, CSV_BAD_SYNTAX, ...
error_description	Error message (if there was an error)
exception_lines	Lines ignored (not defined if no lines ignored)
nb_client_added	Klanten toegevoegd
nb_client_modified	Klanten bijgewerkt
nb_contact_added	Contactpersonen toegevoegd
nb_item_added	Artikelen toegevoegd
nb_item_modified	Artikelen bijgewerkt
nb_user_added	Gebruikers toegevoegd
nb_user_modified	Gebruikers bijgewerkt

Example « Response »

{
	"success": "true",
	"nb_client_added": 0,
	"nb_client_modified": 0,
	"nb_contact_added": 0,
	"nb_item_added": 5,
	"nb_item_modified": 2,
	"nb_user_added": 0,
	"nb_user_modified": 0,
	"exception_lines": {
		"line 3": "Column count doesn't match (defined=8, found=10)",
	},
}

Automatically import your data by FTPs or SFTP!

This program must send CSV or TXT files (semicolon separated file in the POST data) using the identifiers, addresses and syntaxes below:

How FTPs and SFTP works with My DSO Manager

Compatibel met een breed scala aan software: SAP

...

Login to your account via secure FTP of contact us to use SFTP

To log in, use this login and password:

Setup:

Use the same CSV files you used during manual import « Smart Upload »
Name them so that MY DSO MANAGER knows what type of file is sent
(clients files must begin with "clients", items files by "items" and contacts files with "contacts")
Send theses files
The data are instantly processed and updated in your account. The file you sent is replaced with a report file that tells you if everything went well and how many changes have been done.

Overview using FileZilla software to transfer your files:

This overview shows a manual import but you shall make it automatically by creating a script that sends CSV files.

How to automate transfer via secure FTP:

Send with curl (Windows, Linux):

curl -u login:password ftp://ftp.mydsomanager.com:21 --ftp-ssl --ftp-pasv -T clients.csv

Send with LFTP (Linux, Windows via cygwin):

lftp -e "set ftp:prefer-epsv no; put clients.csv; quit" -u login,password ftp.mydsomanager.com

Send with WinSCP (Windows):

winscp.com /ini=nul /command "open ftpes://login:password@ftp.mydsomanager.com/" "put clients.csv" "exit"

With our connectors, you can import your customer data and accounts receivable data (open invoices, credit notes, ...) in a simple and automated way!

To do this, select below your ERP / CRM software and follow the instructions to synchronize your data with My DSO Manager at the frequency you want (daily, weekly, or manually).