SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 &S is not workable. Instead I want to use &G[] and get both the code and the lookup value: -- What I have: no export format 5826 -- What I could have: export format set to get lookup value -- &GCOD_NAME.COD.SRS England -- What I want: export format to...

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

Zoho CRM: Schedule a Call using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is set to...

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

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

14 May 2024 reminder time","status":"error"} There was nothing wrong with the date time format here. Just that I was submitting a TRIGGER=DATE-TIME but without the correct additional parameters omitted/needed (in my case the UNTIL given a CRM/Atom date time...

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

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 I did it and what worked for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format -...

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

Returned a data type that is not validhttp://mail.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Parameters not being used in report processinghttp://mail.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the...

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

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 ----------- ----------- ----------- ----------- -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you...

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

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

07 September 2015 you specify a different image type (default is PNG) (eg. PNG to JPG -> means module has to re-download thumbnails into JPG format) - Fixed Bug: Weblink hit counter now works through Joomla! CMS - Date Uploaded: Wed, 13th Jul 2011 1.3.1- Modified code to...

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

AutoHotkey: Get Media Information and Displayhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 , "System.Audio.ChannelCount" , "System.Audio.Compression" , "System.Audio.EncodingBitrate" , "System.Audio.Format" , "System.Audio.IsVariableBitRate" , "System.Audio.PeakValue" , "System.Audio.SampleRate" , "System.Audio.SampleSize" ,...

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

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

11 November 2021 } How? We're going to parse the created date and time parts as well as the timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate =...

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

Zoho CRM: Manage a subform using Client Scripthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display as per the format on the CRM record) v_StartDateFormatted = v_LocalStartDate.toJSON().slice(0,...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal week (in other words, not alphabetical,...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookLog = zoho.crm.createRecord("Webhook_Payloads",m_WebhookLog); */ return {"crmAPIResponse":m_ResponseHeader}; The...

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

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 following screenshot is how your report should look now. Result: You can even run/preview it and you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time From Time To Hours ---------- --------------- --------------- ----------------...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const WM_INPUTLANGCHANGE = $0051 Const WM_TCARD = $0052 Const WM_HELP = $0053 Const WM_USERCHANGED = $0054 Const WM_NOTIFYFORMAT = $0055 Const WM_CONTEXTMENU = $007B Const WM_STYLECHANGING = $007C Const WM_STYLECHANGED = $007D Const WM_DISPLAYCHANGE =...

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

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

07 July 2011 Comments (for Product Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News...

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

Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending order, I would recommend...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 as Start a program for Program/Script, Specify the command path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c start "VisualStudio2010" "C:\Program Files\Microsoft Visual...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *