Stream: troubleshooting

Topic: missing datafield text box after adding a metadata block


view this post on Zulip Hansen Zhang (Jun 12 2024 at 21:28):

Hi Everyone, I am trying to add a metadata block, but got the first datafield text box missing. Please see the attached image, tsv, and propertyfile for details.
metafield.png
art_1.tsv
art.properties
Thanks! Hansen

view this post on Zulip Sherry Lake (Jun 13 2024 at 13:07):

Hi Hansen,
In the ".tsv" file, I notice that the "fieldType" for the first field - accessNumber is "none". So I assume that's why there is "no" box?

view this post on Zulip luddaniel (Jun 13 2024 at 13:10):

I agree with @Sherry Lake

view this post on Zulip Hansen Zhang (Jun 13 2024 at 14:03):

Thank you both so much! I somehow did not realize it should not be a "none". Is there a way to delete that field? That field has to be deleted before loading the correct one, right?

view this post on Zulip Philip Durbin ๐Ÿš€ (Jun 13 2024 at 14:08):

You sort of need to start over, I'm afraid. Please see this open issue: Feature Request/Idea: Delete a metadata block (that hasn't been used at all) #9628

And thanks @Sherry Lake and @luddaniel for helping! :heart:

view this post on Zulip luddaniel (Jun 13 2024 at 14:18):

If you cannot start over, database modification will be required (not hard because the field is not used). I can help if you are blocked.

view this post on Zulip Hansen Zhang (Jun 13 2024 at 14:31):

I'd like to know how to change it through database modification. Please help!

view this post on Zulip luddaniel (Jun 13 2024 at 14:44):

delete from datasetfieldtype d where "name" = 'accessionNumber';

view this post on Zulip luddaniel (Jun 13 2024 at 14:45):

Ofc, reload dataset page and update your tsv before reimporting in the future

view this post on Zulip Hansen Zhang (Jun 13 2024 at 18:32):

Thank you so much, Daniel! I successfully deleted the field using the command.

view this post on Zulip Philip Durbin ๐Ÿš€ (Jun 13 2024 at 18:46):

You're braver than I am. :crazy:

view this post on Zulip luddaniel (Jun 14 2024 at 06:50):

If you could see the migration scripts we did with compound fields included... XD


Last updated: Oct 30 2025 at 06:21 UTC