Skip to main content

Access remote project's data sources

Zendesk API User

Author: jzelenkov
Publication Date: 3/13/2013 10:55

I have the following configuration:

FS 4.2. Two FS Projects, one is set as a remote project.

The remote project contains database templates and data sources, which describe objects in general.

A non-remote project, describes particular features of an object.

Example Datasources:

FSRemoteProj.FSDatabaseRemote.Product-prototype
Name
Code
Model
// other general stuff

FSProjectDE.FSDatabase.Product_DE
Description
EC-certification
// other Germany-specific stuff

FSProjectUS.FSDatabase.Product_US
Description
FDA
// other US-specific stuff

Is it possible to link product-prototype remote's data source from a given non-remote project's data source form (formular)?

In other words, I want to be able to do the following:

FSProjectDE.FSDatabase.Product_DE
Prototype: FSRemoteProj.FSDatabaseRemote.Product-prototype.fs_id
Description
EC-certification
// other Germany-specific stuff

Either in the "Templates->Database schemes" editor, or in the "Datasources->Product_DE (form)".

Is it possible? If not, what are the best alternatives for implementing the desired functionality in FS?

Tags: database, datasources, fs4.2, query, remote

Related to

0

Comments

8 comments

Date Votes
  • Zendesk API User
    Author: Peter_Jodeleit - 3/13/2013 12:52

    You could use a FS_DATASET component to linkt to the "remote prototype". The disatvantage is, that it is possible to have multiple links to the same "prototype".

    0
  • Zendesk API User
    Author: jzelenkov - 3/13/2013 16:00

    Peter Jodeleit wrote:

    You could use a FS_DATASET component to linkt to the "remote prototype". The disatvantage is, that it is possible to have multiple links to the same "prototype".

    Hi Peter,

    could you please provide an example code, how FS_DATASET can be used in this situation?

    0
  • Zendesk API User
    Author: andre - 3/13/2013 16:11

    http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dataset.html?communit

    and the mode paramter: http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dataset.html?community#s0_11

    0
  • Zendesk API User
    Author: jzelenkov - 3/13/2013 16:22

    André Pfeiler wrote:

    http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dataset.html?communit

    and the mode paramter: http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dataset.html?community#s0_11

    Hi André,

    thanks for the link. I've already looked at the documentation. Here is what I have so far (taken from the only example available for the FS_DATASET):

      <FS_DATASET name="cs_prototype" useLanguages="no">
                  <LANGINFOS>
                          <LANGINFO lang="*" label="Prototype" description="Choose a Prototype"/>
                  </LANGINFOS>
                  <SOURCES>
                    <CONTENT name=""/> // WHAT GOES IN HERE???
                  </SOURCES>
                </FS_DATASET>
        </CMS_GROUP>

    How do link an external data source in there?

    P.S.

    I'm running FS4.2

    0
  • Zendesk API User
    Author: jzelenkov - 3/13/2013 16:42

    OK, so I have created a form with FS_DATASET configured in the following way:

      <FS_DATASET name="cs_prototype" useLanguages="no">
                  <LANGINFOS>
                          <LANGINFO lang="*" label="Prototype" description="Choose a Prototype"/>
                  </LANGINFOS>
                  <SOURCES>
                  </SOURCES>
                </FS_DATASET>
        </CMS_GROUP>

    When I click on the "Select" button, I only see local data sources and no remote ones. Should I be able to see remote sources in the selection window as well?

    0
  • Zendesk API User
    Author: jzelenkov - 3/13/2013 18:17

    Here is another way to look at the issue I am having:

    I want to select a dataset, which is located on a remote data source.

    Can I do that? If yes, how? Please provide a working code snippet. if no, please, say so explicitly.

    FS_DATASET allows choose an entry ONLY from the local data source.

    Here is a working snippet:

    <FS_DATASET name="prototype" hFill="yes" useLanguages="no">
      <LANGINFOS>
        <LANGINFO lang="*" label="prototype" description=""/>
      </LANGINFOS>
      <SOURCES>
        <CONTENT name="LocalDataSourceName"/>
      </SOURCES>
    </FS_DATASET>

    FS_REFERENCE allows to choose a data source located on a remote FS project, but not the individual dataset, in that data source.

    working snippet:

    <FS_REFERENCE name="prototype" imagePreview="no" upload="no">
      <LANGINFOS>
        <LANGINFO lang="*" label="prototype" description=""/>
      </LANGINFOS>
      <PROJECTS>
        <REMOTE name="FSRemoteProject">
          <SOURCES>
            <FOLDER name="root" store="contentstore"/>
          </SOURCES>
        </REMOTE>
      </PROJECTS>
    </FS_REFERENCE>

    FS_DATASET mode="combobox" parameter only changes the presentation of results, and has no influence on the desired functionality of the FS_DATASET (to select dataset on the remote data source).

    0
  • Zendesk API User
    Author: Peter_Jodeleit - 3/14/2013 9:26

    The remote datasource must be available in the local project (in "read only mode"). You could achive this utilizing the corporate content module (i.e. package pool).

    0
  • Zendesk API User
    Author: jzelenkov - 3/14/2013 11:08

    Peter Jodeleit wrote:

    The remote datasource must be available in the local project (in "read only mode"). You could achive this utilizing the corporate content module (i.e. package pool).

    Thanks

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post