#!/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}/{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'])
