Modified fields in Accoiunts do not show up when moving espo insall

[gilles1971]

Hello
I started with a local (windows) version of Espo and I added some fields through the espo GUI in my database.
I then created a new remote install to access anywhere. I copy the resources directory in the customs directory and that show all the modified layouts OK
I copied the database and they are identical o the remote and local versions

However the fields I added or modified are not showing on the final espo version. Seems the database adds a _ in the name of the actual mysql field. Like I created "Produits" (sorry I am french) and the layout shows Produits but the database name for the field is "c_Produits"

So all the data is there, the layout is ok, but it does not show the data in modified fields when I look in my accounts on Espo

Any ideas on how to link the fields to Espo ??

Thanks

Gilles

[victor]

Could you please add some screenshots as I don't understand the problem.
Regarding the "c" prefix, it is automatically added to custom fields for system entities.

[gilles1971]

Hi victor

Thanks. I uploaded the field entity manager in my old espo setup where I created new fields (Old-Espo-field-manager.png). The fields are in the new database (new-database.png). They don't appear on the new espo field manager (new-Espo-field-manager.png) nor in the layout (old ves new in screenshot as well).

I don't know how to link them

Gilles

[Noah Kal]

The `c_` prefix is normal for custom fields and should not cause any issues.

My guess is that the metadata for the custom fields was not transferred correctly, or a Rebuild/Clear Cache was not run after the migration.

Could you try performing a Rebuild and verify that the custom field definitions exist under `custom/Espo/Custom/Resources/metadata/entityDefs/Account.json` on the remote installation?

[gilles1971]

Hi victor Noah Kal

Thanks. the rebuild, clear cache re-linked the info. I have however lost the fomatting and I can't see the fields in the entity field manager to correct them (see old vs lost formating)

Thanks

Gilles

[victor]

Perhaps you created the fields on the old instance when you had French enabled, and on the new instance the default is English. Then this explains the absence of Labels and it will be enough to return the language in which the Labels were created (French).

[gilles1971]

you are an absolute star... Did the trick . So many thanks