FOXBOX DOCS Official documentation

This article illustrates the procedure to publish on a website the contents that you received via MMS channel. Before starting, please check if your SIM card has been activated to manage MMS.

Each time a MMS message is received, the FoxBox will insert its details inside of the SQLite database called mms.sqlite, located inside of the folder /mnt/flash/root/db . Here there are two tables:

• Incoming
• Media

Regarding the first table, here is an explanation of its fields:

• id: the identification provided by the carrier, unique and used as primary key;
• subject: the subject of the MMS message;
• fromnum: the sender number;
• carboncopy: the number in CC for the MMS (usually NULL);
• bcarboncopy: as CC, it contains the BCC number (usually NULL);
• contenttype: the MMS type, usually application/vnd.wap.multipart.related;
• timestdel: the timestamp of delivery;
• messagesize: size of the MMS (in KB).

While these are the fields of the second one:

• id: the identification provided by the carrier, unique and used as external key;
• mtype: the mime type of the media (ex. application/smil, image/jpeg, image/gif or text/plain for the text of the message);
• fromnum: the number of the sender (useful for data checks);
• ext: the extension of the file (ex. .jpg, .gif, .txt);
• filename: the full path to the media (useful to switch the storage, ex. a USB key).

All media are saved in /mnt/flash/root/documents and available over FTP and SSH. Now, using the well known FoxBox APIs you can retrieve, process and publish the contents however you prefer.