Import only imports the last week

[JonasVautherin]

I tried to export my data and import it into a self-hosted v2.4.1 instance, but it only seems to import the last week, i.e. seven out of hundreds of pageviews.

When I open the exported .csv, it does have hundreds of fields, so that seems fine. Also the log said:

Your import is finished; 595 pageviews were imported successfully and there were no errors.

Am I missing something?

[arp242]

Is there any chance you can send me the CSV file? Then I can take a look. Otherwise it's a bit hard to say 😅

[JonasVautherin]

Sure, here it is: goatcounter-export-acarg-20230516T230630Z-0.csv.gz

This is a new one (I lost the one from last month 🙈), and interestingly it does import the last month (up to ~April 9th). Which seems to be consistent with what was happening when I opened the issue (it seemed to import one week, but it was around April 18th).

However I haven't found an obvious error in the csv file around that date 🤔.

[arp242]

The issue is that the sites.first_hit_at doesn't get updated properly; it's a check to prevent you from going from before your site exists in the UI.

I need to fix that, but you can correct it manually with:

goatcounter db query "update sites set first_hit_at='2022-07-09 00:00:00'"

Can be done either before or after the import; just remember to restart goatcounter once you've done that.

[JonasVautherin]

It works, thanks a lot!