What?
An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system.
Why? ...
What I have:
A CSV file exported from Excel along with double-quotes
label1,label2
item1a,item2a
item1c,"item2c,c"
item1b,item2b
What I want:
To read the file (stored on the server) and ...
What?
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.
Why? ...
... comment_count
FROM
my_joomla_db.jos_content
ORDER BY
id
Importing the joomla categories to Wordpress: (still to do: sections as parent categories?)
SET @CountCategoriesAlreadyEntered:=(SELECT ...
... is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when receiving and responding to webhooks.
Important!: For the REST ...
... data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only headers)
Click on "Create" then "New Table/Import Data" > Select "Files" (the one with the Excel icon)
Give ...
... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...
... key here to enable inventory tracking
m_CreateBooksItem.put("item_type","inventory");
//
// other less important values to include re purchase information
m_CreateBooksItem.put("product_type","goods");
m_CreateBooksItem.put("reorder_level",0);
m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong());
m_CreateBooksItem.put("initial_stock",v_Quantity.toLong());
m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal());
m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...
... how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client.
Who owns the domain (eg. mycompany.com)
So this ...
... of your data.
That being said, it's important to note that the use and distribution of trained models may be subject to legal or ethical considerations, depending on the nature of the data and the ...
... to your form. I'm going to call it CSS_Overrides. It is important that this field will never be hidden (it cannot be seen on the front-end of the application but it must not be removed by Creator). If ...
... to the same school and updates some number fields on the matched CRM account.
Why?
For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...
... specified in a previous multi-line text field
l_PackageRefs = c_Appt.Associated_Package_Slips1.toList();
//
// important to declare this as a list of integers
l_PackagesToAdd = List:Int();
for ...
... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are:
Setup recurring FTP connection.
Make data readily available to ZohoCRM. ...
What?
This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match ...
... set the param name to file (this is important)
r_CreatorPhoto.setParamName("file");
//
// upload the photo to CRM (and prevent workflows from running)
v_Endpoint2 = "https://www.zohoapis.com/crm/v2/Products/" ...
... Standard as for any usual form without a redirect.
Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as "Save_and_Close" (the field link name is important ...
... it Shopify - Webhook - Order Update
Specify the Category, I'm going to say Standalone
Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won ...
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.