Create CMSB Schema from mySQL table
3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 26, 2012 (RSS)
By rjbathgate - March 25, 2012
Hi,
I have a mySQL table, created directly in phpmyadmin.
Now I want it as a section in CMSB - i.e. need a schema for it.
The table has a rather lot of fields, so don't really want to do it manually.
Is there an easy/automatic way of doing it?
If I create the CMSB table, and then add in the extra fields in phpmyadmin, it updates them in CMSB, but this isn't really what I'm after as I don't get field labels (these are to be same as the field names), and I still would have to add the fields again in phpmyadmin.
Any suggestions, most appreciated.
Thanks
I have a mySQL table, created directly in phpmyadmin.
Now I want it as a section in CMSB - i.e. need a schema for it.
The table has a rather lot of fields, so don't really want to do it manually.
Is there an easy/automatic way of doing it?
If I create the CMSB table, and then add in the extra fields in phpmyadmin, it updates them in CMSB, but this isn't really what I'm after as I don't get field labels (these are to be same as the field names), and I still would have to add the fields again in phpmyadmin.
Any suggestions, most appreciated.
Thanks
Re: [rjbathgate] Create CMSB Schema from mySQL table
By (Deleted User) - March 26, 2012
Hi rjbathgate,
There is no easy way to build a schema from an extant mysql table created outside of CMSB.
One approach to try might be to manually create a schema file for the table in question by copying and pasting the various column entries from other CMSB tables (changing the column names where needed).
If you open a schema file (cmsAdmin/Data/schema/) to have a look at the structure you can then assemble a schema for your table.
Depending on how many columns you have in your table, this method could end up being pretty work intensive.
Let me know if this helps,
Tom
There is no easy way to build a schema from an extant mysql table created outside of CMSB.
One approach to try might be to manually create a schema file for the table in question by copying and pasting the various column entries from other CMSB tables (changing the column names where needed).
If you open a schema file (cmsAdmin/Data/schema/) to have a look at the structure you can then assemble a schema for your table.
Depending on how many columns you have in your table, this method could end up being pretty work intensive.
Let me know if this helps,
Tom
Re: [Tom P] Create CMSB Schema from mySQL table
By rjbathgate - March 26, 2012
Hey
Thanks for the info - yeah thought it would be a manual case like that.
Worth a try thou ;)
Cheers
Thanks for the info - yeah thought it would be a manual case like that.
Worth a try thou ;)
Cheers