WebRatio no imports all attributes (fields) of a table

19 Aug '13, 04:52 PM
40,407 Views
Forum Forum Starter - Level 3

Hi, I have a Postgres database and I want to import its tables. So, I created the DB, I synchronize it (with 3 database schema), and, WebRatio doesn't import some attributes or fields in my tables, casuallity, this attributes or fields are FOREIGN KEYS. I synchronized with button foreign key with option enable and disable. It is a bug?

In Metadata Database appear all fields!!!

//------------------PSQL----------------------------------//

Scripts in postgres:

CREATE TABLE metadatavalue
(
  metadata_value_id integer NOT NULL DEFAULT nextval('metadatavalue_seq'::regclass),
  item_id integer,
  metadata_field_id integer,
  text_value text,
  text_lang character varying(24),
  place integer,
  authority character varying(100),
  confidence integer DEFAULT (-1),
  CONSTRAINT metadatavalue_pkey PRIMARY KEY (metadata_value_id ),
  CONSTRAINT metadatavalue_item_id_fkey FOREIGN KEY (item_id)
      REFERENCES item (item_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT metadatavalue_metadata_field_id_fkey FOREIGN KEY (metadata_field_id)
      REFERENCES metadatafieldregistry (metadata_field_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);

CREATE TABLE item
(
  item_id integer NOT NULL,
  submitter_id integer,
  in_archive boolean,
  withdrawn boolean,
  last_modified timestamp with time zone,
  owning_collection integer,
  CONSTRAINT item_pkey PRIMARY KEY (item_id ),
  CONSTRAINT item_submitter_id_fkey FOREIGN KEY (submitter_id)
      REFERENCES eperson (eperson_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);

CREATE TABLE metadatafieldregistry
(
  metadata_field_id integer NOT NULL DEFAULT nextval('metadatafieldregistry_seq'::regclass),
  metadata_schema_id integer NOT NULL,
  element character varying(64),
  qualifier character varying(64),
  scope_note text,
  CONSTRAINT metadatafieldregistry_pkey PRIMARY KEY (metadata_field_id ),
  CONSTRAINT metadatafieldregistry_metadata_schema_id_fkey FOREIGN KEY (metadata_schema_id)
      REFERENCES metadataschemaregistry (metadata_schema_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);

Relationship:

metadatafieldregistry-----------------metadatavalue-----------------item

//----------END PSQL------------------------------------------//

//------------WebRatio----------------------------------------//

These tables and fields are what I see in WebRatio Domain Model

TABLE metadatavalue
(
  metadata_value_id integer,
  text_value text,
  text_lang character varying(24),
  place integer,
  authority character varying(100),
  confidence integer,
);

TABLE item
(
  item_id integer,
  in_archive boolean,
  withdrawn boolean,
  last_modified timestamp,
  owning_collection integer,
);

TABLE metadatafieldregistry
(
  metadata_field_id integer,
  element character varying(64),
  qualifier character varying(64),
  scope_note text,
);

//----------------END WebRatio------------------------------------//

Thanks, Jose

 
x 0
Follow
Answer Answer at this question and get points!
Forum Expert - Level 8

Hi,

the WebRatio Domain Model right now is a normalized Entity Relationship model. This means that all columns that are set as FOREIGN KEY are considered by WebRatio as part of a relationship, so they are not visible as attributes but they are used to map a relationship outgoing from the specific entity.

For example, if you select the relationship between Metadatavalue and Metadatafieldregistry and then you look in the Properties View, when you select the Mapping tab you can see which columns are used for the relationship and you will find there the columns used.

You can still use this columns also has attributes, for example if you want to show these information using a List or a Simple List. To do this, you have to manually add the attributes to the entity and then to manually map them. It means that, once you select the new attribute, you have to go to the Properties View, select the Mapping tab, and choose the column to which the attribute refer to.

 
x 1
Forum Starter - Level 3

"

Database imported:

Database in WebRatio, after the importation, I follow these steps or recommendation ""Reverse Engineering"": http://wiki.webratio.com/index.php/The_Data_Model_Mapping#toc4

Thanks!!! Jose

"

 
x 0
Forum Starter - Level 3

Hi.

These attributes I can't see in the Data Model, but, I can show it in a Index Unit (Simple List) or Power Unit (List), importing these attributes by interface "Display Attribute Selection" in the layout properties of Index_Unit (or Power_Unit) .

Thanks,

Jose

 
x 0
Forum Starter - Level 3

It's correct!!!

I could make these examples!!!

Thanks, Jose

 
x 0
Answer at this question and get points!

Related questions

502 proxy error-generate and run Adding and deleting from the database Agregar boton de cambio de contraseña en el login Alimentar graficas con base de datos Atributos Condicionales heredados Attribute comparison in a selector unit [beginner] - How to store and browse data collected with BPM app? Business object data Cancellare campi e tabelle dal database Cannot add a Database in the Domain Model Cannot connect to MySQL Cannot insert an entity in the database Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! Change uplod directory and protect anauthorized access to files Como mostrar una imagen en una lista o en la componente detalles? Como recuperar todos los atributos de una relacion N:N y insertar registros? Conexion a Oracle 12g Connection refused. connect to Cloud Convert data in a Calculated attribute Convert selector component result to single value Could not open the editor: This copy of WebRatio is not registered Creación DB Apache Derby - Modelado BPMN Criptare dati sensibili nel database Database connection, Host and Port number Database password encrypting Database properties Database resource consumption Database Tables Creation After Remote Deploy DB in Data Service Project Deploy in Cloud Amazon Beanstalk with Postgres Dynamic data type Empty record mistakenly saved Error updating metadata process EverLasting error "The TCP/IP connection to the host has failed. Connection refused" Execute truncate sql query Export XML file analysis then update MySQL database Find Model Problemas Foriegn key relationship Generate and run locally on webratio professional edition. getting data from database Groovy and Database Guardar Saltos de LINEA Hide a form if condition if true How can I import a view in the Domain Model as an attribute of an Entity? How database or datamodel migration? How I can receive the primary key value after adding into database from OK Port. How to block empty string in Database How to disble derby database? How to fix Network error(status 0) How to show certain values derived from relations in the domain model? I can't run any application with WebRatio (Table/View 'APP.POST' does not exist) Image in List field Import an XPDL 2.2 file into a BPM Project Importing JAR Libraries into Script Unit Insert data into database Is it possible to create a derived relationship between databases? JDBC4 Postgresql Driver JDBC connection with mysql on mac Job not start correctly Mapping database of the entity '...' is unspecified Missing units when importing project [MOBILE] Can't synchronize domain model with beck end DB Modifica Entità tramite file xml Mostrar datos de diferentes tablas/ show dates from diferentes entities MS SQL server jdbc file multi selections field problem MySQL Driver jdbc No Apache Derby driver found No Database on Cloud account No database on my cloud account Non riesco a fare funzionare Xml out unit Passing JSON Object to Model Personalizzare lo stile di un progetto PostgreSQL Predefined values in database Problem accessing MySQL with WebRatio 6 Problema Grafo da una lista gerarchica Problema ¨HTTP Status 404" Problemas con el Operations View Delete Problem saving multi selection from input Problems to connect Sql Server DB from Webratio Problems with Database Metadata Problem with fields with accents used in attribute condition Problem with query unit! Problem with stored procedure Problem with the deletion of more than 50.000 records in a table Process model import in other languages publish web service for storing information in PostgreSQL DB following XSD Resource query a database Refresh and Synchronize DB Problems Relaciones Removing the User-Group-Module tagles Retrieve a value and add some value to it reverse engineering, problema con le relazioni di default Script Unit e Mysql Share database connection Solve "Generation Error" with Generate and Run option Statistics Component for WebRatio > 7.2.0 Status ProcessInstance and activityInstance in spanish Sybase JConnect 4 JAR replace Sync DataService Project with Mobile Project Table 'freeapp43.profesion' doesn't exist Tarea de servicio no me evalua el valor Trying to Synchronize Domain Model Unable to execute the script java.lang.NullPointerException Unknow property on Dynaclass after generation Unspecified BPM Engine Database Update mutiple records with the same value upload file and the move it to other location User Login Timestamp Username come chiave Using own User and Group tables Web ratio data model WebRatio - list results of joined tables Web Ratio Mobile and Foreign Key Web Ratio Mobile - Remote data mapping problem Where is the ACME demo data stored?! White report