Is there a way in Expression Engine to edit the comment date?
Development and Programming
I’m migrating comments that were made in another CMS and i want to transfer the dates the comments were made too. When i go to edit a comment it only shows the text from the comment. I’m wondering is there a way to edit more things associated with the comment?
If that is not possible then how can i edit the comment date in the mysql database? I see its stored as an integer. I’m not familiar with that method of storing dates.
Moved to Development and Programming by Moderator
Hi, CDPRfletcher.
EE uses a Unix date/time stamp. You’d need to edit the database directly, let me move this to the Development forum for additional community support.
ok thanks. I’m fine with editting the database directly.
Do you have a magic equation to use to convert the date that I have to the proper unix date/time? Is there maybe an easier way to do it in excel?
Is there a plugin that will let me edit the datestamp for comments?
See: http://emspace.com.au/article/how-convert-date-string-excel-unix-timestamp
NOTE: I have not tested, just googled for it. 😊
I’m also working on transferring a blog from Wordpress and really need to retain current comments. Are there any new development on this? I’m surprised no one has developed an add-on for this. Seems this kind of thing would be quite common. Any chance the next EE update will include the ability to edit comment dates?