Hi everyone! I'm working with data from our CRM system and modeling it in Power BI. I’ve encountered a structural issue between two tables: Ticket Contains a field called tags , which stores a foreign key array . The values in this field are text strings , not numeric IDs. Tags Contains a field called tags_id , which is the primary key . This PK is a numeric indexed field (clustered, unique). The problem is that the Ticket.tags field contains text-based identifiers, while the Tags.tags_id field is numeric. Because of this, it's not possible to create a direct relationship in Power BI between the two tables. I'm looking for guidance on: How the CRM system expects these fields to be related; Whether there is a missing mapping table or lookup logic; Or if there's a recommended method for converting the text values in Ticket.tags into the numeric tags_id values so they can be modeled properly in Power BI. Any insight into how these two fields are intended to connect would be greatly appreciated.

Hi, i have a field definied for contact the field is SuperOffice:43. By more contact are this field set to 44444. How can i make a SearchEngine, to give me, all the contact that have SuperOffice:43 = 44444 ? Have you got any Idea? Thanks

I have a simple flow which adds a person to a static selection when a person is added as a project member to a project. The flow works fine when you manually adds a project member. But when I do it by CRM-script, the flow doesn't trigger. I use the code below to add project memeber. Is this a bug? NSProjectAgent pAgent; NSProjectEntity project = pAgent.GetProjectEntity(16); NSProjectMember[] members = project.GetProjectMembers(); NSProjectMember pMember; pMember.SetProjectId(project.GetProjectId()); pMember.SetContactId(809); pMember.SetPersonId(1143); members.pushBack(pMember); project.SetProjectMembers(members);   project = pAgent.SaveProjectEntity(project);

I'm trying to up- and downloading documents using crm-script in Customer Portal. The files are big. 50-150 MB. I'm using "printBinary" when I'm downloading. And  "decodeBase64AsStream(base64)" and  "documentAgent.SetDocumentStream(....)" for creating document.   When it's above 50 MB I get " Script is taking too much memory" Is it possible to change the memory limit for a given tentant Id?    

Hello! I've recently come across a support ticket where certain users are unable to create a new contact. Reason being a trigger we created several years ago now throws an error. In this trigger we run NSNumberAllocationAgent.SaveCountRefEntity() in context of a user, but this only works for users with user level 0, We're not sure if the customer has done any changes to their users, or if the access rights for this method has changed with SuperOffice release 11.5?   Example code: #setLanguageLevel 4; NSNumberAllocationAgent numAllocAgent; NSRefCountEntity contactNumberEntity = numAllocAgent.GetRefCountEntity(96); // 96 = Contact number counter Integer incrementedNumber = contactNumberEntity.GetCurrentValue() + 1; // Save the incremented number to counter in database contactNumberEntity.SetCurrentValue(incrementedNumber); numAllocAgent.SaveRefCountEntity(contactNumberEntity); // This one fails!!   Throws error for users outside user level 0:

If im not mistaken, its standard to have E-marketing on the person card for mailings. I'm wondering how you can get/set these values from CRMScript. Been trying to read around the  person table , NSPerson , NSPersonAgent and NSPersonEntity classes, but not finding any useful information on it.

Is there a better way to get the personId of the current contact than using getCgiVariable("personId")? Lately this has become unstable and often returns the personId of a previously viewed user. The following script is run when a user clicks a button on either a contact card or a ticket/request. So what I need in the end is the x_personid, which is a custom field on person. #setLanguageLevel 4; Integer personId = getCgiVariable("personId").toInteger(); if (personId.isNull() == true || personId < 1) { setVariable("url", getProgramBlogic() + "&action=doScript&includeId=close"); } String externalPersonId; SearchEngine se; se.addField("person.x_personid"); se.addCriteria("person.person_id", "Equals", personId.toString()); if(se.select() > 0) externalPersonId = se.getField(0); if(externalPersonId.toInteger()>0) setVariable("url", "https://bn.app.local/Customer/Link/" + externalPersonId); else setVariable("url", getProgramBlogic() + "&action=doScript&includeId=close");