Finance | Project Operations, Human Resources, ...

Regarding Valid from in D365Fo

(0) Share

Report

Posted on by waytod365

351

Hi,

I want to while import if 'Valid from' and 'valid to' empty in excel.

I want to pick employment start date worker against same like also 'valid from'(max date).

Example:

My excel:-

[Worker no [valid from [Valid to

000020 [Null [Null

Once i import above excel i want to based on 20 against start date so that how to do in x ?

Below my code.

Note : toInsert is my custom table and has it relation in HcmWorker.

if(str2Date(range.get_Item(rowNo,2).Text, 123) == dateNull())
{
    toinsert.ValidFrom = //Here is how can i achive it ?
}
if(str2Date(range.get_Item(rowNo,3).Text, 123) == dateNull())
{
    toinsert.Validto = DateTimeUtil::maxValue(); // Max date is correct ?
}

Thanks

I have the same question (0)

All responses (9)

Answers (0)

waytod365 351 on at

Like (0)

Report

Correction : *same like also 'valid to'

Was this reply helpful? Yes No
Suggested answer

greengrimms 1,400 on at

Like (1)

Report
Hi,

So, if I understand correctly, you want to assign the Employment start date from the Worker to your Valid from field, right?

If that's the ask, then you can use Worker # in order to get Employee start date:

select HcmEmployment join hcmWorker where hcmWorker.RecId == HcmEmployment.Worker && hcmWorker.RecId == workerNbr //000020 worker you mentioned

And then assign HcmEmployment.ValidFrom to your table field.

Let me know if that answers your question.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi waytod365,

What exact date value do you want to use for the ValidFrom field? If you need an "empty" date, you can use DateTimeUtil::minValue().

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your replay mr.Danilo Bambi ,

I will tell you what i want exactly in Excel.

I have an one custom form.

As shown in the picture above, there is Worker no : 000001 against Valid from : 2/1/2006.

The standard HcmWorker form.

Worker no : 000001 against in the Employment history valid from 2/1/2006.

Note : in my custom form i did it manual entry.

The same process while import in excel and 'valid from' and 'valid to' null in excel column based on a worker against in the employment valid from date insert in my custom form valid from.

Now, i will go to import worker no :000011 in Employment history valid from (8/5/2009 12:00:00 AM)

The same valid from while import if valid from null same date i want.

My excel column:

Valid from , valid to is empty once imported 000011 record.

Then i will go to check my custom form. there is worker against in the emmployment history same to date insert or not.

So that how to write in x++ give me example for that.

Thanks for your attention.

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
Danino's approach is correct, only if I'm not mistaken, the same worker can have multiple records, you need to look at the active record. Or you can use the table's own method directly.

if(str2Date(range.get_Item(rowNo,2).Text, 123) == dateNull()) { toinsert.ValidFrom = HcmEmployment::getActiveEmploymentsByWorker(HcmWorker::findByPersonnelNumber("000020").RecId).ValidFrom;//Here is how can i achive it ? } if(str2Date(range.get_Item(rowNo,3).Text, 123) == dateNull()) { toinsert.Validto = DateTimeUtil::maxValue(); // Max date is correct ? }

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Sorry for the late replay sir,

I hope you'll be well and i remember in prayer turkey.

Thanks for your suggestion.

I noted 'valid from' and 'valid to' is mandatory in my table so that I changed little bit.

While import dialogue add new check box pick from employment if it’s = 'yes '

This check box valid for contract status.

How to do in if its 'yes' ?

thanks a lot for your time beforehand.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report
Sir,

I want to only contract status in check box so that i wrote a one code.

public boolean Fld2_1_modified() { FormComboBoxControl control = dialog.formRun().controlCallingMethod(); boolean isEmployments; isEmployments = control.modified(); if(isEmployments) { dialogEmployment.value(NoYes::No); if(control.selection()) { if(importTypes == ImportType::Contracts) { dialogEmployment.visible(true); } } } return isEmployments; }

As i mentioned above code i did it also getFromDialog()

ImportType = dialogImport.value();

But that modified not worker what am i missing ?

2. Once in the contract status and check box Yes.

Run method.

if (importTypes == ImportType::Contract) { if(IsEmployment.value() == noyes::Yes) { toInsert.validFrom = HcmEmployment::getActiveEmploymentsByWorker(HcmWorker::findByPersonnelNumber("000011").RecId).ValidFrom; toInsert.ValidTo = DateTimeUtil::MaxDate(); ToInsert.Insert(); } } //I'm wondering we need to insert (toinsert.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);) or only update ?

The second approach is correct ? let me know sir if anything missing.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Correction : Not working* in modified.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

I'm getting lost here. Your question was about getting a date from the employment. Now you are mixing up the question with a dialog issue. Can you let us know if the From date issue is solved?

Please create a new question if you have issues with a dialog.

Was this reply helpful? Yes No