What?
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 ...
... connection manager but this is inefficient and not versatile enough to accommodate files that get added later.
Why?
I am creating an extract SSIS package intended to take a text file as its source ...
What?
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud:
Error: The conditional operation ...
What?
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Why?
If you are simply using a text file as your data source, then ...
... "Maci", "Macala", "Mack", "Macoy", "Macey", "Macedonia"...
Source(s):
Wikipedia: Category: Compound surnames
Diana, Goddess of the Hunt - Every-Name Index to Family Group Sheets: Mac / Mc
Wikipedia ...
What?
There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...
What?
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday.
Why?
I think it's the US system which generally says that a week starts on a ...
What?
A quick article on getting the payment terms in Zoho Books along with their IDs.
Why?
I often need to send through an automatic payment term on the creation of an invoice but lots of my ...
What?
One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory:
Why?
Who uses ZohoInventory ...
... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks
Source(s):
ZohoCRM: ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
... string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime()
Source(s)
Zoho CRM v3 Organization API
Zoho Community Forums ...
... "Message: " + r_ZohoShipmentUpdate.get("message");
}
}
}
}
}
}
}
}
Caveat(s):
Limited to 250 requests per day (can be upgraded at a cost)
Source(s):
DH ...
... on each row and then the campaigns as columns.
What we want:
Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3
---------------- --------------- -------------- -------------- ...
... Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI.
If I train OpenAI on a dataset, can that data be accessed by external sources?
No, ...
What?
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory ...
What?
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well.
Why?
Because I need this ...
... 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 ...
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.