jzelenkov
I'm new here

Access remote project's data sources

Jump to solution

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?

0 Kudos
1 Solution

Accepted Solutions

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).

Peter

View solution in original post

0 Kudos
8 Replies
Peter_Jodeleit
Crownpeak employee

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".

Peter

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 Kudos

André Pfeiler wrote:

http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dat...

and the mode paramter: http://www.e-spirit.com/odfs50/en/vorlagenentwicklung/formular/eingabekomponenten_2/fs_dataset_1/dat...

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 Kudos

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 Kudos
jzelenkov
I'm new here

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).

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).

Peter
0 Kudos

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 Kudos