User Tools

Site Tools


MMS Web publishing database administration

This article illustrates the procedure to publish on a website the contents that you received via MMS channel. :id1: 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.

mms_web_publishing.txt · Last modified: 2016/06/14 18:35 (external edit)