1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Edit dates of posts

Discussion in 'Installation, Upgrade, and Import Support' started by Morgain, Oct 30, 2011.

  1. Morgain

    Morgain Well-Known Member

    We currently have an old forum which withered - will import into XF this week.
    I would also like to import the contents of an email list which has been quite good at surviving, so we don't have two communication areas.

    I'm willing to slog through the email list for a few hours to post each person's best posts in.
    But I want to preserve the date order, not just have a bunch of stuff apparently on the same day.

    Can anyone suggest a way?
    (I'm doing tutorials on MySQL but nowhere near able to do things safely yet so I'm looking for an admin method.)
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The only way to change that data is by directly editing the SQL database.
  3. Morgain

    Morgain Well-Known Member

    Thanks Brogan as usual very solid accurate advice.

    I went hunting and found this workaround.
    Most of the email list is in my gmail account.
    (If someone needs to do this without DB SQL work, you'd need to get the list imported into gmail)
    There's an app called gmail backup which downloads gmail content. The result textfile has the labels (gmail tags) so could be edited for the label pre-attached to this list (or another group of emails).

Share This Page