Questions & Conversations
Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community
- 1,802 Topics
- 6,202 Replies
How do I show the hour and min from a datetime in my application?
Hello Community, I want to show the exact time of a new added record. I use the datatype datetime for the record i want to show. In SQL Manager it does show the hour/min/seconds, but in my application it doesn't. See below for reference. How do I show the hour and min from a datetime in my application? Sql manager [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/ff6c6b8e-ef0a-444b-9194-fed0d381661d.png[/img] Application [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a1a23571-fbd6-456a-a8a4-23ab24505077.png[/img] Kind regards, Thijs Holterman
Suite upgrade instructions
We would like to upgrade our Thinkwise suite from version 2017.1 to the latest 2018.3. I've got all the upgrade files ready. Our database names are of the following structure: -APPLICATION_SF_ONT (SF database) -APPLICATION_IAM_ONT (SF end product) -APPLICATION_IAM_PROD (IAM and end product in production) -COMPANY_DATA (company data model for live end product) After ignoring the files for older suites there are 3 large upgrade scripts to be applied to the SF_ONT database. I've tested these on a copy of that database and all upgrades run without issues. After that the process becomes unclear for me however. [QUESTION 1] Do I also apply the files 030_checks.sql, 040_constraints etc to the SF_ONT database? If not, what do I do with these files? [QUESTION 2] After completing the upgrade on a copy of the SF_ONT database (for testing purposes) I would like to run the new SF version off of it. How do I switch to a different SF database so I can actually test if it's running fi
Using a different 'merge' program when solving template conflicts
When a template code conflict occurs during a merge session it will be possible the merge the code via an external 'merge' program. TSF requests the existence of a 'merge' program like WinMerge or Kdiff3. I'm not really a fan of either. We always use UltraCompare as a 'merge' program. Is it possible to use UltraCompare as the default 'merge' program? And how do I set this up? I found a page on ultraedit.com which may be of use: [url=https://www.ultraedit.com/support/tutorials-power-tips/ultracompare/version-control-comparison.html]https://www.ultraedit.com/support/tutorials-power-tips/ultracompare/version-control-comparison.html[/url]
Records in report queue are not being processed
We have a Reporting Service installed and configured to look at multiple instances/databases (development and test). All records in table rapport_queue are processed for the first connection. When a record is added in the second application, it is not processed by the Reporting Service. After a restart of the service, all records with report_status = 0 are processed correctly. New records will not be processed after a restart. We have uninstalled the Reporting service (3.00) and installed the latest version (3.20) with no different result. What could be the problem? Config: connectionString=" Data Source=CFS-TWDB01\THINKWISE; Initial Catalog=CF_FINAS; Integrated Security=true; User Id=; Password=; Persist Security Info=True" providerName="System.Data.SqlClient"/> connectionString=" Data Source=CFS-TWDB01\TEST; Initial Catalog=CF_FINAS;
Questions regarding the use of DevExpress Reporting
[list=1] [*]Is a separate license necessary for the use of DevExpress Reporting or is this part of the suite? [*]Is a viewer needed or is this standard in the GUI? [*]How can I import a Crystal Report? I do not see an option to import Crystal Reports, as described in the release notes. [/list]
Web GUI - grid not able to select rows?
Symptom: not able to select rows in the Grid of the Web GUI, while the Windows GUI Grid allows it. Cause: In the SF the "Allow navigation" rights checkbox is disabled for the subject. Explanation: The Web GUI disables navigation between rows overall based on "Allow Navigator". The Windows GUI only uses this setting to disable navigation buttons of form and ribbon. There is an extended property available for the Windows GUI to copy the behaviour of the Web GUI: [code]useallownavigationasrights = yes [/code] Due to technical difficulties the Web GUI doesn't met the Windows behaviour (yet).
Task to control a process flow
Sometimes I use a task (button) to start a process flow. The task in itself actually does nothing, it only calls the process flow. For these kind of tasks I use the tasktype ‘Stored procedure’ and leave the template empty. I noticed that there are other tasktypes available that are not described (like ITP Interface). Could one of these tasktypes be a better option here?
Can anyone tell me what control is in use for the embedded browser in the Windows GUI (in the document preview)? I have read that the browser used in winForms is based on IE 4. For one of our features we rely on this browser component, so it would be great to know exactly what we are looking at.
A couple of questions about Indicium
Lately, we’ve received the question from several parties (app suppliers like WerkbonApp) whether it’s possible to realize a connection with them. Because of that, I’ve started some intensive testing with Indicium (2018.1 build 2). While doing this, I’ve encountered several problems and questions that I’d like to submit. 1. Is there another authentication way than Basic Auth.? If so, which one and how can I apply this? 2. Why is it possible to filter by $select, $filter and $orderby separate but not with a combination of these? 3. Why is the $top=10 parameter allowed on a table but not on a view? 4. How can I track down the cause of a problem when the system returns a particular HTTP error code (like the 500 internal server error)? I’m aware of the subfolder Logs from Indicium on the (web)server. Are there any other methods to tackle this problem? 5. Is it possible to request both master and detail records (like organisation and contact) in one response? 6. A few p
Message when calling a report
I get the following message when calling a report: The RPC server is unavailable. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a14bb357-6477-4f6c-9cf5-cab3bcf5635d.png[/img] - Do you recognise this message? - Is this possible because there is no printer installed on our server?
Change language but not the date notation
If I change the setting of my application (from Dutch to English) the order of the date changes (to month/day/year from day/month/year). Is it possible to change the language with changing the layout of the date fields? I tried using an extended property called CustomDateMask, which has no effect.
I would like to know more about the possibilities of Extenders. In my opinion I am missing a few Extender Types? The extenders which I now have available to me: [list] [*]Custom_display_format [*]Default_editable_cube [*]Maps [*]Resource_scheduler [/list] I seem to have read somewhere that there are Extenders available for grid grouping and multiline headers. Who can tell me more about it?
View creation method
When I want to use a view in the application, there are three options: automatic, customizable and template. Normally, I work with a template but in this case a cube is required where the data is in a table. I was planning on making a variant for the table but that doesn’t fulfil the needs in this case. I thought it would be possible to make this view without a template, but this doesn’t seem to work. My question here is: what is the difference between customizable and automatic? And why is the field ‘view_from_clause’ not customizable in both? And if it’s not customizable, why is the content not emptied? Anyway, while generating the piece of code between ‘select’ and ‘from’ is left blank, despite I’ve defined 4 fields in the view, and they do exist on the table. What am I doing wrong? Why isn’t this work? Am I still obligated to make a template? See the two print screens below: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/05cbcbf9-e8c9-405d-a9
Icon on Windows taskbar not customizable anymore?
We have a separate icon for our standard software application ‘JP-Bouwmanagement’ that is linked to our Thinkwise application. In the G8 we were able to include this icon in a shortcut by adding a INI-parameter ‘ApplicationIcon’ to the shortcut with a link to the icon. It looks like this is not working in the Windows GUI 2018.1.17. A standard Thinkwise icon appears on the Windows taskbar, were the custom icon used to be, our users a not familiar with this icon. Is this a known problem and will this be resolved?
Database name is empty when starting a report
I’ve created an new Crystal Reports report. When I open this from my development PC it’s working proper (see print screen below) [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/e9754ba5-0e33-4191-a122-645742d3660a.png[/img] But when the user starts this from the test environment, from a different PC, the database name is not filled. The following screen pops up: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a4871719-8d40-467b-900c-f61c869131c9.png[/img] When I check the debugger, I notice that the database is filled (see print screen below), the same goes for my other Crystal Reports reports. Am I missing something? Maybe some settings in Crystal Reports? [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/7a21597b-5bd7-4f3f-9d4c-82a5718d56e3.png[/img] [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/29665246-6cb6-402f-aa7e-c7c19d445642.png[/img]
Login to the Thinkwise Software Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.