Page 1 of 1

Getting Data From FTP Server to MySQL

Posted: September 13th, 2021, 5:10 am
by munirmdee1
Hello CSPro Users,

I'm using FTP Server to Synchronize Data from tablet (android) to FTP Server. I need to know if there is a way I transfer data from the FTP server to MySql database. I'm asking this because sychronizing data from the android to ftp does not create csdb file, its encrypted and its hard to read unless if you use cspro dataviewer.

Can I obtain the data from that ftp to mysql without using dataviewer?

Thanks in advanced

Re: Getting Data From FTP Server to MySQL

Posted: September 13th, 2021, 12:16 pm
by sherrell
Hi Munir,

Unfortunately there is no way to go directly from an FTP server to MySQL. You will have to download your files first as CSDB files so they can be properly assembled before using DataViewer to export.

Sherrell

Re: Getting Data From FTP Server to MySQL

Posted: October 7th, 2021, 10:41 am
by htuser
Hi Munir,
Your can download ftp data to csdb using some logics inside a batch application.
Then, you'll have to use some tools, such as this free: https://github.com/techouse/sqlite3-to-mysql
( i've a clone of this, but with a GUI)
sqlite3-to-mysql gui
sqlite3-to-mysql gui
GUI.jpg (43.56 KiB) Viewed 2160 times
to transfer the resulting csdb to MySQL.
Manies other tools existing on the web for this task.
Hope this help you!