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

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

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