williansmartins / itauscraper

Download Itaú exportable files using node and Puppeteer. OFX, OFC and TXT(CSV)

Itau Scraper

Download Itaú exportable files using node and Puppeteer. Available file formats:

• PDF
• XLS
• TXT - It's a CSV with semi-colon
• OFX - Money 2000 (DEFAULT)
• OFC 1.0 - Money 1995 a Money 1999
• OFC 1.06 - Quicken 6

Usage

node run.js --branch=0000 --account=00000-0 --password=000000 --days 5 

Usage - Docker

WARNING: Docker image is outdated

docker run -v $(pwd):/usr/itauscrapper/download \
    -e BRANCH='0000' \
    -e ACCOUNT='00000-0' \
    -e PASSWORD='000000' \
    -e DAYS='000000' \
    -rm \
    viniciusgava/itauscraper:latest 

Help

Usage: node run.js [options]

Options:
  --help             Show help                                         [boolean]
  --version          Show version number                               [boolean]
  --branch, -b       Itaú branch number, format: 0000        [string] [required]
  --account, -c      Itaú account number, format: 00000-0    [string] [required]
  --password, -p     Itaú account digital password(6 digits) [number] [required]
  --days, -d         Transaction log days
                          [number] [required] [choices: 3, 5, 7, 15, 30, 60, 90]
  --file_format, -f  File format to export
       [choices: "pdf", "xls", "txt", "ofx", "ofc10", "ofc106"] [default: "ofx"]
  --node_env         Node environment
        [choices: "development", "production", "docker"] [default: "production"]

Crontab

First create bash like this:

#!/bin/bash
SCRIPTPATH="$( cd "$(dirname "$0")" ; pwd -P )"

# print current date at log
date

# try 5 times
n=0
until [ $n -ge 2 ]
do
    echo "trying $n"
    /usr/bin/docker run --env-file "$SCRIPTPATH/env-configs" \
    --rm \
    viniciusgava/viniciusgava/itauscraper:latest 2>&1 && break
    n=$[$n+1]
    sleep 15
done

Mac tip: You must to pass docker full path to works at crontab /usr/local/bin/docker

Second add all env variables at env-configs. Example:

BRANCH=0000
ACCOUNT=00000-0
PASSWORD=000000
DAYS=5

DO NOT use quotation to define values on env files.

Then run crontab -e and add the follow cron. Example:

0 */4 * * * sh /home/username/automate/itauscraper/run.sh  >> /home/username/automate/itauscraper/log.log

The example bellow runs every 4 hours of all days

You can generate a different crontab config on https://crontab-generator.org

Links

• GitHub
• Docker Hub

Contar lançamentos

via JQUERY

TODOS Lançamentos

todos
$(".fatura__table .linha-valor-total").length

somente 9457
$(".fatura__tipo:nth-child(2)").find(".fatura__table .linha-valor-total").length

somente 5020
$(".fatura__tipo:nth-child(3)").find(".fatura__table .linha-valor-total").length

via SQL

select * from tb_lancamentos_cartao_credito tlcc 
where vencimento = '2022-11-26'	

Total da fatura

select sum(valor) 
from tb_lancamentos_cartao_credito tlcc 
where 
	vencimento = '2022-11-26'

output:

2760.96