Create CMSB Schema from mySQL table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 26, 2012   (RSS)

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