view src/kaigo/Porori/make.bat @ 65:0369656be06c default tip

many changes.
author pyon@macmini
date Fri, 20 May 2022 06:30:34 +0900
parents 34a474fb83c3
children
line wrap: on
line source

@echo off

rem --------------------------
rem Config (make porori.json)
rem --------------------------
porori64.exe

rem --------------------------
rem Get Data (recent)
rem --------------------------
set ACCESS="C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE"
set MDB=C:\Users\KAIGO\Desktop\Porori\export.mdb
set NCSV=C:\Users\KAIGO\Documents\nintei.csv
set ICSV=C:\Users\KAIGO\Documents\i.csv
set CCSV=C:\Users\KAIGO\Documents\c.csv
set TCSV=t.csv
set EXCELFILE=【被保険者番号 前0仕様追加後】受付台帳(R3.6.11最新).xlsm

%ACCESS% %MDB% /nostartup /x data

rem --------------------------
rem rem Excel 2 Csv
rem --------------------------
excelize.exe %EXCELFILE% > %TCSV%

rem --------------------------
rem Do Filter
rem --------------------------
porori64_go.exe %NCSV% %ICSV% %CCSV% %TCSV% > a.csv
start a.csv