Vocabulary from referenced CSV not added to database

Hi.

I'm trying to add this .csv as a vocabulary in studio. It's uploaded and “referenced” by the vocabulary. I've verified that, when I download the project as a .jar, the spreadsheet is present in /data/vocabularies and is correct (at least, it's what I uploaded). In the database (postgresql), the appropriate studio vocabulary table is created but not populated with data (I've dropped and recreated the database to verify).

Is there some step I'm missing here?

0 votes

1 answers

2227 views

ANSWER

I'm updating the studio project through the nuxeo admin interface, I'm just downloading the jar to check its contents. Possibly relevant detail that I omitted.
08/11/2014

Hi, what is your Vocabulary creation policy on Studio? (http://doc.nuxeo.com/x/bYgZAQ)
08/11/2014

It's set to on_missing_columns.
08/11/2014

did you try always (at least to test)
08/11/2014

It does get created with always, yes.
08/11/2014

Well…I've changed it back to on_missing_columns and updated the project. The table is now reliably populated. Gremlins? I've tested by dropping the table individually and by dropping the entire database.

It definitely was empty before. I assume this all has something to do with the order in which I was updating the project, restarting nuxeo, and modifying the database.

08/11/2014

glad that is works now, I'll convert my previous comment as an answer then
08/11/2014



I tested your CSV file referenced in a test vocabulary, if the vocabulary does not exist (with on missing column policy), the vocabulary gets created and populated. Do you confirm that your vocabulary gets created but is empty? On missing column (not row) will not populate the vocabulary if it exists already, even empty.

0 votes