Finance | Project Operations, Human Resources, ...

Fail to publish data on Excel-addin

(0) Share

Report

Posted on by Ett

533

Hi guys,

I tried to update Sell Price on Item Master via excel add-in. However, all records are failed to published and the error message does not help enough to find the solution.

Could you please advise what the exact error here?

Many thanks

Kylie

I have the same question (0)

All responses (11)

Answers (0)

Blue Wang on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

HI Kylie ,

Please try to Generate CIL.

Was this reply helpful? Yes No
Ett 533 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi Blue WANG,

I did Compile into.Net FrameworkCIL from System Admin and try to publish again, it doesnt work at all. I got same error.

Kylie

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi ETT,

You tried to update a lot of data (>2700 records).

Have you tried if the update works on a subset of them?

That is, can you update 1, 2 or 3 prices with the Excel addin?

If this does not work as well, then have a look at the data management framework and try using this one for your price update.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ett 533 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi Ludwig,

Thanks for your reply. I tried to update prices for some items, but the same error happened.

Please advise me which entity is suitable to import item price.

Many thanks

Ett

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hello ETT,

Can you check which data entity is showing in excel add-ins for uploading the item sale price? Is it "Released products V2" entity or anything else?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi Ett,

So, the upload did not work at all.

Can you provide more details how you tried doing the upload? What entity you used and how you prepared your data?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hello ETT,

Couple of suggestions already provided on this thread.

Appreciate if you kindly go through and update the status in the Forum.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Ett 533 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi ALL,

I uploaded Item sell price via DIXF, Entity name: Item.

My data include: DisplayProductNumber, Itemid, SalesPrice, Date, SalesPriceUnit.

It worked well, price is updated. However, other previous setup at Item level such as Tracking dimension, ProductDimension and Searchname have gone. That's is terrible. Luckily I only work on Test and Dev.

Do you guy know whether is a safer way to upload price?

Ett

Many thanks

Was this reply helpful? Yes No
Ett 533 on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

I prepared data as follow. However, after I uploaded these data, other Item configurations such as Tracking dimension, search name have gone.

Can anyone explain me and let me know the solution?

Many thanks

Ett

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fail to publish data on Excel-addin

Hi Ett,

Do you make use of trade agreements?

It might be an option to upload the prices into this form then there is no direct touchpoint to the item form/tables.

Best regards,

Ludwig

Was this reply helpful? Yes No