Fix My MQTT to CSV PHP Script

Completed Posted 4 hours ago Paid on delivery
Completed Paid on delivery

I have a PHP script that translates MQTT data into a CSV file. This script worked perfectly when it was sourcing data from a single MQTT topic. However, I've since moved my GPS data to a separate topic and now the script is parsing data into incorrect columns. I need a skilled developer to correct this code so that the data is parsed correctly again.

Key Details:

- The GPS data and sensor data needs to be put into the right columns, but the specific columns are yet to be determined. This will need to be figured out based on the structure of the data.

- The script currently handles multi-level MQTT topics, but the sorting and parsing needs to be adjusted to accommodate the separate GPS topic.

- The task should not take long for someone with the right skills and experience.

Ideal Skills and Experience:

- Proficient in PHP

- Experienced with MQTT protocol

- Capable of parsing and organizing data accurately

- Quick turnaround time

Below is an example of the mqtt messages.

16:13:58.708 -> DEBUG: MQTT => connected

16:13:58.708 -> DEBUG: publish => Request intervals => log/upload

16:13:58.708 -> DEBUG: 'Request intervals' published successfully

16:14:03.728 -> DEBUG: starting GPS data upload...

16:14:03.777 -> DEBUG: Publishing GPS data => 55.941566,8.781980,-33.90,0.93,6

16:14:03.777 -> DEBUG: GPS data uploaded successfully

16:14:03.777 -> DEBUG: starting log upload...

16:14:03.810 -> DEBUG: publish => 2025-01-22,16:10:25,63,"DO",81.01,%,7.99,mg/L,15.90,C,"TU",18.473,NTU,16.08,C

16:14:03.810 -> DEBUG: uploaded => 2025-01-22,16:10:25,63,"DO",81.01,%,7.99,mg/L,15.90,C,"TU",18.473,NTU,16.08,C

16:14:03.843 -> DEBUG: publish => 2025-01-22,16:11:25,63,"DO",81.01,%,7.99,mg/L,15.93,C,"TU",18.475,NTU,16.08,C

16:14:03.843 -> DEBUG: uploaded => 2025-01-22,16:11:25,63,"DO",81.01,%,7.99,mg/L,15.93,C,"TU",18.475,NTU,16.08,C

16:14:03.843 -> DEBUG: publish => 2025-01-22,16:12:25,63,"DO",81.07,%,7.99,mg/L,15.94,C,"TU",18.473,NTU,16.09,C

16:14:03.883 -> DEBUG: uploaded => 2025-01-22,16:12:25,63,"DO",81.07,%,7.99,mg/L,15.94,C,"TU",18.473,NTU,16.09,C

16:14:03.883 -> DEBUG: logs => removed after upload

16:14:03.928 -> DEBUG: MQTT => disconnected after uploads

attached is a csv file generated from the code.

Point is each unit must be 1 row and each row must have gps data....

PHP JavaScript MQTT

Project ID: #39018884

About the project

41 proposals Remote project Active 25 mins ago

Awarded to:

julianw10

Hello, As an experienced and versatile full-stack developer, I am confident about fixing your PHP script to accurately parse data from MQTT topics. My expertise in JavaScript - which powers MQTT, PHP scripting, and AP More

$10 USD in 5 days
(0 Reviews)
0.0

41 freelancers are bidding on average $21 for this job

kabirchy

Hi There, I am writing to propose my services for correcting your PHP script that translates MQTT data into a CSV file. The script currently handles multi-level MQTT topics but needs adjustments to accommodate the sepa More

$25 USD in 1 day
(1271 Reviews)
9.5
siddhu1986

Hi, I am an experienced Web Developer with over 10 years of experience. I have good experience with JSON and CSV and parsing between these two types. I have checked your requirements and can update the code to work pr More

$30 USD in 1 day
(705 Reviews)
8.1
shihan033010

Hello Sir I can fix the code as you need. Please accept the bid and create the milestone. I am available to start the project now. Regards Shihan

$20 USD in 1 day
(326 Reviews)
6.9
vano101

Hello I have several years of experience with PHP and I have experience with MQTT I checked attached files, and I have ideas how to fix - I am able to start now!

$20 USD in 1 day
(431 Reviews)
6.8
softiarttech

Hi, I’ve carefully checked your Requirement "Fix My MQTT to CSV PHP Script" and I would be happy to assist you on this project. I know you have several tempting proposals here, but I guarantee you to be impressed More

$30 USD in 1 day
(40 Reviews)
5.6
toriquldev123

Hello Dear! Good Day! I hope you are doing fine. My name is Toriqul Islam. I am an expert Web Developer with 10+ years of experience in PHP, HTML5, CSS3, JavaScript, jQuery, Bootstrap, MySql, and different Frameworks More

$30 USD in 1 day
(14 Reviews)
4.3
afaq619

I am a highly skilled and experienced full stack developer with over 7 years of expertise in delivering innovative and customized solutions across various fields. My expertise spans across a wide range of technologies More

$19 USD in 2 days
(6 Reviews)
3.8
hafeelmo

Tried id.[mqtt_to_csv,sesor_data]I have detailed plan for your job because I 've just completed a project similar to yours.I can send you it immediately and I can start it immediately. I am confident in your job and I More

$30 USD in 2 days
(4 Reviews)
3.6
aaravktech

Hello, I'm Dinesh Kumawat, Working last 14 years on different different platform, build lots of startup with day night hard work and I'm committed to delivering high-quality work that guarantees 100% satisfaction. You More

$20 USD in 7 days
(15 Reviews)
3.5
centaurusagency

⭐ Verified UAE Agency ⭐ Greeting Jan, As a senior custom website developer, I can surely help you to Fix My MQTT to CSV PHP Script as per your requirement with 100% job satisfaction. Jan, Please share complete det More

$30 USD in 1 day
(1 Review)
2.8
ivans69

Hi, Jan J. I am thrilled about the opportunity to collaborate on your project! With extensive experience in JavaScript, PHP and MQTT, I bring a professional skillset and a deep commitment to delivering exceptional res More

$30 USD in 1 day
(3 Reviews)
2.4
umairdev101

Hello, I went through your project description and it seems like I would be a great fit for this job. I am an expert which have many years of experience on PHP, JavaScript, MQTT Please come over chat and discuss y More

$25 USD in 1 day
(3 Reviews)
1.9
anisbouk

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with my work. I am an expert who have many years of experience on PHP, JavaScript, MQTT. Looking forward to hearing from you soon. More

$30 USD in 1 day
(2 Reviews)
1.7
mutayyabm

I have carefully reviewed your project requirements and I am confident that I can deliver the perfect solution for you, Jan J. Let's discuss the details further to ensure a successful outcome. Looking forward to workin More

$10 USD in 7 days
(1 Review)
1.3
rajeshrolen

Hello Jan J., We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, JavaScript, MQTT Please come over chat More

$20 USD in 7 days
(1 Review)
0.2
jackt45

Hello, As an experienced and adaptable Full Stack Developer, my expertise lies in creating seamless, high-performance applications tailored to meet specific business needs. With a key focus on backend programming and More

$15 USD in 3 days
(0 Reviews)
0.0
abek8

Hello, Drawing from my diverse skill set and seven years of front-end development experience, I confidently affirm that I can expertly unravel your MQTT to CSV PHP script challenge. Being proficient in both PHP and Ja More

$15 USD in 1 day
(0 Reviews)
0.0
jackl78

Hello, Jan J. Good afternoon! I am a professional full-stack developer with over 6 years of experience, specializing in technologies such as PHP, ASP, JavaScript, Python, Node.js, Laravel, React.js, Vue.js, Django, an More

$10 USD in 3 days
(0 Reviews)
0.0
williamc363

Hi Mate Jan J., Good afternoon! I am professional mobile software engineer with skills including PHP, MQTT and JavaScript. I am checking your attachment, I'll update you shortly... "TU" Please contact me to discu More

$10 USD in 5 days
(0 Reviews)
0.0
liama62

Hello, As one of the select few who feel equally comfortable with both PHP and JavaScript, I believe my skills are uniquely suited to tackle your project. Having worked extensively with MQTT in the past, I'm aware of More

$10 USD in 6 days
(0 Reviews)
0.0