Thursday, July 26, 2012

MySQL JSON import tool version 1.4 is out

This is just a quick notice that there is a new version of the JSON import tool available now. The main thing in it is that it fixes an iddues with threadinig that caused a threaded load (and this is the default) to hang of there was an error or the import was interrupted. Also, there are some minor fixes and also a runtime status printing, available by sending a SIGUSR1 signal to the process, feature is available.

Download from sourceforge.



Dan said...

Hi - I'm excited to try this out but I keep running into the same issue when trying to run ./configure. I get the error. Here's an excerpt that includes the error...

Note, I'm running this, to explicitly include the paths necessary: ./configure --with-mysql=/usr/local/mysql --with-jansson=/usr/local

checking whether struct tm is in sys/time.h or time.h... time.h
checking MySQL home directory... configure: Using MySQL Home: /usr/local/mysql
checking for mysql_config... no
./configure: line 4343: --cflags: command not found
./configure: line 4344: --libs_r: command not found
./configure: line 4345: --version: command not found
checking Jansson library home... checking for json_string in -ljansson... no
configure: error: Jansson library doesnt exist

I've installed the Jansson library and confirmed that Jansson's files are where you'd expect (and that install seemed to go fine).

At this point I'm sort of lost on where I should go next to get this working since I can't get beyond running ./configure.

Any ideas or suggestions?

Alejandro Garcia said...

hello. I have successfully installed the program. I've done tests from terminal, but for the project I'm doing would need to run it in applescript. I have looked for ways to make the script under "Run Shell Script" but it has not worked.

the execution that execute in terminal is:

cd /Users/itserver/mysqljsonimport-1.4.1;
./mysqljsonimport --col-value=group=57 --col-json-name=id=_FileName --table=col --database=epdb2 col

in AppleScript:

do shell script ("cd /Users/itserver/mysqljsonimport-1.4.1;
./mysqljsonimport --col-value=group=57 --col-json-name=id=_FileName --table=col --database=epdb2 col")

When I run the commands in AppleScript, a system error occurs.

Any ideas or suggestions?

Joan Codina said...

Y have the same problem that Dan is reporting,
checking Jansson library home... checking for json_string in -ljansson... no
I have tried Jansson 2.4 and Janson 2.3 but in ./confgure I get the same error ,

Joan Codina said...

it seems that the error is on the mysql_config that needs to be installed

sudo apt-get install libmysqlclient-dev

andthen it runs...

hikmatune said...
This comment has been removed by the author.
hikmatune said...
This comment has been removed by the author.
hikmatune said...


I am getting this error.

2013-05-06 12:23:31 Loading table dataimport
2013-05-06 12:23:31 Loading table dataimport
2013-05-06 12:23:31 2013-05-06 12:23:31 JSON load error on record: 1
'[' or '{' expected near ''
JSON load error on record: 1
'[' or '{' expected near ''
Loaded 2 tables (0 rows) in 0 seconds.

The File I am importing has structure something like this:

{ "row" : [
{"name": "James"
"surname": "Adam"

any help would be much appreciated

marko said...

You will get wet momentarily riding a bicycle and it rained however you can simply discover a spot to stop and get shade in light of the fact that it's littler than most vehicles. Still, an insightful man dependably checks the climate before wandering out in a motorbike so be that man and you'll not get into this kind of inconvenience. check cashing nearer in fresno ca

marko said...

More often than not, auto credits are secured advance however unsecured auto advances are likewise getting to be well known in UK. Benefiting secured credits oblige you to put any of your property as guarantee against auto acquiring sum. Auto advances are secured advances subsequent to the auto that you mean to buy serves itself as insurance for the credit sum. Payday Loans Chicago

Mission Vission said...

Unmistakably, our course of action renders best another with riches while rising a key up to now for bikes on an especially essential level articular with Bajaj Bikes Accommodation India. Bajaj Auto Finance has unequivocally vanguard servile work environments with proficient advancement exemplified limit aptitudes which joins best contempo examination demography proceeding of work environments, best Check Cashing San-diego