News & Activity Feed

Thursday, August 16, 2018 5:54 PM | Brandy Riggs
When i generate the application I see the icons just fine, when i publish the application, they no longer display.

So I built a new application where i started as ASPX, and I have the same issue with the new application, so it doesn't seem like it has anything to do with converting from HTML to ASPX...
Thursday, August 16, 2018 4:59 PM | Rob Berry
Hi,
Followed the online instructions to create a custom membership system. got it done but when i try to create a new user, all seems ok. No errors but no user is created. Verified but looking in the tabes in Managment studio. where should I go to fix this?
Thanks!
Rob Berry
Thursday, August 16, 2018 3:54 PM | Tom Kustura
When initially announced, one of the features of Advanced Search was going to be that "Data views will keep track of up to 30 recent searches". Is this feature available?

Alternatively, is it possible to capture the search criteria from the Advanced Search and store it somewhere?
Thursday, August 16, 2018 1:32 PM | John Willems
I have a Custom Search allowing the user to use one of three data fields. That part works like I want.

I get the results populated in the grid. Like the video when the user selects a record from the record I want its edit form to show the details for that record.

In following the video it makes use of a SQL script and the @xxxx_FilterValue parameter.

Using the video as a model I created the following script. It fails saying the @xxxx_FilterValue is scalar and must be declared.

I need a fresh set of eyes to look at this and tell me if they see something wrong. I appreciate the help.

If @Parameters_LicenseeName IS NOT NULL
EXEC usp_PublicDataSearch @LicenseeName = @Parameters_LicenseeName
Else
If @Parameters_DBA IS NOT NULL
EXEC usp_PublicDataSearch @DBA = @Parameters_DBA
ELSE
IF @Parameters_City IS NOT NULL
EXEC usp_PublicDataSearch @City = @Parameters_City

If @Iden_FilterValue IS NOT NULL
Select
LiqMast.iden,
LiqMast.LicenseeName,
LiqMast.DBA,
LiqMast.City,
LiqMast.County,
LiqMast.LicenseTypeCode,
LiqMast.ExpiredDate,
LiqMast.LicenseStatus
From LiqMast
Where
LiqMast.Iden = @Iden_FilterValue
Thursday, August 16, 2018 5:32 AM | Rob Blevins
Howdy, I'm working through the Tutorial, and was about finished when I started getting this error. Not sure what to do what to do with this.

Thanks

System.IndexOutOfRangeException: Index was outside the bounds of the array.

Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

or:

2) Add the following section to the configuration file of your application:

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[IndexOutOfRangeException: Index was outside the bounds of the array.]
Hivoltech.Data.DataControllerBase.PopulateManyToManyField(ViewPage page, DataField field, String primaryKeyField) +436
Hivoltech.Data.DataControllerBase.PopulateManyToManyFields(ViewPage page) +330
Hivoltech.Data.DataControllerBase.Hivoltech.Data.IDataController.GetPage(String controller, String view, PageRequest request) +3505
Hivoltech.Handlers.SiteBase.PreparePrefetch(String content) +1555
Hivoltech.Handlers.SiteBase.OnInit(EventArgs e) +1341
System.Web.UI.Control.InitRecursive(Control namingContainer) +360
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1505
Thursday, August 16, 2018 1:36 AM | baa
I have an 8.6.12 version of codeontime which have been working fine. However, over the last few days where I continue to receive notification to upgrade to 8.7.4 version.
Of late anytime I attempt to start codeontime application IO only get
a black screen which says codeontime is starting and stays like that forever.

I have uninstalled and installed over a number of times.
Is there any way to get around this?
The
Wednesday, August 15, 2018 8:36 AM | fajrin
Dear COT Team,
I have requirement to create dashboard using user control.
My intention are : get data from database
then displaying using bootstrap or other custom html/css.

I am having trouble applying bootstrap template for panel, and
also my script is not running expected
Here's what I have done:
1. Create user control 'TestDashboard'
2. Add custom html with script:

--------------------------


<!DOCTYPE HTML>
<html>
<head>
<title>Dashboard</title>

</head>
<body data-authorize-roles="*">
<!--The contents of this page will be overwritten by app generator.
Set page property "Generate" to "First Time Only"
to preserve changes.-->
<div data-app-role="page" data-activator="Button|Dashboard">
This is the content of <i>Dashboard</i> page.
<div class="row" data-role="content" >
<div class="col-md-3" >
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">User</h3>
</div>
<div class="panel-body">
<h2><div id="users_count">0</div></h2>
</div>
</div>
</div>
<div class="col-md-3" >
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Task</h3>
</div>
<div class="panel-body">
<h2><div id="tasks_count">0</div></h2>
</div>
</div>
</div>
<div class="col-md-3" >
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Contact</h3>
</div>
<div class="panel-body">
<h2><div id="contacts_count">0</div></h2>
</div>
</div>
</div>
<div class="col-md-3" >
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Others</h3>
</div>
<div class="panel-body">
<h2><div id="Others_count">0</div></h2>
</div>
</div>
</div>
</div>
<script>
$( document ).ready(function() {
console.log('enter nav app');
$app.execute({
controller: 'Dashboard1'
}).then(function (result) {
console.log(result);
$('#users_count').val(result.users_count);
$('#tasks_count').val(result.tasks_count);
$('#contacts_count').val(result.contacts_count);
});

});
</script>
</div>

</body>
</html>


------------------------

3. I have created controller with name:
Dashboard
with Command:
Name: cmdDash1:
Sqltext : "select ( select count(*)
from simapp.tasks ) as tasks_count ,( select count(*)
from simapp.my_aspnet_users ) as users_count ,
(select count(*) from simapp.contacts) as contacts_count"
Fields: tasks_count(int32),users_count(int32),contacts_count(int32)

my console.log(result)=>
{totalRowCount: 1, pageIndex: 0, pageSize: 100, Dashboard1: Array(1), primaryKey: Array(1), ...}
Dashboard1
:
Array(1)
0
:
{tasks_count: null, users_count: null, contacts_count: null, PrimaryKey: 1}
........

My Questions are
I. Kindly help why result is not showing from mysql database
and how to implement custom select from command query correctly
using client api?
II. Also how to implement bootstrap correctly ?
( for this case using panel and laid 4 panel horizontally )

My Spec:
Mysql 5.7.2 : utf8mb4 default collation
COT Standard 8.7.4.0
Windows 10

Any help greatly appreciated
Thank you
Wednesday, August 15, 2018 3:56 AM | Poncius Pilatus
Is not quite easy but still trying . Some progress has been achieved. Don't know how to upload current pdf sample I have made so it can be eyed as an attachment (only images < 2 mb allowed)
Wednesday, August 15, 2018 2:40 AM | Rob Berry
I enabled the custom membership as defined in the tutorial. When I create a new user the password is not encrypted in the database and therefor does not allow me to login as that new user. The default admin and user work because they are encrypted.
How do I resolve this?
Best Regards,
Rob Berry
Tuesday, August 14, 2018 1:56 PM | uremovic
What do you suggest for time event based functionalities like:
- periodically sending email,
- periodically generating reports,
- periodically inserting records in tables (e.g. tasks every night),
- etc.

How to implement this kind of functionality? Is there any COT generated easy solution?

Tnx in advance.
Tuesday, August 14, 2018 6:25 AM | amdawi
Hello,
I have 2 language ( English , Spanish ) in my application.
I want to create 2 buttons to change language using javascript.
What is the javascript code to write ?

Regards,
Monday, August 13, 2018 7:11 PM | Brandy Riggs
I've gone through a ton of support questions about Windows Authentication. I have read where it says if i enable windows authentication, then I can assign the Active Directory Roles to each page, but this doesn't work.
I do not want to set up a separate User Manager page and the tables that go along with it for each project I build.

I just want to simply be able to set up the application with Windows Authentication, then set up the security on each page under Roles. I have set up an OU in Active Directory specifically for groups that will be for each project.

Currently I have a project with 5 pages. 1 group of users need to see 4 of the pages and 1 group of users need to only see 1 of the pages.

There has to be an easier way to accomplish this without requiring a user to login or having to add locations authorization to the web.config file.

I set up my first project a few weeks ago and modified the web.config, but it was much easier, because it was 1 group of users for the entire application.

This is now my second project, and I can not set it up the same way, but need it to be as simple as possible for the users. Mainly no login screens of any kind.

Any help to simplify the whole Windows Authentication process will be much appreciated...thank you.
Monday, August 13, 2018 8:47 AM | Zhan Hui
I have created a new Role called "Purchaser" and assigned to "Membership" Page.


However, when I log in with a user ID with role "Purchaser" and go to "Membership" Page, error occurred.


Anyone can help to solve this?
Thanks in advance. :)
Sunday, August 12, 2018 5:42 PM | Rob Berry
How do I use membershipmanagerextender.cs to add a extended customer profile data table, to add fields for more info needed for my app?
Thanks,
Rob
Saturday, August 11, 2018 9:19 PM | Adam Webdell
I have a new database requirement and I am trying to figure if I should use COT or just creat a Windows app in VS so...

The database is going to be used to show electronic component information possibly some stock control in the future.

What I would like to happen is that each component supplied on a reel with have a barcode label, each record will have a unique barcode. I will be using a simple barcode scanner with a build in keyboard wedge so is it possible to adapt the search in code to be set as equals a certain field and goes straight to the show record view? And upon closing returns the focus to the search bar which would be cleared and ready for the next input?

Any thoughts on how this could work or a different approach would be appreciated
Saturday, August 11, 2018 3:15 AM | boonchoo chatsrinopkun
what're the scopes of and differences among 1) cache, 2) log and 3) sync XML files in the repo folder?

when changes are messed up because of switching between visual studio and cot tool, where is the best place i can look for changes causing the mess?

Saturday, August 11, 2018 2:16 AM | Ryan Sytsma
New to COT. When a controller is generated, why is there only a command created for select and identity and not insert/update/delete? Where do those get built or do they need to be configured as needed?
Ryan
Friday, August 10, 2018 8:41 PM | Jonesy
Does anyone know if geo tagging is working yet?
Is there something else required other than the online tut?

Cheers,
Jonesy
Friday, August 10, 2018 3:54 PM | Brandy Riggs
The code works for allowing and denying roles and users from the applications, using Windows Authentication, but what if i need a certain account to be able to read one of the pages, but not have the rights to edit or add entries, and 4 other pages that specific account does not need to see at all?

How would i tackle this issue...I know there is a Roles area in the grid, create and edit forms, but can i use my same groups I used in the web.config above to specify in each grid edit or create form? Or do I have to do some complex add membership table to the db thing...

Thank you.
Friday, August 10, 2018 3:27 PM | Brandy Riggs
Is there a way to export to a PDF or word document an actual calendar view report?
I want to be able to print like January through December of a given year, where the view is each page is a month of calendar events shown in a calendar view.

Thanks.
See All Posts