Ajuda online
Automatic import »

How to import your data automatically?

Translate this page to BrazilianBrazilian ?
Carregando Carregando
For users of the Versão Profissional (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 :
How ftp and sftp works with My DSO Manager
Compatível com muitos softwares: SAP Sage Oracle...

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

To log in, use this login and password :
You must subscribe to Versão Profissional to get the access codes

Implemento :

  1. Use the same CSV files you used during manual import « Smart Upload »
  2. 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")
  3. Send theses files
  4. 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.
Filezilla preview to import 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"
← Voltar : Ajuda online » Várias perguntas