Data entity for Excel add-in with Table, Category, Group and All column

(0) Share

Report

Posted on by Abhinay Tharwal

1,244

Hi,

Greetings and thank you for reading this post!

I have created a data entity for editing the records in Excel add-in.

I have a column of enum type TableGroupCategoryAll.

For the TableGroupCategoryAll::Category records to edit, I added EcoResCaegory table on the data source with property IsReadyOnly set to Yes and correct relation.

The I added the Name and CategoryHierarchy fields from the EcoResCaegory datasoruce to the fields, key and autoreport nodes.

I am able to read, create records. But when I try to delete any non category records, I get error message:

Error message: 'No resources were found when selecting for update.'

To debug this, I added the delete, write, validateWrite methods on the data entity, but the debugger won't stop on any of these methods.

(I had attached the iisexpress.exe service)

Any suggestions?

Best regards,

Abhinay

I have the same question (0)

All responses (4)

Answers (1)

Sort by

huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

Hi Abhinay,

There are two ways to delete excel add-in data, the first one is to delete the data from the add-in as you mentioned and then refresh the list. The second method is that you can use DMF to export the template, then delete the specified data in the template and re-import the entity data, it should be noted that you need to check the truncate entity data on the form, so that the data from the previous template will be automatically deleted. Of course, you can't rule out some situations that the primary data cannot be deleted due to data consistency requirements.

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Judy,

Thank you for your reply.

The requirement is specifically for the Excel add-in.

//BR, Abhinay

Was this reply helpful? Yes No
Verified answer

huijij 19,813 on at

Like (1)

Report
Copy link

Link copied!

You can refer to similar issues, and it's possible that it was designed that way. However, if you want to figure out the root cause exactly, it is recommended that you raise a ticket with Microsoft.

Was this reply helpful? Yes No
Suggested answer

Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The issue was the additional fields added to the entity key (EcoResCaegory: Name, CategoryHierarchy). I removed them and it worked fine.

To view these columns, users will have to go to the design in Excel and add them from the list of available columns.

I hope this helps.

//BR, Abhinay

Was this reply helpful? Yes No