dan/StorefrontUtility
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
Files
Dev
StorefrontUtility/XMLTesting.py
Dan Dembinski 5ee6190bc2 Updating to most recent
2021-02-16 11:55:15 -05:00

316 lines
39 KiB
Python
Raw Permalink Blame History

import requests
from datetime import datetime, timedelta
import time
from main import Obtain_Ticket, Release_Ticket
URL = "http://ccm.gli.us.com/store/storefrontapi.asmx"
temp1 = URL.split('://')
temp2 = temp1[1].split('/')
HOST = (temp2[0])
ticket = Obtain_Ticket(URL, HOST)
print("CCM is starting")
now = datetime.now()
first = now.replace(day=1)
lastMonth = first - timedelta(days=1)
previous = lastMonth.strftime("%m/01/%Y")
now = now.strftime("%m/%d/%Y")
REPORT_FIELDS = '<string>Order ID</string>, <string>Order Status</string>'
# ws4 = wb.create_sheet("Downloaded Items")
report_filter = """ <filterNameOrXml>&lt;?xml version="1.0"?&gt; &lt;PFWebFilter:UserFilter xmlns:PFWebFilter="http://www.pageflex.com/schemas/2004/Storefront/UserFilters/20040817" filterClass="Items"&gt; &lt;PFWebFilter:Step publicFieldName="Date/Time Created" query="IsBetweenDate" minValue=""" + '"' + previous + ' 00:00"' + """ maxValue=""" + '"' + now + ' 00:00"' """/&gt; &lt;PFWebFilter:Step publicFieldName="PrintingFreeDownloadOnly" query="ExactEquals" minValue="download" maxValue="" /&gt; &lt;/PFWebFilter:UserFilter&gt;</filterNameOrXml>
"""
send = """<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<GetReport xmlns="http://www.pageflex.com/XmlWebServices/2004/StorefrontAPI/20041111">
<token>""" + ticket + """</token>
<reportName>Items</reportName>
<archived>false</archived>
""" + report_filter + """
<columnNames>"""+REPORT_FIELDS+"""</columnNames>
</GetReport>
</soap12:Body>
</soap12:Envelope>"""
headers = {'Host': HOST, 'Content-Type': 'application/soap+xml; charset=utf-8', 'Content-Length': 'length',
'SOAPAction': 'http://www.pageflex.com/XmlWebServices/2004/StorefrontAPI/20041111/GetReport'}
response = requests.post(url=URL, data=send, headers=headers).text
temp1 = response.split('</GetReportResult>')
temp2 = temp1[1].split('<error />')
report = (temp2[0])
print(report)
Release_Ticket(ticket, URL, HOST)
# from bs4 import BeautifulSoup as bs
# # import csv
# from openpyxl import workbook
#
#
#
# ###REPORT ColumnFormat TESTING#####
#
# with open("StorefrontUtilitiesConfig.xml") as f:
# r = f.read()
#
# y = bs(r, "lxml")
#
# ClientName = []
# SF_URL = []
# SF_HOST = []
# CLIENT_SUMMARY_TAB = []
# SUMMARY_TAB = []
# client_headers = []
# headers = []
#
# CLIENT_COLUMN_FORMAT = []
# COLUMN_FORMAT = []
#
# for x in y.find_all('name'):
# # print(x.text)
# ClientName.append(x.text)
# # print(ClientName)
#
# for w in y.find_all('client'):
# for x in w.find_all('monthlyreport'):
# for g in x.find_all('summarytab'):
# for z in g.find_all('columnname'):
# z.name = "string"
# CLIENT_SUMMARY_TAB.append(z)
# client_headers.append(z.text)
# SUMMARY_TAB.append(CLIENT_SUMMARY_TAB)
# headers.append(client_headers)
# CLIENT_SUMMARY_TAB = []
# client_headers = []
#
#
# for w in y.find_all('client'):
# for x in w.find_all('monthlyreport'):
# for g in x.find_all('summarytab'):
# for z in g.find_all('columnformat'):
# CLIENT_COLUMN_FORMAT.append(z.text)
# COLUMN_FORMAT.append(CLIENT_COLUMN_FORMAT)
# CLIENT_COLUMN_FORMAT = []
#
#
# option = 0
# columnformat = dict.fromkeys(headers[option])
#
#
# for w in y.find_all('client'):
# for x in w.find_all('name'):
# if x.text == ClientName[option]:
# for x in w.find_all('monthlyreport'):
# for g in x.find_all('summarytab'):
# for z in g.find_all('columnformat'):
# CLIENT_COLUMN_FORMAT.append(z.text)
#
# count = 0
#
#
# # print(columnformat)
# for key in columnformat:
# columnformat[key] = CLIENT_COLUMN_FORMAT[count]
# count = count + 1
# print(columnformat)
# external_ids = ['G-ADA-13B0D9D1', 'G-ADA-13A8D9CF']
#
# for z in external_ids:
# report_filter = """&lt;?xml version="1.0"?&gt; &lt;PFWebFilter:UserFilter xmlns:PFWebFilter="http://www.pageflex.com/schemas/2004/Storefront/UserFilters/20040817" filterClass="Items"&gt; &lt;PFWebFilter:Step publicFieldName="Order ID" query="ExactEquals" minValue=""""" + z + """"" maxValue="" /&gt; &lt;/PFWebFilter:UserFilter&gt;"""
# print(report_filter)
#
# report_filter = """<PFWebFilter:UserFilter xmlns:PFWebFilter="http://www.pageflex.com/schemas/2004/Storefront/UserFilters/20040817" filterClass="Orders">
# <PFWebFilter:Step publicFieldName="Balance Due" query="ExactUnequals" minValue="0.00" maxValue="" />
# <PFWebFilter:Step publicFieldName="Order Status" query="ExactEquals" minValue="Completed" maxValue="" />
# </PFWebFilter:UserFilter>"""
# ####XML OUTPUT TESTS#####
#
# r = '<report><ArrayOfString><string>G-SOPREMA-063AF3D7</string><string>$ 47.46</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-93A6C270</string><string>$ 37.06</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-93A6C26C</string><string>$ 66.24</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-EE315084</string><string>$ 61.38</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-EE31507A</string><string>$ 59.74</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-4B89DBE6</string><string>$ 83.13</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-338039BA</string><string>$ 46.38</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C520</string><string>$ 47.46</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C519</string><string>$ 134.80</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C516</string><string>$ 77.54</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-C0EC0977</string><string>$ 61.05</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-C0EC0975</string><string>$ 145.31</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-A8E26745</string><string>$ 93.64</string></ArrayOfString><ArrayOfString><string>G-063AF2AB</string><string>$ 77.32</string></ArrayOfString><ArrayOfString><string>G-F0FF4DBC</string><string>$ 59.72</string></ArrayOfString><ArrayOfString><string>G-EE315064</string><string>$ 43.52</string></ArrayOfString><ArrayOfString><string>G-EE31505B</string><string>$ 36.54</string></ArrayOfString><ArrayOfString><string>G-4B89DBC2</string><string>$ 72.35</string></ArrayOfString><ArrayOfString><string>G-90D8C4FF</string><string>$ 59.01</string></ArrayOfString><ArrayOfString><string>G-90D8C4FB</string><string>$ 87.88</string></ArrayOfString><ArrayOfString><string>G-63937DF3</string><string>$ 109.39</string></ArrayOfString><ArrayOfString><string>G-C0EC095E</string><string>$ 41.42</string></ArrayOfString><ArrayOfString><string>G-A8E26728</string><string>$ 64.25</string></ArrayOfString><ArrayOfString><string>G-A8E26726</string><string>$ 40.35</string></ArrayOfString><ArrayOfString><string>G-063AF294</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-063AF28E</string><string>$ 416.77</string></ArrayOfString><ArrayOfString><string>G-C0EC093B</string><string>$ 26.50</string></ArrayOfString><ArrayOfString><string>G-C0EC093A</string><string>$ 71.67</string></ArrayOfString><ArrayOfString><string>G-E4909E2D</string><string>$ 40.67</string></ArrayOfString><ArrayOfString><string>G-9F41B4F7</string><string>$ 155.14</string></ArrayOfString><ArrayOfString><string>G-41DA2992</string><string>$ 40.04</string></ArrayOfString><ArrayOfString><string>G-FC8B405C</string><string>$ 110.41</string></ArrayOfString><ArrayOfString><string>G-44A926E9</string><string>$ 40.38</string></ArrayOfString><ArrayOfString><string>G-872A12C8</string><string>$ 44.44</string></ArrayOfString><ArrayOfString><string>G-9F33B4F7</string><string>$ 181.27</string></ArrayOfString><ArrayOfString><string>G-59E4CBC1</string><string>$ 147.05</string></ArrayOfString><ArrayOfString><string>G-A202B24E</string><string>$ 40.63</string></ArrayOfString><ArrayOfString><string>G-59E5CBC1</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-44AB26E9</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-29D38763</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-FC8E405C</string><string>$ 39.57</string></ArrayOfString><ArrayOfString><string>G-B73F5726</string><string>$ 39.98</string></ArrayOfString><ArrayOfString><string>G-A204B24E</string><string>$ 39.57</string></ArrayOfString><ArrayOfString><string>G-E4859E2D</string><string>$ 129.38</string></ArrayOfString><ArrayOfString><string>G-9F36B4F7</string><string>$ 61.40</string></ArrayOfString><ArrayOfString><string>G-B7405726</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29D58763</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-41DF2992</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-FC90405C</string><string>$ 44.07</string></ArrayOfString><ArrayOfString><string>G-44AE26E9</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29D68763</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-E4879E2D</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-9F38B4F7</string><string>$ 49.08</string></ArrayOfString><ArrayOfString><string>G-59E9CBC1</string><string>$ 86.02</string></ArrayOfString><ArrayOfString><string>G-44AF26E9</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-873012C8</string><string>$ 159.52</string></ArrayOfString><ArrayOfString><string>G-FC92405C</string><string>$ 39.33</string></ArrayOfString><ArrayOfString><string>G-44B626EA</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29DE8764</string><string>$ 43.74</string></ArrayOfString><ArrayOfString><string>G-E48F9E2E</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-9F40B4F8</string><string>$ 44.75</string></ArrayOfString><ArrayOfString><string>G-59F1CBC2</string><string>$ 100.90</string></ArrayOfString><ArrayOfString><string>G-44B726EA</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-29DF8764</string><string>$ 133.81</string></ArrayOfString><ArrayOfString><string>G-E4909E2E</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-9F41B4F8</string><string>$ 127.24</string></ArrayOfString><ArrayOfString><string>G-59F2CBC2</string><string>$ 40.31</string></ArrayOfString><ArrayOfString><string>G-44A826EA</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-E4819E2E</string><string>$ 54.03</string></ArrayOfString><ArrayOfString><string>G-9F32B4F8</string><string>$ 69.62</string></ArrayOfString><ArrayOfString><string>G-29D18764</string><string>$ 61.64</string></ArrayOfString><ArrayOfString><string>G-E4829E2E</string><string>$ 41.59</string></ArrayOfString><ArrayOfString><string>G-9F33B4F8</string><string>$ 61.01</string></ArrayOfString><ArrayOfString><string>G-59E4CBC2</string><string>$ 64.27</string></ArrayOfString><ArrayOfString><string>G-44AA26EA</string><string>$ 61.64</string></ArrayOfString><ArrayOfString><string>G-E4839E2E</string><string>$ 41.59</string></ArrayOfString><ArrayOfString><string>G-9F34B4F8</string><string>$ 40.01</string></ArrayOfString><ArrayOfString><string>G-B73E5727</string><string>$ 39.60</string></ArrayOfString><ArrayOfString><string>G-872C12C9</string><string>$ 43.04</string></ArrayOfString><ArrayOfString><string>G-41DD2993</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-FC8E405D</string><string>$ 43.04</string></ArrayOfString><ArrayOfString><string>G-44AC26EA</string><string>$ 39.54</string></ArrayOfString><ArrayOfString><string>G-29D48764</string><string>$ 39.54</string></ArrayOfString><ArrayOfString><string>G-E4859E2E</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-FC8F405D</string><string>$ 40.28</string></ArrayOfString><ArrayOfString><string>G-B7405727</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-E4869E2E</string><string>$ 40.57</string></ArrayOfString><ArrayOfString><string>G-9F37B4F8</string><string>$ 89.13</string></ArrayOfString><ArrayOfString><string>G-59E8CBC2</string><string>$ 89.13</string></ArrayOfString><ArrayOfString><string>G-44AE26EA</string><string>$ 40.25</string></ArrayOfString><ArrayOfString><string>G-872F12C9</string><string>$ 54.16</string></ArrayOfString><ArrayOfString><string>G-41E02993</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-FC91405D</string><string>$ 39.51</string></ArrayOfString><ArrayOfString><string>G-44AF26EA</string><string>$ 120.84</string></ArrayOfString><ArrayOfString><string>G-29D78764</string><string>$ 39.27</string></ArrayOfString><ArrayOfString><string>G-E4889E2E</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-FC92405D</string><string>$ 61.24</string></ArrayOfString><ArrayOfString><string>G-B7435727</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-A20EB250</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-59F1CBC3</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-44B726EB</string><string>$ 40.54</string></ArrayOfString><ArrayOfString><string>G-29DF8765</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-E4909E2F</string><string>$ 42.96</string></ArrayOfString><ArrayOfString><string>G-9F41B4F9</string><string>$ 107.82</string></ArrayOfString><ArrayOfString><string>G-B74B5728</string><string>$ 50.23</string></ArrayOfString><ArrayOfString><string>G-A200B250</string><string>$ 81.50</string></ArrayOfString><ArrayOfString><string>G-872912CA</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-FC8B405E</string><string>$ 151.17</string></ArrayOfString><ArrayOfString><string>G-44A926EB</string><string>$ 42.93</string></ArrayOfString><ArrayOfString><string>G-29D18765</string><string>$ 41.44</string></ArrayOfString><ArrayOfString><string>G-E4829E2F</string><string>$ 41.44</string></ArrayOfString><ArrayOfString><string>G-44AA26EB</string><string>$ 53.74</string></ArrayOfString><ArrayOfString><string>G-B73F5728</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-A204B250</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872D12CA</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-41DE2994</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC8F405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-B7405728</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-A205B250</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC90405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-B7415728</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-872F12CA</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-41E02994</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC91405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-44AF26EB</string><string>$ 40.15</string></ArrayOfString><ArrayOfString><string>G-29D78765</string><string>$ 40.15</string></ArrayOfString><ArrayOfString><string>G-41E12994</string><string>$ 45.13</string></ArrayOfString><ArrayOfString><string>G-FC92405E</string><string>$ 51.28</string></ArrayOfString><ArrayOfString><string>G-29DE8766</string><string>$ 67.94</string></ArrayOfString><ArrayOfString><string>G-FC99405F</string><string>$ 48.71</string></ArrayOfString><ArrayOfString><string>G-B74A5729</string><string>$ 67.94</string></ArrayOfString><ArrayOfString><string>G-29DF8766</string><string>$ 43.54</string></ArrayOfString><ArrayOfString><string>G-9F41B4FA</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-44A826EC</string><string>$ 43.80</string></ArrayOfString><ArrayOfString><string>G-29D08766</string><string>$ 42.08</string></ArrayOfString><ArrayOfString><string>G-41DA2995</string><string>$ 41.76</string></ArrayOfString><ArrayOfString><string>G-59E3CBC4</string><string>$ 42.08</string></ArrayOfString><ArrayOfString><string>G-29D18766</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-872A12CB</string><string>$ 41.79</string></ArrayOfString><ArrayOfString><string>G-9F33B4FA</string><string>$ 41.79</string></ArrayOfString><ArrayOfString><string>G-A202B251</string><string>$ 37.96</string></ArrayOfString><ArrayOfString><string>G-E4839E30</string><string>$ 37.96</string></ArrayOfString><ArrayOfString><string>G-59E5CBC4</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-44AB26EC</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-29D38766</string><string>$ 97.74</string></ArrayOfString><ArrayOfString><string>G-41DD2995</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-FC8E405F</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-B73F5729</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-A204B251</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872D12CB</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-41DE2995</string><string>$ 36.13</string></ArrayOfString><ArrayOfString><string>G-B7405729</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-A205B251</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872E12CB</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-29D68766</string><string>$ 32.50</string></ArrayOfString><ArrayOfString><string>G-E4879E30</string><string>$ 32.50</string></ArrayOfString><ArrayOfString><string>G-9F38B4FA</string><string>$ 47.50</string></ArrayOfString><ArrayOfString><string>G-44AF26EC</string><string>$ 47.50</string></ArrayOfString><ArrayOfString><string>G-29D78766</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-E4889E30</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-9F39B4FA</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-59EACBC4</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC1B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB7B789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB8B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB8B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB5B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB9B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78E</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78E</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDCAB78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDCAB78E</string><string>$ 0.00</string></ArrayOfString></report>'
# y = bs(r, "lxml")
# results = []
# # print(y.report.arrayofstring)
#
# wb = workbook.Workbook()
# ws = wb.active
# ws.title = "Order Summary"
#
#
# for child in y.report:
# for childs in child:
# results.append(childs.text)
# ws.append(results)
# results = []
# wb.save('report.xlsx')
#
# # for child in y.report:
# # for childs in child:
# # results.append(childs.text)
# # print(results)
# # results = []
####REPORT SELECTION TESTING#####
#
# with open("Config_ORIG.xml") as f:
# r = f.read()
#
# y = bs(r, "lxml")
#
# ClientName = []
# SF_URL = []
# SF_HOST = []
# CLIENT_SUMMARY_TAB = []
# SUMMARY_TAB = []
#
# for x in y.find_all('name'):
# # print(x.text)
# ClientName.append(x.text)
# # print(ClientName)
#
#
# for w in y.find_all('client'):
# for x in w.find_all('monthlyreport'):
# for g in x.find_all('summarytab'):
# for z in g.find_all('columnname'):
# z.name="string"
# CLIENT_SUMMARY_TAB.append(z)
# SUMMARY_TAB.append(CLIENT_SUMMARY_TAB)
# CLIENT_SUMMARY_TAB = []
#
# print(SUMMARY_TAB[1])
# REPORT_FIELDS = '\n'.join(map(str, SUMMARY_TAB[1]))
# print(REPORT_FIELDS)
####REPORT SELECTION TESTING SUMMARY TAB#####
#
# with open("Config_ORIG.xml") as f:
# r = f.read()
#
# y = bs(r, "lxml")
#
# ClientName = []
# SF_URL = []
# SF_HOST = []
# CLIENT_SUMMARY_TAB = []
# SUMMARY_TAB = []
#
# for x in y.find_all('name'):
# # print(x.text)
# ClientName.append(x.text)
# # print(ClientName)
#
#
# for w in y.find_all('client'):
# for x in w.find_all('monthlyreport'):
# for g in x.find_all('summarytab'):
# for z in g.find_all('columnname'):
# z.name="string"
# CLIENT_SUMMARY_TAB.append(z)
# SUMMARY_TAB.append(CLIENT_SUMMARY_TAB)
# CLIENT_SUMMARY_TAB = []
#
# print(SUMMARY_TAB[1])
# REPORT_FIELDS = '\n'.join(map(str, SUMMARY_TAB[1]))
# print(REPORT_FIELDS)
#####XML CLIENT/URL CONFIG AND MENU TESTING#####
# with open("Config_ORIG.xml") as f:
# r = f.read()
#
# y = bs(r, "lxml")
#
# ClientName = []
# SF_URL = []
# SF_HOST = []
#
# for x in y.find_all('name'):
# # print(x.text)
# ClientName.append(x.text)
# # print(ClientName)
#
# for x in y.find_all('storefrontapiurl'):
# # print(x)
# SF_URL.append(x.text)
# # print(SF_URL)
#
# for x in SF_URL:
# temp1 = x.split('://')
# temp2 = temp1[1].split('/')
# HOST = (temp2[0])
# SF_HOST.append(HOST)
# # print(SF_HOST)
#
#
# choice = 0
# for x in ClientName:
# print(choice, x)
# choice = choice + 1
#
# yeah = int(input())
# print(SF_URL[yeah])
# print(SF_HOST[yeah])
####REPORT XML PARSING TESTS#####
# r = '<report><ArrayOfString><string>G-SOPREMA-063AF3D7</string><string>$ 47.46</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-93A6C270</string><string>$ 37.06</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-93A6C26C</string><string>$ 66.24</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-EE315084</string><string>$ 61.38</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-EE31507A</string><string>$ 59.74</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-4B89DBE6</string><string>$ 83.13</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-338039BA</string><string>$ 46.38</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C520</string><string>$ 47.46</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C519</string><string>$ 134.80</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-90D8C516</string><string>$ 77.54</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-C0EC0977</string><string>$ 61.05</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-C0EC0975</string><string>$ 145.31</string></ArrayOfString><ArrayOfString><string>G-SOPREMA-A8E26745</string><string>$ 93.64</string></ArrayOfString><ArrayOfString><string>G-063AF2AB</string><string>$ 77.32</string></ArrayOfString><ArrayOfString><string>G-F0FF4DBC</string><string>$ 59.72</string></ArrayOfString><ArrayOfString><string>G-EE315064</string><string>$ 43.52</string></ArrayOfString><ArrayOfString><string>G-EE31505B</string><string>$ 36.54</string></ArrayOfString><ArrayOfString><string>G-4B89DBC2</string><string>$ 72.35</string></ArrayOfString><ArrayOfString><string>G-90D8C4FF</string><string>$ 59.01</string></ArrayOfString><ArrayOfString><string>G-90D8C4FB</string><string>$ 87.88</string></ArrayOfString><ArrayOfString><string>G-63937DF3</string><string>$ 109.39</string></ArrayOfString><ArrayOfString><string>G-C0EC095E</string><string>$ 41.42</string></ArrayOfString><ArrayOfString><string>G-A8E26728</string><string>$ 64.25</string></ArrayOfString><ArrayOfString><string>G-A8E26726</string><string>$ 40.35</string></ArrayOfString><ArrayOfString><string>G-063AF294</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-063AF28E</string><string>$ 416.77</string></ArrayOfString><ArrayOfString><string>G-C0EC093B</string><string>$ 26.50</string></ArrayOfString><ArrayOfString><string>G-C0EC093A</string><string>$ 71.67</string></ArrayOfString><ArrayOfString><string>G-E4909E2D</string><string>$ 40.67</string></ArrayOfString><ArrayOfString><string>G-9F41B4F7</string><string>$ 155.14</string></ArrayOfString><ArrayOfString><string>G-41DA2992</string><string>$ 40.04</string></ArrayOfString><ArrayOfString><string>G-FC8B405C</string><string>$ 110.41</string></ArrayOfString><ArrayOfString><string>G-44A926E9</string><string>$ 40.38</string></ArrayOfString><ArrayOfString><string>G-872A12C8</string><string>$ 44.44</string></ArrayOfString><ArrayOfString><string>G-9F33B4F7</string><string>$ 181.27</string></ArrayOfString><ArrayOfString><string>G-59E4CBC1</string><string>$ 147.05</string></ArrayOfString><ArrayOfString><string>G-A202B24E</string><string>$ 40.63</string></ArrayOfString><ArrayOfString><string>G-59E5CBC1</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-44AB26E9</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-29D38763</string><string>$ 40.64</string></ArrayOfString><ArrayOfString><string>G-FC8E405C</string><string>$ 39.57</string></ArrayOfString><ArrayOfString><string>G-B73F5726</string><string>$ 39.98</string></ArrayOfString><ArrayOfString><string>G-A204B24E</string><string>$ 39.57</string></ArrayOfString><ArrayOfString><string>G-E4859E2D</string><string>$ 129.38</string></ArrayOfString><ArrayOfString><string>G-9F36B4F7</string><string>$ 61.40</string></ArrayOfString><ArrayOfString><string>G-B7405726</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29D58763</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-41DF2992</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-FC90405C</string><string>$ 44.07</string></ArrayOfString><ArrayOfString><string>G-44AE26E9</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29D68763</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-E4879E2D</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-9F38B4F7</string><string>$ 49.08</string></ArrayOfString><ArrayOfString><string>G-59E9CBC1</string><string>$ 86.02</string></ArrayOfString><ArrayOfString><string>G-44AF26E9</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-873012C8</string><string>$ 159.52</string></ArrayOfString><ArrayOfString><string>G-FC92405C</string><string>$ 39.33</string></ArrayOfString><ArrayOfString><string>G-44B626EA</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-29DE8764</string><string>$ 43.74</string></ArrayOfString><ArrayOfString><string>G-E48F9E2E</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-9F40B4F8</string><string>$ 44.75</string></ArrayOfString><ArrayOfString><string>G-59F1CBC2</string><string>$ 100.90</string></ArrayOfString><ArrayOfString><string>G-44B726EA</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-29DF8764</string><string>$ 133.81</string></ArrayOfString><ArrayOfString><string>G-E4909E2E</string><string>$ 129.01</string></ArrayOfString><ArrayOfString><string>G-9F41B4F8</string><string>$ 127.24</string></ArrayOfString><ArrayOfString><string>G-59F2CBC2</string><string>$ 40.31</string></ArrayOfString><ArrayOfString><string>G-44A826EA</string><string>$ 40.60</string></ArrayOfString><ArrayOfString><string>G-E4819E2E</string><string>$ 54.03</string></ArrayOfString><ArrayOfString><string>G-9F32B4F8</string><string>$ 69.62</string></ArrayOfString><ArrayOfString><string>G-29D18764</string><string>$ 61.64</string></ArrayOfString><ArrayOfString><string>G-E4829E2E</string><string>$ 41.59</string></ArrayOfString><ArrayOfString><string>G-9F33B4F8</string><string>$ 61.01</string></ArrayOfString><ArrayOfString><string>G-59E4CBC2</string><string>$ 64.27</string></ArrayOfString><ArrayOfString><string>G-44AA26EA</string><string>$ 61.64</string></ArrayOfString><ArrayOfString><string>G-E4839E2E</string><string>$ 41.59</string></ArrayOfString><ArrayOfString><string>G-9F34B4F8</string><string>$ 40.01</string></ArrayOfString><ArrayOfString><string>G-B73E5727</string><string>$ 39.60</string></ArrayOfString><ArrayOfString><string>G-872C12C9</string><string>$ 43.04</string></ArrayOfString><ArrayOfString><string>G-41DD2993</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-FC8E405D</string><string>$ 43.04</string></ArrayOfString><ArrayOfString><string>G-44AC26EA</string><string>$ 39.54</string></ArrayOfString><ArrayOfString><string>G-29D48764</string><string>$ 39.54</string></ArrayOfString><ArrayOfString><string>G-E4859E2E</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-FC8F405D</string><string>$ 40.28</string></ArrayOfString><ArrayOfString><string>G-B7405727</string><string>$ 41.53</string></ArrayOfString><ArrayOfString><string>G-E4869E2E</string><string>$ 40.57</string></ArrayOfString><ArrayOfString><string>G-9F37B4F8</string><string>$ 89.13</string></ArrayOfString><ArrayOfString><string>G-59E8CBC2</string><string>$ 89.13</string></ArrayOfString><ArrayOfString><string>G-44AE26EA</string><string>$ 40.25</string></ArrayOfString><ArrayOfString><string>G-872F12C9</string><string>$ 54.16</string></ArrayOfString><ArrayOfString><string>G-41E02993</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-FC91405D</string><string>$ 39.51</string></ArrayOfString><ArrayOfString><string>G-44AF26EA</string><string>$ 120.84</string></ArrayOfString><ArrayOfString><string>G-29D78764</string><string>$ 39.27</string></ArrayOfString><ArrayOfString><string>G-E4889E2E</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-FC92405D</string><string>$ 61.24</string></ArrayOfString><ArrayOfString><string>G-B7435727</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-A20EB250</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-59F1CBC3</string><string>$ 39.92</string></ArrayOfString><ArrayOfString><string>G-44B726EB</string><string>$ 40.54</string></ArrayOfString><ArrayOfString><string>G-29DF8765</string><string>$ 41.49</string></ArrayOfString><ArrayOfString><string>G-E4909E2F</string><string>$ 42.96</string></ArrayOfString><ArrayOfString><string>G-9F41B4F9</string><string>$ 107.82</string></ArrayOfString><ArrayOfString><string>G-B74B5728</string><string>$ 50.23</string></ArrayOfString><ArrayOfString><string>G-A200B250</string><string>$ 81.50</string></ArrayOfString><ArrayOfString><string>G-872912CA</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-FC8B405E</string><string>$ 151.17</string></ArrayOfString><ArrayOfString><string>G-44A926EB</string><string>$ 42.93</string></ArrayOfString><ArrayOfString><string>G-29D18765</string><string>$ 41.44</string></ArrayOfString><ArrayOfString><string>G-E4829E2F</string><string>$ 41.44</string></ArrayOfString><ArrayOfString><string>G-44AA26EB</string><string>$ 53.74</string></ArrayOfString><ArrayOfString><string>G-B73F5728</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-A204B250</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872D12CA</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-41DE2994</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC8F405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-B7405728</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-A205B250</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC90405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-B7415728</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-872F12CA</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-41E02994</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-FC91405E</string><string>$ 42.04</string></ArrayOfString><ArrayOfString><string>G-44AF26EB</string><string>$ 40.15</string></ArrayOfString><ArrayOfString><string>G-29D78765</string><string>$ 40.15</string></ArrayOfString><ArrayOfString><string>G-41E12994</string><string>$ 45.13</string></ArrayOfString><ArrayOfString><string>G-FC92405E</string><string>$ 51.28</string></ArrayOfString><ArrayOfString><string>G-29DE8766</string><string>$ 67.94</string></ArrayOfString><ArrayOfString><string>G-FC99405F</string><string>$ 48.71</string></ArrayOfString><ArrayOfString><string>G-B74A5729</string><string>$ 67.94</string></ArrayOfString><ArrayOfString><string>G-29DF8766</string><string>$ 43.54</string></ArrayOfString><ArrayOfString><string>G-9F41B4FA</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-44A826EC</string><string>$ 43.80</string></ArrayOfString><ArrayOfString><string>G-29D08766</string><string>$ 42.08</string></ArrayOfString><ArrayOfString><string>G-41DA2995</string><string>$ 41.76</string></ArrayOfString><ArrayOfString><string>G-59E3CBC4</string><string>$ 42.08</string></ArrayOfString><ArrayOfString><string>G-29D18766</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-872A12CB</string><string>$ 41.79</string></ArrayOfString><ArrayOfString><string>G-9F33B4FA</string><string>$ 41.79</string></ArrayOfString><ArrayOfString><string>G-A202B251</string><string>$ 37.96</string></ArrayOfString><ArrayOfString><string>G-E4839E30</string><string>$ 37.96</string></ArrayOfString><ArrayOfString><string>G-59E5CBC4</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-44AB26EC</string><string>$ 39.06</string></ArrayOfString><ArrayOfString><string>G-29D38766</string><string>$ 97.74</string></ArrayOfString><ArrayOfString><string>G-41DD2995</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-FC8E405F</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-B73F5729</string><string>$ 75.47</string></ArrayOfString><ArrayOfString><string>G-A204B251</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872D12CB</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-41DE2995</string><string>$ 36.13</string></ArrayOfString><ArrayOfString><string>G-B7405729</string><string>$ 43.26</string></ArrayOfString><ArrayOfString><string>G-A205B251</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-872E12CB</string><string>$ 39.04</string></ArrayOfString><ArrayOfString><string>G-29D68766</string><string>$ 32.50</string></ArrayOfString><ArrayOfString><string>G-E4879E30</string><string>$ 32.50</string></ArrayOfString><ArrayOfString><string>G-9F38B4FA</string><string>$ 47.50</string></ArrayOfString><ArrayOfString><string>G-44AF26EC</string><string>$ 47.50</string></ArrayOfString><ArrayOfString><string>G-29D78766</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-E4889E30</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-9F39B4FA</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-59EACBC4</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC1B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB798</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB7B789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB789</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB8B78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78A</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB6B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB8B78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78B</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDBAB78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB5B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB9B78D</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDC2B78E</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDB4B78E</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDCAB78C</string><string>$ 0.00</string></ArrayOfString><ArrayOfString><string>G-CDCAB78E</string><string>$ 0.00</string></ArrayOfString></report>'
# y = bs(r, "lxml")
# results = []
# # print(y.report.arrayofstring)
#
# with open('report.csv',mode='w') as out:
# out_writer = csv.writer(out, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
# for child in y.report:
# for childs in child:
# results.append(childs.text)
# out_writer.writerow(results)
# results = []
#
#
# # for child in y.report:
# # for childs in child:
# # results.append(childs.text)
# # print(results)
# # results = []
Reference in New Issue View Git Blame Copy Permalink