Not quite sure how to ask this question, so forgive me if I fumble around a bit! I’ve been working with a new install of Piwik (1.4) and experimenting with importing my old data from Google Analytics with the google2piwik script. I don’t have shell access on my server (I’m using shared hosting), so I’ve been using a dummy set-up on a local Ubuntu box to do the actual import, with a view to exporting the database there and importing it to the db on my “real” server.
I’ve noticed a difference, though, between the db as it exists on my dummy server, and the export it generates. I’m specifically looking at the piwik_log_visit table, in the idvisitor and configid fields – when I export, the encoding seems to change…or something. Here’s a sample record:
Import db –
Export db –
Also, on a somewhat related note, all the locationip’s in my Google import show up as 30, but export as 0. Is that to be expected?
(Now that I’m looking, those field values on a new install of Piwik on my “real” server are things like:
So is this normal, or do I need to tweak some encodings before I run with my Google import?