3.2.2 CSVファイルの出力

Interstage BPM Monitoring 解説書 9.0

第3章モニタリング結果の分析例

> 3.2 表計算ソフトを利用した分析例

3.2.2 CSVファイルの出力

プロセスモニタ用CSV出力コマンドでのイベントデータCSVファイル出力の手順を以下に示します。

検索定義ファイルの作成

テキストエディタを使用し、プロセスモニタ用CSV出力コマンドの検索定義ファイル「出荷業務10月.env」を、以下の内容で作成します。

targetDB=AnalyzeDB
businessModel=出荷業務
csvFormat=出荷業務フォーマット
dateFormat=2
dataType=
dataKey=
propertiesName=
propertiesValue=
startTime=2004-10-01 00:00:00
finishTime=2004-10-31 23:59:59
targetVersion=

CSVファイルの出力

上記で作成した、検索定義ファイル「出荷業務10月.env」を使用し、プロセスモニタ用CSV出力コマンド(bpadata2csv.bat)により、CSVファイルを出力します。
ここでは、CSVファイルを「出荷業務10月.csv」として保存します。

プロセスモニタ用CSV出力コマンド例

bpadata2csv -p BPM Monitoringパスワード -o 出荷業務10月.csv -e 出荷業務10月.env

CSVファイル「出荷業務10月.csv」の内容

"ModelName","DataType","DataKey","EventName","StartTime","FinishTime","StandardTime","TimeCost","QuantityCost","FixedCost","作業者"
"出荷業務","受注伝票","CS_0001","受注","2004-10-04 12:48:43","2004-10-04 16:00:04",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0001","出荷","2004-10-04 13:22:42","2004-10-04 13:46:25",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0002","受注","2004-10-05 10:09:13","2004-10-05 13:04:40",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0002","出荷","2004-10-05 13:26:25","2004-10-05 13:44:50",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0003","受注","2004-10-06 10:23:13","2004-10-06 13:54:08",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0003","出荷","2004-10-06 14:21:54","2004-10-06 14:59:45",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0004","受注","2004-10-07 09:12:38","2004-10-07 12:50:45",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0004","出荷","2004-10-07 14:15:22","2004-10-07 14:35:03",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0005","受注","2004-10-08 10:11:13","2004-10-08 13:13:31",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0005","出荷","2004-10-08 14:01:42","2004-10-08 14:20:01",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0006","受注","2004-10-08 15:11:13","2004-10-08 18:13:31",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0006","出荷","2004-10-08 19:01:42","2004-10-08 19:20:01",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0007","受注","2004-10-12 09:50:43","2004-10-12 13:01:04",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0007","出荷","2004-10-12 13:20:42","2004-10-12 13:47:25",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0008","受注","2004-10-12 10:07:13","2004-10-12 13:05:40",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0008","出荷","2004-10-12 13:27:25","2004-10-12 13:45:50",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0009","受注","2004-10-13 10:24:13","2004-10-13 13:58:08",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0009","出荷","2004-10-13 14:20:54","2004-10-13 14:55:45",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0010","受注","2004-10-14 14:15:38","2004-10-14 17:50:45",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0010","出荷","2004-10-15 11:15:22","2004-10-15 11:34:03",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0011","受注","2004-10-15 10:11:13","2004-10-15 13:13:31",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0011","出荷","2004-10-15 14:01:42","2004-10-15 14:20:01",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0012","受注","2004-10-18 09:50:43","2004-10-18 13:01:04",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0012","出荷","2004-10-18 13:20:42","2004-10-18 13:47:25",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0013","受注","2004-10-19 10:06:13","2004-10-19 13:05:40",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0013","出荷","2004-10-19 13:20:25","2004-10-19 13:45:50",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0014","受注","2004-10-20 10:22:13","2004-10-20 13:58:08",3.0,4000,800,1100,"富士通花子"
"出荷業務","受注伝票","CS_0014","出荷","2004-10-20 14:26:54","2004-10-20 14:55:45",0.3,3800,900,1700,"富士通花子"
"出荷業務","受注伝票","CS_0015","受注","2004-10-21 14:16:38","2004-10-21 17:50:45",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0015","出荷","2004-10-22 11:14:22","2004-10-22 11:34:03",0.3,3800,900,1700,"富士通太郎"
"出荷業務","受注伝票","CS_0016","受注","2004-10-22 10:11:13","2004-10-22 13:13:31",3.0,4000,800,1100,"富士通太郎"
"出荷業務","受注伝票","CS_0016","出荷","2004-10-22 14:01:42","2004-10-22 14:20:42",0.3,3800,900,1700,"富士通太郎"