Atom Server - commands question

22 views
Skip to first unread message

Aggi Sochanska

unread,
Oct 9, 2025, 10:19:40 AM (2 days ago) Oct 9
to AtoM Users
Hi AtoM users, I have been working on my new AtoM server and uploaded Archival descriptions, Authority records, Archival institutions, Subjects and Places. All of this is test data. I have seen that I can change the publication status to draft using these commands:
mysql -u [your_db_user] -p [your_db_name]
UPDATE status SET status_id = 159 WHERE type_id = 158 AND object_id <> 1;
UPDATE status SET status_id = 159 WHERE type_id = 158 AND object_id <> 1;

followed by
php symfony propel:delete-draft-descriptions  

This deletes the Archival Descriptions only, does anyone know if it is possible to do this for Authority records, Archival institutions, subjects and Places, if so what type id they would be?

If this is not possible, does anyone have any hints and tips on how to clear down the data that's not purge all, I'd like to keep my users and settings!

Thanks in advance

Johan Pieterse

unread,
Oct 9, 2025, 10:21:49 AM (2 days ago) Oct 9
to Dan Gillean
Hi Aggi

Unfortunately not.

Johan Pieterse
082 337-1406

Southbank Centre
Belvedere Road
SE1 8XX London

Registered Charity No. 298909

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/ica-atom-users/8081be9d-4949-4acc-bb63-4ef57eec6482n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages