vasanth
I'm new here

Column Mapping Not Found

Dear All,

I am facing a issue (Column Mapping Not Found) in the Page Store. I have tow tables (for eg. A and B) and its having 1:N mapping and in the B Table

i have wriiten the code like below (B table's Template).

<CMS_INPUT_COMBOBOX name="cs_list_type" hFill="yes" singleLine="no" useLanguages="no">

    <CMS_INCLUDE_OPTIONS type="database">

      <LABELS>

        <LABEL lang="*">#item.name</LABEL>

        <LABEL lang="DE">#item.name</LABEL>

        <LABEL lang="EN">#item.name</LABEL>

      </LABELS>

      <TABLE>schema.list_type</TABLE>

    </CMS_INCLUDE_OPTIONS>

    <LANGINFOS>

      <LANGINFO lang="*" label="List Type"/>

    </LANGINFOS>

  </CMS_INPUT_COMBOBOX>

Even i have mapped the cs_list_type to the A table. I have added the value in the table A and I also mapped the Table A value to the Value B.

Finally i mapped the B table to the Master Page template to get the value (see the code below) and I added the Master Page Template to the some page..

<FS_LIST name="pt_XXXX" hFill="yes">

        <DATASOURCE type="database" useLanguages="yes">

          <ACTIONS>

            <ACTION name="ADD">

              <PARAM name="add-index">last</PARAM>

              <PARAM name="select-ui">dialog</PARAM>

            </ACTION>

            <ACTION name="REMOVE"/>

          </ACTIONS>

          <COLUMNS>

            <COLUMN show="no">#identifier</COLUMN>

          </COLUMNS>

          <LAYOUT>

            <ADD component="toolbar" constraint="top"/>

            <ADD component="overview" constraint="center"/>

            <ADD component="stackedview" constraint="hide"/>

          </LAYOUT>

          <table>schema.list_type</table>

        </DATASOURCE>

        <LANGINFOS>

          <LANGINFO lang="*" label="A-Z Configurations"/>

          <LANGINFO lang="DE" label="A-Z Konfigurationen"/>

        </LANGINFOS>

      </FS_LIST>

But in the Page, I tried to add the records of the B table. And i am getting the Error Message like "Column Mapping for cs_list_type Not Found".

please suggest me to solve this issue.

Thank You,

Vasanth

0 Kudos
4 Replies
andre
I'm new here

which FirstSpirit-VErsion do you use?

could provider us with a screenshot of the described mappings (schema.list_type) ?

regards

andré

0 Kudos
gockel
Crownpeak employee

> could provider us with a screenshot of the described mappings (schema.list_type) ?

See an example of the mithras demo project below:

mapping.jpg

0 Kudos

Hello Mr. Andre,

Please find the screenshot below ..

Page Mapping.JPG

0 Kudos
gockel
Crownpeak employee

The posted screenshot shows a mapping of a table template named "...page_type". This table template has never been mentioned in your first posting.

Furthermore the screenshot shows a mapping of a CMS_INPUT_TEXT component with name "cs_pagetype" which has not been mentionend in your first posting either.

Please check the column mapping in table template related to "B" in your first post for the CMS_INPUT_COMBOBOX component named "cs_list_type".

0 Kudos