Dynamics Community Forum Thread Details

DIEF - Error occurred while doing bulk copy from temp table to entity table..

Hello, people,
My question is - how to make DIEF work for you?
What I want to achieve is: import Quantities into InventItem/Purch/Sales/Invent/Setup and maybe DefaultOrderType (into InventItemSetupSupplyType) for an item. For many items.
I found standard entities for importing data into these three tables. Nothing happened (except for the ColumnMapping error). I tried to duplicate and modify DMFProductEntity Table, in order to combine all the data I have to import in one table. Created fields like InventItemInventSetup_LowestQty, InventItemPurchSetup_HighestQty .. and so on for each quantity field, also - InventDimId, InventDimIdDefault for each of these tables. Then I created new entity using this new table, mapped the fields, corrected the data types. I could preview the file(*CSV), everything looked ok. But when I try to run Staging data execution I get the error:
"Error occurred while doing bulk copy from temp table to entity table-The given ColumnMapping does not match up with any column in the source or destination."
But the validation is ok: "'InventItemSetup' entity is validated for data import/export". And I have validated the entity before using it. The fields from my template are exactly the same as the ones in the table. This is the first time I'm using DIEF and I'm really confused. I read about the case sensitivity, problematic fields like partition, recId, dataArea and so on, but I'm not even allowed to use them when I'm importing (which I think is normal). Probably I'm missing something essential or really basic, but the time is running out.
If someone has any clue what the problem might be, I'd be glad to hear it! :)

Quick Links

Leaderboard