Page 1 of 1

Auto Import

Posted: Mon May 25, 2015 10:00 am
by vijaya
Hi All,

I have imported CSV file successfully using "import" under Recipient.

Now I have to use Auto import ,But "check connection" always fails . Path of CSV files is in local system (Windows 7).
Please let me known , what should be the details of "File Server".

Re: Auto Import

Posted: Tue May 26, 2015 9:30 am
by maschoff
Check connection tries to initiate a SFTP connection with the remote server via port 22. If the remote server is localhost, make sure to open port 22 in your firewall. You may also define a different port number in your server connection string.

Re: Auto Import

Posted: Wed Jun 17, 2015 5:29 am
by vijaya
The port 22 is unblocked . But even though it displays Connection failed error

File server = Username:Password@domain
File path =<Path of the CSV file>.

I am referring the" User Manual 1.0" document.

Re: Auto Import

Posted: Fri Jun 19, 2015 12:50 pm
by aso
The normal Import allows you to use a local file to upload and import.
Auto-Import tries to use files from a SFTP- or FTP-server, because no user is connected with his local system to the OpenEMM when the auto-import is executed.
Do you have a SFTP- or FTP-server running on your local system?
If so, you might use the following syntax for "fileserver":
sftp://username:password@sftp-server-host
or
ftp://username:password@ftp-server-host
The default when used without a protocol prefix is sftp://

Re: Auto Import

Posted: Thu Jul 02, 2015 12:34 pm
by vijaya
Thanks for the reply.

I have install ftp file server in the same system , where I am running openemm.ON stopping the iptables service (firewall), I can observe the ftp files in the browser by using the link "ftp://<ip_address>" , it display the list of the files .If I use the same(ftp://user_name:pwd@ip_address) in the Openemm tool again it displays connection fail.

With the iptables enabled , I can not see any files in brower "ftp://<ip_address>".

Please any suggestion regarding the ftp connection is appreciated.