Getting Data From FTP Server to MySQL

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
munirmdee1
Posts: 74
Joined: August 17th, 2015, 9:32 am
Location: Dar es Salaam, Tanzania

Getting Data From FTP Server to MySQL

Post 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
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
sherrell
Posts: 397
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: Getting Data From FTP Server to MySQL

Post 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
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Getting Data From FTP Server to MySQL

Post 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 1983 times
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
Post Reply