Parsing string to csv and passing it to List Control

(0) Share

Report

Posted on by Community Member

Hi All,

I have a string returned by API which I need to parse to csv or any other format supported by List Box (or List View) and display on Form.

How to parse string to csv in X++?

However, I didn't find much info about List Box or List View so would appreciate your help in choosing right control and examples how to pass data to it.

Thank you!

I have the same question (0)

All responses (14)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You don't need a CSV when setting up a ListBox or ListView, so there's no need to parse text into CSV.

Did you mean that the API returns a CSV and you want to populate a ListBox/ListView with the values from the CSV?

If yes, you could cast the CSV into a container with str2con function, and then iterate the container to add elements to ListBox or ListView.

If no, then you need to let us know the format of the information that you get from the API.

I found a lot of examples of ListView and ListBox by web search, here's one: axbeginners.blogspot.com/.../listviewcontrol-in-dynamics-ax.html

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

You can't parse text to CSV. CSV is a text format, therefore you can either parse CSV text to something you can work with, or you can take data and serialize it to CSV.

Also, you can't simply pass CSV to those form controls, therefore your design wouldn't work.

Before we can tell you how you can parse the string returned by the API, you'll have to tell which format it's using.

A better option than using List Box or List View controls may be putting the data to a temporary table and displaying it in a grid.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have str variable which looks like usual CSV seperetad by comma

"Header1", "Header2", "Header3"

"Value1", "Value2", "Value3"

... ... ...

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

So, you have a CSV.

Then you can follow the approach that I suggested in my earlier message (as mentioned in that message).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for help!

I saw the article you sent but didn't find how to add multiple columns and data to them

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

If you need multiple columns, the right type of control is grid. As I mentioned, you can insert records with the data into a temporary table and use this temporary table as the data source of a grid.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So, List View doesn't support multiple columns, right?

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

It does - you can use addColumn() method.

But there is a reason why grids, rather then list views, are normally used for showing tabular data. For example, they allow users to easily sort and filter data.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have a requirement to use list.

When we do addColumn() method how then we insert data to different columns?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report
A requirement? Why? What's the business requirement leading to this technical requirement? What if I confirmed your statement that it can't be done? Would it still be a requirement? Would you tell the client that showing the data is impossible, or would you accept that the type of control is an implementation detail and you can implement the business requirement in different ways?

Anyway, this is an example how you can create multiple columns in a list view and set some values:

listView.addColumn(1, new FormListColumn("First")); listView.addColumn(2, new FormListColumn("Second")); FormListItem item = new FormListItem(); int idx = listView.addItem(item); listView.setText(idx, "Value A", 0); listView.setText(idx, "Value B", 1);

Was this reply helpful? Yes No