自动导入您的数据 → with FTP (secure FTP)

在线帮助

Automatic import » How to import your data automatically?

Translate this page to

正在加载

To use this interface, create a script that will send every night (for example) your file of items, clients and contacts.

This program should send a CSV (file separated by semi-colon in the POST data) using credentials, url and syntax as below :

Login to your account via our API

To log in, use this login and password :

您须先登录以加载此网页

Example « Headers »

POST ...
...
Authorization: Basic xxxxxxxxxxxxxxxxxxx
...

数据导入选项

Use these options only if you need them :

Parameter	描述
encoding	文件格式 Possible values: UTF-8 (默认值), ISO-8859-1, ...
clear_items_not_modified	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. 默认值: false

Example « Headers » 和 « 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://www.mydsomanager.com/api/items

Use SSL to secure your connections

Columns syntax of the CSV file :

数列	描述
client_code *	公司代码
item_amount_initial	原金额不含税
item_amount_initial_inc_tax *	原金额含税 Example / Possible values: 1200 1 200,00 1200.00123 ...
item_amount_remaining	剩余金额不含税
item_amount_remaining_inc_tax	剩余金额含税
item_business_case	交易名称
item_currency	货币 Example: EUR, USD, ...
item_date_due *	到期日日期格式: YYYY-MM-DD
item_date_issue *	签发日期日期格式: YYYY-MM-DD
item_date_order	订单日期日期格式: YYYY-MM-DD
item_date_payment	付款日期日期格式: YYYY-MM-DD
item_erp_type	企业资源管理系统中单据类别
item_file_number	档案号
item_number *	单据号码
item_order_number	订单号
item_sales_administrative	销售主管
item_sales_manager	销售经理
item_sense_writing	借方或贷方
item_type *	单据类型 Possible values: FAC, AVO, RGL, ODI, TRT, DPA
item_unique_key	单据识别名

Example « Headers » 和 « Data »

POST /api/items HTTP/1.1
Host: www.mydsomanager.com
...
Authorization: Basic xxxxxxxxxxxxxxxxxxx
...

"item_type";"item_number";"client_code";"item_date_issue";"item_date_due";"item_amount_initial_inc_tax";"item_currency"
"FAC";"00000123";"C0001";"2019-12-07";"2019-12-14";"6 580,10";"USD"
...

必填数列 : 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://www.mydsomanager.com/api/clients

Use SSL to secure your connections

Columns syntax of the CSV file :

数列	描述
client_address_city	地址 (城市)
client_address_country	地址 (国家)
client_address_postbox	地址 (邮局信箱)
client_address_state	地址 (省份 / 地区)
client_address_street	地址 (街道)
client_address_street_number	地址 (n° 街道)
client_address_zip	地址 (邮政编码)
client_blocked	账户被锁 (是 / 否) Possible values: 0, 1 (默认值: 0 <=> 否)
client_blocked_date	账户被锁 / 日期日期格式: YYYY-MM-DD
client_business_line	市场
client_business_name *	公司 / 公司注册名
client_code *	公司代码
client_comments	备注
client_commercial_email	与客户关联的销售人员 / 邮件
client_commercial_fax	与客户关联的销售人员 / 传真
client_commercial_firstname	与客户关联的销售人员 / 名
client_commercial_lastname	与客户关联的销售人员 / 姓
client_commercial_phone	与客户关联的销售人员 / 电话
client_commercial_phone_cell	与客户关联的销售人员 / 手机号
client_credit_limit	风险 / 信用额度
client_email	邮件
client_fax	传真
client_group	集团 List of customer groups separated by commas
client_group_key	类别编号
client_guarantee_insurer	风险 / 担保方
client_guarantee_insurer_reference	风险 / 保险人资料
client_guarantee_score	风险 / 得分
client_guarantee_temporary	风险 / 临时担保
client_guarantee_temporary_date_end	风险 / 临时担保 / 结束日期
client_guarantee_temporary_date_start	风险 / 临时担保 / 开始日期
client_guarantee_type	风险 / 保证类型
client_guarantees_currency	风险 / 担保货币
client_id	公司注册号
client_order_backlog	订货清单
client_others_guarantees	风险 / 其他担保
client_payment_mean	付账方式
client_payment_term	付账期
client_phone	电话
client_phone_cell	手机号
client_siret	Siret (for French companies)
client_trading_name	品牌名
client_url	网站
client_vat	增值税税号

Example « Headers » 和 « Data »

POST /api/clients HTTP/1.1
Host: www.mydsomanager.com
...
Authorization: Basic xxxxxxxxxxxxxxxxxxx
...

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

必填数列 : client_code + client_business_name

Add contacts to your customers

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

Use SSL to secure your connections

Columns syntax of the CSV file :

数列	描述
client_code *	公司代码
contact_collection	催款联系人 (是 / 否) Possible values: 0, 1 (默认值: 0 <=> 否)
contact_comments	备注
contact_email	邮件
contact_fax	传真
contact_firstname	名
contact_lastname *	姓
contact_phone	电话
contact_phone_cell	手机号
contact_role	角色 Possible values: accounting : 会计员 buyer : 购买方 company : 公司 manager : 领导人 other : 其他 (默认值)
contact_title	头衔 (先生，女士...)

Example « Headers » 和 « Data »

POST /api/contacts HTTP/1.1
Host: www.mydsomanager.com
...
Authorization: Basic xxxxxxxxxxxxxxxxxxx
...

"contact_firstname";"contact_lastname";"contact_email";"contact_role";"client_code"
"Mike";"Jackson";"test@test.com";"other";"C0001"
...

必填数列 : client_code + contact_lastname

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 :

字段	描述
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
nb_client_added	个客户已被添加
nb_client_modified	个客户已被修改
nb_contact_added	个联系方式已被添加
nb_item_added	个单据已被添加
nb_item_modified	个单据已被修改

Example « Response »

{
	"success": "true",
	"error_code": "",
	"error_description": "",
	"nb_client_added": 0,
	"nb_client_modified": 0,
	"nb_contact_added": 0,
	"nb_item_added": 5,
	"nb_item_modified": 2
}

For users of the 专业版 (and during 15 days free), it is possible to access to the automatic import FTP / SFTP interfaces of MY DSO MANAGER to automate the upload of your data.

To use this interface, create a script that will send every night (for example) your file of items, clients and contacts.

This program should send a CSV (file separated by semi-colon in the POST data) using credentials, url and syntax as below :

How ftp and sftp works with My DSO Manager

与众多软件兼容:

...

Login to your account via secure FTP

To log in, use this login and password :

You must subscribe to 专业版 to get the access codes

建立 :

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
(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.