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 >
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
