![]() Use the migration wizard to import new records into the CRM. Add Parent IDs to Child spreadsheets, use vlookups if required.Split the data into several spreadsheets, one for each module you want to import into.Import from an improvised spreadsheet database or generic list Use the Zoho migration wizard to add the data to the CRM.Optional – Copy and Paste the data into the Zoho import templates you have created.Optional – Export the tables from Zoho’s destination modules, clear the data to create import templates, leave the column headers.Ensure you add Parent IDs to Child spreadsheets, use vlookups if required.Export the tables from the source CRM into a spreadsheet per module, ensure you have the IDs.That is the error I receive.Before you can do the import, answering the following questions will help you complete your data import. TypeError: 'NoneType' object is not subscriptable R=self._sendRequest(url=url,httpMethod="POST",payLoad=payload,action="IMPORT",callBackData=None)įile "/Users/./zoho_analytics_connector/report_client.py", line 165, in _sendRequestįile "/Users/./zoho_analytics_connector/report_client.py", line 1830, in _init_ĬontHeader = urlResp.headers ![]() Res = enhanced_client.data_upload(import_content=import_content, table_name=ZohoTracking.TABLENAME)įile "push2zoho.py", line 100, in enhanced_data_uploadįile "/Users/./zoho_analytics_connector/enhanced_report_client.py", line 99, in data_uploadįile "/Users/./site-packages/zoho_analytics_connector/report_client.py", line 464, in importData_v2 ![]() Print(f"Error:Check if file exists in the import directory ") With open("./import/tracking3.csv", "r") as f: Then have a method to upload data to existing table, the data_upload() function has the problem.Įnhanced_client = self.get_enhanced_zoho_analytics_client() Just setting email, token, etc using class above Instantiate the Client Class def get_enhanced_zoho_analytics_client(self) -> EnhancedZohoAnalyticsClient:Īssert (not self.OAUTH and self.AUTHTOKEN) or (self.OAUTH and self.REFRESHTOKEN) REFRESHTOKEN = os.getenv("ZOHOANALYTICS_REFRESHTOKEN")ĬLIENTID = os.getenv("ZOHOANALYTICS_CLIENTID")ĬLIENTSECRET = os.getenv("ZOHOANALYTICS_CLIENTSECRET")ĭATABASENAME = os.getenv("ZOHOANALYTICS_DATABASENAME") LOGINEMAILID = os.getenv("ZOHOANALYTICS_LOGINEMAIL") Hence, I installed a wrapped for this ReportClient from ( ).įollowing sample examples from Zoho website and tests in github of wrapper for Zoho in Python3, I implement something like this:įrom zoho_analytics_connector.report_client import ReportClient, ServerErrorįrom zoho_analytics_connector.enhanced_report_client import EnhancedZohoAnalyticsClient Zoho Report Client for Python is not compatible with Python 3. What I found out that the ReportClient provided by Zoho Analytics team Like soĬurl -X POST \ ' ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=JSON&ZOHO_API_VERSION=1.0&ZOHO_IMPORT_TYPE=APPEND&ZOHO_AUTO_IDENTIFY=True&ZOHO_ON_IMPORT_ERROR=ABORT&ZOHO_CREATE_TABLE=False' \ -H 'Authorization: Zoho-oauthtoken *******' \ -H 'content-type: multipart/form-data boundary=-WebKitFormBoundary7MA4YWxkTrZu0gW' \ -F ZOHO_FILE='path_to_csv'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |