Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+===== 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_api|FoxBox APIs]] you can retrieve, process and publish the contents however you prefer.

FOXBOX DOCS Official documentation

User Tools

Site Tools

Differences

Page Tools