Questions & Conversations

When I use cubes with a time dimension, I often have to add empty entries for a time dimension (e.g. dates, weeks or months). This gives a better view in time.  Is there a solution in the model to extend the time dimension with missing entries?  

Showing email messages with the previewer is a very nice feature, exept this message which appears before a message can be previewed.  In our scenario msg files are saved in a shared network folder.Any ideas on how to get rid of this warning? I hope there is a way to do this, without changing settings in the Trust Center of Outlook/Office.  

In IAM it is possible to specify environment specific settings (similar to app.config in C#). See Authorization >> Applications >> Properties. Is it possible to encrypt fields here (e.g. in case of a security token or password?)

Hi, is there something changed in call_web function? When we try to start  some websites, for example www.thinkwisesoftware.com we get an error "The request was aborted: Could not create SSL/TLS secure channel."  Other websites don’t (www.google.com, www.nu.nl)  ​​call_web www.thinkwisesoftware.comon www.nu.nl it’s working fine: c# - The request was aborted: Could not create SSL/TLS secure channel - Stack Overflowor do I have to change something on our server? We have 4.7.2 installed Any idea or suggestion?

Hi,I've made a process flow where users can assign multiple groups to an article. The flow starts with a task (nr 1) with several task parameters, the output values are bounded to process variables. I want to use these variables later in the flow when task 2 is executed.The flow goes through a list of articles, and in the detail tab the user can assign multiple groups (in the step ‘Grid edit’) to that article, with a checkbox.What I want is that task 2 is executed after the user left the grid edit-mode, but at this moment the task is executed immediately after starting the flow.Is it possible to ‘wait’ until the user left the Grid Edit-mode or how do I achieve this?I'm quite new to process flows, so maybe this isn't logically built at all.. 

Hi,How can I overcome this error that happen on some tables but not all - without altering the current code (i.e. expression fields from the table) or the datamodel:It looks like the query is that is behind the load task has been shortened/truncated/cut-offrgds Ricky 

I'm trying to convert some trigger logic to default logic, because I would like to use the 'system versioned tables'. Having triggers causes a lot of records in the history table, which isn't necessary.I'm currently using a trigger to update the 'update_user' and 'update_date_time', and also an update_counter for preventing concurrent editing. I've tried to set up a default which sets the update_user and update_date_time. Problem is that it's only fired when a column has default logic enabled and the value is changed. What I want is that the default is also triggered when the user starts editing. Or maybe after he's done editing. Then I would like to update the update user / datetime. When inserting a record this happens (e.g. @cursor_from_col_id is null), but when editing it isn't.A work around is passing all table columns to the default, but I don't want this because it's unneccesary and a performance killer.Any suggestions on this case, preventing unneccesary records in the history

For our customer we have to adjust a string. This requires a DLL written in C# that we want to deploy on an AWS RDS SQL server. Is this possible and how do I go about doing this with safety in mind?For parsing a barcode text field into information useful to the client, the DLL is written in C#. If the above is not possible, please provide an alternative. Thank you.

I would like to export a SF project with version 2021.1 and import it on another SF (on another system) with version 2021.2. What is the easiest way to accomplish this? I have read the article about the stored procedure (copy_project_vrs). But it seems this only works with the same SF version: 

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalThe goal of this solution is to automatically add trace fields to all tables so the user can see who added the record or who made the last change. This solution adds these fields to a separate tab page on a form. This looks like this in the GUI:  You can choose at what moment you want the fields to be filled: During editing or after saving the record.SolutionThe solution consists of code for Dynamic Model (for adding the fields) and two Control Procedures (for filling the fields). Depending on the moment you want the fields to be filled (during editing or after saving), you can choose  either for a control procedure for defaults or for a control procedure for triggers.Dynamic model add_trace_columnsThis code adds trace columns to every table.The trace fields are: update_user update_date_time insert_user insert_date_time If you add the tag 'no_trace' to a table, no trace columns

Good morning, I would like to have a conditional layout in a variant of a subject. With a default subject template, I would go to Subjects > Default > select the relevant subject > Data > Conditional layouts. However, with Variants, there is no option for Conditional layouts in the Data tab. My current workaround is to create a view that contains the same data as the variant I want a conditional layout for, then set that view as a detail of the Default subject. This is quite unpractical, and I feel like I should be able to set a conditional layout in a variant. Is this at all possible?Edit: I just found out that I can create a Conditional layout in the Default, then enable or disable this layout in the Variant.

When creating a new azure database from the creation menu it's automatically created in the highest pricing tier. This is since the Create database query uses the default gen5 tier.There seems to be no way to set a default pricing tier in azure. But you can use a parameter with the create database query to set the pricing tier.Is there any way to set the default pricing tier in the SF or fill in the service_objective parameter of the create database query?Related topic on microsoft forums: https://social.msdn.microsoft.com/Forums/en-US/fd294936-06fa-4c23-aa11-d0b6836df56e/set-the-default-pricing-tier-for-newly-created-databases?forum=ssdsgetstarted 

Hello,i’m configuring Indicium (2021.2) on Windows Server 2019 with IIS 10.I’ve copy the Indicum folder and created the application pool. When I test Indicium page i get the error 500.19 : the page configuration data is invalid 

In indicium-Universal there is the possibility to run System-flows in the backgroundSometimes these System flows will run for sometime, (minutes or longer).If we need to stop the system (par example for deployments), I have to be sure there is no System-flow running. Therefor I need the following functions:1.    A way to tell Indicum-universal not to start new tasksIs the way to achieve this to run the task: ‘Disable schedule’ ?http://acto-D-upgradetest-EVO.acto.nl/indicium/api/20/disable_schedule Input Parameters:  {  "project_id": "EVO",  "project_vrs_id": "7.05",  "gui_appl_id": 26,  "process_flow_id": "create_iam_user"}2.    A way to find out whether there is still a task running.Can you tell me how to do this?3.    A way to tell Indicum-universal to start new tasksIs the way to achieve this to run the task: ‘reset_system_flow_schedule’ ?http://acto-D-upgradetest-EVO.acto.nl/indicium/api/20/reset_system_flow_schedule Input Parameters:  {  "project_id": "EVO",  "project_vrs_id": "7.

We currently use SF/IAM version 2020.2… Due to a lack of time, there hasn't been time to upgrade to a more recent version. I've downloaded version 2020.2 to see if it somewhere tells me I can't skip a version (just for checking).My question: is there a check in twdeployerGUI.exe on the version that is currently running and does twdeployerGUI.exe take care of what needs to be done to skip (in this case) one release?I can of course do an upgrade and see if it fails, but I'd rather know that it is possible…..

When accessing the Universal GUI from the web browser, Windows authentication is first requested. Only after ignoring (canceling) this pop-up will you arrive at the login screen.How can we get rid of the first pop-up?   

One of our strategic goals is to completing the DEVOPS spirit of working @Acto in an Agile way of thinking. This means that most of the complete development cycle has to be automated DevOps software lifecycle management @ActoCurrently one of our projects is working on automating and speeding up the biggest part of the generation of the deploy package, one could say that these are the steps between Build and Test, which currently takes about 3 to 6 hours for each cycle (without testing, just generating). Our goal is to have several cycles a day if not many more, which of course can only be achieved when (almost) fully automated   We want everything that can be automated to be automated. We want it to run mainly in the background.   It would be helpful if the whole thing could be automated by Thinkwise  – but until then, there are things we can do ourselves, but for certain parts we are unable to automate them in the process of creating a deploy package.   The process consists out

We're looking for methods to improve our build automation with the SF. We think we do a lot of manual and repeating tasks / labour which could be automated. I'm not sure if what is already possible, or is a feature request. I'd like to hear some thoughts and experiences of other users. As ISV we have experience with build automation, using tooling like Atlassian Bamboo, Jenkins, Azure DevOps etc to automate processes. But with the SF platform this is kind of new.For each release / merge we do exactly the same steps, which are all prone to fail because of manual labour. Once we have the deployment package, we're good: We can push this package to a GIT repository and pick it up for testing installation- and upgrade script, synchronization with IAM, running automated UI tests etc.But before you have the deployment package you need to do some steps;Merge the branch into the trunk  Run the validations  Execute unit tests Create the deployment packageWhat we want to achieve is that those ste

Hi,as far as I can see now, it’s not possible to have any control over the Badge value. Is this correct? For instance, i show total number of items. But when I turn on my prefilter ‘sold items’, I want the badge_value to show the total value that matches with the corresponding prefilter. Am I missing a thing, or is there a way to get this done? 

We are sending e-mail to users with 2FA. However, sometimes these emails are sent using correct html  and sometimes they are sent as plain text. See both images for the difference. Both have been sent on the same day, different users, from the same email provider using the same application and therefore also the same configuration.Where does this behaviour come from? Do I have to look at the email provider, our system administrators or is it something within the TW application? We are using Office365, TW platform 2021.2, webgui 2021.2.17 all hotfixes applied until 20211001 - Exclude deeplink process flows.    

Where can I find the maximum size of the logo on the login page of the web GUI? I can’t seem to find it anywhere in the documentation or in the software factory.

Apparently when select another record in a list with details on the right forces a DELETE ERROR according to/in the developer tool We never triggered a delete, we never clicked on delete, we never commanded a delete but it clutters the error list as if we’ve done something wrong as a developer.How can we overcome this invalid error in the developertools and extra network traffic?rgds Ricky

When I use the combined filter (search) functionality to filter a list of items, I would like to have the option to use an accent insensitive search. For example, when I want to find all items that contain the word “Citroën”, I want to be able to find those items by searching with the term “citroen”. Is there any way to enable this using the SF currently, and, if so, where do I find it? I would expect to find it in the subjects → data → search detail tab.

When I select my row, it gets due to the theme a brown color. However, some rows have color coding with the Conditional Layout. For instance, when an invoice is final, I make it green. But when I select this row, the them goes on top of the row, not showing the green anymore. Is it possible to changes this; so that the green is always shown?Edit; it works with only 1 column made green, but not the whole row. Is this correct?

In order to make targeted improvements to the performance of the application, I investigate which actions take the most time.I've found that there is a field 'duration_ms' in the table 'use_log_usr_action' in the IAM database for that. However, the field contains no data.Is this field created for future features or should an specific option/property be set for it?