Finance | Project Operations, Human Resources, ...

Reading Enum From Excelsheet

(0) Share

Report

Posted on by Ram Kumar

454

I am having a Table named as M_Account . This table has 4 Fields. the Fourth field is a Enum Field named as Resource Category . In a Excel Sheet There are Four fields as same as M_Account Table. I have to Read the Enum Field from excel sheet and i have to Insert that Enum Data into the M_Account Table .

_rescat = str2enum(cells.item(row,4).value().bStr());

I am facing an error wrong number of arguments has been specified for the method .

Please give the solution for me and i am new to AX.

Thanks in Advance,

Ram.

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ram,

The data import/export framework is able to read Excel files and do the import for you which also takes enum fields in consideration. Have you had a look at this framework? Or what is the reason that you started developing something with x++ coding? What is the business process here?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

I suggest you use standard data entities, then you don't have to think about such things at all.

Anyway, if you want to convert string to enum, please continue reading.

When you type "str2Enum(" you see the tooltip which says you must provide two parameters: enum type and the text. This is very important information for a developer so it's good to get familiar with utilizing such documentation that is provided you during development.

Having to provide the enum type is quite obvious, because otherwise there would not be enough information for the conversion. Many enums might have options that have the same name. So how would the system know which enum it is, unless you tell it?

For example, to convert text "Invoiced" into SalesStatus enum value "Invoiced", you call str2enum(SalesStatus, "Invoiced"). Is it now clear?

Was this reply helpful? Yes No
Ram Kumar 454 on at

Like (0)

Report

Hi André,

This is my Spreadsheet the last field is an Enum in my table i have to read that data from the spreadsheet and i have to store that in a variable. All the other fields in my table are String fields.

_accountstruct = cells.item(row, 2).value().bStr();
_expcat = cells.item(row, 3).value().bStr();

_rescat = str2enum(cells.item(row,4).value().bStr());

Here i succesfully Readed the data for the String fields and i stored in a string variable . But i can't able to read the Res_Cat field from the spreadsheet and store in a enum variable .

I need syntax for the code to read the data from the spreadsheet and to store in an enum variable .

Thanks in advance,

Ram.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Ram, I think I provided you the solution in my previous post above. Did you not notice it?

Was this reply helpful? Yes No