Package WAPT tis-excel-parser-processor 1.3.1-0 windows

tis-excel-parser-processor

1.3.1-0

Automate downloads from Excel files. Simply does the tedious, repetitive operations for rows of Excel files and reports the results. It downloads files from URL(s) in column A, if a new filename is provided at column B it will rename before saving. It will even create sub folders if column C is filled with a valid folder name

0 downloads

Download
See build result See VirusTotal scan

Description

package : tis-excel-parser-processor
name : Excel-Parser-Processor
version : 1.3.1-0
categories : Utilities,Office
maintainer : WAPT Team,Tranquil IT,Jimmy PELÉ,Jordan ARNAUD
installed_size : 239699600
editor : btargac
licence : opensource_free,cpe:/a:mit:x11_license,wapt_enterprise
signature_date : 2024-07-06T13:02:47.571556
size : 1.51 Mo
locale : all
target_os : windows
impacted_process : Excel Parser Processor
architecture : x64
Homepage : https://github.com/btargac/excel-parser-processor?

control


package           : tis-excel-parser-processor
version           : 1.3.1-0
architecture      : x64
section           : base
priority          : optional
name              : Excel-Parser-Processor
categories        : Utilities,Office
maintainer        : WAPT Team,Tranquil IT,Jimmy PELÉ,Jordan ARNAUD
description       : Automate downloads from Excel files. Simply does the tedious, repetitive operations for rows of Excel files and reports the results. It downloads files from URL(s) in column A, if a new filename is provided at column B it will rename before saving. It will even create sub folders if column C is filled with a valid folder name
depends           : 
conflicts         : 
maturity          : PROD
locale            : all
target_os         : windows
min_wapt_version  : 2.3
sources           : 
installed_size    : 239699600
impacted_process  : Excel Parser Processor
description_fr    : Automatisez les téléchargements à partir de fichiers Excel. Il effectue simplement les opérations fastidieuses et répétitives pour les lignes de fichiers Excel et rapporte les résultats. Il télécharge des fichiers à partir de l'URL dans la colonne A, si un nouveau nom de fichier est fourni dans la colonne B, il le renommera avant de l'enregistrer. Il crée même des sous-dossiers si la colonne C contient un nom de dossier valide
description_pl    : Automatyzacja pobierania z plików Excel. Po prostu wykonuje żmudne, powtarzalne operacje dla wierszy plików Excel i raportuje wyniki. Pobiera pliki z adresów URL w kolumnie A, jeśli nowa nazwa pliku zostanie podana w kolumnie B, zmieni nazwę przed zapisaniem. Tworzy nawet podfoldery, jeśli kolumna C jest wypełniona prawidłową nazwą folderu
description_de    : Automatisieren Sie Downloads aus Excel-Dateien. Erledigt einfach die mühsamen, sich wiederholenden Operationen für Zeilen von Excel-Dateien und meldet die Ergebnisse. Es lädt Dateien von URL(s) in Spalte A herunter und benennt sie vor dem Speichern um, wenn in Spalte B ein neuer Dateiname angegeben wird. Es erstellt sogar Unterordner, wenn in Spalte C ein gültiger Ordnername angegeben ist
description_es    : Automatice las descargas desde archivos Excel. Simplemente realiza las tediosas y repetitivas operaciones para filas de archivos Excel e informa de los resultados. Descarga archivos desde URL(s) en la columna A, si se proporciona un nuevo nombre de archivo en la columna B, lo renombrará antes de guardarlo. Incluso creará subcarpetas si la columna C se rellena con un nombre de carpeta válido
description_pt    : Automatiza as transferências a partir de ficheiros Excel. Simplesmente faz as operações tediosas e repetitivas para linhas de ficheiros Excel e reporta os resultados. Descarrega ficheiros a partir do(s) URL(s) na coluna A, se for fornecido um novo nome de ficheiro na coluna B, este será renomeado antes de ser guardado. Até cria subpastas se a coluna C for preenchida com um nome de pasta válido
description_it    : Automatizza i download da file Excel. Esegue semplicemente le operazioni noiose e ripetitive per le righe di file Excel e riporta i risultati. Scarica i file dagli URL nella colonna A; se nella colonna B viene fornito un nuovo nome di file, questo viene rinominato prima di essere salvato. Crea anche delle sottocartelle se la colonna C è riempita con un nome di cartella valido
description_nl    : Automatiseer downloads uit Excel-bestanden. Voert gewoon de vervelende, repetitieve bewerkingen uit voor rijen Excel-bestanden en rapporteert de resultaten. Het downloadt bestanden van URL('s) in kolom A, als een nieuwe bestandsnaam wordt opgegeven in kolom B zal het de naam wijzigen voordat het wordt opgeslagen. Het zal zelfs submappen maken als kolom C is gevuld met een geldige mapnaam
description_ru    : Автоматизируйте загрузку данных из файлов Excel. Просто выполняет утомительные, повторяющиеся операции для строк файлов Excel и сообщает о результатах. Он загружает файлы с URL-адресов в столбце A, если в столбце B указано новое имя файла, он переименует его перед сохранением. Она даже создаст вложенные папки, если в столбце C указано правильное имя папки
audit_schedule    : 
editor            : btargac
keywords          : 
licence           : opensource_free,cpe:/a:mit:x11_license,wapt_enterprise
homepage          : https://github.com/btargac/excel-parser-processor?
package_uuid      : 6fde7558-8d5e-427b-a05d-2cee4329fa97
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : 
min_os_version    : 10.0
max_os_version    : 
icon_sha256sum    : 56d1c9b74a47724795b22d1ec63162db7d3c1f1e4dd8a17e13d3abb1bef13352
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature         : yyhu6aNPzClw6izuaC2ZEHSqgefDbksv48e3ZI96F/nGmyp8NP0Y18p9mjInrRAPAiuKh/0Jwnj27varrfy06LzeG9me6V3iFSNM2yaqmQYmtJz3OAFimJ1ZLhOil4QyHBVln9jrHuWNwp4cUJy/MwlJhJMah+cdGFqBOR48GpRoqTYDiyqsBDsNDYj6ESMKrF7n8EXywWtqDyihzcLU3h/SA/o22Jf/BrAKyUOaj9gk+kAZvW1YqTOtdy/NaR6mjTdJNR3ymPF/oh8elMlr0ZNusYFmmahCeiBXfx30F44tagQ5PUyIArw8UEyIlXp1/fGWCM+QgtqDtv9rwb2fpw==
signature_date    : 2024-07-06T13:02:47.571556
signed_attributes : package,version,architecture,section,priority,name,categories,maintainer,description,depends,conflicts,maturity,locale,target_os,min_wapt_version,sources,installed_size,impacted_process,description_fr,description_pl,description_de,description_es,description_pt,description_it,description_nl,description_ru,audit_schedule,editor,keywords,licence,homepage,package_uuid,valid_from,valid_until,forced_install_on,changelog,min_os_version,max_os_version,icon_sha256sum,signer,signer_fingerprint,signature_date,signed_attributes

Setup.py


# -*- coding: utf-8 -*-
##################################################
# This file is part of WAPT Enterprise
# All right reserved, (c) Tranquil IT Systems 2024
# For more information please refer to
# https://wapt.tranquil.it/store/licences.html
##################################################
from setuphelpers import *
import glob
import subprocess

app_name = "Excel Parser Processor"

app_dir = makepath(programfiles, app_name)


def install():
    bin_name = glob.glob("Excel-Parser-Processor-*.exe")[0]
    app_path = makepath(app_dir, bin_name)
    # Installing software
    killalltasks(ensure_list(control.impacted_process))
    if isdir(app_dir) and force:
        remove_tree(app_dir)
    mkdirs(app_dir)
    filecopyto(bin_name, app_path)

    # Creating shortcuts
    create_desktop_shortcut(app_name, target=app_path)
    create_programs_menu_shortcut(app_name, target=app_path)


def uninstall():
    # Uninstalling software
    killalltasks(ensure_list(control.impacted_process))
    for uninstall in installed_softwares("Excel Parser Processor"):
        uninstall_string = uninstall.get("uninstall_string", "")
        print(f"Uninstalling Excel Parser Processor: {uninstall_string}")
        run(f"{uninstall_string} --uninstall --uninstall -s")
        wait_uninstallkey_absent(uninstall["key"], max_loop=600)
    if isdir(app_dir):
        remove_tree(app_dir)

    # play uninstall registry key from current user
    # "C:\Users\xxx\AppData\Local\Programs\excel-parser-processor\Uninstall Excel Parser Processor.exe" /currentuser /S
    def get_current_user():
        result = subprocess.run(["whoami"], capture_output=True, text=True)
        return result.stdout.strip().split("\\")[-1]

    def get_program_path(user):
        return rf"C:\Users\{user}\AppData\Local\Programs\excel-parser-processor\Uninstall Excel Parser Processor.exe"

    current_user = get_current_user()
    program_path = get_program_path(user)
    command = rf'"{program_path}" /currentuser /S'
    subprocess.run(command, shell=True)

    # Removing shortcuts
    remove_desktop_shortcut(app_name)
    remove_programs_menu_shortcut(app_name)

update_package.py


# -*- coding: utf-8 -*-
##################################################
# This file is part of WAPT Enterprise
# All right reserved, (c) Tranquil IT Systems 2024
# For more information please refer to
# https://wapt.tranquil.it/store/licences.html
##################################################
from setuphelpers import *
import re


def update_package():
    # Declaring local variables
    package_updated = False
    proxies = get_proxies()
    if not proxies:
        proxies = get_proxies_from_wapt_console()
    os_dict = {"windows": ".exe", "debian_based": ".deb", "redhat_based": ".rpm", "darwin": ".dmg"}
    api_url = "https://api.github.com/repos/btargac/excel-parser-processor/releases/latest"

    # Get data from API
    releases_dict = json.loads(wgets(api_url, proxies=proxies))
    exe_found = False  # Flag pour indiquer la découverte d'un fichier .exe
    # version = json_loads["tag_name"].replace("v", "").replace(".windows", "")
    for release in releases_dict:
        if exe_found:
            break
        for asset in releases_dict["assets"]:
            if asset["browser_download_url"].endswith(".exe") and os_dict[control.target_os] in asset["browser_download_url"]:
                url_download = asset["browser_download_url"]
                latest_bin = url_download.split("/")[-1]
                version = releases_dict["tag_name"].replace("v","")
                exe_found = True  # Mettre à jour le flag pour indiquer qu'un exe a été trouvé
                break

    # Deleting binaries
    for f in glob.glob("*.exe"):
        if f != latest_bin:
            remove_file(f)

    # Downloading latest binaries
    print("Download URL is: %s" % url_download)
    if not isfile(latest_bin):
        print("Downloading: %s" % latest_bin)
        wget(url_download, latest_bin, proxies=proxies)
    else:
        print("Binary is present: %s" % latest_bin)


        control.set_software_version(version)
        control.save_control_to_wapt()

manifest.sha256


                                
ef72bc9aa04d36191b035b48bcacf635d5feddf3025b792ef3c8a83e07025285 : setup.py 
0fc485aeebcf92e6034d85e9f996b9bbbef1b30d0ae94341a666bc5e95f37310 : Excel-Parser-Processor-Web-Setup-1.3.1.exe 
 : __pycache__ 
c40543ec8c453a36bd3ba68d6388664c8395ade4effc4b5e89342a23fd054e67 : update_package.py 
56d1c9b74a47724795b22d1ec63162db7d3c1f1e4dd8a17e13d3abb1bef13352 : WAPT/icon.png 
a5a97261381e1d0ad46ee15916abec9c2631d0201f5cc50ceb0197a165a0bbbf : WAPT/certificate.crt 
06b358104f47ba32a22211b6c23aff866fe96bda2cba54db81099497ca83b8ab : luti.json 
e3ff871d61dd432f0c5d8e7b7bd2ac68cc769e4122149b5ef7a09f582b2fdca0 : WAPT/control

Choose languages

Choose architecture

Choose OS

Choose Categorie

Filter on package licensing

tis-excel-parser-processor

Description

control

Setup.py

update_package.py