Mercurial > repos > artbio > facturation_ibps
changeset 2:3bbcf49ad677 draft
planemo upload for repository https://github.com/ARTbio/tools-artbio/tree/master/tools/facturation_ibps commit 9a51dcfe718e63148d19717c473f9e234652fade
| author | artbio |
|---|---|
| date | Thu, 08 Nov 2018 05:45:50 -0500 |
| parents | 927553056183 |
| children | 1c5097aea031 |
| files | facturation.py facturation.xml newtests/test.xlsx |
| diffstat | 3 files changed, 4 insertions(+), 9 deletions(-) [+] |
line wrap: on
line diff
--- a/facturation.py Tue Oct 23 11:13:24 2018 -0400 +++ b/facturation.py Thu Nov 08 05:45:50 2018 -0500 @@ -1,4 +1,3 @@ -#!/usr/bin/env python2 # -*- coding: utf-8 -*- @@ -30,11 +29,13 @@ facture_html = facture_html.decode('utf-8') facture_html = facture_html.replace(r' ', r' ') facture_html = facture_html.replace(u' \u20ac', '') - # parsing de la date et de la période de facturation + # parsing de la référence, de la date et de la période de facturation date = re.search(r'Paris le (.*?)</p>'.decode('utf-8'), facture_html).group(1) periode = re.search(r'de la prestation (.*?)</p>'.decode('utf-8'), facture_html).group(1) + ref = re.search(r'sur le bon de commande :\s*(.*?)<'.decode('utf-8'), + facture_html).group(1) # parsing des tableaux html avec pandas facture_parsed = pd.read_html( @@ -54,12 +55,6 @@ elements = elements.rename(columns=elements_col).drop( elements.index[0]) - misc = facture_parsed[3] - - ref = misc.iloc[:, # récupération de la référence - 0].str.extract(r'sur le bon de commande :\s*(.*)$', - expand=False).dropna().iloc[0] - # ouverture fichier output facture_output = openpyxl.load_workbook( 'template_facture.xlsx', data_only=False, keep_vba=False)
--- a/facturation.xml Tue Oct 23 11:13:24 2018 -0400 +++ b/facturation.xml Thu Nov 08 05:45:50 2018 -0500 @@ -1,4 +1,4 @@ -<tool id="facturation_ibps" name="IBPS facturation parser" version="0.3.0"> +<tool id="facturation_ibps" name="IBPS facturation parser" version="0.3.1"> <description /> <requirements> <requirement type="package" version="4.6.3=py27_0">beautifulsoup4</requirement>