Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 as we want the code to read from the input fields dynamically and in real-time. To this end, I create a field called "Audit_Change" and then I add to it our workflow with the main bit of code. For any other field that needs to update this preview, I...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database...

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

MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the system. Approvers can e-sign an article (approving it) by clicking on a button. We want to...

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

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

28 June 2011 in terms of processing and disk space. The program doesn't care what sites you've done or how many times you used it (no audit trail). Client-side: Server solutions take up processing power in order to convert/download these on-the-fly. Use this program...

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

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

02 September 2011 which will open another report (the confirmation page) and pass through 2 parameters (the Student ID and the Job ID [for audit purposes]). The 3rd parameter is the Username of the person running the report. This second page is called "HouseKeepForm". We...

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

SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle error usually returns in the format of -12345. If we want to look...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 for files (default is /COPY:DAT). (copyflags : D=Data, A=Attributes, T=Timestamps). (S=Security=NTFS ACLs, O=Owner info, U=aUditing info). /DCOPY:T :: COPY Directory Timestamps. /SEC :: copy files with SECurity (equivalent to /COPY:DATS). /COPYALL ::...

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

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 Store/Save Testing: Monitoring the monitors Some useful tools: Stu-Talk Monitor Details (SMD): The SITS application audit giving details on each process. Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters. Stu-Talk Monitor...

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

Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 installing any third-party extensions and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 HH:mm:ss") + "\",\"" + v_ThisEventNote + "\""; l_NewCSVrows.add(v_NewCSVline); } // // generate CSV v_CSVFilename = "audit-log-" + v_ThisEventTime.toString("yyyy-MM") + ".csv"; v_CSVFile = l_NewCSVrows.toString("\n").toFile(v_CSVFilename); // // send...

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