Follow

Schema Migration in CakePHP 3.x

Posted on April 17, 2017 by in PHP Solutions

Introduction

In this blog, we’re going to look at the purpose of the schema migration tool provided by CakePHP and the benefits of using it in our project(s).

What does it do

CakePHP provides a plugin called migration which is supported by the core team. This plugin is a wrapper for the database migrations library Phinx.

Using a migration file we can create or drop tables, add or remove columns, create indexes and even insert data into our database. A migration file contains PHP script which handles our schema.

Reusable class for UI controls on iOS

Posted on March 20, 2017 by in iOS

Introduction

Most of the UI controls are usually provided by Apple while developing an app. Depending up on the requirements, it is common to change the default behavior and design of a UI control to create an app with uniform look and feel.

It is not only tedious but a bad practice to design/alter each control separately. Moreover, the process of altering each control not only time-consuming and cost-intensive but often prone to human error which could cause all sorts of compatibility problems with any other interdependent apps or systems.

iOS App Launch using Geo-fencing

Posted on February 24, 2017 by in iOS

We’re currently working on updating this post. It’ll be back soon! Sorry for any inconvenience caused.

QB Remote Connector

Posted on February 23, 2017 by in Quickbooks

QuickBooks SDK is a time tested option while doing custom programming against any flavor of QuickBooks Desktop edition. This SDK is based on COM with two interfaces: QBFC and QBXML.

QBFC uses pre-defined objects to build XML requests, whereas much of the plumbing has to be done by you with QBXML that includes XML serialization and deserialization.

While it is a breeze to consume the SDK from .NET based languages, the same is not true with other popular languages/frameworks such as PHP, Java, Node.js etc., because of the SDK’s roots in COM. Common problem across programming languages/frameworks is connecting to a remote instance of QuickBooks and perform pull/push of data.

MS SQL Server Cell/Column Level Encryption & Decryption

Posted on February 15, 2017 by in SQL

Introduction

Database is a wonderful tool to store information and to look at the data in different ways to make decisions, present an opinion etc. However, the same data can pose a big problem should it fall in the hands of unscrupulous people and the impact can be more devastating if it has sensitive information such as Credit Card/Bank Account numbers, personal Telephone/Email details. For some organizations, it is mandatory to meet stringent data security regulations such as PCI-DSS, HIPAA/HITECH, or GLBA/FFIEC. Hence all such sensitive information must be encrypted in order to protect the customers and avoid data loss in the event of data breach.

This article focuses on how to do data encryption in Microsoft SQL Server by looking at the available options.

Common mistakes while working with CakePHP index page views

Posted on February 3, 2017 by in PHP Solutions

At some point of time as developers, we all go through a situation where we have a short deadline and a hand-full of work. In such situations if we are working with CakePHP index views, this blog may help you avoid some common mistakes. For this tutorial, we are targetting CakePHP 2 and CakePHP 3.

Prerequisite

  • Knowledge on CakePHP views

Dynamics 365 - Add Icons to Entity Views

Posted on January 21, 2017 by in CRM Solutions

1.   Introduction

Microsoft Dynamics 365 has a new feature added for customizing entity views, where-in we can add custom icons with tool-tip text to display in a column depending on the column value; we can also specify localized tool-tip text.

This can be done by using JavaScript web resource and icons as image web resource. Below are the steps to add icons and tool-tips to entity view.

Dynamics 365 - Backup/Restore online CRM instance

Posted on January 6, 2017 by in CRM Solutions

Maintaining backup of CRM is always suggestible to save organization(s) from unforeseen errors. Microsoft introduced on demand backups for online CRM instances. Backups can be,

Prevent iOS from zooming in on input fields

Posted on January 5, 2017 by in General, iOS, Mobile Technologies

Developing a responsive website that works well across various browsers and devices is tough. The difficulty is compounded by the fact that browser vendors keep adding distinct behaviors to improve user experience. We recently faced an issue with the auto zoom-in feature in Safari on iOS. 

Dynamics 365 - App & Site Map Designer

Posted on December 29, 2016 by in CRM Solutions

Continuing from our previous post of Dynamics 365 features, today we will go through the App Designer and Site map editor.

App Designer:

Apps are solution-aware components which are designed to simplify the work experience of the users. Based on the CRM license apps like Sales, Marketing, Customer Service, Project Service apps are given OOB.

App designer gives a CRM customizer ability to design apps tailored to their users/needs easily. Site map editor is integrated with app designer and simplifies the process of creating navigation and site maps with WYSIWYG designer.