Solved

Hi,   I am trying to get an application for mobile up and running. I have made a small test application and deployed it on a test server using our test_iam. When trying to log in using the desktop viewer I receive the above error. The network tab in debug shows no error. Using insomnia I am able to login to retrieve the metadata using the same credentials. The IIS and indicium are working fine, we are also using it for communication with our webshop. I checked all iam user settings, but they seem fine since I can start the application with the desktop GUI as well. screen login:   What am I doing wrong here?  

Although I didn’t learn about this in my standard SF training I recently found out that there is a way in the SF to make a column unique by creating a unique index. See picture below:   I wonder if this is common practice when one needs a value in a column to be unique? Are there any drawbacks that I have to take into account? I also wonder why this option isn’t available when creating the column?

Are you actively testing heatmap analytics 'frameworks’ (support) on the webgui/universal UI? Especially an implementation for user behaviour tracking. - Hotjar for example. For those that are unkown with heatmaps: Heatmaps are visual representations of attention, engagement, and interactions generated by your visitors as they navigate through your application. It uncovers areas of improvement in our business processes that we've always guessed but never really gotten confirmed to focus upon. May just also be the best solution to get to focus on the right/proper testing area's -  business process wise and technically -  but also where to place AI/ML in between It also helps detecting where we can/should add functionality and where to ditch or reposition certain functionality that never ever gets touched. (Which happens more often than one would think)

In our application we usually allow the standard export of a table through the button on the lint. In many cases though there are columns which are used for calculation of presentation but are not meant to be exported. It would be handy to hide these columns from the list of column to export when the user chooses the advanced export. Unfortunately hiding such a column in the ‘Subject’ tab or through a layout does not have the desired effect of hiding it from the export. So the question is: is there actually a way to hide a column in a table so that the user can never select it for export?

Apparently the mobile app starts resizing the columns to a “collapsed format” when the screen size is lower than 800px. It looks like if all information for the entity is displayed in a single column, this give the following result:         Both images are the same grid. Is there an option or setting so we can force the display of the grid to not collapse this information, and start showing the configured columns (second image)? 

We would to be able to send whatsapp messages from the application to users, in this case employees. Has anyone done this with the SF? Pleas let me know.

I like to create a very simple grid to add and maintain records in a table. To make it even more easy for inexperienced users, I like to create an ‘Add’ button in form, with a task without logic. Result:   To let it work I like to make use of a simple process flow. For some reason, it does not work. The process flow monitor remains blank. What am I doing wrong?          

I'm trying to let the end user import ‘large’ sets of data (CSV/Excel) into the database via the Web GUI. It's not that large as in this (https://community.thinkwisesoftware.com/development-13/best-practice-for-inserting-large-amounts-of-rows-into-one-table-837) thread, but large enough to let the web interface time-out. The problem then is that the import is partially done: It could have imported for example 3k of 50k records. The end-user doesn't know what to do: What part is partially imported? And how to fix it? I'm trying to speed this up, but I can't really increase it's performance. When I take a look at the debugger in de Windows GUI I see a lot of database-calls per row. For each row the default and layout concept are triggered, and the record is inserted per piece. Imagine you want to insert 50k records, and each cycle takes only 5ms, but when it's multiplied with 50k it's 250 seconds. From a user point of view this is absolutely unacceptable (besides it probably crashes in t

I'm having difficulties unit testing certain concepts like a context. Let's say I'm having the following use case; The purchase_order (PO) contains purchase_order_line's (POL). When the PO has the status ‘done’, the user or api cannot insert or update PO lines for that PO. I've disabled this using a trigger, i.e. if exists ( select 1 from inserted i -- purchase_order_line join purchase_order po on po.purchase_order_id = i.purchase_order_id where po.status = 'done') begin -- abort etc, cancel insert/update for purchase_order_line.end I have attached a layout and a context concepts for both the PO and POL's. I want to unit test the behaviour for in example the context or layout of a purchase_order_line, that certain tasks / buttons are disabled. This can be done via unit test or via process tests. If I do this via unit tests I have to create a Data set. When I do this and I execute the unit test, the data set creation fails: Due to the trigger i'm not able to both insert a purchase_or

I'm trying to use the Indicium OData API via a .NET Core 3.0 console application. I receive an exception on inserting records, while the record is inserted in the database. I have no clue why. I'm not sure if this is an issue in the Indicium OData API or the .NET nuget package. For example I want to add a ‘server’ to the IAM database. By using a generated piece of code (see https://docs.microsoft.com/nl-nl/odata/client/basic-crud-operations) this is quite easy to set up; Add the indicium OData API via “Unchase OData Connected Service” Configure the metadata ($metadata.xml is the result of http://server/indicium/iam/iam/$metadata)With the following code you retrieve the ‘server’ table and insert a new record in to it: using SQLSERVER_IAM;using System;using System.Net;namespace IndiciumTest{ class Program { static void Main(string[] args) { var uri = new Uri("http://server/indicium/iam/iam"); var container = new Container(uri); container.Credentials = new NetworkCredential("userName", "p

Can the email notification messages send by the Community Portal be made more focused to the topic? This to make them more valuable to read. The same picture with a man watching his tablet PC, doesn't make sense and is just pollution of my inbox. The title of the topic should be part of the email subject, something like: [b]'New Idea: Apex Refactor and Software Factory'[/b] or [b]'New comment on topic: Home button in Mobile GUI'[/b] The description, part of the description or comment in the body, would be great.

/-This is more of a SQL question-/For the project I work on I'm in charge of realizing functionality to import large amounts of Product data (ASCII format / .txt file data). The database I work with is placed in a environment where multiple companies work on the same database. In the application, they only see their own data. For example, if 30 companies use the database and all have a pool of 1 million Products, then the 'Product’ table will have 30 million records in total but will only see their own 1 million products.The data that I will import consists possibly over a million records and will be inserted into the single ‘Product’ table. What I'm worried about is that inserting 1 million products in one go will take a very long time, so I want to look at possible ways to accelerate this process and making sure that importing big files does not take hours.I have read about removing indexes, parallel processes and such to speed up the process but I'm not fully convinced it would be t

We are trying to design a new screen for data input with a grid similar to a spreadsheet. Let me try to picture our situation. Our products are garments in all kinds of sizes which could be XXS to XXL, 44 to 64, etc. Several size systems are at play here and every kind of garment has its own system as well as size range. Our design team needs an easy input screen with spreadsheet like layout. Per type of garment and per size there are several measurements to be made. Think of something like this for trousers: 44 46 48 50 52 54 56 58 60 62 64Waist . . . . . . . . . . .Inseam . . . . . . . . . . .Length . . . . . . . . . . .Pocket . . . . . . . . . . .The left column contains the measurement types. The top row contains the sizes. Every dot is a measurement that needs to be recorded.A t-shirt however might look something like this

I'm trying to deploy an application to Azure using App Services and a Azure SQL database. We want users to log in with their e-mail address, such as user@company.com and john@doe.com both on the same application / database. The user id in IAM is an e-mail address and the users in the SQL database are also. Only when trying to log in, the login with the e-mail address user@company.com fails: Cannot open server “company.com” requested by the login. The login failed. When I add the database server address to the e-mail address (user@company.com@my-database.database.windows.net), then the login succeeds. How can I fix this that the user doesn't have to add the database server address? Please note, when connecting with this user via SQL Server Studio Management Tools it also requires the postfix of the database server address in the user name, despite the fact that the user / login in the database is only [user@company.com].

We created a report in which we want to retrieve some images we uploaded in the application. The images are saved in the application folder where the service account has full rights. We can approach the image in the windows and web GUI by pressing the download button. However, when we create the report the previewer in the Web-GUI seems not to retrieve the image properly. Does the dev-express reporting previewer expect access in a different way in the web-gui? I expect this to be the same for web and windows.  webwindows 

 where can i change the field width from the filter

I created a column in a table with the xml data type. However during execution of the source code of the update trigger of that table, I get the following error caused by this field.Therefore I would like to exclude this field from the update trigger, but I cannot find a way to do this. I already set the “Trigger for update” attribute of the column to false in the subject, but that doesn’t do the trick.The following highlighted code fragment in the update trigger is the problem I guess.Is there a way to exclude this field from the automatically generated update trigger?

We want to use the API alias but when we fill the alias (field API alias) however the name does not change in the OData layer (Indicium)

Is this correct behavior by the (latest) GUI? It seems to me this is not the way it should work. A password shouldn't be revealed like this.Visible password values 

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

We have a request from Customer Aartsen if we can provide (besides custom background and logo) opportunity to have custom colored (Aartsen red) progress bar on Windows GUI splash screen starting the application.  

When I was studying the present situation in our system, I came across attached database design. I would never have designed it this way myself, but since I'm relatively new to database design and eager to learn, I wonder what the advantages and disadvantages are of laying out the references and private keys in this way.A 'calculatie' consists of one of more 'calculatie_onderdeel' which consists of one or more 'calculatie_onderdeel_blok' which consists of one or more 'calculatie_onderdeel_blok_vak'.When I would have been the one to design this, I would have used one private key per table. E.g. calculatie_id for the first, calculatie_onderdeel_id for the second and so on. Then I would have created PK / FK references on these id fields.Please see attached picture of the design I'm referring to. Any thoughts on this, or some background information are welcome.

As a follow up on [url=https://community.thinkwisesoftware.com/deployment-12/images-of-tasks-filters-resources-etc-visible-on-azure-717]this [/url]topic, I'm trying to replace the application icon in the web gui. According to the [url=https://office.thinkwisesoftware.com/docs/docs/sf/configuration_file.html#other-parameters]documentation[/url], the value for ApplicationLoginLogo must be an absolute (UNC) path. But when you're hosting on Azure, or an IIS without network access, you cannot specify a absolute path. In the settings.ini file i've tried to use .\MyLogo.png, MyLogo.png, .\App_LocalResources\MyLogo.png, App_LocalResources\MyLogo.png (placed MyLogo.png both in the root and App_LocalResources for all cases, just to be sure). But none of those work. According to the documentation, a full path is required, but isn't there a way to fix this using a relative path?

I would like to be able to assign a task to a taskbar like we assign details to a detailgroup. I want to be able to show other tasks in the taskbar above the grid than the tasks on the form.  In case we use 2 taskbars in the same screentype you get all the tasks in both bars (see Any ideas/tricks to running tasks from different parts of the same screen?) .It would be easier to assign the tasks to the ‘taskgroup’ of the taskbar. Maybe It could also be used to omit tasks in the taskbar (see Configure task, report and prefilter bars). The same could apply for reports.

I have a Long list of test question evaluations.  Because rther e is no indication of the Learning Pan or Course, onbly the Question is repeated, it is very hard to look up a specific evaluation.