Add Created By, Created Date Columns in import Table

0
I am importing an excel in my application     this is the method i am using to import it. On importing a file for the first time, i also want to show created by and created date columns in the imported table. How is that possible? Also, if already a file has been imported and user decided to import again, how do i replace the existing data that is there completely and also update the changed by and changed date columns?      
asked
3 answers
1

Hi Pranav,

 

I hope you are using Excel Import module only I believe, 

By default system members are enabled only so just add columns in page level it will work as expected.

image.png

Hope it helps!

Thanks & Regards,

Manikandan K

answered
0

Hi Pranav,

Owner (CreatedBy), createdDate, changedBy, and changedDate are system members.

If you have enabled all these members in your entity before starting the import, these members will be automatically updated during the import process. During the first import, the Owner and createdDate attributes will be updated. From the second import onward, the changedBy and changedDate attributes will also be updated.

answered
0

Hi Pranav,

as Stella Mentioned , those system members if you enable will be updated automatically

Created by will be updated by one who is importing and created date will be current date time.

Note: Although these values you won't be able to show In Datagrid as these are system members , if you have to show them then  you need to separately maintain and store  created person  via creating association with main entity to account and attribute for created date.

answered