Blog: Posts from January, 2012

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 January, 2012
Saturday, January 21, 2012PrintSubscribe
SharePoint Factory is Out!

Code On Time release 6.0.0.19 includes new code generation project SharePoint Factory and miscellaneous product enhancements.

This release includes the following features and enhancements:

  • SharePoint Factory web application project.
     
  • Theme page of the project wizard now offers an index of all theme samples.
     
  • New themes: Mission, Laminate, Grapello, Graham, Convention, Construct, Cay, Bittersweet, Berry, Municipal.
     
  • DotNetNuke Factory will produced a Visual Studio 2010 project if Visual Studio 2010 is detected.
     
  • New "strongNameKey" code generator instruction creating a random key pair with the help of Strong Name Utility is integrated in the code generator. If the SNU is not available then the standard key is copied from the library to the output. This feature is provided to support SharePoint Factory.
     
  • EASE EventTracker class has been updated to ensure compatibility with Visual Basic.
     
  • Alias Field Name property of data fields is left blank if the Discovery Depth is set to zero.
     
  • Suppression of duplicate foreign keys is now performed by the code generator in all project types. Duplicate foreign keys were previously causing erroneous code generation.
     
  • "Project Refresh" window now offers Select All/None buttons to allow quick selection of all items.
     
  • Quick Find performs a case-insensitive search in projects using Oracle backend.
     
  • Settings "Features | Grid | Enable standard action column in all grid views" will add an action column to all views of an application.
     
  • Click on a "View Details" link next to a lookup field in a master view will not stop refreshing of child views when the selected master record has changed.
     
  • Slow running detail views will automatically cancel data requests if the master has changed. The previous implementation may have resulted in the wrong detail data displayed if the selected master record has changed before all details were retrieved.
     
  • It is now possible to process "Report..." actions in business rules.
     
  • Designer log progressing progress in now displayed in the log box of the code generator. This will be noticeable with large change longs only when the project is refreshed.
     
  • Batch Update in grid view will not raise an "Unauthorized command..." exception when user tries to save the changes.
     
  • Connection String Name defined in the data controller properties is correctly used in the generated apps. Read about implementing multi-database projects at /blog/2012/01/multiple-databases.html.
     
  • Check for updates is automatically initiated when an activation code is registered.

Tuesday, January 10, 2012PrintSubscribe
Multiple Databases

Multiple Database support has been added in Code On Time web applications. The feature will be available in the next release. If you want the capability now, submit a ticket and request the multiple database hotfix.

Learn how to set up a web application that accesses data from multiple databases at /Documents/UG-Multiple_DB.pdf.

Monday, January 9, 2012PrintSubscribe
Converting Designer Spreadsheet to Baseline

Code On Time’s Designer Spreadsheet has been a popular tool for editing Code On Time applications in a rapid fashion. Unfortunately, it uses a different method for saving changes and has been phased out of use. However, this feature will soon be replaced with a new and improved version – Code On Time Tools for Excel. Those of you who used Designer Spreadsheet on your projects will need to migrate a few files to make sure all your changes are migrated to the newest version of Code On Time Generator.

First, you will need to find the folder location of your project. This can be easily done by running Code On Time Generator, selecting the project name, and press Open. Alternatively, you can navigate to My Documents/Code OnTime/Projects, and find it there. The folder should look like this.

image

You will need to delete the following four files:

Application.Baseline.xml

Application.Cache.xml

Controllers.Baseline.xml

Controllers.Cache.xml

image

All the changes made to the application in the Designer Spreadsheet are recorded in the file Controllers.Master.xml. Make a copy of the file, and rename the copy to Controllers.Baseline.xml.

image

You will need to make one more change to ensure that categories are processed correctly. After the Designer Spreadsheet was released, an id parameter was added to all categories. This field will need to be added to all of the old categories in the baseline file. Otherwise, Code On Time Designer will not place any data fields in the categories, as shown below.

image

Open this file in your preferred editor (we used Visual Studio). Find the first category, and add an id parameter to this category.

image

You will have to perform this operation on the rest of the categories as well. Find and Replace (Ctrl + H) is highly suggested at this time. Each category in the same view must have a unique id. If you have added multiple categories to the same view, you must manually change the id.

image

Once all the categories have an id, it is safe to save this file and open the project in Code On Time Generator. You can see that the data fields are now correctly nested in the proper category.

image

We apologize for any inconveniences this move may have made, but we believe that you will find Code On Time Tools for Excel to be a vast improvement, and well worth the upgrade.