def setUp(self):
httpretty.register_uri(httpretty.POST,
"http://example.com",
body='{"message":"Logged In"}',
content_type="application/json")
self.frappe = FrappeClient("http://example.com", "*****@*****.**",
"password")
def main(username: str = None, password: str = None):
while not username:
username = input("Username: "******"print_format") as it:
for entry in it:
html = None
if entry.name not in PRINT_FORMATS:
continue
with open(entry.path) as html_file:
html = html_file.read()
client.update({
"doctype": "Print Format",
"name": PRINT_FORMATS.get(entry.name),
"html": html,
"css": css,
})
def sync():
# read temperature
print("Reading sensor data...")
sense = SenseHat()
sense.clear()
temperature = sense.get_temperature()
temperature = round(temperature, 1)
print("{} {}".format(temperature, temperature_unit))
# read humidity
humidity = sense.get_humidity()
humidity = round(humidity, 1)
if humidity > 100:
humidity = 100.0
print("{} {}".format(humidity, humidity_unit))
# write data to ERP
print("Logging into ERP {}...".format(server))
client = FrappeClient(server, user, password)
print("Creating sensor data...")
doc = {"doctype": "Sensor data"}
doc["date"] = strftime("%Y-%m-%d")
doc["time"] = strftime("%H:%M")
doc["sensor_name"] = sensor_name
doc["value"] = temperature
doc["unit"] = temperature_unit
client.insert(doc)
print("Inserted " + doc["sensor_name"])
def bioconnect(bioip, attdate, attdate1):
conn = None
client = FrappeClient("https://erpmaxdclghana.com", "Administrator",
"S3kur1tiGH")
bioip = bioip.split(":")
zk = ZK(bioip[1], port=4370)
try:
conn = zk.connect()
curdate = datetime.now().date()
attendance = conn.get_attendance()
for att in attendance:
biodate = att.timestamp.date()
userid = att.user_id
if biodate >= attdate and biodate <= attdate1:
biotime = att.timestamp.time()
emp = client.get_value("Employee", ["name", "employee_number"],
{
"biometric_id": userid,
"status": "Active"
})
if emp:
fetch_attendance(client, emp["name"], biodate, biotime)
except Exception as e:
print e
messagebox.showinfo('Error', e)
def main():
password = getpass()
username = input('Username: '******'print_format') as it:
for entry in it:
html = None
if entry.name not in PRINT_FORMATS:
continue
with open(entry.path) as html_file:
html = html_file.read()
client.update({
'doctype': 'Print Format',
'name': PRINT_FORMATS.get(entry.name),
'html': html,
'css': css
})
def sync():
print("logging in...")
client = FrappeClient("https://xxx.frappecloud.com", "xxx", "xxx")
with open("jobs.csv", "rU") as jobsfile:
reader = csv.reader(jobsfile, dialect='excel')
for row in reader:
if row[0] == "Timestamp":
continue
print("finding " + row[EMAIL])
name = client.get_value("Job Applicant", "name",
{"email_id": row[EMAIL]})
if name:
doc = client.get_doc("Job Applicant", name["name"])
else:
doc = {"doctype": "Job Applicant"}
doc["applicant_name"] = row[NAME]
doc["email_id"] = row[EMAIL]
doc["introduction"] = row[INTRODUCTION]
doc["thoughts_on_company"] = row[THOUGHTS_ON_COMPANY]
doc["likes"] = row[LIKES]
doc["links"] = row[LINKS]
doc["phone_number"] = row[PHONE]
if doc.get("status") != "Rejected":
doc["status"] = "Filled Form"
if name:
client.update(doc)
print("Updated " + row[EMAIL])
else:
client.insert(doc)
print("Inserted " + row[EMAIL])
def sync_master_after_submit(self, method):
server_tujuan = frappe.db.get_single_value("Sync Server Settings",
"server_tujuan")
clientroot = FrappeClient(server_tujuan, "Administrator", "admin")
# frappe.throw(clientroot.get_doc("Company","Jungle"))
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
doc = frappe.get_doc(self.doctype, self.name)
kolom_parent_after_submit = frappe.db.sql(""" SELECT td.fieldname
FROM `tabDocField` td
WHERE parent = "{}"
AND allow_on_submit = 1
GROUP BY td.`fieldname`
ORDER BY OPTIONS; """.format(self.doctype))
pr_doc = {}
for rowkolom in kolom_parent_after_submit:
if str(rowkolom[0]) != "docstatus":
if str(doc.get(str(rowkolom[0]))) != "None":
if not docu_tujuan:
pr_doc.update({
(rowkolom[0]): str(doc.get(str(rowkolom[0])))
})
elif str(rowkolom[0]) != "creation" and str(
rowkolom[0]) != "modified":
pr_doc.update({
(rowkolom[0]): str(doc.get(str(rowkolom[0])))
})
pr_doc.update({"doctype": doc.doctype})
pr_doc.update({"name": doc.name})
# pr_doc_items = []
# for temp_baris_item in self.uoms :
# pr_doc_items.append({
# "uom" : temp_baris_item.uom,
# "conversion_factor" : temp_baris_item.conversion_factor,
# })
# pr_doc.update({ "uoms": pr_doc_items })
# stringdoc = (str(pr_doc)).replace(" u'","'")
# stringdoc = stringdoc.replace("'", '"')
# stringdoc = stringdoc.replace("'", '"')
# stringdoc = stringdoc.replace("{u", "{")
# frappe.throw(stringdoc)
# d = json.dumps(stringdoc)
# frappe.throw(str(pr_doc))
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
if docu_tujuan:
clientroot.update(pr_doc)
else:
clientroot.insert(pr_doc)
def sync_submit_master(self, method):
if self.get("amended_from"):
return
server_tujuan = frappe.db.get_single_value("Sync Server Settings",
"server_tujuan")
clientroot = FrappeClient(server_tujuan, "Administrator", "admin")
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
if docu_tujuan:
pr_doc = clientroot.get_doc(self.doctype, self.name)
clientroot.submit(pr_doc)
def sync_role_master(self, method):
# /home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/role row 14, after insert WARNING
server_tujuan = frappe.db.get_single_value("Sync Server Settings",
"server_tujuan")
clientroot = FrappeClient(server_tujuan, "Administrator", "admin")
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
doc = frappe.get_doc(self.doctype, self.name)
pr_doc = {}
pr_doc.update({"doctype": "Role"})
pr_doc.update({"role_name": doc.role_name})
if docu_tujuan:
clientroot.update(pr_doc)
else:
clientroot.insert(pr_doc)
def http_connection():
connection = True
try:
connection = FrappeClient(settings.erpnext_host, settings.erpnext_user,
settings.erpnext_password)
except SocketTimeout as st:
logging.warning("Connection to %s timed out. (timeout=%s)" %
(st.host, st.timeout))
connection = False
except SocketError as e:
logging.warning("Failed to establish a network connection")
connection = False
return connection
def http_connection():
connection = []
try:
connection = FrappeClient("https://meraki.erp.co.zm", "api",
"Meraki55%%")
except SocketTimeout as st:
print("Connection to %s timed out. (timeout=%s)" %
(st.host, st.timeout))
connection = False
except SocketError as e:
# print("Failed to establish a new connection: %s" % e)
print("Failed to establish a network connection")
connection = False
return connection
def migrate():
print("logging in...")
client = FrappeClient(HOST, USERNAME, PASSWORD)
limit = 100
offset = 0
all_synced = True
while (all_synced):
employees_list = client.get_list('Employee',
fields=['name', 'cnic_no'],
filters={
'name': '024232',
'status': 'Active',
"image": ["<", "0"]
},
limit_start=offset,
limit_page_length=limit)
if (len(employees_list) < limit):
all_synced = False
for employee in employees_list:
try:
emp = client.get_doc('Employee', employee["name"])
filename = "{0}.jpg".format(employee["cnic_no"])
img_str = get_base64_encoded_image(
"source/pictures/{0}".format(filename))
if (img_str):
file_path = upload_file(client=client,
employee=employee["name"],
filename=filename,
filedata=img_str)
if (file_path):
emp = client.get_doc('Employee', employee["name"])
emp["image"] = file_path
client.update(emp)
except Exception as e:
print('Failed to upload file for employee: {0} {1}'.format(
employee["name"], e))
continue
offset += limit
def setUpClass(cls):
cls.conn = FrappeClient(**test_config)
from apiclient import discovery
import oauth2client
from oauth2client import client
from oauth2client import tools
try:
import argparse
flags = argparse.ArgumentParser(parents=[tools.argparser]).parse_args()
except ImportError:
flags = None
SCOPES = 'https://www.googleapis.com/auth/spreadsheets.readonly'
CLIENT_SECRET_FILE = 'client_secret.json'
APPLICATION_NAME = 'Google Sheets API Python Quickstart'
client = FrappeClient("http://pds.intego.rw:8000", "administrator", "pds")
def get_credentials():
home_dir = os.path.expanduser('~')
credential_dir = os.path.join(home_dir, '.credentials')
if not os.path.exists(credential_dir):
os.makedirs(credential_dir)
credential_path = os.path.join(
credential_dir, 'sheets.googleapis.com-python-quickstart.json')
store = oauth2client.file.Storage(credential_path)
credentials = store.get()
if not credentials or credentials.invalid:
flow = client.flow_from_clientsecrets(CLIENT_SECRET_FILE, SCOPES)
def sync_master(self, method):
server_tujuan = frappe.db.get_single_value("Sync Server Settings",
"server_tujuan")
clientroot = FrappeClient(server_tujuan, "Administrator", "admin")
# frappe.throw(clientroot.get_doc("Company","Jungle"))
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
doc = frappe.get_doc(self.doctype, self.name)
if doc.get("docstatus") == 1:
return
if doc.get("amended_from"):
return
kolom_parent = frappe.db.sql(
""" SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tab{}' """
.format(self.doctype))
kolom_child = frappe.db.sql(""" SELECT td.fieldname, td.options
FROM `tabDocField` td
WHERE parent = "{}" AND fieldtype = "Table"
GROUP BY td.`fieldname`
ORDER BY OPTIONS;
""".format(self.doctype))
kolom_table = frappe.db.sql(
"""SELECT td.fieldname, ic.COLUMN_NAME, ic.DATA_TYPE FROM `tabDocField` td
JOIN INFORMATION_SCHEMA.COLUMNS ic ON CONCAT("tab",td.`options`) = ic.`TABLE_NAME`
WHERE parent = "{}" AND fieldtype = "Table"
ORDER BY OPTIONS """.format(self.doctype))
pr_doc = {}
# for temp_baris_item in self.get("uoms") :
# tampungan = temp_baris_item.get("uom")
# frappe.throw(str(tampungan))
for rowkolom in kolom_parent:
if str(rowkolom[0]) != "docstatus":
if str(doc.get(str(rowkolom[0]))) != "None":
if str(rowkolom[1]) == "date" or str(
rowkolom[1]) == "datetime" or str(
rowkolom[1]) == "time":
if not docu_tujuan:
pr_doc.update({
(rowkolom[0]):
str(doc.get(str(rowkolom[0])))
})
elif str(rowkolom[0]) != "creation" and str(
rowkolom[0]) != "modified":
pr_doc.update({
(rowkolom[0]):
str(doc.get(str(rowkolom[0])))
})
else:
pr_doc.update({(rowkolom[0]): (doc.get(str(rowkolom[0])))})
for rowkolom in kolom_child:
if self.get(rowkolom[0]):
pr_doc_items = []
for rowtable in self.get(rowkolom[0]):
pr_doc_child = {}
# frappe.throw(str(rowtable.get("uom")))
for rowbaris in kolom_table:
if rowbaris[0] == rowkolom[0]:
if str(rowbaris[1]) != "docstatus" and str(
rowbaris[1]) != "name":
if str(rowtable.get(str(rowbaris[1]))) != "None":
if str(rowbaris[2]) == "date" or str(
rowbaris[2]) == "datetime" or str(
rowbaris[2]) == "time":
if not docu_tujuan:
pr_doc_child.update({
rowbaris[1]:
str(rowtable.get(str(rowbaris[1])))
})
elif str(
rowbaris[1]) != "creation" and str(
rowbaris[1]) != "modified":
pr_doc_child.update({
rowbaris[1]:
str(rowtable.get(str(rowbaris[1])))
})
else:
pr_doc_child.update({
rowbaris[1]:
(rowtable.get(str(rowbaris[1])))
})
pr_doc_items.append(pr_doc_child)
# frappe.throw(str(pr_doc_items))
pr_doc.update({rowkolom[0]: pr_doc_items})
pr_doc.update({"doctype": doc.doctype})
# pr_doc_items = []
# for temp_baris_item in self.uoms :
# pr_doc_items.append({
# "uom" : temp_baris_item.uom,
# "conversion_factor" : temp_baris_item.conversion_factor,
# })
# pr_doc.update({ "uoms": pr_doc_items })
# stringdoc = (str(pr_doc)).replace(" u'","'")
# stringdoc = stringdoc.replace("'", '"')
# stringdoc = stringdoc.replace("'", '"')
# stringdoc = stringdoc.replace("{u", "{")
# frappe.throw(stringdoc)
# d = json.dumps(stringdoc)
docu_tujuan = clientroot.get_value(self.doctype, "name",
{"name": self.name})
if docu_tujuan:
clientroot.update(pr_doc)
else:
clientroot.insert(pr_doc)
import requests
from pandas.io.json import json_normalize
import numpy as np
from voucher import Voucher, JournalEntryAccount
from frappeclient import FrappeClient
import pandas
import json
try:
client = FrappeClient("https://erp.tecton.cl", "*****@*****.**",
"tecton")
except:
print("ERROR LOGEARSE AL ERP")
raise
with open("output.json", "r") as read_file:
voucher = json.load(read_file)
print(client.get_doc('Journal Entry', 'JV-16352'))
headers = {
'content-type': 'application/json',
'auth_token': 'daSY92P7JMXZzFBkZCDDMYiU'
}
url = 'https://tecton.buk.cl/api/v1/accounting/export?month=10&year=2019&company_id=76.407.152-2'
r = requests.get(url, headers=headers)
buk = json.loads(r.content)
data = json_normalize(
import csv
from frappeclient import FrappeClient
client = FrappeClient("http://54.188.92.179/", "username", "******")
DOC_NAME = "Sales Order"
out_dict = dict()
for doc in client.get_doc(DOC_NAME):
items = client.get_doc(DOC_NAME, doc['name']).get('items')
for item in items:
if item.get('item_name') in out_dict.keys():
a = out_dict[item.get('item_name')]
out_dict[item.get('item_name')] = a + item.get('qty')
else:
out_dict[item.get('item_name')] = item.get('qty')
with open('SalesOrder.csv', mode='w') as csv_file:
writer = csv.writer(csv_file,
delimiter=',',
quotechar='"',
quoting=csv.QUOTE_MINIMAL)
writer.writerow(["Item Name", "Count"])
for key in out_dict.keys():
writer.writerow([key, out_dict[key]])
def initialize(cls):
settings = sg.UserSettings()
Api.api = FrappeClient(settings['-server-'])
Api.api.authenticate(settings['-key-'], settings['-secret-'])
Api.api.get_list("Company")
def add_faturas():
print "Ficheiro clientes_dev.csv deve estar no /TMP"
print "Formato do ficheiro Nomecliente,valor"
print "Mudar o IP do Servidor"
print "Mudar o Usuario e a Senha para Importar"
# client= FrappeClient("http://192.168.229.139:8000","*****@*****.**","demo123456789")
client = FrappeClient("http://127.0.0.1:8000", "*****@*****.**",
"demo123456789")
# loop no txt,csv and get Client, Valor
# Lancamento de Devedores com IS OPENING=1
with open('/tmp/clientes_dev.csv') as csvfile:
readCSV = csv.reader(csvfile)
print "Lendo o ficheiro..."
for row in readCSV:
if (len(row[0]) > 1): #(row[0].strip() != "0"):
nomecliente = row[0]
valorcliente = row[1]
print nomecliente
print valorcliente
try:
existe = frappe.get_doc("Customer", nomecliente)
except frappe.DoesNotExistError:
print "Cliente ", unicode(
nomecliente.strip()), " nao existe"
print existe.name == nomecliente
if (existe.name == nomecliente):
doc = {
"company":
"AngolaERP",
"conversion_rate":
1.0,
"currency":
"KZ",
"customer":
nomecliente,
"customer_name":
nomecliente,
"debit_to":
"31121000-Clientes Nacionais - CF",
"docstatus":
0,
"doctype":
"Sales Invoice",
"due_date":
frappe.utils.nowdate(),
"is_opening":
"Yes",
"is_pos":
0,
"is_recurring":
0,
"is_return":
0,
"items": [{
"cost_center": "Main - CF",
"item_code": "BFWDB",
"qty": 1.0,
"rate": flt(valorcliente)
}],
"status":
"Draft",
"submit_on_creation":
0,
"taxes": [{
"account_head":
"34210000-Imposto De Producao E Consumo - CF",
"charge_type": "On Net Total",
"cost_center": "Main - CF",
"description": "IPC %10",
"included_in_print_rate": 0,
"rate": 10.0
}],
"taxes_and_charges":
"Imposto de Consumo"
}
print doc
x = client.session.post(
"http://127.0.0.1:8000/api/resource/Sales Invoice",
data={"data": json.dumps(doc)})
print x
client.logout()
