FOXBOX DOCS Official documentation

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 “imp.sh” 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 “imp.sh” files.

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

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”

Choose:
“always Y (yes)”

apt-get install proftpd

when asked:
“1. da inetd 2. autonomo”

Choose:
“2 autonomo (standalone)”

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”

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

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

So launch:

crontab -e

And add this line:

10 18 * * * /imp.sh

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

Here you can download the required files. They are:

1. imp.sql, available here: imp_sql.zip
2. imp.sh, available here: imp_sh.zip