Export User Data SQL - GDPR

I have a user requesting his personal data from my forums. Does anyone have SQL to do this yet?

Comments

  • phreakphreak VanillaAPP - White label iOS and Android App MVP

    @HIAviator: If he just wants the user data you can simply send him the field values you find in his dashboard user page.

    But I guess the user wants a data dump of all his discussions and comments or?

  • I'm not entirely clear on what GDPR requires in this regard. I guess it's user data and discussions, comments etc?

  • whu606whu606 I'm not a SuperHero; I just like wearing tights... Moderator

    I doubt very much if GPDR requires you to provide them with a list of comments/discussions.

    I would say that was is held in the USER table would be all that could be reasonably expected.

    Have a look at the GPDR thread for Linc's view on this.

  • If that's the case it will be simple. Thanks!

  • There is very little in the user table that isn't already public information and also personally identifying. It is mostly the email. You can provide the name and gender also there are IP related fields. Note the password is hashed. You don't want to provide that as it would compromise them and possibly other users. They are free to change it.

    Unless of course you re using specific Addons which collect more data. You might also what to check the UserMeta table and you can query with he UserID.

    GPDR has complicated what used to be very clear data protection legislation with possible prison sentence and conflated it it with privacy legislation which is different thing.

    grep is your friend.

  • Am I required to send the user their post history as well?

  • whu606whu606 I'm not a SuperHero; I just like wearing tights... Moderator

    I don't believe so.

    It would be hard to argue posts were personal information.

Sign In or Register to comment.