Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data ...; Created on 02 July 2024
2. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with ...; Created on 05 December 2023
3. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see ...; Created on 29 March 2023
4. Excel - Check a column for values found in another column: / Excel /; ... 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 automatically change when you copy the formula to other parts of the spreadsheet ...; Created on 14 February 2019
5. MS Excel - Split Workbook into separate files per sheet: / Excel /; What? This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file ...; Created on 11 February 2019
6. Include a carriage return in a column heading: / SQL Server /; ... headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before ...; Created on 07 July 2014
7. Excel: Find values in one column that are not in another: / Excel /; ... in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 ...; Created on 06 March 2014
8. MS Excel - Sort pivottable column headings by date: / Excel /; ... made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because ...; Created on 12 April 2013
9. Convert Decimal (Person Days) to Time in Excel: / Excel /; What? We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...; Created on 13 February 2013
10. Search a database for a string (MySQL, T-SQL): / Databases /; What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...; Created on 08 October 2012
11. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; The Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The ...; Created on 30 September 2011
12. Developer's Checklist: Taking over a projec: / Web-Development /; ... rights/roles in the system (reasons for different accesses) Get all known logins (database, ftp, sftp, ssl, site logins: test & admins) List all files, their purpose (consider a spreadsheet of all ...; Created on 01 March 2011
13. Project Plan for Freelance Website: / Web-Development /; ... use Create custom documentation for back-end (admin panel) use. Links to basic documentation Issues and Errors List Issues List Create an excel spreadsheet ...; Created on 25 February 2010