Microsoft Dynamics AX (Archived)

Container insert as table reocrds

(0) Share

Report

Posted on by OrangeRocks

700

I have the following question:

I need to insert 300 records into a table where each record contains two fields:

basically like this:

	Field 1	Field 2
1	Basti	Leffert
2	Sebi	Semmi
3	Andi	Leffi
...
300	Kara	Nesti

The 300 records a written in MS Excel. How do I do that?

I could work with containers: I use Excel to insert the records into a container and then in my job in AX

myContainer1=conpoke(myContainer1,1,"Basti","Leffert" );

myTable.Name = conpeek(myContainer1, 1);

myTable.Surname = conpeek(myContainer1, 2);

myTable.doInsert();

But I was wondering if there is a possibility that the name of my container is changeable, so I can put it in a loop, like an array type, or smth:

for ( myContainer[i] =1; i < 300; i++ )

{

myTable.Name = conpeek(myContainer[i], 1);

myTable.Surname = conpeek(myContainer[i], 2);

myTable.doInsert();

}

I use AX 2009

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (1)

Verified answer

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

Like (1)

Report

What's the advantage of putting values into container first instead of to the table directly?

I would expect you to iterate the lines in Excel, reading the two values and inserting them into your table.

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (1)

Report

If you really want to see database hit performance while inserting records into table after reading it from excel. You can use record_InsertList to make only one database call to insert records, container is not going to help you there I wonder.

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

Hi Martin,

"What's the advantage of putting values into container " -

I see the advantage at naming the values, so I dont need to copy them manually.

I am afraid I dont quite understand what do you mean by iterating the lines in Excel? I dont have a connection to the Excel Sheet whatsoever. But I can copy the things I have in the excel sheet to my job in AX.

How would you solve it then?

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

thank you, i guess I can use records_insertlist

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

Like (0)

Report

If you have the data in Excel, you must read them somehow...

Don't let me guess and please explain how you do it.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

It seems like you are not aware of the possibility to read excel files:

http://axpedia.blogspot.de/2013/02/import-from-excel-file-using-x-in-ax.html

And for csv:

http://axaptacorner.blogspot.de/2012/09/how-to-read-csv-files-in-ax-2012.html

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

I read them with the copy+paste from excel to the job in AX

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Oh dear....please use the code from the links I provided to read the file line by line.

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

Like (0)

Report

Wouldn't it be better to get rid of the the manual step of copy/paste? It sounds highly inefficient.

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

;)

thanks for help, I am trying your solution.

I have AX 2009 though.

Was this reply helpful? Yes No