I'm looking into deleting entries in umbraco forms via sql because the BackOffice is not working*. And also it might be nice to be able to script this process for a client who wants to regularly remove data.
Deleting entries from ufrecords (by UniqueId or where clauses) isn't working because of a REFERENCE constraint in relation to UFRecords_Email.UFRecordsID.
Should I be able to remove a corresponding UFRecords_Email entry and then remove the UFRecords entry? Or is there more to it?
Thanks for helping me understand!
Update it seems to work but let me know if I am missing something :)
*by BackOffice not working I mean when I select entries in an umbraco form and click on the trashcan/delete icon nothing happens and the process seems to timeout and the entry is deselected after a couple of minutes.
I saw somewhere a somewhat similar issue that upgrading solved. I am still considering upgrading but concerned about the possible trouble related to our customization. ... I'll probably see about trying that sometime, but I wanted to know how to do this data removal manually anyway so I don't depend on that working :)
I think that you should upgrade to the latest version of Umbraco Forms 4.3.2 because it has got a lot of love, in the UX / UI and in the bug fixes as well.
I have just tired to delete an entry in Umbraco Forms 4.3.2 and it works perfectly. From version 4.1.3 we have fixed 53 issues.
I would strongly recommend you to upgrade to at least 4.1.5, for a security reason, try to see this blogpost.
Thanks Dennis, I really appreciate the advice, I do plan on getting that upgrade installed but at the moment I am more concerned about having control over the client's data.
Even if it works after the upgrade I would like to be able to manage the data directly so I can build an external tool that can monitor/delete data as necessary. I understand there is probably an API for that as well but if I can do it in SQL then I can do it in anything, I'm sure you understand.
Could you please comment on my process of removing umbraco forms entries directly?
I guess the question rephrased would be..
Is it safe to remove ufrecords_email entries and ufrecords entries to remove the entry from the form or is there some mechanism like a verification of the count of those entries that could cause a problem?
I am thinking I should also remove entries in the UFRecordDataXXX tables.
Delete entries from Umbraco Forms via sql
I'm looking into deleting entries in umbraco forms via sql because the BackOffice is not working*. And also it might be nice to be able to script this process for a client who wants to regularly remove data.
Deleting entries from ufrecords (by UniqueId or where clauses) isn't working because of a REFERENCE constraint in relation to UFRecords_Email.UFRecordsID.
Should I be able to remove a corresponding UFRecords_Email entry and then remove the UFRecords entry? Or is there more to it?
Thanks for helping me understand!
Update it seems to work but let me know if I am missing something :)
*by BackOffice not working I mean when I select entries in an umbraco form and click on the trashcan/delete icon nothing happens and the process seems to timeout and the entry is deselected after a couple of minutes.
HI jrip,
Which version of Umbraco and Umbraco Forms are you using at the moment?
/Dennis
Hi Dennis thanks for reading.
I saw somewhere a somewhat similar issue that upgrading solved. I am still considering upgrading but concerned about the possible trouble related to our customization. ... I'll probably see about trying that sometime, but I wanted to know how to do this data removal manually anyway so I don't depend on that working :)
Hi jtrip,
I think that you should upgrade to the latest version of Umbraco Forms 4.3.2 because it has got a lot of love, in the UX / UI and in the bug fixes as well.
I have just tired to delete an entry in Umbraco Forms 4.3.2 and it works perfectly. From version 4.1.3 we have fixed 53 issues.
I would strongly recommend you to upgrade to at least 4.1.5, for a security reason, try to see this blogpost.
https://umbraco.com/follow-us/blog-archive/2016/1/27/umbraco-forms-security-notice/
/Dennis
Thanks Dennis, I really appreciate the advice, I do plan on getting that upgrade installed but at the moment I am more concerned about having control over the client's data.
Even if it works after the upgrade I would like to be able to manage the data directly so I can build an external tool that can monitor/delete data as necessary. I understand there is probably an API for that as well but if I can do it in SQL then I can do it in anything, I'm sure you understand.
Could you please comment on my process of removing umbraco forms entries directly?
I guess the question rephrased would be..
Is it safe to remove ufrecords_email entries and ufrecords entries to remove the entry from the form or is there some mechanism like a verification of the count of those entries that could cause a problem?
I am thinking I should also remove entries in the UFRecordDataXXX tables.
is working on a reply...