CMDBuild Forum

Re: What if I need to add a column?..

Old Versions
#1

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..

#2

Since no  one replied I’ve proceeded to do exactly as I suggested -

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.