For users of the PRO Version
(and during 15 days free), it is possible to access to the automatic import FTPs / 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 :
Login to your account via secure FTP
To log in, use this login and password :
You must subscribe to PRO Version
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.
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:email@example.com/" "put clients.csv" "exit"