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
Getting Data From FTP Server to MySQL
-
- Posts: 77
- Joined: August 17th, 2015, 9:32 am
- Location: Dar es Salaam, Tanzania
Getting Data From FTP Server to MySQL
Munir Mdee
Software Programmer
National Bureau of Statistic (NBS)
Jakaya Kikwete Road,
P.O.Box 2683,
Dodoma,TANZANIA
Mob: +255 755 740090
Email: munir.mdee@nbs.go.tz
munirmdee@gmail.com
Software Programmer
National Bureau of Statistic (NBS)
Jakaya Kikwete Road,
P.O.Box 2683,
Dodoma,TANZANIA
Mob: +255 755 740090
Email: munir.mdee@nbs.go.tz
munirmdee@gmail.com
Re: Getting Data From FTP Server to MySQL
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
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
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) to transfer the resulting csdb to MySQL.
Manies other tools existing on the web for this task.
Hope this help you!
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) to transfer the resulting csdb to MySQL.
Manies other tools existing on the web for this task.
Hope this help you!
G.VOLNY, a CSProuser from Haiti, since 2004