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.

Cheers
/Karlsson

7 comments:

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...

Hello,

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