Importing Ip Addresses From Csv File – Truncated

[cdthomp]

Hello,

 

I am trying to load a log file from a firewall into my database so I can search it. Things work great, except for the ip address. An ip of 10.10.40.123 becomes 10.1040 in the database, which is utterly useless. I have tried changing the map so that it is text and varchar, but none of that makes a difference. Here is a sample line from the csv. Both of the IP addresses turn out the same, even if I change the map file to have them handled differently.

 

2015-05-22 23:59:59.928,10.10.40.183,,10.10.40.183,https://www.google.com/,false,false,Haiku site

 

Any suggestions on how to make it see the number properly? 

 

Thanks

Charles

[peterlaursen]

First  all: your link does not work!

 

Please tell: what localisation(s) do you have of Windows and Office? English only? It looks like the truncation happens inside the ODBC driver where it is assuming “.” as decimal sign (and not “,” as used in most non-English speaking countries). 

 

Anyway .. we will check this and see what can be done. 

[cdthomp]

Hi, 

 

Thanks for your reply. I ended up using the Import CSV data using Load Local, once all the fields were already made and types set. That worked, though it doesn’t give me the opportunity to use the Where clause to limit the import. It wasn’t ideal, but it worked. Any chance of adding the Where to that dialog?

 

Thanks

[peterlaursen]

LOAD DATA is executed server-side and not inside SQLyog.  So this request should go to Oracle/MySQL and not to us. 

[Author]

Posts