... " ");
// adding an apostrophe/single-quote to ID values so MS Excel doesn't round them up
v_ProductIDStr = "\"'" + v_ProductID + "\"";
v_VariantIDStr = "\"'" + v_VariantID + "\"";
v_InventoryIDS ...
... TSV, Text, Excel, MS Access DB, HTML, JSON, XML and others:
Supports server types of FTP, FTPS - File Transfer over Explicit TLS/SSL, FTPS - File Transfer Over Implicit TLS/SSL, and SFTP - SSH File ...
... Lipman: Zoho Deluge: Generate List of TimeZones
Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file)
Wikipedia: Daylight saving time by country
Wikipedia: List of tz database time ...
...
Source(s):
Joel Lipman: Zoho Deluge: Generate List of TimeZones
Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file)
Wikipedia: Daylight saving time by country
Wikipedia: ...
...
Source(s):
Zoho Deluge: Supported Time Zones
Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file)
Wikipedia: Daylight saving time by country
Wikipedia: List of tz database time ...
... someone may want to open this in Google Sheets or Microsoft Excel:
//
// init
l_NewCSVrows = List();
v_ThisEventTime = zoho.currenttime;
//
// loop through dataset
for each r_Event in zoho.crm.getRecords("Events", ...
What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
Applies To:
MS SQL Server 2008 R2
MS Windows 7 Enterprise (Client)
MS Excel 2010
What?
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...
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 ...
...
This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we ...
... Report on development per project (GANTT?)
--- Report on server bandwidth (security concerns)
--- Use flash charts
--- Publish to URL (for public/registered access)
--- Export to Excel (Joomla! admins ...
... tank - Study the basics from this; I will not be covering them.
- W3Schools - Many links listed below will take you to this website, which is an excellent resource for learning JavaScript in depth.Thank ...
... Excel (if installed) excel Microsoft Frontpage (if installed) frontpg Microsoft Movie Maker moviemk Microsoft Paint mspaint Microsoft Powerpoint (if installed) powerpnt Microsoft Word (if installed)/td>winword ...
... &rs:Format=XML
Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0
So to export to PDF in landscape
http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render ...
... we added just before. You can now right-click on the top of the [Order] column (grey square -like excel- to select the column). Select "delete columns".
Still deleting: Make sure you select ...
... use
Create custom documentation for back-end (admin panel) use.
Links to basic documentation
Issues and Errors List
Issues List
Create an excel spreadsheet ...
I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.