Questions & Conversations

Hi,Is it possible to gather data then generate, export and download an .xml file by executing a task in Web GUI?Thanks!

Hi,Initially I thought you can’t create/use folders on azure file storage. So, now I place all files in de root. How can I make it like this, that I create a shipment, it creates a folder on the file storage. And that files are placed in that folder, when uploaded. I thought that SF didn’t support folder structure, but I heard it does.. so.. anyone can clarify this? 

 I need to filter the data based on the user role .An employee has more items ,but each employee has his own set of items .For example if the user is logged as an employee ,I would like to see the specific items for this employee . How I should approach this problem?

Hi, I’ve created a new Azure Storage. In IAM I’ve set the Storage name + KEY as credentials. They appear bold - I assume due to that they differ from the runtime config version from SF -. When I upload a file in my form (web gui); It shows no error and the path in the db is correct (https://NAME.file.core.windows.net:443/ff-uploads/)But, there is no filename and it is not uploaded to the file storage. It’s in limbo sort of. What is causing this? And how to fix this. 

Hello, So I have 2 tasks on two different tables. I have an id on the first table and I want pass it as a parameter on the second task, I do not have a column for the id in the second table. I tried to put it as an output in a process flow but it's taking the id as null.As you can see in the images below in the first task I have the current_id but in the second one is null. This is the first taskThis is the second task 

Hi all,I am trying to import data using a excel sheet in Universal GUI, but am running into a problem where the existing records won’t update. Context: importing data in a detail screen.Steps taken:export data using option “Export immediately” changing some fields in excel > save excel sheet import using the “Import (update existing rows)” option. Also noticed that it doesn’t update but rather add the rows again.Please help! Thanks

Hi, We are trying to implement dragging and dropping of records in a view to change the order of the records.This particular view has 2 primary keys:slaughterherd_id supplyherd_idAs per:In tasks I've created a task and added 4 task parameters: I added the task to the appropriate view and filled the first 2 task parameters: In Subjects I set the following: 

I create a DevExpress report using a stored procedure. I have 2 parameters with the actual value NULL: Somehow the report tries to execute the stored procedure with a value of -1 instead of NULL:  I checked the NULL value allowed checkbox in DevExpress, so that should not be a problem I think. What am I doing wrong here? SF 2022.1 ; DevExpress 1.40

When I am exporting to Excel from a grid view, the currency fields are displayed in Excel with a $ sign. How can I control this? Extended properties of the application are set to "UseWindowsCulture”. However no matter what kind of language settings in Windows I change, I do not succeed to display the € in Excel. The cell property in Excel is set to $ #.##0,000 during export. While the currency setting in Excel is set to display € sign. 

At this moment we are trying to implement unit testing in our process. However, we encounter several problems.The biggest problem we encounter is preparing the mock data, because it’s very time consuming. Is there anyone who could explain me what would be best practice for inserting mock data in the Software Factory. What we experience is that it is difficult and not user friendly to insert data values into a data row. It costs us a lot of time to insert this data, and it is not very clear what foreign keys are of the table and the domains  of the values. So, all tips and best practices would be very helpful.  

I have written below query in a function to send the message when the check box is checked:if @work_permit_check_box = 1 /*and @work_permit= 0 checked*/ beginexec tsf_send_message 'Please change the work permit expiration date.', null, 1;end  The output I am getting. How can I translate this message?

Hi,I have a functionality which automatically triggers an email (a reminder sent on a daily basis) when the work permit of the employee is expired in 30 days.Now we added a checkbox , when it is checked the email should not be sent any more. I tried to implement this with below steps:Created a control procedure : layout  Below code in the template(the work_permit_expiration date is mandatory): if @work_permit_check_box = 1 /*when checked*/ begin set @work_permit_expiration = NULL /*null the date*/ end However, this seems not do perform any changes.Where am I doing wrong? Or is there any other simple way to execute it.

Can you tell me how to encode the File data for the FTP connector when using the FTP method 'Upload file (STOR)’?It seems that the connector uses the UFT-16 Little Endian although the source for the data comes from a VARCHAR.

Hi,since some months our SQL Job which will sync the AD groups to IAM runs into an error after a certain time.SQL Job:DECLARE @usr_grp_id AS varchar(100) ,@active_directory_grp_name AS varchar(100) ,@active_directory_domain_name AS varchar(1000) ,@net_bios_name AS varchar(15) ,@user_name AS varchar(100) ,@password AS nvarchar(100)SET @user_name = '{DOMAIN SERVICE ACCOUNT}'SET @password = '{DOMAIN SERVICE ACCOUNT PASSWORD}'DECLARE sync_ad_groups CURSOR FAST_FORWARDFORSELECT usr_grp_id ,active_directory_grp_name ,active_directory_domain_name ,net_bios_domain_nameFROM usr_grpWHERE 1 = 1 AND usr_grp_type = 1 AND active_directory_grp_name IS NOT NULLOPEN sync_ad_groupsFETCH NEXTFROM sync_ad_groupsINTO @usr_grp_id ,@active_directory_grp_name ,@active_

Hi, I have a table with companies, the screen type has a grid on the left side and a form on the right side. I also have a task to export these records to a XML file. Since it’s a general export task, it doesn’t make sence to use this task from the form of a selected record. I would like the button to only be available in the task bar in the grid section of the screen. However, if I use a context to hide the task, its hidden in both the form and the grid. Is there a way to only hide the task in the form? (we only use the windows GUI btw) Thanks in advance!Marvin

I created a report with report type DevExpress and use it as a table report. When the report is downloaded the file name is always te same. It looks like the Report Translation is used. Is it possible to add something unique to file name, like the current date and data from a column in the table? 

The filter on the cube view does niet give the expected results. How is this possible? See image below, the filtered results are in the range until - 10.000, however, I see different results. It does not matter if the check ‘apply to specific level’ is on. Could anyone help me with this odd situation? 

In the date helper, there is a task to go tot the current date. This task is working in the GUI. However, the same task in universal is not working. Can someone please guide? GUI image Universal image 

Hi, We are implementing unit tests and want to keep track of our progress. However, we have several unit tests with the unit test type 'Subroutine’. This unit test type is not taken into account in the analysis. How can we keep track of our subroutines (i.e. functions and procedures) in the different cubes? The unit test types: And the code groups show in the cubes:  

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalWhen you have system versioned tables in your database, SQL Server logs all changes made to the data in those tables. This solution makes this logging data available for the user. This can look like this: SolutionThe solution in this topic creates views on all system-versioned tables. These views give the user access to the logging data. Also, all of these views get conditional layouts in the Software Factory. These conditional layouts give fields with changed values a color, which makes it easier to analyze the data.Dynamic model meta_view_historyThis code create a view definition for every system vers

At a client, we’re going to deploy the universal interface in a short while. While testing the client found an interesting flow concerning login and password recovery that is undesirable.Happy flowIn the universal interface, the user clicks the password recovery link.  The browser is redirected to the indicium interface. The user enters their username/email and a token gets sent out. The user enters the token and new password en hits enter. The user enters a username and password to log in. The user enters their email TOTP token. The user gets redirected to the universal interface.What happened during testing?Somehow the client manually went back to the indicium interface. And started the password recovery there. The process worked the same except he didn't get redirected to the universal interface as no redirect URL was available. They also tr

When opening the Universal GUI login page, DevTools gives a 401 (Unauthorised) error. After logging in with a user with a picture uploaded in IAM the error is shown again.  GET https://office.niverplast.com/indicium/iam/iam/i_ui_usr?$eager=profile_picture401 (Unauthorized)401 - unauthorized. The user is not logged in to Indicium (anymore). Note that the login page will execute i_ui_user before login to validate whether the user has logged in or not. This may cause a 401 error on purpose if not.Once logged in, the profile picture is displayed correctly.Isn't this GET request an attempt to read the IAM profile p

We have upgraded the SF to 2022.2. During the generation of the project the following error occurs on sql_indexes:The MERGE statement conflicted with the FOREIGN KEY constraint "ref_prog_object_item_prog_object_item_parmtr". The conflict occurred in database "sf_raijmakers", table "dbo.prog_object_item".We were unable to find missing or false keys.We analyzed the generated code which looks like this :/* Create index 'besteld' on table 'inkoop_order_regel'. */if exists (select 1 from sys.fulltext_indexes fx                    join sysobjects ot on ot.id = fx.object_id                    join sysindexes ix on ix.id = ot.id and ix.indid = fx.unique_index_id                    where ot.xtype = 'U'                      and ot.name  = 'inkoop_order_regel'                      and ix.name  = 'besteld')   drop fulltext index on "inkoop_order_regel"goif exists (select 1 from sysindexes ix

Is there a ShortKey (e.g. Ctrl+Enter) to go directly to the 'Execute' button in a task from any field?Users wish to complete a task faster, by skipping optional fields, without having to use the mouse. Example:  

Is it possible to change the image on the "forgot password” page and the following pages such as the  "Enter token and new password” page