|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloa lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloads $ curl -i -X POST [URL_WITH_CREDENTIALS] ~/Downloads $ cp ~/Downloads/report\(1\).csv /tmp/report1.csv
cp ~/Downloads/report\(2\).csv /tmp/report2.csv
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloads $ curl -s -X POST https://finance-hub.lakylak.xyz/api/upload/preview \
-F "files=@/tmp/report1.csv" \
-F "files=@/tmp/report2.csv" | python3 -m json.tool
[
{
"file": "report1.csv",
"rows": [
{
"rawMessage": "Date: 08.05.2026 | Debit......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloa lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloads $ curl -i -X POST [URL_WITH_CREDENTIALS] ~/Downloads $ cp ~/Downloads/report\(1\).csv /tmp/report1.csv
cp ~/Downloads/report\(2\).csv /tmp/report2.csv
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/Downloads $ curl -s -X POST https://finance-hub.lakylak.xyz/api/upload/preview \
-F "files=@/tmp/report1.csv" \
-F "files=@/tmp/report2.csv" | python3 -m json.tool
[
{
"file": "report1.csv",
"rows": [
{
"rawMessage": "Date: 08.05.2026 | Debit......
|
NULL
|
NULL
|
NULL
|
|
"08.05.2026","400915xxxxxx4447 ПЛАЩАН "08.05.2026","400915xxxxxx4447 ПЛАЩАНЕ НА ПОС 08.05.2026 19:32<br/>Авт. код: 6NM31C<br/>Номер на у-во: V5411421","BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR","","КАРТОВА ОПЕРАЦИЯ","","","","67,81",""...
|
NULL
|
NULL
|
NULL
|
|
"08.05.2026","400915xxxxxx4447 ПЛАЩАН "08.05.2026","400915xxxxxx4447 ПЛАЩАНЕ НА ПОС 08.05.2026 19:32<br/>Авт. код: 6NM31C<br/>Номер на у-во: V5411421","BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR","","КАРТОВА ОПЕРАЦИЯ","","","","67,81",""...
|
NULL
|
NULL
|
NULL
|
|
"08.05.2026","400915xxxxxx4447 ПЛАЩАН "08.05.2026","400915xxxxxx4447 ПЛАЩАНЕ НА ПОС 08.05.2026 19:32<br/>Авт. код: 6NM31C<br/>Номер на у-во: V5411421","BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR","","КАРТОВА ОПЕРАЦИЯ","","","","67,81",""...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build backend frontend && sudo docker compose up -d
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build backend && sudo docker compose up -d backend
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build frontend && sudo docker compose up -d frontend
...
|
NULL
|
NULL
|
NULL
|
|
"08.05.2026","400915xxxxxx4447 ПЛАЩАН "08.05.2026","400915xxxxxx4447 ПЛАЩАНЕ НА ПОС 06.05.2026 13:16<br/>Авт. код: 1TV886<br/>Номер на у-во: 06030191","POL BALICE Lagardere Travel R KR3","","КАРТОВА ОПЕРАЦИЯ","","","","5,49",""...
|
NULL
|
NULL
|
NULL
|
|
"08.05.2026","400915xxxxxx4447 ПЛАЩАН "08.05.2026","400915xxxxxx4447 ПЛАЩАНЕ НА ПОС 06.05.2026 13:16<br/>Авт. код: 1TV886<br/>Номер на у-во: 06030191","POL BALICE Lagardere Travel R KR3","","КАРТОВА ОПЕРАЦИЯ","","","","5,49",""...
|
NULL
|
NULL
|
NULL
|
|
docker exec finance-hub-db-1 psql -U finance -d fi docker exec finance-hub-db-1 psql -U finance -d finance_hub -c "SELECT id, date, recipient, amount, source, created_at FROM payments ORDER BY id DESC LIMIT 5;" 2>/dev/null || docker ps --format "{{.Names}}" | grep finance...
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub -c "SELECT id, date, recipient, amount, source, created_at FROM payments ORDER BY id DESC LIMIT 5;" 2>/dev/null || docker ps --format "{{.Names}}" | grep finance
[sudo] password for Adm1n:
Sorry, try again.
[sudo] password for Adm1n:
id | date | recipient | amount | source | created_at
----+---------------------+-----------------------------------------+--------+--------+-------------------------
8 | 2026-05-08 00:00:00 | POL BALICE Lagardere Travel R KR3 | 5.49 | UPLOAD | 2026-05-09 08:26:53.656
7 | 2026-05-08 00:00:00 | BGR SOFIA CBA EKO MARKET | 5.51 | UPLOAD | 2026-05-09 08:26:53.642
6 | 2026-05-08 00:00:00 | BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR | 67.81 | UPLOAD | 2026-05-09 08:26:53.624
5 | 2026-05-08 00:00:00 | | 9.04 | UPLOA......
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub -c "SELECT id, date, recipient, amount, source, created_at FROM payments ORDER BY id DESC LIMIT 5;" 2>/dev/null || docker ps --format "{{.Names}}" | grep finance
[sudo] password for Adm1n:
Sorry, try again.
[sudo] password for Adm1n:
id | date | recipient | amount | source | created_at
----+---------------------+-----------------------------------------+--------+--------+-------------------------
8 | 2026-05-08 00:00:00 | POL BALICE Lagardere Travel R KR3 | 5.49 | UPLOAD | 2026-05-09 08:26:53.656
7 | 2026-05-08 00:00:00 | BGR SOFIA CBA EKO MARKET | 5.51 | UPLOAD | 2026-05-09 08:26:53.642
6 | 2026-05-08 00:00:00 | BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR | 67.81 | UPLOAD | 2026-05-09 08:26:53.624
5 | 2026-05-08 00:00:00 | | 9.04 | UPLOA......
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub -c "SELECT id, date, recipient, amount, source, created_at FROM payments ORDER BY id DESC LIMIT 5;" 2>/dev/null || docker ps --format "{{.Names}}" | grep finance
[sudo] password for Adm1n:
Sorry, try again.
[sudo] password for Adm1n:
id | date | recipient | amount | source | created_at
----+---------------------+-----------------------------------------+--------+--------+-------------------------
8 | 2026-05-08 00:00:00 | POL BALICE Lagardere Travel R KR3 | 5.49 | UPLOAD | 2026-05-09 08:26:53.656
7 | 2026-05-08 00:00:00 | BGR SOFIA CBA EKO MARKET | 5.51 | UPLOAD | 2026-05-09 08:26:53.642
6 | 2026-05-08 00:00:00 | BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR | 67.81 | UPLOAD | 2026-05-09 08:26:53.624
5 | 2026-05-08 00:00:00 | | 9.04 | UPLOA......
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub -c "SELECT id, date, recipient, amount, source, created_at FROM payments ORDER BY id DESC LIMIT 5;" 2>/dev/null || docker ps --format "{{.Names}}" | grep finance
[sudo] password for Adm1n:
Sorry, try again.
[sudo] password for Adm1n:
id | date | recipient | amount | source | created_at
----+---------------------+-----------------------------------------+--------+--------+-------------------------
8 | 2026-05-08 00:00:00 | POL BALICE Lagardere Travel R KR3 | 5.49 | UPLOAD | 2026-05-09 08:26:53.656
7 | 2026-05-08 00:00:00 | BGR SOFIA CBA EKO MARKET | 5.51 | UPLOAD | 2026-05-09 08:26:53.642
6 | 2026-05-08 00:00:00 | BGR SOFIYA LIDL BALGARIYA EOOD UL TODOR | 67.81 | UPLOAD | 2026-05-09 08:26:53.624
5 | 2026-05-08 00:00:00 | | 9.04 | UPLOA......
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build backend && sudo docker compose up -d backend
...
|
NULL
|
NULL
|
NULL
|
|
sudo docker exec finance-hub-db-1 psql -U finance sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub -c \
"DELETE FROM payments WHERE source = 'UPLOAD';"
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build backend frontend && sudo docker compose up -d
...
|
NULL
|
NULL
|
NULL
|
|
sudo docker exec finance-hub-db-1 psql -U finance sudo docker exec finance-hub-db-1 psql -U finance -d finance_hub \
-c "DELETE FROM transaction_imports WHERE source = 'UPLOAD';"
...
|
NULL
|
NULL
|
NULL
|
|
Row insert failed: Invalid `prisma.transactionImpo Row insert failed: Invalid `prisma.transactionImport.create()` invocation in /app/src/routes/upload.js:86:50 83 } 84 85 const transactionId = await linkTransaction(prisma, paymentData); → 86 const imp = await prisma.transactionImport.create({ data: { rawMessage: "Date: 04.05.2026 | Type: КОМУНАЛНИ УСЛУГИ | Payee: КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ | Debit: 17.93 EUR", date: new Date("2026-05-04T00:00:00.000Z"), type: null, card: null, recipient: "КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ", amount: 17.93, currency: "EUR", balance: null, source: "UPLOAD", debitBgn: 17.93, ~~~~~~~~ creditBgn: null, transactionType: "КОМУНАЛНИ УСЛУГИ", payerAccount: "[IBAN]", ...
|
NULL
|
NULL
|
NULL
|
|
Row insert failed: Invalid `prisma.transactionImpo Row insert failed: Invalid `prisma.transactionImport.create()` invocation in /app/src/routes/upload.js:86:50 83 } 84 85 const transactionId = await linkTransaction(prisma, paymentData); → 86 const imp = await prisma.transactionImport.create({ data: { rawMessage: "Date: 04.05.2026 | Type: КОМУНАЛНИ УСЛУГИ | Payee: КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ | Debit: 17.93 EUR", date: new Date("2026-05-04T00:00:00.000Z"), type: null, card: null, recipient: "КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ", amount: 17.93, currency: "EUR", balance: null, source: "UPLOAD", debitBgn: 17.93, ~~~~~~~~ creditBgn: null, transactionType: "КОМУНАЛНИ УСЛУГИ", payerAccount: "[IBAN]", ...
|
NULL
|
NULL
|
NULL
|
|
Row insert failed: Invalid `prisma.transactionImpo Row insert failed: Invalid `prisma.transactionImport.create()` invocation in /app/src/routes/upload.js:86:50 83 } 84 85 const transactionId = await linkTransaction(prisma, paymentData); → 86 const imp = await prisma.transactionImport.create({ data: { rawMessage: "Date: 04.05.2026 | Type: КОМУНАЛНИ УСЛУГИ | Payee: КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ | Debit: 17.93 EUR", date: new Date("2026-05-04T00:00:00.000Z"), type: null, card: null, recipient: "КОМУНАЛНИ РАЗХОДИ ЕЛ. КАНАЛИ", amount: 17.93, currency: "EUR", balance: null, source: "UPLOAD", debitBgn: 17.93, ~~~~~~~~ creditBgn: null, transactionType: "КОМУНАЛНИ УСЛУГИ", payerAccount: "[IBAN]", ...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub
sudo docker cd /volume2/docker/finance/finance-hub
sudo docker compose build backend && sudo docker compose up -d backend
...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run...
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run
ERROR: export file not found: --dry-run...
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run
ERROR: export file not found: --dry-run...
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --dry-run
ERROR: export file not found: --dry-run...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh...
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh
Import target : http://localhost:3001/api/payments/ingest
Records found : 215
Mode : LIVE
[1/215] OK DSK Bank. Na 18/02/2026 v 20:38 sa plateni 4.19 EUR s karta 400915***4
[2/215] OK DSK Bank. Na 20/02/2026 v 13:08 sa plateni 13.75 EUR s karta 400915***
[3/215] OK DSK Bank. Na 20/02/2026 v 18:17 sa plateni 16.58 EUR s karta 400915***
[4/215] OK DSK Bank. Na 20/02/2026 v 18:28 sa plateni 12.51 EUR s karta 400915***
[5/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa iztegleni 400.00 EUR s karta 483890
[6/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa plateni 0.50 EUR/0.50 EUR s karta 4
[7/215] OK DSK Bank. Na 24/02/2026 v 08:42 sa plateni 116.85 EUR s karta 400915**
[8/215] OK DSK Bank. Na 25/02/2026 v 08:38 sa plateni 78.01 EUR s karta 400915***
[9/215] OK DSK Bank. Na 26/02/2026 v 08:39 sa plateni 59.65 EUR s karta 400915***
[10/215] OK DS......
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh
Import target : http://localhost:3001/api/payments/ingest
Records found : 215
Mode : LIVE
[1/215] OK DSK Bank. Na 18/02/2026 v 20:38 sa plateni 4.19 EUR s karta 400915***4
[2/215] OK DSK Bank. Na 20/02/2026 v 13:08 sa plateni 13.75 EUR s karta 400915***
[3/215] OK DSK Bank. Na 20/02/2026 v 18:17 sa plateni 16.58 EUR s karta 400915***
[4/215] OK DSK Bank. Na 20/02/2026 v 18:28 sa plateni 12.51 EUR s karta 400915***
[5/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa iztegleni 400.00 EUR s karta 483890
[6/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa plateni 0.50 EUR/0.50 EUR s karta 4
[7/215] OK DSK Bank. Na 24/02/2026 v 08:42 sa plateni 116.85 EUR s karta 400915**
[8/215] OK DSK Bank. Na 25/02/2026 v 08:38 sa plateni 78.01 EUR s karta 400915***
[9/215] OK DSK Bank. Na 26/02/2026 v 08:39 sa plateni 59.65 EUR s karta 400915***
[10/215] OK DS......
|
NULL
|
NULL
|
NULL
|
|
Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/fin Adm1n@DXP4800PLUS-B5F8:/volume2/docker/finance/finance-hub$ bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh
Import target : http://localhost:3001/api/payments/ingest
Records found : 215
Mode : LIVE
[1/215] OK DSK Bank. Na 18/02/2026 v 20:38 sa plateni 4.19 EUR s karta 400915***4
[2/215] OK DSK Bank. Na 20/02/2026 v 13:08 sa plateni 13.75 EUR s karta 400915***
[3/215] OK DSK Bank. Na 20/02/2026 v 18:17 sa plateni 16.58 EUR s karta 400915***
[4/215] OK DSK Bank. Na 20/02/2026 v 18:28 sa plateni 12.51 EUR s karta 400915***
[5/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa iztegleni 400.00 EUR s karta 483890
[6/215] OK DSK Bank. Na 22/02/2026 v 11:05 sa plateni 0.50 EUR/0.50 EUR s karta 4
[7/215] OK DSK Bank. Na 24/02/2026 v 08:42 sa plateni 116.85 EUR s karta 400915**
[8/215] OK DSK Bank. Na 25/02/2026 v 08:38 sa plateni 78.01 EUR s karta 400915***
[9/215] OK DSK Bank. Na 26/02/2026 v 08:39 sa plateni 59.65 EUR s karta 400915***
[10/215] OK DS......
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --from 201
...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --from 201
...
|
NULL
|
NULL
|
NULL
|
|
bash /volume2/docker/finance/finance-hub/scripts/r bash /volume2/docker/finance/finance-hub/scripts/reimport_sms.sh --from 201
...
|
NULL
|
NULL
|
NULL
|
|
DSK Bank 31/03/2026 07:46:49 nalichnost po smetka DSK Bank 31/03/2026 07:46:49 nalichnost po smetka 26574472 : 16913.59 EUR...
|
NULL
|
NULL
|
NULL
|
|
DSK Bank 31/03/2026 07:46:49 nalichnost po smetka DSK Bank 31/03/2026 07:46:49 nalichnost po smetka 26574472 : 16913.59 EUR...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub && cd /volume2/docker/finance/finance-hub && docker compose up -d --build
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub && cd /volume2/docker/finance/finance-hub && docker compose up -d --build backend
...
|
NULL
|
NULL
|
NULL
|
|
curl -s "http://localhost:3001/api/payments?li curl -s "http://localhost:3001/api/payments?limit=3&hideBalanceAlerts=true&dateFrom=2026-05-01&dateTo=2026-05-09" | python3 -m json.tool | head -10
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub && cd /volume2/docker/finance/finance-hub && docker compose up -d --build
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub && cd /volume2/docker/finance/finance-hub && docker compose up -d --build
...
|
NULL
|
NULL
|
NULL
|
|
cd /volume2/docker/finance/finance-hub && cd /volume2/docker/finance/finance-hub && docker compose up -d --build
...
|
NULL
|
NULL
|
NULL
|
|
[EMAIL]:lakylak/finance-hub.git
|
NULL
|
NULL
|
NULL
|
|
https://auth.lakylak.xyz/if/admin/
|
NULL
|
NULL
|
NULL
|
|
https://auth.lakylak.xyz/if/admin/
|
NULL
|
NULL
|
NULL
|
|
Finance Hub Proxy
|
NULL
|
NULL
|
NULL
|