Blog

22
Jun

Batch process for bulk upload ‐ A Digital Agency US

A Digital Agency US This PHP application is a support tool for Google Adwords MCC account with the help of the Adwords API client library. This application automates the operations in bulk including the creation of shopping campaigns, adding schedules to campaigns, associating re-marketing lists(Audiences) to campaigns and Bid strategy download. Each operations imports CSV sheet of about 2000 rows. The fast and accurate execution reduces the complexity of these things done in adwords account UI. The major requirements includes Shopping campaign creation Ad-Scheduling Audience

07
May

SharDB, HyperDB and Multi-DB = Part 2

Part 1 is here.   HyperDB   HyperDB plugin is the implementation of replication property of WP Hyperdb. HyperDB plugin requires a master DB and a number of slaves are connected to master DB. Read and/or write permissions can be assigned to each databases. In this setup, the slaves have the same data, and act as fail over and load distribution nodes. If a database fails or if HyperDB cannot find something on a database, it auotmatically switches to another slave.   The

22
Jan

SharDB, HyperDB and Multi-DB = Part 1

The Problem   As part of the WordPress Multi-Site Installation which involved more than 600,000 blogs, the biggest problem was that mySQL installation cannot support so many tables required for as many blogs. The filesystem was the real bottleneck here as there is a limit to the number of subdirectories that can be formed and mySQL will cross this if we create 600k blogs as each blog requires 9 tables.   Solution   The solution is very obvious, to split the blogs into multiple databases. We

21
Nov

ZenDesk API Integration to get ticket details daily

Aim: To get count of tickets for every day.   User flow and implementation:   Step 1: Authorization as per https://support.zendesk.com/entries/24458591-Using-OAuth-authentication-with-your-application   Redirect the user to the authorization page in ZenDesk Get authorized using the access token.   Step 2: Get count of tickets created for a particular date.   curl Call:   curlWrap($zendfetchmail, $zendfetchkey, $zendfetchurl, "/api/v2/search.json?query=created>$dayin", null, "GET"); Note: curlWrap is a curl function which gives the response output. It passes the parameters of <mail_id>,<API key>, <app_url>,<request url>.   <request url> specifies our request. If we want to request

05
Oct

Xero API Integration to get Total Sales

Aim: A tool where multiple Xero Account users can add their Xero Accounts easily and can get daily statistics from Xero and store it locally for further analysis..   Links: http://developer.xero.com/documentation/getting-started/public-applications/   User flow and implementation: A button called “Connect to Xero” to start the process of integrating a user xero account. If the user clicks on this button, it redirects to Xero and asks the user to login if the user does not have an existing Xero

21
May

XML formatting using xmllint

XMLs can come in varying shapes and sizes and often we encounter XMLs which are not formatted and hence not easy on the eye. We used to write emacs macros to format these ugly ones, but not any more. Because xml lint is here and is so easy to use in Ubuntu.   xmllint is pre-installed in Ubuntu. To make a good looking and readable XML, use: xmllint -format ugly.xml -output pretty.xml Just used it to read a one line, pretty huge XML file

05
Nov

Optical Character Recognition (OCR) is a widely used technology for extracting text from the scanned or camera images containing text.   One of our clients gave as a challenging task to see if we can improve the Tesseract Output somehow. They have been using Tesseract, but not with a satisfying performance or output. The challenge was to see if we can somehow improve the performance. After the steps outlined below, we were able to improve the accuracy by 52%.     This technology

05
Nov

Comparing different OCR packages

Optical Character Recognition (OCR) is a widely used technology for extracting text from the scanned or camera images containing text. There are different types of Open source and Commercial OCR Software. In this article, We will compare between the best of the available OCR software in the Open source and Commercial.     A general Comparison between different OCR software is given in this wiki article. But There is no sample data on the OCR efficiency.

30
Oct

Again, working on a different QA project testing the iOS app and the various versions of it that the development team keeps releasing very fast. Getting the logs and stack trace is going to be very helpful for the development team and this is what we did:     Getting Console Output Without Xcode When installing Xcode isn't an option, download the iPhone Configuration Utility to save Console output. It is available for both Mac OS X and Windows.  Plug in the device and open

30
Oct

Getting stack trace of a crash from android devices

We were working on the QA project of a mobile app for a LA based startup. As a WA presence, it is helpful if we can report the crashes along with the stack traces which will help the developers to find the root cause very quickly and resolve it. This is particularly important in the domain of mobile apps, as the crash can in most cases be device dependent and O/S dependent and may not always be reproducible on handsets