annotate 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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
1 @echo off
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
2
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
3 rem --------------------------
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
4 rem Config (make porori.json)
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
5 rem --------------------------
65
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
6 porori64.exe
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
7
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
8 rem --------------------------
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
9 rem Get Data (recent)
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
10 rem --------------------------
65
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
11 set ACCESS="C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE"
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
12 set MDB=C:\Users\KAIGO\Desktop\Porori\export.mdb
65
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
13 set NCSV=C:\Users\KAIGO\Documents\nintei.csv
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
14 set ICSV=C:\Users\KAIGO\Documents\i.csv
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
15 set CCSV=C:\Users\KAIGO\Documents\c.csv
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
16 set TCSV=t.csv
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
17 set EXCELFILE=【被保険者番号 前0仕様追加後】受付台帳(R3.6.11最新).xlsm
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
18
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
19 %ACCESS% %MDB% /nostartup /x data
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
20
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
21 rem --------------------------
65
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
22 rem rem Excel 2 Csv
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
23 rem --------------------------
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
24 excelize.exe %EXCELFILE% > %TCSV%
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
25
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
26 rem --------------------------
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
27 rem Do Filter
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
28 rem --------------------------
65
0369656be06c many changes.
pyon@macmini
parents: 41
diff changeset
29 porori64_go.exe %NCSV% %ICSV% %CCSV% %TCSV% > a.csv
41
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
30 start a.csv
34a474fb83c3 add perori/porori/nk.
pyon@macmini
parents:
diff changeset
31