#!/usr/bin/env python # -*- coding: utf-8 -*- from SugarCRMAPI import SugarCRMAPI import os from os.path import basename import csv host = "" user_name = "" password = "" clientId = "" clientSecret = "" directory = "" api = SugarCRMAPI(host, clientId, clientSecret) result = api.oauth2_token(user_name, password) # Validar access_token uploaded = False with open('result.csv', 'wb') as csvfile: spamwriter = csv.writer(csvfile, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL, skipinitialspace=True) for dirname, dirnames, filenames in os.walk(directory): if uploaded: break for filename in filenames: if uploaded: break path = os.path.join(dirname, filename) filename, file_extension = os.path.splitext(path)
from SugarCRMAPI import SugarCRMAPI import os from os.path import basename import csv import mimetypes host = "" user_name = "" password = "" clientId = "" clientSecret = "" directory = "" field_name = "" csv_import = "" module_name = "" api = SugarCRMAPI(host, clientId, clientSecret) result = api.oauth2_token(user_name, password) with open(csv_import, 'rb') as csvfile: reader = csv.DictReader(csvfile) for row in reader: url = "{module_name}/{1}/file/{3}?format=json&delete_if_fails=true&oauth_token={2}".format( module_name=module_name, row['producttemplate_id'], api.access_token, ) path = "{1}/{0}".format(row['path'], directory) file_content = open(path, 'rb') filename, file_extension = os.path.splitext(path) content_type = mimetypes.types_map[file_extension] result = api.upload(url, file_content, content_type, field_name)
from SugarCRMAPI import SugarCRMAPI import os from os.path import basename import csv import mimetypes host = "" user_name = "" password = "" clientId = "" clientSecret = "" directory = "" field_name = "" csv_import = "" module_name = "" api = SugarCRMAPI(host, clientId, clientSecret) result = api.oauth2_token(user_name, password) with open(csv_import, 'rb') as csvfile: reader = csv.DictReader(csvfile) for row in reader: url = "{module_name}/{producttemplate_id}/file/{field_name}?format=json&delete_if_fails=false&oauth_token={access_token}".format(module_name=module_name,producttemplate_id=row['producttemplate_id'], access_token=api.access_token,field_name=field_name ) path = "{1}/{0}".format(row['path'],directory) file_content = open(path,'rb') filename, file_extension = os.path.splitext(path) content_type = mimetypes.types_map[file_extension.lower()] result = api.upload(url, file_content, content_type, field_name) print "{0}#ProductTemplates/{1}".format(host,row['producttemplate_id'])
#!/usr/bin/env python # -*- coding: utf-8 -*- from SugarCRMAPI import SugarCRMAPI import os from os.path import basename import csv host = "" user_name = "" password = "" clientId = "" clientSecret = "" api = SugarCRMAPI(host, clientId, clientSecret) result = api.oauth2_token(user_name, password) with open('products.csv', 'rb') as csvfile: reader = csv.DictReader(csvfile) for row in reader: print row['producttemplate_id'] result = api.create_link("ProductTemplates", row['producttemplate_id'], "producttemplates_documents_1", row['document_id']) print result
#!/usr/bin/env python # -*- coding: utf-8 -*- from SugarCRMAPI import SugarCRMAPI import os from os.path import basename import csv host = "" user_name = "" password = "" clientId = "" clientSecret = "" directory = "" api = SugarCRMAPI(host, clientId, clientSecret) result = api.oauth2_token(user_name, password) # Validar access_token uploaded = False with open('result.csv', 'wb') as csvfile: spamwriter = csv.writer(csvfile, delimiter=',',quotechar='"', quoting=csv.QUOTE_ALL, skipinitialspace=True) for dirname, dirnames, filenames in os.walk(directory): if uploaded : break for filename in filenames: if uploaded : break path = os.path.join(dirname, filename) filename, file_extension = os.path.splitext(path) if file_extension == ".pdf": data = { "name": basename(filename), } result = api.save('Documents',data)