Assuming from is required, the following 419 results were found.
-
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
companies). This will have an impact on some of the systems date and time operations (eg. if you get an e-mail at 2am PST from the server, this is also 10am GMT – e-mails from people will use the timezone they are accessing the service from). Additional...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the format of non-XML data within an XML document redefine Redefines simple and complex types, groups, and attribute groups from an external schema restriction Defines restrictions on a simpleType, simpleContent, or a complexContent schema Defines the...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
this. The client wanted restricted users to be able to search the PDF indexer but not to return any other Joomla articles from other categories. Public users should not be able to use this search or see the restricted documents. I've googled far and...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these don't...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to open the Chrome browser with that profile. How? So you will need to be able to run AutoHotkey or create executables from an AHK file. Here is the code that creates a GUI with a ListView with rows that can be double-clicked to open the profile. As an...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
for the month before, and duplicates each one for the new month. How? First you have to get all the applicable fields from the settings API. In API v2, you have to do it this way apparently. So setup a Zoho Oauth connector (see the end of this article...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in the sendmail is not supported in Zoho Creator and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment" message: "This is a test" attachments: file:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you were making the connection): From within books (or inventory, subscriptions as these are simillar), go to edit a custom function and click on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
l_RecordsToSend); // // this is REST API so by default all triggers run. Use an empty list to stop or prevent these from triggering. m_Data.put("trigger",[]); // // send via REST API v2.1 on EU datacenter r_CreateCrmQuote = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF