Assuming data is required, the following 218 results were found.
-
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
-
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
-
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: *
-
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
-
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
- 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
- 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
- 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
-
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
- 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
- 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
- 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
- Language: *
-
demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available"....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also output any of the variables and responses for debugging purposes....
- Type: Article
- Author: Joel Lipman
- Category: Google
- 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
- 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
- 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
- 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
- Language: *