CSV inconsitencies

Support on setups where you copy the hostip.info database locally.

Moderator: Moderators

CSV inconsitencies

Postby mbethke on Thu Nov 08, 2007 10:09 am

I stumbled on the inconsistency ilg1976 found in the last post as well. Plus, there are a few others in the current CSV file that seem to have gotten in there recently, namely "0" entries in a network's country column. As countries are numbered starting with 1, and -1 for non-countries, that's an error my Postgres complains about when I try to import the data.
For now, I just hacked my import script to replace zeroes by -1 (the first error is the double US/CA entry):

Incompatible entry 226 != 38
Fixed country 0 -> -1 for net 24.170.0.0
Fixed country 0 -> -1 for net 61.0.203.0
Fixed country 0 -> -1 for net 68.124.0.0
Fixed country 0 -> -1 for net 73.99.6.0
Fixed country 0 -> -1 for net 82.0.95.0
Fixed country 0 -> -1 for net 82.0.221.0
Fixed country 0 -> -1 for net 172.186.0.0
mbethke
n00b
 
Posts: 2
Joined: Thu Nov 08, 2007 9:56 am

mmonice.com aoc gold

Postby sherriesyo on Sun Jan 04, 2009 11:19 pm

I want to say,that is WOO! move me
we are a good site for age of conan game.If you need AOC Gold,Age of Conan Gold,Age of Conan Power Leveling ,Age of Conan PowerLeveling,age of conan service,come here!
sherriesyo
n00b
 
Posts: 4
Joined: Fri Jan 02, 2009 7:38 pm


Return to Hostip.info database local copy support

Who is online

Users browsing this forum: No registered users and 0 guests

cron