Assuming joel is required, the following 656 results were found.
-
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
-
This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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
-
Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Specify Data Range", xTitleId,...
- 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: *
-
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: *
-
What? A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How?...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *