Chiedi agli espertiAzioni sul documento
Re: What if I need to add a column?..
Vai al livello superiore
Re: What if I need to add a column?..
Lasciato da
Victor
il
16 gennaio 2012 alle 7:28
Hi,
I am populating CMDbuild using different sources - mostly Excel spreadsheets. These were maintained by different people often approaching same things but from different angle. So I am discovering things (read - CI attributes) on the go. Got a picture?
Now the problem. Say I am introducing a new attribute. If the attribute has limited (small) number of possible values, then I can use Multiple update feature no problem.
However what if the new attribute has a lot of possible values?
How you guys would approach such situation?
One way I'm thinking of is
1. export class content to .csv;
2. introduce and populate new column in this .csv by concatenating it with another source (PERL, Ruby are my friends here);
3. Delete all the current entries in the class
4. Update schema, adding new attribute.
5. import from .csv
Is there an easier way?
Thanks and regards,
Victor.
BTW, great product guys! I only with I knew about it 1 year ago..
Re: What if I need to add a column?..
Lasciato da
Victor
il
27 gennaio 2012 alle 6:46
1. export class content to .csv;
2. introduce and populate new column in this .csv by concatenating it with another source (PERL, Ruby are my friends here);
3. Delete all the current entries in the class
4. Update schema, adding new attribute.
5. import from .csv
However now I have another issue:
cmdbuild=# DELETE from "Blades";
ERROR: CM_FORBIDDEN_OPERATION
What am I doing wrong?Thanks,Victor.
