topic Re: Vocabulary from referenced CSV not added to database in Nuxeo Forum

Vocabulary from referenced CSV not added to database

mconley_ — Mon, 11 Aug 2014 16:47:23 GMT

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?

Re: Vocabulary from referenced CSV not added to database

mconley_ — Mon, 11 Aug 2014 16:48:26 GMT

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.

Re: Vocabulary from referenced CSV not added to database

Fred_Vadon — Mon, 11 Aug 2014 17:26:32 GMT

Hi, what is your Vocabulary creation policy on Studio?

Re: Vocabulary from referenced CSV not added to database

mconley_ — Mon, 11 Aug 2014 17:33:22 GMT

It's set to on_missing_columns.

Re: Vocabulary from referenced CSV not added to database

Fred_Vadon — Mon, 11 Aug 2014 17:37:12 GMT

did you try always (at least to test)

Re: Vocabulary from referenced CSV not added to database

mconley_ — Mon, 11 Aug 2014 17:37:48 GMT

It does get created with always, yes.

Re: Vocabulary from referenced CSV not added to database

Fred_Vadon — Mon, 11 Aug 2014 17:47:09 GMT

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.

Re: Vocabulary from referenced CSV not added to database

mconley_ — Mon, 11 Aug 2014 17:59:22 GMT

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.

Re: Vocabulary from referenced CSV not added to database

Fred_Vadon — Mon, 11 Aug 2014 18:05:10 GMT

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