Latest Contributions by DambéSANWOGOU

Hello, I had the same thing, I had put passwords with very complicated characters, when I made the update, everything is ok. Thanks ... View more

Any response for me please ???   ... View more

Any news for integrating Plus Codes Into Esri's Suite of Products ... View more

Thank you Jake Skinner , I got to do this. I added a python code to make an authentication for email. import requests, json, datetime, time, smtplib, math from datetime import timedelta # Disable warnings requests.packages.urllib3.disable_warnings() # Variables username = 'xxxxxxxxxxx'        # AGOL Username password = 'xxxxxxxxxxxxxx'    # AGOL Password URL = 'https://services3.arcgis.com/Wobi1dRiFkLPw0IP/arcgis/rest/services/TestPUDCUpdate/FeatureServer/0/query'       # Feature Service URL uniqueID = 'OBJECTID'           # i.e. OBJECTID dateField = 'CreationDate'      # Date field to query hoursValue = 1                  # Number of hours to check when a feature was added fromEmail = 'anselme.s@hitech-services.com' # Email sender toEmail = 'anselme.s@hitech-services.com'   # Email receiver smtpServer = 'xxxxxxxxxxxxxxxx'    # SMPT Server Name portNumber = xxx                 # SMTP Server port # Create empty list for uniqueIDs oidList = [] # Generate AGOL token try:         print('Generating Token')         tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'         params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}         r = requests.post(tokenURL, data=params, verify=False)         response = json.loads(r.content)         token = response['token'] except:         token = '' # Return largest ObjectID whereClause = '1=1' params = {'where': whereClause, 'returnIdsOnly': 'true', 'token': token, 'f': 'json'} r = requests.post(URL, data = params, verify = False) response = json.loads(r.content) try:     response['objectIds'].sort() except Exception as e:     print("Error: {0}".format(e)) OIDs = response['objectIds'] count = len(response['objectIds']) iteration = int(response['objectIds'][-1]) minOID = int(response['objectIds'][0]) - 1 OID = response['objectIdFieldName'] # Query service and check if created_date time is within the last hour if count < 1000:     params = {'f': 'pjson', 'where': "1=1", 'outFields' : '{0}, {1}'.format(uniqueID, dateField), 'returnGeometry' : 'false', 'token' : token}     r = requests.post(URL, data=params, verify=False)     response = json.loads(r.content)     for feat in response['features']:         createDate = feat['attributes'][dateField]         createDate = int(str(createDate)[0:-3])         t = datetime.datetime.now() - timedelta(hours=hoursValue)         t = time.mktime(t.timetuple())         if createDate > t:             oidList.append(feat['attributes'][uniqueID]) else:     y = minOID     x = minOID + 1000     ids = response['objectIds']     newIteration = (math.ceil(iteration/1000.0) * 1000)     while y < newIteration:         if x > int(newIteration):             x = newIteration         where = OID + '>' + str(y) + ' AND ' + OID + '<=' + str(x)         print('Querying features with ObjectIDs from ' + str(y) + ' to ' + str(x))         params = {'f': 'pjson', 'where': where, 'outFields' : '{0}, {1}'.format(uniqueID, dateField), 'returnGeometry' : 'false', 'token' : token}         r = requests.post(URL, data=params, verify=False)         response = json.loads(r.content)         for feat in response['features']:             createDate = feat['attributes'][dateField]             if createDate != None:                 createDate = int(str(createDate)[0:-3])                 t = datetime.datetime.now() - timedelta(hours=hoursValue)                 t = time.mktime(t.timetuple())                 if createDate > t:                     oidList.append(feat['attributes'][uniqueID])         x += 1000         y += 1000 print(oidList) # Email Info FROM = fromEmail TO = [toEmail] SUBJECT = 'New Features Added' TEXT = "Features with {0}s {1} were added.".format(uniqueID, oidList) message = """\ From: %s To: %s Subject: %s %s """ % (FROM, ", ".join(TO), SUBJECT, TEXT) # If new features exist, send email if len(oidList) > 0:     smtpObj = smtplib.SMTP(host='smtp host name', port='smtp port')     smtpObj.login("your email","your email password")     smtpObj.sendmail(FROM, TO, message)     print("Successfully sent email")     smtpObj.quit() ... View more

Ok ok Jake Skinner i share it, many thanks, Best regards, Anselme ... View more

Ok Jake Skinner‌ iinvitation send Anselme GIS Developer ... View more

Hi Jake Skinner‌, Need help please, Anselme, GIS Developer ... View more

Hi Jake Skinner‌ i run this code in my python interpreter with this error.Need help please... Generating Token Querying features with ObjectIDs from 0 to 1000 Traceback (most recent call last):   File "C:\Users\SIG02-PC\Desktop\MailSending.py", line 79, in <module>     for feat in response['features']: KeyError: 'features' >>>  The code import requests, json, datetime, time, smtplib from datetime import timedelta import math # Disable warnings requests.packages.urllib3.disable_warnings() # Variables username = '********'        # AGOL Username password = '************'    # AGOL Password URL = 'https://services3.arcgis.com/Wobi1dRiFkLPw0IP/arcgis/rest/services/TestPUDCUpdate/FeatureServer/0/query'       # Feature Service URL uniqueID = 'objectid'           # i.e. OBJECTID dateField = 'Created_Date'      # Date field to query hoursValue = 1                  # Number of hours to check when a feature was added fromEmail = 'anselme.s@hitech-services.com' # Email sender toEmail = 'anselme.s@hitech-services.com'   # Email receiver smtpServer = 'mail.hitech-services.com'    # SMPT Server Name portNumber = 587                 # SMTP Server port # Create empty list for uniqueIDs oidList = [] # Generate AGOL token try:         print('Generating Token')         tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'         params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}         r = requests.post(tokenURL, data=params, verify=False)         response = json.loads(r.content)         token = response['token'] except:         token = '' # Return largest ObjectID whereClause = '1=1' params = {'where': whereClause, 'returnIdsOnly': 'true', 'token': token, 'f': 'json'} r = requests.post(URL, data = params, verify = False) response = json.loads(r.content) try:     response['objectIds'].sort() except Exception as e:     print("Error: {0}".format(e)) OIDs = response['objectIds'] count = len(response['objectIds']) iteration = int(response['objectIds'][-1]) minOID = int(response['objectIds'][0]) - 1 OID = response['objectIdFieldName'] # Query service and check if created_date time is within the last hour if count < 1000:     params = {'f': 'pjson', 'where': "1=1", 'outFields' : '{0}, {1}'.format(uniqueID, dateField), 'returnGeometry' : 'false', 'token' : token}     r = requests.post(URL, data=params, verify=False)     response = json.loads(r.content)     for feat in response['features']:         createDate = feat['attributes'][dateField]         createDate = int(str(createDate)[0:-3])         t = datetime.datetime.now() - timedelta(hours=hoursValue)         t = time.mktime(t.timetuple())         if createDate > t:             oidList.append(feat['attributes'][uniqueID]) else:     y = minOID     x = minOID + 1000     ids = response['objectIds']     newIteration = (math.ceil(iteration/1000.0) * 1000)     while y < newIteration:         if x > int(newIteration):             x = newIteration         where = OID + '>' + str(y) + ' AND ' + OID + '<=' + str(x)         print('Querying features with ObjectIDs from ' + str(y) + ' to ' + str(x))         params = {'f': 'pjson', 'where': where, 'outFields' : '{0}, {1}'.format(uniqueID, dateField), 'returnGeometry' : 'false', 'token' : token}         r = requests.post(URL, data=params, verify=False)         response = json.loads(r.content)         for feat in response['features']:             createDate = feat['attributes'][dateField]             createDate = int(str(createDate)[0:-3])             t = datetime.datetime.now() - timedelta(hours=hoursValue)             t = time.mktime(t.timetuple())             if createDate > t:                 oidList.append(feat['attributes'][uniqueID])         x += 1000         y += 1000 print(oidList) # Email Info FROM = fromEmail TO = [toEmail] SUBJECT = 'New Features Added' TEXT = "Features with {0}s {1} were added.".format(uniqueID, oidList) message = """\ From: %s To: %s Subject: %s %s """ % (FROM, ", ".join(TO), SUBJECT, TEXT) # If new features exist, send email if len(oidList) > 0:     smtpObj = smtplib.SMTP(host=smtpServer, port=portNumber)     smtpObj.sendmail(FROM, TO, message)     print("Successfully sent email")     smtpObj.quit() ... View more

Ok thanks Jonathan Quinn I delete the db folder. I have this error here was an error creating your initial administrator account. java.lang.Exception: Failed to start the database server. The startup timed out. Please check the log file at C:\arcgisportal\logs\\database\pgsql.log. For more information, please view the log messages located in the content directory specified during setup (C:\arcgisportal\logs\). Best regards, Anselme GIS Developer ... View more

Jake Skinner‌ Invitation sent. Regards, ... View more