9 thoughts on “Import WBS (Work Breakdown Structure) into D365FO project quotation”
Yuri Rusanovsaid:
Hello,
I have an issue with Excel template and the mapping configuration between file and model. In my case when i try to import Excel file with data base on template, D365 return me parsing error.
Error message:
Evaluating expression for path ‘model/MAIN_RecList’.
A parsing error in the format component ‘Cell: Real’: Input string was not in a correct format..
Error while evaluating expression for path ‘format/MAIN_RecList/MAINTable’.
Can you help me for this error, or can you send me the configuration files from video tutorial to analyze the configurations
Hello Yuri,
The error indicates that there is an issue with one of the numbers that you entered. Please check the decimal separator that you used and that all fields that can contain a number (hours, cost, sales prices, etc.) actually contain a number and are not left empty.
Best regards,
Ludwig
Thank you for the very detailled explanations in this video !
Had it in my todo list for a while, and I finally managed to make it works on recent D365 updates (10.0.27)
I only have one issue left on CBS roles lines : my guess is that I do not manage well empty values (especially Items and fees transactions types that do not need resource role) and it blocks the import of such lines.
How would you advise to handle “empty values” checks for datas that do not need these ?
Hi Castille,
I would probably configure the ER model mapping in a way that values that are filled in the Excel sheet but that should not import anything result in a ‘blank’ / ’empty’ result in F&O.
Have you tried doing that?
Best regards,
Ludwig
Thank you for the quick reply, I did managed such rule in the mapping for values in Excel that I do not want in F&O.
My main issue is from the other side : when there is no value in Excel for the “Resource Role” (for example on items CBS’ line), the model mapping is rejecting the lines.
I can’t find where to manage the “allow empty value for Resource Role if type is not Hour” rule in the model mapping, because of the used filtered view that have a string input / RecID output for the mapping.
Hi Castille,
If there is no value in the excel file, wouldn’t a simple if/then/else formula do the job? Something like if … a blank / no value is imported … then enter 0 … else … enter what you have in Excel?!
Regards,
Ludwig
I just tested to do so at each level of the model mapping formulas for this precise field (excel (string) to view, view to CBS field (RecID)), i think I found the root cause of my issue.
Problem is not the test, but the false condition return: I’m not setting a correct value in the last mapping formula (Veiw to field) when source excel field was empty.
I’ll check how map an “empty RecID” with ER.
If(transaction type = hour,
CBS.RecID = View.RecID,
>Empty(RecIDformat)<
)
Many thanks for your help and patience !
Regards,
Vincent
Dynamics 365FO/AX Finance & Controlling 
Hello,
I have an issue with Excel template and the mapping configuration between file and model. In my case when i try to import Excel file with data base on template, D365 return me parsing error.
Error message:
Evaluating expression for path ‘model/MAIN_RecList’.
A parsing error in the format component ‘Cell: Real’: Input string was not in a correct format..
Error while evaluating expression for path ‘format/MAIN_RecList/MAINTable’.
Can you help me for this error, or can you send me the configuration files from video tutorial to analyze the configurations
Best regards,
Yuri Rusanov
LikeLike
Hello Yuri,
The error indicates that there is an issue with one of the numbers that you entered. Please check the decimal separator that you used and that all fields that can contain a number (hours, cost, sales prices, etc.) actually contain a number and are not left empty.
Best regards,
Ludwig
LikeLike
Hello,
Thanks a lot for these two videos about ER and WBS import.
LikeLike
Two more to come with some cool PowerApp features 😉
LikeLike
Hello,
Thank you for the very detailled explanations in this video !
Had it in my todo list for a while, and I finally managed to make it works on recent D365 updates (10.0.27)
I only have one issue left on CBS roles lines : my guess is that I do not manage well empty values (especially Items and fees transactions types that do not need resource role) and it blocks the import of such lines.
How would you advise to handle “empty values” checks for datas that do not need these ?
Many thanks for the reply,
LikeLike
Hi Castille,
I would probably configure the ER model mapping in a way that values that are filled in the Excel sheet but that should not import anything result in a ‘blank’ / ’empty’ result in F&O.
Have you tried doing that?
Best regards,
Ludwig
LikeLike
Hi Ludwig,
Thank you for the quick reply, I did managed such rule in the mapping for values in Excel that I do not want in F&O.
My main issue is from the other side : when there is no value in Excel for the “Resource Role” (for example on items CBS’ line), the model mapping is rejecting the lines.
I can’t find where to manage the “allow empty value for Resource Role if type is not Hour” rule in the model mapping, because of the used filtered view that have a string input / RecID output for the mapping.
Regards,
LikeLike
Hi Castille,
If there is no value in the excel file, wouldn’t a simple if/then/else formula do the job? Something like if … a blank / no value is imported … then enter 0 … else … enter what you have in Excel?!
Regards,
Ludwig
LikeLike
Hi Ludwig,
I just tested to do so at each level of the model mapping formulas for this precise field (excel (string) to view, view to CBS field (RecID)), i think I found the root cause of my issue.
Problem is not the test, but the false condition return: I’m not setting a correct value in the last mapping formula (Veiw to field) when source excel field was empty.
I’ll check how map an “empty RecID” with ER.
If(transaction type = hour,
CBS.RecID = View.RecID,
>Empty(RecIDformat)<
)
Many thanks for your help and patience !
Regards,
Vincent
LikeLike