Adding companies to Normalization Data Services?

[Jeff Pascoe]

We are trying to evaluate Normalization Data Services to help with our ever-sprawling list of companies in the core_company table.   It seems to work great for the companies that are in the list provided by the service, but we seem to have lots of companies that aren’t a part of that list and so they aren’t being normalized.   We don’t appear to have access to add new companies/company mappings to the published list, so how can we go about getting these additional companies normalized?  

[Mark Stanger]

You should be able to use the 'Normalized Company Names' and 'Normalize Mappings' links in your left nav to do this.  Just click 'Normalized Company Names' and then click 'New' from the list.

[Jeff Pascoe]

Hi Mark,

Thanks for the reply.   As an admin, I don't have the 'New' button on the Normalized Company Names list.  It appears the ACLs on this table limit creation to 'maint'.

I could certainly tweak the ACLs to allow me to add records to this table, but I'm afraid of the unintended consequences there, like what might happen when additional data is downloaded to that table from CDS.

Any further thoughts?

Jeff

[Mark Stanger · Accepted solution]

I'm running on a London instance so that's probably why the discrepancy.  The London instance security is opened up (I see the button with no modification) so I'm guessing this was just a temporary limitation or an oversight in a previous version.  You should have no problems overriding that ACL though.  I would be shocked if a future download wiped out your records but it's probably worth exporting the contents of that table to XML if you're worried about it - at least until you've upgraded to London.

Please mark my answer above as correct if I've answered your question.

[Abhishek Pidwa]

Hey Mark, 

This might be an old thread but I am trying to write some WRITE ACL for certain role users to go in and edit the normalized company names by themselves. Now even if I write the ACL , it is still showing as READ ONLY field. Upon reading the docs, it says admin role required to add/delete/edit company names.

When I turn on my security debug I do see ACL evaluated right but still it says X but everything looks good:

Any idea why this is happening ? Is it that only admin can go in and edit those ?