In the code of the UsrAccountInfoByTypeConverter you are trying to use the GetTypedColumnValue method in 81, 85 and 87 line and it's done incorrectly. You need to debug the code of the UsrAccountInfoByTypeConverter and check why the error is returned there (this should be related with types usage and columns from which data should be retrieved).
I am trying to import data into account address object. By default Creatio allows the records to map with account object by name column. I need to map using a custom column. When I manually add the Account ID column(GUID) and map it with the account lookup in account address its creating a new record with Creatio GUID as name and mapping the address records to it. How can this be achieved?
If I am understanding your issue correctly, you are importing from excel and trying to map the the Account.ID column but actually mapping to the Account.Name column, which means you're actually creating new records with the GUID as the name.
What you need to do is when mapping, click on "related objects", find "Account", then select "Id". Your map should read like the attached.
Hope that helps. Don't forget to select the "Id" as the unique field to import by.
Thanks for the response Harry. I have a custom ID column (Text ) in the detail table(Account Address) which I have to map to the main table(Account). I have already tried to follow the step you have mentioned for that custom column and tried to import but the import is not processing. And when I checked in the process log it has failed with the error " Terrasoft.Common.ItemNotFoundException: Column by path (prefix) not found in schema Account"
Just to clarify, so the issue is when you create an activity using an Online mode and switching to Offline, the activities you have created previously are not available in offline mode?
I added a new mailbox to our our Creatio on-prem instance and want to download emails from customized folders. I've selected this option but no folders are displaying. What could be causing this?
Most likely, the mailbox synchronization is unsuccessful, you can open the browser console on the Network tab, then open the mailbox settings, in "Network" you should see the GetMailboxFolders request that reads existing mailboxes from the mail server.
Check if this request completes successfully, if there are any problems, you will see the reason why the mailbox is not displayed in the "response" tab of the request.
You can also make sure that the synchronization is correct on the mailbox diagnostics page.
If the problem persists, please contact our support team at support@creatio.com.
Hi I keep getting an error trying to download Calculated Metrics For Creatio into Dev. My version is 8.05.2424. It says it works on version 7 and up. Is anyone else having this issue?
1) How is it possible to perform password import from Excel? When I add a column 'Password' to the Excel file import doesn't start.
I would like to import users, set some default password (the same for everyone or equal to username). Is it possible to do with Import, Process or SQL script?
2) How is it possible to send invitation email to all portal users imported from Excel? Can any Business process do that?
I cannot imagine how to make this manualy for hundreds users
As for importing the passwords, yes, it is possible. However the column cannot be named "Password". If you name the column in the Excel file "Passwd" or something other than Password, you can import the passwords. Also useful to check the box for reset password so they're prompted to change it from the default on first login.
You'll also need to import to Users in Roles to add them to All employees role as well, last I checked that doesn't happen automatically from an import of users.
As for an email of some kind, I don't recall if you can use a signal in a process for a record added to SysAdminUnit, however, you could do it from a signal from a record added in Contact where a SysAdminUnit record exists (with a Type=4) and trigger a process from that (since importing the user will also create the contact). I believe that would work, although I've not tried it.
As for importing the passwords, yes, it is possible. However the column cannot be named "Password". If you name the column in the Excel file "Passwd" or something other than Password, you can import the passwords. Also useful to check the box for reset password so they're prompted to change it from the default on first login.
You'll also need to import to Users in Roles to add them to All employees role as well, last I checked that doesn't happen automatically from an import of users.
As for an email of some kind, I don't recall if you can use a signal in a process for a record added to SysAdminUnit, however, you could do it from a signal from a record added in Contact where a SysAdminUnit record exists (with a Type=4) and trigger a process from that (since importing the user will also create the contact). I believe that would work, although I've not tried it.
However, the one thing you can't do from an import of users, is set their license. You'll have to do that manually after the import.
It's not so bad though, in the System Users section you can select all the imported users and then select "Grant license" from the Actions menu. You can also do it in the License Manager (add multiple users to a license at once)
We have multiple business units that have different pipeline stages. I can see how to create stages within the existing pipeline, but I can't see how to create separate pipelines with their own unique stages. Is that possible?
I'm wondering if anyone can help in how the system could give me a report (I'm currently attempting with the Excel Reports app).
Example:
I am looking to run a list of Companies with the columns as "Name" and "Total Contacts".
I want the "Total Contacts" to only include Contacts created in the last week.
I thought the logical way would be to use a section report for Companies. Then user Advanced filter to drilldown into Contacts table and filter by my criteria.
What that does is only show the companies who have had contacts created within the last week, but when I run the report, the value for "Total Contacts" = Total contacts of all time.
I'm trying to find a way to show a section folder tree by default when the user enters a section.
For instance, when users go to the [Accounts] or [Contacts] section, they'll see the folder tree by default on the section page, just like when users go to the [Process library] section or [Lookup] section, they see the Folder Tree for those sections displayed by default.
The tree will open by default if user once opened it in the section and left it opened when leaving the section (since this state of the folders is written in the SysProfileData table and selected by the system when user enters the section).
So the user should once open the folder tree and not close it.
To solve the problem, I wrote SQL Script to update the SysProfileData table record where the user's settings were stored when the user entered the section.
Does anyone know how long a cookie auth token is valid for, and is it best practice to call and create another one for each call to the API?
Also, is there anyway to request an Auth Token without having to use an email and password? It doesn't seem so safe to share this information with 3rd party systems (in my case, Make.com).
