Copying table records to duplicate table (date() / buf2buf)

(0) Share

Report

Posted on by Ashein

275

Hi everyone

I am trying to copy records from inventTable to my duplicateInventTable. But when i try, my duplicate table ends up being filled up with empty records.

I have tried to use buf2buf but when i create/duplicate inventTable it ends allocating new fieldId's so i can't use it.

And when i use data(), it just fills my duplicate table with empty records.

Please help.

4212.1.png

7026.2.png

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Crispin John Augustine 37,081 on at

Like (0)

Report

Hi,

Try a manual field assignment for the mandatory fields (instead of using data()) and check if it is importing.

Was this reply helpful? Yes No
Ashein 275 on at

Like (1)

Report

I have checked, and then it works. But i am trying to do it without manual field assignment. Because of all the fields that exist in InventTable

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

Hi Ashein,

The buf2buf() and data() methods are intended to be used on the same table. You can try to use a table Map object where you can link fields of various tables.

More information can be found here: msdn.microsoft.com/.../bb278211.aspx

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report

I get what you think. (based on same field name)

The system understands based on fieldIds.

Was this reply helpful? Yes No
Ashein 275 on at

Like (0)

Report

But if i use maps, then i would have to manually map every field to each table?

Was this reply helpful? Yes No
Ashein 275 on at

Like (0)

Report

Crispin, so i should compare each fieldId from both tables?

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

Like (0)

Report

Hi Ashein,

The map is an AOT object where you define the mapping once. Yes, you have to manually map it. You can write an own routine to search field ID's based on field names, but that would also be quite cumbersome.

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report

No, comparing fieldIds will only complicate things. I just wanted to point out that only manual assignment works with your code.

Andre's suggestion to use a Map is your best available standard AX option.

Was this reply helpful? Yes No
Ashein 275 on at

Like (0)

Report

Ok, thanks. I just thougth there were and easier way to do it.

Was this reply helpful? Yes No
Brian Kinser 815 on at

Like (0)

Report

a little late but.....would buf2buf by name work? I have used this successfully in the past for archiving and logging....basically just like buf2buf but use field names instead

static void buf2BufByName(Common _from, Common _to)
{
DictTable dictTableFrom = new DictTable(_from.TableId);
DictTable dictTableTo = new DictTable(_to.TableId);
DictField dictFieldFrom;
FieldId fieldIdFrom = dictTableFrom.fieldNext(0);
FieldId fieldIdTo
;

while (fieldIdFrom && ! isSysId(fieldIdFrom))
{
dictFieldFrom = new DictField(_from.TableId, fieldIdFrom);

if(dictFieldFrom)
{
fieldIdTo = dictTableTo.fieldName2Id(dictFieldFrom.name());

if(fieldIdTo)
_to.(fieldIdTo) = _from.(fieldIdFrom);
}

fieldIdFrom = dictTableFrom.fieldNext(fieldIdFrom);
}
}

1 people found this reply helpful.

Was this reply helpful? Yes No

Community site session details

Copying table records to duplicate table (date() / buf2buf)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Copying table records to duplicate table (date() / buf2buf)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates