Auto Import

Use this forum to discuss usability issues of OpenEMM like difficult to use features and ideas for improvements.

Moderator: moderator

vijaya
Posts: 28
Joined: Wed May 13, 2015 9:04 am

Auto Import

Post 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".
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Auto Import

Post 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.
OpenEMM Maintainer
vijaya
Posts: 28
Joined: Wed May 13, 2015 9:04 am

Re: Auto Import

Post 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.
aso
Posts: 33
Joined: Fri Jun 19, 2015 12:43 pm

Re: Auto Import

Post 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://
vijaya
Posts: 28
Joined: Wed May 13, 2015 9:04 am

Re: Auto Import

Post 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.
Post Reply