I have been struggling to find the table link that will let me list all of the attributes that are listed on an Item Class.
The INItemClass table has this beautiful field called ItemClassStrID which is a direct match to the EntityClassID on the CSAttributeGroup table.
Using this relation would solve all my problem, but the ItemClassStrID field isn’t available to use as a relation data field.
Does anyone have a GI that lists the Attributes on an Item Class?
Thank You!
Page 1 / 1
Hi @donnadeskins55
Please see attached
AMAZING!!
Thank you @manikantad18 !
@manikantad18 , I have a followup question for you (I see that you have provided a lot of helpful information around attributes and imports ).
My ultimate goal with this inquiry is to make changes or delete the Attributes on the Item Classes with an import scenario.
I have a customer with 630 item classes and each one has up to 10 attributes on it.
I have been successful adding the attributes with an import scenario, but have not been successful with updating or deleting the Attributes from the Item class with an import scenario.
Do you have any suggestions or examples for updating and deleting?
Thank you!
Hi @donnadeskins55 I have sample Import scenario to Update the attribute in Items class. Please modify as needed
Thank you @manikantad18 !
I think I saw this example on another post and when I tried it, it behaves like it want’s to add a new ItemClass/Attribute rather than update it.
Here is what the Import looks like (I’m attempting to set the status to inactive so that I can delete a particular attribute):
and this is the error I get when trying to run it:
@donnadeskins55 Hello, these errors may be linked to the fields in the data provider. I suggest checking the source fields for the data provider to see if the fields mentioned in the error message are marked as active. If they are, include the missing fields in the import scenario, or mark them as inactive if you decide you do not need them in the import scenario. I hope this helps with troubleshooting the error.
Hi @manikantad18 .
I have tried to follow the Get Item Class html file but am missing something. Your guidance would be greatly appreciated.
I must be missing a table or a relations between tables or both.
@RoslynRule you probably don’t need this anymore, but since I just landed here looking for an answer, it is