User Tools

Site Tools


mms_web_publishing

Differences

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

Link to this comparison view

mms_web_publishing [2016/06/14 18:35] (current)
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.
mms_web_publishing.txt ยท Last modified: 2016/06/14 18:35 (external edit)