Create Entity Name, Type, Length and Descriptions from Excel File

Create Entity Name, Type, Length and Descriptions from Excel File

  
Hi,

I want to create an Entity Name, Entity Attribute Names, Type, Length, Descriptions automatically from Excel. I already used an option "Import Entities from Excel" by clicking on the entities under Data tab. But it is creating only Entity Name and Entity Attribute Names. But I also want to create Entity Attribute Names, Type, Descritptions ? Pls let me know if it is possible to achieve in Outsystems Service Studio V 7.0 ?

Thanks 
Ravi 
Hi Ravi,

As far as I know, you will have to manually verify/edit the Entity attributes such as
Name, Description, Data Type, Length, and Is Mandatory

Source:
http://www.outsystems.com/help/servicestudio/7.0/default.htm#Using_Data/About_Entities.htm

This is also the same in V 8.
http://www.outsystems.com/help/servicestudio/8.0/default.htm#Using_Data/About_Entities.htm
 

Regards,
Charles.

Further more, if you can somehow manage to generate the Tables into an SQL server or Oracle Server from your excel sheet,
you could create a temporary e-space to integrate with the external system using Integration Studio, and then copy those generated Entities into your e-space

http://www.outsystems.com/forums/discussion/7362/how-to-integrate-with-an-external-sql-server-or-oracle-database-in-outsystems/
Another approach would be to reference the System-Entity_Attr entity and use the UpdateEntity_Attr Api, but this approach makes changes directly to the metamodel, so you really need to be carefull.
Thanks Charles for your recommendations. Could you explain more on updateEntity_ATT api please ? Can you pls give me a sample SQL ?
Hi,

What's exactly your problem? Can't you just fill the rest of the information manually after using the automatic import part? All automatic operations in Service Studio should be viewed as helpers to get the work started.

All the sugestions in this topic so far would either not help or give you even more work.

As for the entity_attr entity (as most metamodel) it is NOT to be changed in any circunstance. It can break your platform.

Regards,
João Rosado
João Rosado wrote:
As for the entity_attr entity (as most metamodel) it is NOT to be changed in any circunstance. It can break your platform.
João is absolutely right, ignore my suggestion about changing the entity_attr.