Assuming data is required, the following 229 results were found.
-
I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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 Problem We can select all cells and set row height to be 30 for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
on the Sales Order but does not associate any records... not sure why this is. So we have a workaround, by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
eBay allows users to request the deletion of their personal data from eBay's own systems, as well as from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Zoho Widget SDK. Why? At time of print, I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
r_Fields = zoho.writer.getMergeFields(v_TemplateID, "joels_connector"); info r_Fields; // // map data to these fields m_Data = Map(); m_Data.put("Contact.First_Name", r_ContactRecord.get("First_Name")); m_Data.put("Contact.Last_Name",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Auth_Token + "@api.twilio.com/2010-04-01/Accounts/" + v_Account_SID + "/Messages.json"; // // build up the JSON request m_Data = Map(); m_Data.put("Body",v_Message); m_Data.put("From",v_OurTwilioNumber); m_Data.put("To",v_CustomerNumber); // // JSON...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I could customize the receiving PHP script to receive a JSON request and process it that way but my usage was to send data to a Third-Party API over which I had no control. What I need to send to the 3rd-party API: { "auth": { "secret":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
below to see if this helps anyone: Stop Workflows from executing: l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes); l_Triggers = List(); l_Triggers.add("none"); m_Data.put("trigger",l_Triggers); v_Url =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the data to be overwritten,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
{ v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData = Map(); m_FieldTextData = Map(); m_FieldBooleanData = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *