Thank you both, I hadn't really understood how vocabularies worked. A custom schema is the way to go.
Daniel Pérez Álvarez Technological Solutions Atos Origin +34 91 126 7290 C/ Albasanz, 16 28037 Madrid Spain ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Plamen Tanov Sent: martes, 14 de julio de 2009 15:41 To: Daniel Perez Alvarez Cc: [email protected] Subject: Re: [Ecm] Vocabulary with custom columns Why you use schema "vocabulary" (<schema>vocabulary</schema>)? I think you can use custom schema (defined by you) that has needed columns. Drawback is that you can't edit it's content from "vocabularity" in admin panel (probably you should create custom view). On Tue, Jul 14, 2009 at 4:20 PM, Daniel Perez Alvarez <[email protected]> wrote: Situation: We are trying to access some data stored in SQL tables outside Nuxeo, but right now we are simulating it with CSV files. Question: Is there a way for vocabularies to store columns other than "id", "label", "parent" and "obsolete"? We have tried to add custom columns to our CSV file, but Nuxeo complains with a "column not found: <name of the custom column>" error. Are we doing something wrong? If it's a limitation, is there a workaround? Our contrib XML looks like this: <?xml version="1.0"?> <component name="es.seia.ereg.directories"> <extension target="org.nuxeo.ecm.directory.sql.SQLDirectoryFactory" point="directories"> <directory name="office"> <schema>vocabulary</schema> <dataSource>java:/nxsqldirectory</dataSource> <idField>id</idField> <table>office</table> <createTablePolicy>always</createTablePolicy> <dataFile>directories/office.csv</dataFile> </directory> </extension> </component> And our CSV: id,label,telephone,email,obsolete "madrid","Madrid","91 5556677","[email protected]",0 "barcelona","Barcelona","93 5556677","[email protected]",0 "bilbao","Bilbao","94 5556677","[email protected]",0 Thank you for your time. Daniel Pérez Álvarez Technological Solutions Atos Origin +34 91 126 7290 C/ Albasanz, 16 28037 Madrid Spain ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------ _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------ _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
