User Tools

Site Tools


Address book auto import

In this guide we will explain how to automatically import address book.
The system will automatically import every day the “AD_Collect.csv” file.

“imp.sql” and “” files needs to be places inside system root path.

:!: If you need to change the “AD_Collect.csv” file name, remember to change also the reference names inside “imp.sql” and “” files.

:id1: The “imp.sql” file separator has already been set to the value: “;

#1: Instructions

1) SQLite install

apt-get install sqlite

when it prompts:
After this operation, 4186 kB of additional disk space will be used. Do you want to continue [Y/n]? Y

always Y (yes)

2) ProFTPD install

apt-get install proftpd

when asked:
1. da inetd 2. autonomo

2 autonomo (standalone)

3) Add a FTP user to foxboxftp

root@foxbox:/# useradd foxboxftp
root@foxbox:/# passwd foxboxftp

when it prompts:
Enter new UNIX password:

Prompt a new password. Retype the new password when requested. If your password is successfully created, you will read:
passwd: password updated successfully

4) Create home for the foxboxftp user

root@foxbox:/# mkdir -p /home/foxboxftp
grant privileges 
root@foxbox:/# chmod -R 0777 /home/foxboxftp

5) Put the 2 files attached in "/" folder of foxbox

grant privileges
chmod -R 0777 imp.*
schedule command / in your crontab for example each day 18:10

6) Crontab launch

So launch:

crontab -e

And add this line:

10 18 * * * /

7) Upload "AD_Collect.csv"

Use FTP to upload a file with name “AD_Collect.csv” into “/home/foxboxftp” folder.

#2: Downloads

Here you can download the required files. They are:

  1. imp.sql, available here:
  2., available here:
address_book_auto_import.txt · Last modified: 2016/06/14 18:35 (external edit)