Finance | Project Operations, Human Resources, ...

GL data entity extension import

(0) Share

Report

Posted on by Johnny

6,494

Hello,

I have extended GL data entity with one field.

Export works fine.

During import I want to update LedgerJournalTRans table's field based on some logic,

In which method should I write the code?

I copied events related to mapEntityToDataSource method and insertEnttyDataSource, but during import I can't see those executed.

Breakpoint is not hit, nothing happens.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sukrut Parab 71,741 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You can write in any of the above methods. mapEntityToDataSource is called for each datasource on the entity, so you can try to write in it . If you are break point it not hitting thats a different problem but these methods must be getting called during import. Which entity you are using ?

Was this reply helpful? Yes No
Johnny 6,494 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sukrut,

I added just an infolog to see and nothing was displayed.

I'm using Standard LedgerJournalEntity

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,741 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

LedgerJournalEntity does set based operation , check if the set based operation is enabled on the entity . copyCustomStagingToTarget method gets called when you import through this entity , you can take a look at this method and see how records are inserted and updated and use COC to handle your scenario.

Was this reply helpful? Yes No
MATTGUO 22,353 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Johnny,

You need to use COC to extend the mapEntityToDataSource method,

I create a test field, and update LedgerJournalTRans table’s RCashDocRepresPersonId field with the test field.

Please refer to the following code:

[ExtensionOf(tableStr(LedgerJournalEntity))] final class LedgerJournalEntity_Extension { public void mapEntityToDataSource(DataEntityRuntimeContext entityCtx, DataEntityDataSourceRuntimeContext dataSourceCtx) { next mapEntityToDataSource(entityCtx, dataSourceCtx); if (dataSourceCtx.name() == "LedgerJournalTRans") { LedgerJournalTRans ds = dataSourceCtx.getBuffer(); ds.RCashDocRepresPersonId=this.test; } } }

Was this reply helpful? Yes No
fspafj 259 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi MATTGUO,

I am also trying to update value for a mandatory field xxx in the target data source by using a test field in the mapEntityToDataSource method similarly with your example code above.

However after importing the source file successfully into staging table, error occured while writing into target with below message:

Results.Field 'xxx' must be filled in.

Results.Validations failed while writing entity record.

I have built the project, model and synced database but the error still occured. What could be the reason for this error?

Thanks in advance.

Was this reply helpful? Yes No