Automatically import your data by FTPs or SFTP!
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 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
(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:firstname.lastname@example.org/" "put clients.csv" "exit"