SMS, SD Card, Text Filtering and Responding back.

Hey All,

I need help in designing the work flow.

My project is based on GSM-Module, When ever SMS is received, It should respond back automatically depending up on text received.

SMS Example:

Attendance (unique ID)
Marks (unique ID)
.. etc

I am doing it for my college, Here "Attendance" , "Marks" are predefined keywords. Now I am able to process the Strings, checking for and saving them to temporary variables.

TempVariable1 - Attendance
TempVariable2 - unique ID

My Questions:

  1. How to use String compare in Files( If i have 1000 Students ) ?

  2. Should I create only one file or multiple files ??

  3. If multiple files, Is it preferable to create separate file for every key word defined?

  4. Which format is preferable for creating DataBase ? (In later stage,I want it to upload it to some server)

  1. How to use String compare in Files( If i have 1000 Students ) ?

Read the file one character at a time, appending to a String, if the character is not the end of record marker. If it is, then don't add the character to the String. Instead, compare the String populated with data from the file with the stored value.

The number of students is irrelevant, except that it defines how long it will take to find a particular student.

  1. Should I create only one file or multiple files ??

Until you determine how long it takes to process one large file, such a decision is premature.

  1. If multiple files, Is it preferable to create separate file for every key word defined?

Same answer.

  1. Which format is preferable for this application ? (In later stage,I want it to upload it to some server)

Format for what? What is "it" that you want to upload to a server?

Plan B:

Use cloud service Twilio to send and receive SMS.

Use SQL database for lookup and get responding.

Arduino Yun & Sqlite , PHP

Arduino Yun & Twilio

Sir, Thanks fr Responding :slight_smile:

I want to create a database in SD-card Sir, but I am unable to figure-out How to create one. (I have data In excel Sheet in my pc)

What extension I have to save the File with ?

Arduino Yun create Sqlite3 in SD card

http://www.ibuyopenwrt.com/index.php/8-yun-compatible/97-shell-script-and-sqlite3

Use SQL database for lookup and get responding.

I am having Mega, SD/Ethernet Shield W5100, Can I create any similar sot of database which can reside on SD-card. Actually, I am trying to create a standalone device.

BhanuTejaJ:
I am having Mega, SD/Ethernet Shield W5100, Can I create any similar sot of database which can reside on SD-card. ...

No.

You could get Dragino Yun shield with Mega.

I figured out, ".csv ", file can be used as small db and basic file i/o operation can be performed directly.

Is It reliable ?? ... If reliable, should I search every time, by just opening the file stored in SD-Card or load it in to ram creating some temp variable ? Which can perform quick search?

SD Card- 2 GB, Class 4

ATmega2560
SRAM 8 KB
Clock 16 MHz
8 bits MCU

Yun or shield's CPU
AR9331
RAM 64 MB
Clock 400 MHz
32 bits CPU

Use ATmega2560 search 1000 Students list will be only good as paper weight.

  1. Which format is preferable for this application ? (In later stage,I want it to upload it to some server)

Format for what? What is "it" that you want to upload to a server?

Sir, I want to Edit files saved on SD-card via Ethernet, Using some webpage(for Editing manually Attendance or Marks) and Updating those files in memory card.

I am lost sir, unable to decide, never build any website. I am from Electronics background and good at c&c++.

  1. There are many type of servers ?? Which to choose? (Ftp or web servr or both, for uploading files and displaying webpage)

  2. do I need any database if I only want to edit .csv files ?

  3. I want my device to be standalone device and update when ever connected. So, should I program my arduino as Client ??

I am lost sir, unable to decide, never build any website. I am from Electronics background and good at c&c++.

Arduino Yun & Assembly Language

Arduino Yun & GCC C

Arduino Yun & GCC C++

  1. There are many type of servers ?? Which to choose? (Ftp or web servr or both, for uploading files and displaying webpage)

Web & FTP server Packages in Yun

  1. do I need any database if I only want to edit .csv files ?

No. but .csv would not support search, it is not database.

  1. I want my device to be standalone device and update when ever connected. So, should I program my arduino as Client ??

Arduino Yun should be fine.