Assuming into is required, the following 207 results were found.
-
entirely in UTF-8, I would simply load the received XML with SimpleXML and use the built-in PHP JSON_encode function. I ran into the following errors: Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 1: parser error...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Click on "Create" You will be issued a Client ID and Client Secret, make a note of these or leave this window to copy&paste into the next step. Setting up the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type == "Subform1") { // store the first subform into a collection c_SubformRows = r_Record.mySubform1; } // set an else if condition else if(r_Record.Type == "Subform2") { // store...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Display Name: FN - Xero - Receive Webhook Description: Function used to receive webhooks from Xero and parse these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
system but important to some staff... How? In an earlier article, I've shown how to change a radio type field in ZohoCreator into a Carousel type of interface. This time, we're going to repurpose and restyle a radio type field into a color picker....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
is the first and 'hits' in descending (so most hit first) For specific categories For my website, I've shoved all my links into one page because I didn't like how weblink categories display on the weblinks page. I could modify the page for categories...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
ask for the surplus money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # eg. search for 'foo' matches 'a foo a' but not 'a food a'. function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to shove all these files into a folder which I will then compress and install using the Joomla! CMS Extension Manager. I'm going to call the folder...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Click on the list to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening cursor for the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves their cursor into the field or clicks on it. In this specific case, if the value is "Name:", then clear the field and change the color to black (so...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
(myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo site. If you want to reset the visitor count and...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF