Converting Designer Spreadsheet to Baseline

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
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.