Blog: Posts from May, 2013

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from May, 2013
Thursday, May 2, 2013PrintSubscribe
Code On Time Tools for Excel, Upload/Download Adapters

Code On Time release 7.0.8.0 introduces support for Tools for Excel.  This new alternative development environment is an add-in for Microsoft Excel 2010 - 2013. It provides a bird-eye view of project configuration element properties with the ability to make rapid and massive changes. Download Tools for Excel at http://codeontime.com/releases/tools-for-excel and use them alongside the Project Designer built in the application generator.

Application framework in the core of web apps created with Code On Time now supports virtual binary fields that can be stored in the File System, Windows Azure Storage, or Amazon S3. Store your binary content in the external storage systems without writing a single line of code with the  help of upload/download adapters. Adapters are implemented without dependencies on the external libraries. All communications with external storage systems are performed through the corresponding REST APIs.

The following features and enhancements were introduced in the new release:

  • Code On Time Tools for Excel
  • File Upload/Download Adapters
  • jQuery 1.9.1 and jQuery UI 1.10.2 are now integrated in the client library.
  • Metadata Builder has been enhanced to support cross-synonym references for Oracle databases.
  • Auto-refresh of data views will automatically sync a view to show the last selected data row. Auto-refresh will not be performed on form views.
  • Implementation of ActionResult.ShowModal will correctly display modal views of the current controller.

The next release with the new preview of the second generation data sheet view will go out soon. We expect to introduce Mobile Client Library and upload/download adapter for Google Drive in May of 2013.

Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Pages

This is a typical view of pages in a project.

Typical view of pages in a project.

There are several rules that apply to modifying the Name and Path properties of pages in Tools for Excel.

Changing Path Of Child Page

Let’s change the text displayed on the menu option of Orders page. For example, the default path of Orders page is “Customers | Orders”.

Default value of Path for Orders page.

Change the text after the last “|” character to “Order List”.

Path property changed for Orders page.

On the toolbar, press Sync to apply changes.

The path property has been synchronized.

Changing Path of Parent Page

Changes to the text before the “|” character will have no effect. Always change the last segment of  the Path of the parent page to affect the child pages. For example, consider the effect of modifying the path of Customers page.

Default path of Customers page.

Change the path to “Current Customers”.

Changing path of Customers page.

Synchronize the changes, and all child pages will reflect the new parent.

The path of Customers and all child pages have been updated.

Removing Pages from Menu

To remove a page from the navigation menu of the generated web app, clear the Path property.

Clearing the Path property for Products page.

After synchronization, the page will be displayed at the bottom of the list of pages.

The products page will not appear on the menu and shows up at the bottom of the list.

Adding Pages to Menu

To add pages to the menu, enter a value in Path property.

Entering a value in Path property.

The page will be reinserted at the bottom of the list of pages.

The Products page has been readded to the menu and is reinserted at the bottom of the page.

Renaming

Use the Rename function in Project Designer instead to preserve the configuration.

Do not change the page Name if you want it to be renamed. The application generator will remove the existing page and insert a blank page with the new name.

Moving

Rearranging of pages is not supported in Tools for Excel. Please use the Project Designer instead.

Reference

Consult the following table when entering property values:

Property Description
About This Page The text displayed in the "About This Page" sidebar element.
Custom Style Multiple custom Styles can be applied to the page in order to apply custom styling. The styles are space separated.
Description Description is displayed as a tooltip for the page on the navigation menu.
Master Page Specifies the name of a custom Master Page.
Name The name of the generated physical page.
Path Specifies the location of the page in the navigation hierarchy. When left blank, the page will be hidden from the menu.
Roles

Make a comma-separated list roles that are permitted access to the page. Use ? to allow anonymous access to the page. Use * to display the page on the menu for anonymous users, but require them to log in to access the page.

Style Choose a standard CSS Style to apply to the page. The standard stylesheets will change the icon displayed in the top left corner of the page.
Title The text displayed in the browser window header.
URL

The URL will create a menu link to an external web page. No page will be created when this property is specified.

Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Business Rules

This is a typical view of business rules in a project.

Typical view of business rules in a project.

Consult the following table when entering property values:

Property Description
Command Argument Specifies a command argument that will allow trigger of business rule when command name is matched.
Command Name Specifies the command name that will trigger the business rule.
Controller Specifies the controller that the business rule belongs to.
ID Specifies the unique identifier of the business rule.
Name Specifies a name for the rule.
Phase Specifies which phase the rule will be executed in.
Script Specifies the script of the rule.
Type Specifies the implementation type. SQL, C# / Visual Basic, and Email business rules are executed on the server. JavaScript business rules are executed in the browser.
View Specifies the view that the business rule will be triggered on when command name is matched.