Assuming lipman is required, the following 660 results were found.
-
What? A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Applies to: Apimo Webservice 2.0 (apimo.com) PHP v5.5 What? This is an article on how I connected to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
The Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why?...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
What? A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
What? An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
I decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
Some more distractions. This is my filming of some Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *