Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News category (to tell everyone about your new projects) --- Specify high download rate or total downloads as "HOT" ---...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 Ref")),r_CandidateDetails.get("Candidate Ref"),""); // // start building addrecord request m_Create = Map(); // // specify unique name to ensure we don't duplicate these m_Create.put("Candidate x JobOpening Name",v_Name); // // specify the Zoho Recruit...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 zero or one--and only one--occurrence of the preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID $company_id_1 = 1234; $company_id_2 =...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Named pipes...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 (in this case "Edit CAP exchange fields") Under "Exchange Fields", tick which boxes to output Under "Export format", specify any code lookups (eg. for CAP_STAC, we want the code and the lookup value/name and then something to display if the lookup...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Display Date: no, alongside, popup, both - Parameter: Display Hit Counter: no, alongside, popup, both - Parameter: Specify Group(s) which can refresh thumbnails - Parameter: Description Length - Parameter: Image Rounded Corners (latest browsers only) -...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 Click on 'Save and Next' and you will be asked to check your other CSV files... The only correction I had here is to specify the date/time format: On the Review screen it tells you how many fields were mapped. Amazing but not as useful as it is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 1.6.3- Core script reverted to v1.5.2 - Styled Joomla! Admin Options into sliding panels. - Added Joomla! Admin Option: Specify border color for link. - Now checks if mb_strtolower function exists (regresses to strtolower). - Additional parameters (eg....

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify the output page to be in JSON format: // set content type of this page header('Content-Type: application/json'); // init $api...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 the contact or lead the task is related to. What_Id (JSON Object or Int): ID of the account the contact is associated with. Specify this only when the Who_Id is a contact. $se_module (String): The API name of the parent module that the contact is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 out there that will batch convert your images: 150x100, 200x150, 300x200, and 1:1 Output Thumbnail Quality: allows you to specify smaller/bigger files (haven't noticed much difference in how they display, only in the actual size the image uses of disk...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify page to start from v_StartingPageIndex = 1; // // specify the maximum number of products you think you have on eBay // the actual number will be less than this but this is for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 will actually execute our stored procedure. Here we have called the dataset to launch the Stored Procedure as "SP". You can specify command type and stored procedure name here or you can do this in the next screenshot. Note how all our variables are...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 File Connection..." Browse to the first file in the folder to loop through and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis Under...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 Name, I'll call mine fn_Shopify_Webhook_OrderUpdate Give it a Display Name, I'll give it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY coordinates. Export the report to Excel and all the fields in the section appear in the same...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *