You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I try (again) to install ISSO, this time want to try Docker.
One question: Can Wordpress comments be imported if ISSO is a Docker image?
Well, I guess I can simply add them to the comments.db manually (will try once ISSO runs)
Update: Yes I can, but not simply. I have my commentsa from Wordpress in MySQL. I can export to CSV - that give me ALL data that I need.
However, the 'dates' are human dates and Isso wants epochdates, so in Libreoffice I convert them with =(DATEVALUE(MID(D2,1,10)) + TIMEVALUE(MID(D2,12,8)) - DATE(1970,1,1)) * 86400
After lots of tuning I can import the comments with SQLiteStudio - they are perfect in the admin panel - but do not appear on the actual page.
sqlite3 command line import seems to work though. Also, hos nothing to do with Docker. The *.db is external on the webserver, so it's easy to access.
supportSomeone asking for support -> Should be moved to GitHub Discussions
1 participant
Heading
Bold
Italic
Quote
Code
Link
Numbered list
Unordered list
Task list
Attach files
Mention
Reference
Menu
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I try (again) to install ISSO, this time want to try Docker.
One question: Can Wordpress comments be imported if ISSO is a Docker image?
Well, I guess I can simply add them to the
comments.db
manually (will try once ISSO runs)Update: Yes I can, but not simply. I have my commentsa from Wordpress in MySQL. I can export to CSV - that give me ALL data that I need.
However, the 'dates' are human dates and Isso wants epochdates, so in Libreoffice I convert them with
=(DATEVALUE(MID(D2,1,10)) + TIMEVALUE(MID(D2,12,8)) - DATE(1970,1,1)) * 86400
After lots of tuning I can import the comments with SQLiteStudio - they are perfect in the admin panel - but do not appear on the actual page.
sqlite3 command line import seems to work though. Also, hos nothing to do with Docker. The *.db is external on the webserver, so it's easy to access.
Still work in progress.
Beta Was this translation helpful? Give feedback.
All reactions