Pattern in prefix between column and property names

bruno92300 · Post by **bruno92300** » Fri 03 Jun 2011 10:46

Is it possible to use a pattern toi define the prefix in the mapping between names during update process?

I hope to map column of table to property of entity like this:

Table = customer
Entity = Customer
Columns / properties mappings:
cust_id ==> Id
cust_name ==> Name

And for another table/entity:

Table = invoice
Entity = Invoice
Columns / properties mappings:
inv_id ==> Id
inv_date_send ==> DateSend

I found the options to capitalize first letter, to suppress underscore, but not to suppress the first part of the column name.

I'm using the free version for now.

Thanks

Bruno

AndreyR · Post by **AndreyR** » Fri 03 Jun 2011 12:12

Go to Model Settings->Synchronization->Model Naming, and provide the list of prefixes to be removed in the Remove prefix(es) text box separated by semicolon, for example cust;inv.

bruno92300 · Post by **bruno92300** » Fri 03 Jun 2011 13:37

Thanks for info about ';' possibility. But I have 150 tables and 150 different prefixes

I hope a solution like '*_' or aquivalent in regex

AndreyR · Post by **AndreyR** » Fri 03 Jun 2011 15:02

We will investigate the possibility to add this functionality.
I will let you know about the results of our investigation.