MIGx not Showing Column Data

- 30 Posts
ctownsend23 Reply #1, 11 years, 4 months ago

I've got a strange issue I haven't seen to this point. I have a MIGx CMP page that loads column data and a form for editing and inserting content. On the CMP page it shows my column titles and add button, etc. No problems there. The form loads up and I was able to populate the first record via the form. It inserts into the table in the database. However, it's not displaying the data in the columns. I checked the field names and everything is correct. Is there a setting I missed somewhere? I would think since it inserted into the database table for the form all the connections should be correct.

Any help or direction is greatly appreciated as usual.
- 5,888 Posts
Bruno17 Reply #2, 11 years, 4 months ago

can you show your current setup?

MIGX-config and xpdo-schema
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

30 Posts

ctownsend23 Reply #3, 11 years, 4 months ago

Sure. Schema is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<model package="memberdata"
   baseClass="xPDOObject"
   platform="mysql"
   defaultEngine="MyISAM"
   tablePrefix="mp_"
   phpdoc-package="memberdata"
   phpdoc-subpackage="model"
   version="1.1">
   <object class="extUser" extends="modUser">
   		<composite alias="Data" local="id" class="memberProfiles" foreign="FK_user_id" cardinality="one" owner="local" />
   </object>
   <object class="states" table="states" extends="xPDOObject">
        <field key="state_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="stateName" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="stateAbbreviation" dbtype="varchar" precision="2" phptype="string" null="true" default="" />
		<field key="stateISO" dbtype="varchar" precision="8" phptype="string" null="true" default="" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="state_id" collation="A" null="false" />
        </index>
        <composite alias="MemberState" local="state_id" class="memberProfiles" foreign="FK_state_id" cardinality="one" owner="local" />
        <composite alias="MemberCompany" local="state_id" class="companyProfiles" foreign="FK_state_id" cardinality="one" owner="local" />
        <composite alias="MemberLocations" local="state_id" class="companyLocations" foreign="FK_state_id" cardinality="one" owner="local" />
	</object>
    <object class="gender" table="gender" extends="xPDOObject">
        <field key="gender_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="gender" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="genderAbbreviation" dbtype="varchar" precision="10" phptype="string" null="true" default="" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="gender_id" collation="A" null="false" />
        </index>
        <composite alias="MemberGender" local="gender_id" class="memberProfiles" foreign="FK_gender_id" cardinality="one" owner="local" />
        <composite alias="ContactGender" local="gender_id" class="companyContacts" foreign="FK_gender_id" cardinality="one" owner="local" />
	</object>
    <object class="companyType" table="company_type" extends="xPDOObject">
        <field key="companytype_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="companytype" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="companytype_id" collation="A" null="false" />
        </index>
        <composite alias="MemberCompanyType" local="companytype_id" class="companyProfiles" foreign="FK_companytype_id" cardinality="one" owner="local" />
	</object>
    <object class="membersProfiles" table="member_profiles" extends="xPDOObject">
        <field key="memberprofile_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="FK_user_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_gender_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="memberFirstName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberLastName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberTitle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberExt" dbtype="varchar" precision="20" phptype="string" null="true" default="" />
        <field key="memberFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberMobile" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberBio" dbtype="text" phptype="string" null="true" />
        <field key="memberLinkedIn" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberFacebook" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberTwitter" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberGoogle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberPhoto" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="memberpubdate" dbtype="timestamp" phptype="timestamp" null="false" attributes="CURRENT_TIMESTAMP" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="memberprofile_id" collation="A" null="false" />
        </index>
        <aggregate alias="extUser" local="FK_user_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="state" local="FK_state_id" foreign="state_id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" local="FK_gender_id" foreign="gender_id" cardinality="one" owner="foreign" />
        <composite alias="company" local="FK_user_id" class="companyProfiles" foreign="FK_member_id" cardinality="one" owner="local" />
        <composite alias="contacts" local="FK_user_id" class="companyContacts" foreign="FK_member_id" cardinality="one" owner="local" />
        <composite alias="locations" local="FK_user_id" class="companyLocations" foreign="FK_member_id" cardinality="one" owner="local" />
	</object>
    <object class="companyProfiles" table="company_profiles" extends="xPDOObject">
		<field key="companyprofile_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companytype_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="companyName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyTollFree" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
		<field key="companyPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyURL" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyDescription" dbtype="text" phptype="string" null="true" />
        <field key="companyMemberships" dbtype="text" phptype="string" null="true" />
        <field key="companyLicenses" dbtype="text" phptype="string" null="true" />
        <field key="companyLinkedIn" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyFacebook" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyTwitter" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyGoogle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyPinterest" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyInstagram" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyLogo" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
		<field key="companypubdate" dbtype="timestamp" phptype="timestamp" null="false" attributes="CURRENT_TIMESTAMP" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="companyprofile_id" collation="A" null="false" />
        </index>
        <aggregate alias="member" local="FK_member_id" foreign="memberprofile_id" cardinality="one" owner="foreign" />
        <aggregate alias="state" local="FK_state_id" foreign="state_id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" local="FK_companytype_id" foreign="companytype_id" cardinality="one" owner="foreign" />
        <composite alias="contacts" local="companyprofile_id" class="companyContacts" foreign="FK_companyprofile_id" cardinality="one" owner="local" />
        <composite alias="locations" local="companyprofile_id" class="companyLocations" foreign="FK_companyprofile_id" cardinality="one" owner="local" />
	</object>
    <object class="companyContacts" table="company_contacts" extends="xPDOObject">
		<field key="companycontact_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companyprofile_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_gender_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="contactFirstName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactLastName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
		<field key="contactPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="contactExt" dbtype="varchar" precision="20" phptype="string" null="true" default="" />
        <field key="contactFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="contactEmail" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactTitle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyDepartment" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactAvatar" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
		<field key="contactpubdate" dbtype="timestamp" phptype="timestamp" null="false" attributes="CURRENT_TIMESTAMP" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="companycontact_id" collation="A" null="false" />
        </index>
        <aggregate alias="memberContacts" local="FK_member_id" foreign="memberprofile_id" cardinality="one" owner="foreign" />
        <aggregate alias="memberCompany" local="FK_companyprofile_id" foreign="companyprofile_id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" local="FK_gender_id" foreign="gender_id" cardinality="one" owner="foreign" />
	</object>
    <object class="companyLocations" table="company_locations" extends="xPDOObject">
		<field key="companylocation_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk"  generated="native" />
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companyprofile_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="locationName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
		<field key="locationStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="locationEmail" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="locatonFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
		<field key="locationpubdate" dbtype="timestamp" phptype="timestamp" null="false" attributes="CURRENT_TIMESTAMP" />
        <field key="locationPhoto" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
                <column key="companylocation_id" collation="A" null="false" />
        </index>
        <aggregate alias="memberLocations" local="FK_member_id" foreign="FK_user_id" cardinality="one" owner="foreign" />
        <aggregate alias="locations" local="FK_companyprofile_id" foreign="companyprofile_id" cardinality="one" owner="foreign" />
        <aggregate alias="state" local="FK_state_id" foreign="state_id" cardinality="one" owner="foreign" />
	</object>
    </model>

And my MIGx JSON config:

{
  "formtabs":"",
  "contextmenus":"update||duplicate||publish||unpublish||remove",
  "actionbuttons":"addItem",
  "columnbuttons":"",
  "filters":"",
  "extended":{
    "migx_add":"Add State Value",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"states",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":4,
    "packageName":"memberdata",
    "classname":"states",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":1,
    "prefix":"mp_",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"States",
    "cmptabcaption":"View States",
    "cmptabdescription":"Add & Edit State Values",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"state_id",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":2,
      "header":"State",
      "dataIndex":"stateName",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Abbreviation",
      "dataIndex":"stateAbbreviation",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"ISO",
      "dataIndex":"stateISO",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Published",
      "dataIndex":"published",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"this.renderCrossTick",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ]
}

The States value is the only column setup I've done to this point, but I imagine there will be an issue with all.

- 30 Posts
ctownsend23 Reply #4, 11 years, 4 months ago

I just created a form for adding the states and it is adding to the database table, yet it will not display any content within my columns layout. I added data manually to the table so there are several records at this point. The connections must be correct somewhere in order for it to add from the MIGx form. I just can't figure out why it will not display the data in the columns.

5,888 Posts

Bruno17 Reply #5, 11 years, 4 months ago

MIGXdb works best with xPDOSimpleObject (automatically have a field with name 'id' on all tables as the primary-key-field)
So I changed all objects to xPDOSimpleObject

MODX also didn't create table with fields with this

attributes="CURRENT_TIMESTAMP"

in it. So I changed them, to what I'm using normally.

<?xml version="1.0" encoding="UTF-8"?>
<model package="memberdata" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" tablePrefix="mp_" phpdoc-package="memberdata" phpdoc-subpackage="model" version="1.1">
   <object class="extUser" extends="modUser">
        <composite alias="Data" local="id" class="membersProfiles" foreign="FK_user_id" cardinality="one" owner="local" />
   </object>
   <object class="states" table="states" extends="xPDOSimpleObject">
        <field key="stateName" dbtype="varchar" precision="50" phptype="string" null="true" />
        <field key="stateAbbreviation" dbtype="varchar" precision="2" phptype="string" null="true" />
        <field key="stateISO" dbtype="varchar" precision="8" phptype="string" null="true" />
        <composite alias="Members" local="id" class="memberProfiles" foreign="FK_state_id" cardinality="many" owner="local" />
        <composite alias="Companies" local="id" class="companyProfiles" foreign="FK_state_id" cardinality="many" owner="local" />
        <composite alias="Locations" local="id" class="companyLocations" foreign="FK_state_id" cardinality="many" owner="local" />
    </object>
    <object class="gender" table="gender" extends="xPDOSimpleObject">
        <field key="gender" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="genderAbbreviation" dbtype="varchar" precision="10" phptype="string" null="true" default="" />

        <composite alias="Members" local="id" class="memberProfiles" foreign="FK_gender_id" cardinality="many" owner="local" />
        <composite alias="Contacts" local="id" class="companyContacts" foreign="FK_gender_id" cardinality="many" owner="local" />
    </object>
    <object class="companyType" table="company_type" extends="xPDOSimpleObject">
        <field key="companytype" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <composite alias="CompanyProfiles" local="id" class="companyProfiles" foreign="FK_companytype_id" cardinality="many" owner="local" />
    </object>
    <object class="membersProfiles" table="member_profiles" extends="xPDOSimpleObject">
        <field key="FK_user_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_gender_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="memberFirstName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberLastName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberTitle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberExt" dbtype="varchar" precision="20" phptype="string" null="true" default="" />
        <field key="memberFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberMobile" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="memberBio" dbtype="text" phptype="string" null="true" />
        <field key="memberLinkedIn" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberFacebook" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberTwitter" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberGoogle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="memberPhoto" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    	<field key="createdon" dbtype="datetime" phptype="datetime" null="true" />

        <aggregate alias="extUser" class="extUser" local="FK_user_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="state" class="states" local="FK_state_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" class="gender" local="FK_gender_id" foreign="id" cardinality="one" owner="foreign" />
        <composite alias="company" local="id" class="companyProfiles" foreign="FK_member_id" cardinality="one" owner="local" />
        <composite alias="contacts" local="id" class="companyContacts" foreign="FK_member_id" cardinality="one" owner="local" />
        <composite alias="locations" local="id" class="companyLocations" foreign="FK_member_id" cardinality="one" owner="local" />
    </object>
    <object class="companyProfiles" table="company_profiles" extends="xPDOSimpleObject">
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companytype_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="companyName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyTollFree" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyURL" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="companyDescription" dbtype="text" phptype="string" null="true" />
        <field key="companyMemberships" dbtype="text" phptype="string" null="true" />
        <field key="companyLicenses" dbtype="text" phptype="string" null="true" />
        <field key="companyLinkedIn" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyFacebook" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyTwitter" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyGoogle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyPinterest" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyInstagram" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyLogo" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
    	<field key="createdon" dbtype="datetime" phptype="datetime" null="true" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />

        <aggregate alias="member" local="FK_member_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="state" local="FK_state_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" local="FK_companytype_id" foreign="companytype_id" cardinality="one" owner="foreign" />
        <composite alias="contacts" local="companyprofile_id" class="companyContacts" foreign="FK_companyprofile_id" cardinality="one" owner="local" />
        <composite alias="locations" local="companyprofile_id" class="companyLocations" foreign="FK_companyprofile_id" cardinality="one" owner="local" />
    </object>
    <object class="companyContacts" table="company_contacts" extends="xPDOSimpleObject">
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companyprofile_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_gender_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="contactFirstName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactLastName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="contactExt" dbtype="varchar" precision="20" phptype="string" null="true" default="" />
        <field key="contactFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="contactEmail" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactTitle" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="companyDepartment" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="contactAvatar" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
    	<field key="createdon" dbtype="datetime" phptype="datetime" null="true" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
 
        <aggregate alias="memberContacts" local="FK_member_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="memberCompany" local="FK_companyprofile_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="gender" local="FK_gender_id" foreign="id" cardinality="one" owner="foreign" />
    </object>
    <object class="companyLocations" table="company_locations" extends="xPDOSimpleObject">
        <field key="FK_member_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_companyprofile_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="FK_state_id" dbtype="int" precision="10" phptype="integer" null="true" />
        <field key="locationName" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationStreet1" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationStreet2" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationCity" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationZip" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="locationEmail" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="locationPhone" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
        <field key="locatonFax" dbtype="varchar" precision="50" phptype="string" null="true" default="" />
    	<field key="createdon" dbtype="datetime" phptype="datetime" null="true" />
        <field key="locationPhoto" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
 
        <aggregate alias="memberLocations" local="FK_member_id" foreign="FK_user_id" cardinality="one" owner="foreign" />
        <aggregate alias="locations" local="FK_companyprofile_id" foreign="companyprofile_id" cardinality="one" owner="foreign" />
        <aggregate alias="state" local="FK_state_id" foreign="state_id" cardinality="one" owner="foreign" />
    </object>
    </model>

There are still some more issues with the relations, for example missing classnames and wrong cardinalities

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

- 30 Posts
ctownsend23 Reply #6, 11 years, 4 months ago

Bruno,
With your example schema above I was able to create the package, parse the schema and create the tables via MIGx. However, in the tables there is no id. Should I add this to your schema example using id for each table?
- 5,888 Posts
Bruno17 Reply #7, 11 years, 4 months ago

xPDOSimpleObject does automatically add the autoinc-primary with name id to the table.
You don't need to add anything to the schema for that.
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!