Devam Ediyor

Move data from RS232 interface to MySQL

Situation:

There are four pulse sensors, connected to a special receiver which converts pulses to a serial interface data. Each sensor gives the data to RS232 interface every 12 seconds. Since there are four sensors, data in to RS232 interface comes every 3 seconds. From each sensor data is being transmitted consistently: first data are from the first sensor (1> 15), after 3 seconds comes data from the second sensor (2> 12), then after 3 seconds comes data from third sensor (3> 18) and lastly after 3 seconds comes data from the fourth sensor (4> 24). This cycle is being repeated until forced communication break fro RS232 interface. Example of the data being received on RS232 interface:

1> 15

2> 12

3> 18

4> 24

1> 12

2> 16

3> 15

4> 25

Task:

1) Retrieve the data every 3 seconds from the RS232 serial interface;

2) Recognize from which sensor the data comes and remove the beginnings of „1>“, „2>“, „3>“ or „4>“ (leave only pulse counts);

3) If the data received from a first sensor, record it to an array 1, from the second sensor record data to an array 2 and so on. Each array must have 2 columns: first for the pulse value (without „1>“, „2>“..) and the second column should be filled with time tag as „date YYYY:MM:DD time: HH:MM:SS“.

4) When the array has more than 30 entries, then connect to MySQL database DB1 and write recorded data from the array to a table1. The table consist of the 4 columns: ID, pulse value, date_time, timestamp. Also at the same time array of data has to be written into the file /user/admin/documents/1_values. The file data must be separated by „ ; “. If connection to a MySQL database fails, then prolong the array to 100 entries, but at the same each recording time trying to connect MySQL database. If after 100 entries in the array connect to the MySQL data isn‘t established, then write the data to a file „1_values“ only. Accordingly, the data from the sensors 2,3 and 4 has to be written to a tables table2, table3, table4 and files „2_values“, „3_values“, „4_values“.

5) The cycle is turning as long as notice of termination (3, 5 months).

Possible solutions for improvement:

As the data will be transmitted via GPRS, tryiing to save transmission bandwidth and costs available arrays with different amount of entries, also different MySQL database recording algorithms.

Beceriler: C Programlama, MySQL, PHP, Python, Kabuk Betiği

Daha fazlasını görün: rs232 mysql, mysql rs232, rs232 data mysql, connection mysql rs232, mysql rs232 connection, data rs232 mysql, interface rs232 mysql, serial programming, programming data, programming from, php mysql connection, notice leave, interface programming, example algorithms, different algorithms, data sensors, data programming, data algorithms, programming break, programming arrays, amount received, algorithms data, mysql sensor data, data mysql rs232, serial data rs232 mysql

İşveren Hakkında:
( 0 değerlendirme ) Vilnius, Lithuania

Proje NO: #711190

Seçilen:

alexandruchircu

Hi, please check your messages.

14 gün içinde 150$ USD
(2 Değerlendirme)
3.6

13 freelancer bu iş için ortalamada 223$ teklif veriyor

biddyweb

We can implement the job well. We would like to know operating system for which the solution and preferred programming language. We are experts with embedded linux like openWRT. We can not go lower than this.

in 3 gün içinde180$ USD
(7 Değerlendirme)
5.7
ciachn

Good day Sir. We have twelve years of experience with low-level/hardware programming. We are experts in the Assembly/C language, and hardware interaction. We'd be honored if you choose us for your fascinating project.

in 4 gün içinde300$ USD
(13 Değerlendirme)
4.9
EmbeddedWorld

Hello there, I am interested in doing this project. Looking forward to your positive response.

in 5 gün içinde130$ USD
(1 Değerlendirme)
3.7
wildlily981

kindly check pmb.

in 10 gün içinde250$ USD
(2 Değerlendirme)
2.4
xCoder4u

Am ready when you are ready. I understand the specs and this is very dowable within time quoted!

in 10 gün içinde250$ USD
(1 Değerlendirme)
2.0
BitGriffCom

Good day. I have 10 years of programming experience in C/C++, Java, Perl, PHP, SQL, Assembler (x86 and Itanium). Best regards.

in 10 gün içinde200$ USD
(1 Değerlendirme)
0.0
limelect

RS 232 specialist see www.limelect.com

in 21 gün içinde500$ USD
(0 Değerlendirme)
0.0
mentorict

Hello, I have more than 5 years of experience dealing with Hardware Interfacing using - Serial Port (Rs232-RS422 and USB) - PArallel Port - TCP/UDP - Modems I have implemented such Applications using VB6 and C# Daha fazlası

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0
vbsolutions

Hello, please check PM. Thank you.

in 3 gün içinde150$ USD
(0 Değerlendirme)
0.0
adnanahmmad

Please contact me for this project. I am very much familiar with these kinds of work. Best regards.

in 10 gün içinde245$ USD
(0 Değerlendirme)
0.0
kushalumarkar

Hello, I am ready to work on this project. Please check PMB. waiting for your reply. regards

in 10 gün içinde200$ USD
(0 Değerlendirme)
0.0
mgodave

This is fairly simple and is similar to something I have recently done for a large public art install. I am confident that this can be done rather quickly.

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0