最近工作将3T左右的数据导入oracle,按月分类了文件夹,每个文件夹有当月每天的文本文件,每月大概300G。
第一步:分析原始数据文件的格式,创建表,由于数据量大,按每天进行分区,即使这样,每个分区也有10G左右的大小,oracle建议单个表不超过2G,查询应该会较慢
,另原始文件的第一列不需要
create table T_GPSDATA_WEIXINGDINGWEI
(
bus_id VARCHAR2(96) not null,
line_id VARCHAR2(96) not null,
child_line_id VARCHAR2(96) not null,
orgz_id NUMBER,
lct_status NUMBER,
lng NUMBER(15,6),
lat NUMBER(15,6),
lct_altitude NUMBER(15,6),
lct_time DATE,
lct_speed NUMBER(15,2),
lct_direction NUMBER(38,2),
edr_speed NUMBER(15,2),
edr_miles NUMBER(15,2)
PARTITION BY RANGE (LCT_TIME)
INTERVAL(NUMTODSINTERVAL(1,'DAY'))
STORE IN (GPSDATA_WEIXINGDINGWEI)
(
PARTITION LCT_TIME_PART01 VALUES LESS THAN (TO_DATE('2015-05-01','yyyy-mm-dd')) TABLESPACE GPSDATA_WEIXINGDINGWEI
);
第二步:创建控制文件的初步模型,导入过程发现了一些问题,需要调整控制文件
load data
characterset AL32UTF8
infile 'E:\gpsdata\201506\weixingdingwei\卫星定位信息2015060205'
append into table T_GPSDATA_WEIXINGDINGWEI
fields terminated by ','
( terminated,
bus_id,
line_id,
child_line_id,
orgz_id,
lct_status,
lng,
lat,
lct_altitude,
lct_time "to_date(:lct_time,'''yyyy-mm-dd hh24:mi:ss''')",
lct_speed,
lct_direction,
edr_speed,
edr_miles
)
第三步:实验发现几个问题
第一:文本类型不是txt格式,这个容易,直接写个bat将所有文件类型转换成txt格式
第二:打开文本文件发现是UTF-16LE格式,这个亲身试验,导入报错,手动改成utf-8格式,就可以导入,在网上找了个文本格式转换的java源代码,具体参考博文后面的BatchConvertFileEncode.java
第三:lct_time,bus_id,line_id,child_line_id的有些记录为空(2个双引号括起来,中间没有任何内容),并且原始数据文件每个字段都用双引号括起来了,控制文件修改如下:
第四:每个文件夹有几百个文件,我不可能手动输入infile的每个具体的文件位置及名称,还有每个文件的名称都包含中文,也会报错,用java解决,因此自己写了个代码,具体参考博文后面的zip3.java
options(errors=999999999) //允许的错误数,根据需要修改
load data
characterset AL32UTF8
infile 'E:\gpsdata\201506\weixingdingwei\卫星定位信息2015060205'
append into table T_GPSDATA_WEIXINGDINGWEI
fields terminated by ',' //表示每个字段由逗号分隔
OPTIONALLY ENCLOSED BY '"' //表示字段由双引号括起来
( terminated filler, //加上filler表示不导入该列
bus_id "nullif(:bus_id,'')", //nullif对该字段做判断,如果为''(中间没有字符),则插入null显示在oracle就是空
line_id "nullif(:line_id,'')",
child_line_id "nullif(:child_line_id ,'')",
orgz_id,
lct_status,
lng,
lat,
lct_altitude,
lct_time "to_date(nullif(:lct_time,''),'''yyyy-mm-dd hh24:mi:ss''')",
lct_speed,
lct_direction,
edr_speed,
edr_miles
)
最终通过java代码生成如下的控制文件,(zip3.java生成的不完全是,主要是表的字段不一样,这个手动好改):
第四步:在处理好的文件夹下,输入cmd,输入:sqlldr userid=gpsdata/gpsdata@its0 control=000input.ctl rows=100160 readsize=20971520 bindsize=20971520 PARALLEL=TRUE
这里用的是并行的(PARALLEL=TRUE)方式导入,速度较快,具体可参考sqlldr性能优化
http://blog.youkuaiyun.com/kangkangwanwan/article/details/51869994
另外详细的sqlldr参数可参考
https://wenku.baidu.com/view/63737c19cc7931b765ce1517.html
------附上2个java代码
BatchConvertFileEncode.java的内容,只需修改路径,文件转换前后的格式,文件类型即可
zip3.java,其中zipPath是文件夹目录,ctlfile是控制文件名称,oldstr,newstr意思是需要将文件名称内容为oldstr替换为newstr,
里面有些函数,比如重命名文件,比如自动创建控制文件(主要是为了不手动输入每个文件的位置名称)等,根据需要运行,注释不需要的功能即可
第一步:分析原始数据文件的格式,创建表,由于数据量大,按每天进行分区,即使这样,每个分区也有10G左右的大小,oracle建议单个表不超过2G,查询应该会较慢
,另原始文件的第一列不需要
create table T_GPSDATA_WEIXINGDINGWEI
(
bus_id VARCHAR2(96) not null,
line_id VARCHAR2(96) not null,
child_line_id VARCHAR2(96) not null,
orgz_id NUMBER,
lct_status NUMBER,
lng NUMBER(15,6),
lat NUMBER(15,6),
lct_altitude NUMBER(15,6),
lct_time DATE,
lct_speed NUMBER(15,2),
lct_direction NUMBER(38,2),
edr_speed NUMBER(15,2),
edr_miles NUMBER(15,2)
PARTITION BY RANGE (LCT_TIME)
INTERVAL(NUMTODSINTERVAL(1,'DAY'))
STORE IN (GPSDATA_WEIXINGDINGWEI)
(
PARTITION LCT_TIME_PART01 VALUES LESS THAN (TO_DATE('2015-05-01','yyyy-mm-dd')) TABLESPACE GPSDATA_WEIXINGDINGWEI
);
第二步:创建控制文件的初步模型,导入过程发现了一些问题,需要调整控制文件
load data
characterset AL32UTF8
infile 'E:\gpsdata\201506\weixingdingwei\卫星定位信息2015060205'
append into table T_GPSDATA_WEIXINGDINGWEI
fields terminated by ','
( terminated,
bus_id,
line_id,
child_line_id,
orgz_id,
lct_status,
lng,
lat,
lct_altitude,
lct_time "to_date(:lct_time,'''yyyy-mm-dd hh24:mi:ss''')",
lct_speed,
lct_direction,
edr_speed,
edr_miles
)
第三步:实验发现几个问题
第一:文本类型不是txt格式,这个容易,直接写个bat将所有文件类型转换成txt格式
第二:打开文本文件发现是UTF-16LE格式,这个亲身试验,导入报错,手动改成utf-8格式,就可以导入,在网上找了个文本格式转换的java源代码,具体参考博文后面的BatchConvertFileEncode.java
第三:lct_time,bus_id,line_id,child_line_id的有些记录为空(2个双引号括起来,中间没有任何内容),并且原始数据文件每个字段都用双引号括起来了,控制文件修改如下:
第四:每个文件夹有几百个文件,我不可能手动输入infile的每个具体的文件位置及名称,还有每个文件的名称都包含中文,也会报错,用java解决,因此自己写了个代码,具体参考博文后面的zip3.java
options(errors=999999999) //允许的错误数,根据需要修改
load data
characterset AL32UTF8
infile 'E:\gpsdata\201506\weixingdingwei\卫星定位信息2015060205'
append into table T_GPSDATA_WEIXINGDINGWEI
fields terminated by ',' //表示每个字段由逗号分隔
OPTIONALLY ENCLOSED BY '"' //表示字段由双引号括起来
( terminated filler, //加上filler表示不导入该列
bus_id "nullif(:bus_id,'')", //nullif对该字段做判断,如果为''(中间没有字符),则插入null显示在oracle就是空
line_id "nullif(:line_id,'')",
child_line_id "nullif(:child_line_id ,'')",
orgz_id,
lct_status,
lng,
lat,
lct_altitude,
lct_time "to_date(nullif(:lct_time,''),'''yyyy-mm-dd hh24:mi:ss''')",
lct_speed,
lct_direction,
edr_speed,
edr_miles
)
最终通过java代码生成如下的控制文件,(zip3.java生成的不完全是,主要是表的字段不一样,这个手动好改):
点击(此处)折叠或打开
-
options(errors=999999999)
-
load data
-
characterset AL32UTF8
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060114.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060115.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060116.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060117.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060118.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060119.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060120.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060121.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060122.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060123.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060200.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060201.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060202.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060203.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060204.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060205.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060206.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060207.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060208.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060209.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060210.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060211.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060212.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060213.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060214.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060215.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060216.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060217.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060218.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060219.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060220.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060221.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060222.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060223.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060300.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060301.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060302.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060303.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060304.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060305.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060306.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060307.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060308.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060309.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060310.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060311.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060312.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060313.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060314.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060315.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060316.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060317.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060318.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060319.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060320.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060321.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060322.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060323.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060400.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060401.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060402.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060403.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060404.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060405.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060406.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060407.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060408.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060409.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060410.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060411.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060412.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060413.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060414.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060415.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060416.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060417.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060418.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060419.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060420.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060421.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060422.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060423.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060500.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060501.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060502.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060503.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060504.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060505.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060506.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060507.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060508.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060509.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060510.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060511.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060512.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060513.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060514.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060515.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060516.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060517.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060518.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060519.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060520.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060521.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060522.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060523.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060600.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060601.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060602.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060603.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060604.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060605.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060606.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060607.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060608.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060609.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060610.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060611.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060612.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060613.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060614.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060615.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060616.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060617.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060618.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060619.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060620.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060621.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060622.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060623.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060700.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060701.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060702.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060703.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060704.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060705.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060706.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060707.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060708.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060709.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060710.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060711.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060712.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060713.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060714.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060715.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060716.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060717.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060718.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060719.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060720.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060721.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060722.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060723.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060800.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060801.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060802.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060803.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060804.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060805.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060806.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060807.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060808.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060809.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060810.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060811.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060812.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060813.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060814.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060815.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060816.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060817.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060818.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060819.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060820.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060821.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060822.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060823.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060900.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060901.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060902.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060903.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060904.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060905.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060906.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060907.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060908.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060909.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060910.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060911.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060912.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060913.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060914.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060915.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060916.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060917.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060918.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060919.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060920.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060921.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060922.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060923.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061000.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061001.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061002.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061003.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061004.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061005.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061006.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061007.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061008.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061009.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061010.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061011.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061012.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061013.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061014.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061015.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061016.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061017.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061018.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061019.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061020.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061021.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061022.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061023.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061100.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061101.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061102.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061103.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061104.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061105.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061106.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061107.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061108.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061109.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061110.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061111.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061112.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061113.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061114.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061115.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061116.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061117.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061118.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061119.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061120.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061121.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061122.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061123.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061200.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061201.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061202.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061203.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061204.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061205.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061206.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061207.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061208.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061209.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061210.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061211.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061212.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061213.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061214.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061215.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061216.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061217.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061218.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061219.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061220.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061221.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061222.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061223.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061300.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061301.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061302.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061303.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061304.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061305.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061306.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061307.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061308.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061309.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061310.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061311.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061312.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061313.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061314.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061315.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061316.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061317.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061318.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061319.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061320.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061321.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061322.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061323.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061400.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061401.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061402.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061403.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061404.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061405.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061406.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061407.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061408.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061409.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061410.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061411.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061412.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061413.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061414.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061415.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061416.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061417.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061418.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061419.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061420.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061421.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061422.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061423.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061500.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061501.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061502.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061503.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061504.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061505.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061506.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061507.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061508.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061509.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061510.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061511.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061512.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061513.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061514.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061515.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061516.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061517.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061518.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061519.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061520.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061521.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061522.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061523.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061600.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061601.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061602.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061603.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061604.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061605.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061606.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061607.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061608.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061609.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061610.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061611.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061612.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061613.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061614.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061615.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061616.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061617.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061618.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061619.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061620.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061621.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061622.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061623.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061700.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061701.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061702.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061703.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061704.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061705.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061706.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061707.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061708.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061709.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061710.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061711.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061712.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061713.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061714.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061715.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061716.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061717.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061718.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061719.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061720.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061721.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061722.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061723.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061800.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061801.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061802.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061803.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061804.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061805.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061806.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061807.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061808.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061809.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061810.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061811.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061812.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061813.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061814.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061815.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061816.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061900.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061901.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061902.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061903.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061904.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061905.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061906.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061907.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061908.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061909.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061910.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061911.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061912.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061913.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061914.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061915.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061916.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061917.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061918.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061919.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061920.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061921.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061922.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061923.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062000.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062001.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062002.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062003.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062004.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062005.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062006.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062007.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062008.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062009.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062010.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062011.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062012.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062013.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062014.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062015.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062016.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062017.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062018.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062019.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062020.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062021.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062022.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062023.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062100.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062101.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062102.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062103.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062104.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062105.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062106.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062107.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062108.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062109.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062110.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062111.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062112.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062113.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062114.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062115.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062116.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062117.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062118.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062119.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062120.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062121.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062122.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062123.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062200.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062201.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062202.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062203.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062204.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062205.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062206.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062207.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062208.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062209.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062210.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062211.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062212.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062213.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062214.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062215.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062216.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062217.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062218.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062219.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062220.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062221.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062222.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062223.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062300.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062301.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062302.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062303.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062304.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062305.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062306.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062307.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062308.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062309.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062310.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062311.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062312.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062313.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062314.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062315.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062316.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062317.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062318.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062319.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062320.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062321.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062322.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062323.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062400.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062401.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062402.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062403.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062404.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062405.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062406.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062407.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062408.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062409.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062410.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062411.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062412.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062413.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062414.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062415.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062416.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062417.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062418.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062419.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062420.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062421.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062422.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062423.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062500.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062501.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062502.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062503.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062504.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062505.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062506.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062507.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062508.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062509.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062510.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062511.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062512.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062513.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062514.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062515.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062516.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062517.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062518.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062519.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062520.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062521.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062522.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062523.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062600.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062601.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062602.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062603.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062604.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062605.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062606.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062607.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062608.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062609.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062610.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062611.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062612.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062613.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062614.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062615.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062616.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062617.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062618.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062619.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062620.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062621.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062622.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062623.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062700.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062701.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062702.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062703.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062704.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062705.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062706.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062707.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062708.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062709.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062710.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062711.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062712.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062713.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062714.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062715.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062716.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062717.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062718.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062719.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062720.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062721.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062722.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062723.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062800.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062801.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062802.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062803.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062804.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062805.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062806.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062807.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062808.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062809.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062810.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062811.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062812.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062813.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062814.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062815.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062816.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062817.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062818.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062819.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062820.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062821.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062822.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062823.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062900.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062901.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062902.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062903.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062904.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062905.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062906.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062907.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062908.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062909.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062910.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062911.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062912.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062913.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062914.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062915.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062916.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062917.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062918.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062919.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062920.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062921.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062922.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062923.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063000.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063001.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063002.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063003.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063004.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063005.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063006.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063007.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063008.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063009.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063010.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063011.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063012.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063013.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063014.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063015.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063016.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063017.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063018.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063019.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063020.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063021.txt'
-
infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063022.txt'
-
append into table T_GPSDATA_WEIXINGDINGWEI
-
fields terminated by ','
-
OPTIONALLY ENCLOSED BY '"'
-
( terminated filler,
-
bus_id "nullif(:bus_id,'')",
-
line_id "nullif(:line_id,'')",
-
child_line_id "nullif(:child_line_id ,'')",
-
orgz_id,
-
lct_status,
-
lng,
-
lat,
-
lct_altitude,
-
lct_time "to_date(nullif(:lct_time,'null'),'''yyyy-mm-dd hh24:mi:ss''')",
-
lct_speed,
-
lct_direction,
-
edr_speed,
-
edr_miles
- )
第四步:在处理好的文件夹下,输入cmd,输入:sqlldr userid=gpsdata/gpsdata@its0 control=000input.ctl rows=100160 readsize=20971520 bindsize=20971520 PARALLEL=TRUE
这里用的是并行的(PARALLEL=TRUE)方式导入,速度较快,具体可参考sqlldr性能优化
http://blog.youkuaiyun.com/kangkangwanwan/article/details/51869994
另外详细的sqlldr参数可参考
https://wenku.baidu.com/view/63737c19cc7931b765ce1517.html
------附上2个java代码
BatchConvertFileEncode.java的内容,只需修改路径,文件转换前后的格式,文件类型即可
点击(此处)折叠或打开
-
package test;
-
-
import java.io.File;
-
import java.io.FileFilter;
-
import java.io.FileInputStream;
-
import java.io.FileOutputStream;
-
import java.io.IOException;
-
import java.io.InputStreamReader;
-
import java.io.OutputStreamWriter;
-
import java.util.ArrayList;
-
import java.util.List;
-
-
/**
-
* 批量转换文件编码
-
*
-
* @date 2014-10-23
-
*
-
* @author xsoftlab.net
-
*/
-
public class BatchConvertFileEncode {
-
/**
-
* 获取文件或文件夹 不存在则创建
-
*
-
* @param path
-
* 文件或文件夹路径
-
* @return 已有/新创建的文件
-
* @throws IOException
-
* 可能产生的异常
-
*/
-
public static File getFile(String path) throws IOException {
-
File file = new File(path);
-
if (file.isDirectory()) {
-
if (!file.exists())
-
file.mkdirs();
-
} else {
-
// 判断目标文件所在的目录是否存在
-
if (!file.getParentFile().exists())
-
file.getParentFile().mkdirs();
-
if (!file.exists())
-
file.createNewFile();
-
}
-
return file;
-
}
-
-
/**
-
* 递归查找指定后缀名的文件
-
*
-
* @param folder
-
* 目标文件夹
-
* @param suffix
-
* 目标后缀名
-
* @return 找到的文件集合
-
*/
-
public static List<File> searchFile(File folder, final String suffix) {
-
List<File> result = new ArrayList<File>();
-
File[] subFolders = folder.listFiles(new FileFilter() {// 运用内部匿名类获得文件
-
@Override
-
public boolean accept(File pathname) {// 实现FileFilter类的accept方法
-
if (pathname.isDirectory()
-
|| (pathname.isFile() && pathname.getName()
-
.toLowerCase()
-
.endsWith(suffix.toLowerCase())))// 根据文件后缀名过滤
-
return true;
-
return false;
-
}
-
});
-
if (subFolders != null) {
-
for (File file : subFolders) {
-
if (file.isFile()) {
-
// 如果是文件则将文件添加到结果列表中
-
result.add(file);
-
} else {
-
// 如果是文件夹,则递归调用本方法,然后把所有的文件加到结果列表中
-
result.addAll(searchFile(file, suffix));
-
}
-
}
-
}
-
return result;
-
}
-
-
/**
-
* 单个文件转换编码
-
*
-
* @param file
-
* 要转换的文件
-
* @param tarFile
-
* 转换后的文件
-
* @param charset
-
* 转换前的编码
-
* @param tarCharset
-
* 转换后的编码
-
* @throws IOException
-
* 可能出现的异常
-
*/
-
public static void convertFileEncode(File file, File tarFile,
-
String charset, String tarCharset) throws IOException {
-
InputStreamReader reader = null;
-
OutputStreamWriter writer = null;
-
int length;
-
char[] b = new char[3 * 1024];
-
try {
-
// 打开文件输出流
-
reader = new InputStreamReader(new FileInputStream(file), charset);
-
writer = new OutputStreamWriter(new FileOutputStream(tarFile),
-
tarCharset);
-
while ((length = reader.read(b)) != -1) {
-
writer.write(b, 0, length);
-
writer.flush();
-
}
-
} finally {
-
// 关闭文件流
-
if (reader != null)
-
reader.close();
-
if (writer != null)
-
writer.close();
-
}
-
}
-
-
/**
-
* 根据文件夹批量转换编码
-
*
-
* @param folder
-
* 要转换的文件夹
-
* @param tarFolder
-
* 输出文件夹
-
* @param charset
-
* 转换前的编码
-
* @param tarCharset
-
* 转换后的编码
-
* @param suffix
-
* 要转换的文件后缀名
-
* @throws IOException
-
* 可能出现的异常
-
*/
-
public static void convertFileEncodeByFolder(String folder,
-
String tarFolder, String charset, String tarCharset, String suffix)
-
throws IOException {
-
String relTar = null;
-
List<File> result = searchFile(new File(folder), suffix);// 调用方法获得文件数组
-
System.out.println("找到 " + result.size() + " 个需要转换的文件");
-
// 文件尾部处理
-
if (!folder.endsWith("/") && !folder.endsWith("\\"))
-
folder += File.separator;
-
if (!tarFolder.endsWith("/") && !tarFolder.endsWith("\\"))
-
tarFolder += File.separator;
-
for (File file : result) {
-
// 使目标文件夹目录层次与源文件夹对应
-
relTar = tarFolder
-
+ file.getAbsolutePath().replace(folder.replace("/", "\\"),
-
"");
-
convertFileEncode(file, getFile(relTar), charset, tarCharset);
-
}
-
System.out.println("转换成功!");
-
}
-
-
public static void main(String[] args) {
-
try {
-
convertFileEncodeByFolder("E:\\gpsdata\\201506\\weixingdingwei",
-
"E:\\gpsdata\\201506\\weixingdingwei2", "UTF-16LE",
-
"UTF-8", "txt");
-
} catch (IOException e) {
-
e.printStackTrace();
-
}
-
}
- }
zip3.java,其中zipPath是文件夹目录,ctlfile是控制文件名称,oldstr,newstr意思是需要将文件名称内容为oldstr替换为newstr,
里面有些函数,比如重命名文件,比如自动创建控制文件(主要是为了不手动输入每个文件的位置名称)等,根据需要运行,注释不需要的功能即可
点击(此处)折叠或打开
-
package test;
-
-
import java.io.BufferedInputStream;
-
import java.io.BufferedOutputStream;
-
import java.io.BufferedWriter;
-
import java.io.File;
-
import java.io.FileInputStream;
-
import java.io.FileNotFoundException;
-
import java.io.FileOutputStream;
-
import java.io.FileWriter;
-
import java.io.FilenameFilter;
-
import java.io.IOException;
-
import java.util.ArrayList;
-
import java.util.zip.ZipEntry;
-
import java.util.zip.ZipInputStream;
-
-
public class zip3 {
-
-
public static void main(String[] args) throws IOException {
-
// File dir = new File("F:\\ICDATA\\ic卡数据txt版\\201511\\20151108");
-
// String strcmd = "cmd /c start F:\\ICDATA\\ic卡数据txt版\\201511\\20151108\\000.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
-
// run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
-
-
String zipPath="E:\\gpsdata\\201506\\weixingdingwei";
-
String ctlfile = "000input.ctl";
-
String oldstr = "卫星定位信息";
-
String newstr = "weixingdingwei";
-
ArrayList<String> filelist=getFiles(new ArrayList<String>(),zipPath);
-
-
for(String str:filelist){
-
System.out.println(str);
-
-
/*批量重命名文件*/
-
renameFile(str,oldstr,newstr);
-
-
/*自动创建控制文件*/
-
// createCtlFile(ctlfile,str);
-
-
/*自动拷贝bat文件*/
-
// copyFile("F:\\ICDATA\\icdatatxt\\000自动导入.bat",str+"\\000自动导入.bat");
-
-
/*自动执行bat文件*/
-
// File dir = new File(str);
-
// String strcmd = "cmd /c start "+str+"\\000.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
-
// run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
-
// try {
-
// Thread.sleep(60000);
-
// } catch (InterruptedException e1) {
-
// e1.printStackTrace();
-
// }
-
-
/*自动执行数据导入*/
-
// File dir = new File(str);
-
// String strcmd = "cmd /c start "+str+"\\000自动导入.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
-
// run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
-
// try {
-
// Thread.sleep(60000);
-
// break;
-
// } catch (InterruptedException e1) {
-
// e1.printStackTrace();
-
// }
-
-
/*自动删除000.txt文件*/
-
// File f = new File(str+"\\000.txt"); // 输入要删除的文件位置
-
// if(f.exists())
-
// f.delete();
-
// else
-
// System.out.println("未找到文件");
-
-
}
-
-
-
}
-
-
-
static void renameFile(String path,String oldstr,String newstr)
-
{
-
File filename = new File(path);
-
File[] filelist = filename.listFiles();
-
for(File file:filelist){
-
String oldname = file.getName();
-
//System.out.println(oldname);
-
if (oldname.indexOf(".txt")!=-1) {
-
if (oldname.indexOf(oldstr)!=-1) {
-
String newname = oldname.replace(oldstr, newstr);
-
System.out.println(newname);
-
file.renameTo(new File(path+'\\'+newname));
-
}
-
} else {
-
System.out.println("不是txt类型文件");
-
}
-
}
-
}
-
-
/*创建一个指内容的ctl文件*/
-
static void createCtlFile(String ctlfile,String filePath) throws IOException{
-
String data1 = "load data\r\n";
-
String data2 = "characterset AL32UTF8\r\n";
-
String data3 = "infile '";
-
String data4 = "\\";
-
String data5 = "'";
-
String data6 = "\r\n";
-
String datamonth = "append into table T_GPSDATA_INSTATION\r\n";
-
String datatable = "fields terminated by ','\r\n" +
-
"( terminated filler,\r\n" +
-
" bus_id,\r\n" +
-
" line_id,\r\n" +
-
" child_line_id,\r\n" +
-
" orgz_id,\r\n" +
-
" lct_status,\r\n" +
-
" lng,\r\n" +
-
" lat,\r\n" +
-
" lct_altitude,\r\n" +
-
" lct_time " + "\""+"to_date(:lct_time,'''yyyy-mm-dd hh24:mi:ss''')"+"\",\r\n" +
-
" lct_speed,\r\n" +
-
" lct_direction,\r\n" +
-
" edr_speed,\r\n" +
-
" edr_miles,\r\n" +
-
" time_in " + "\""+"to_date(:time_in,'''yyyy-mm-dd hh24:mi:ss''')"+"\",\r\n" +
-
" next_stop_id\r\n" +
-
")";
-
String filenameTemp = filePath+"\\"+ctlfile;//文件路径+文件名称
-
System.out.println(filenameTemp);
-
File filename = new File(filePath);
-
File[] strarr = filename.listFiles();
-
File file = new File(filenameTemp);
-
if (!file.exists()) {
-
try {
-
file.createNewFile();
-
} catch (IOException e) {
-
// TODO Auto-generated catch block
-
e.printStackTrace();
-
}
-
}
-
-
byte[] byteindata1 = data1.getBytes();
-
byte[] byteindata2 = data2.getBytes();
-
try {
-
FileOutputStream output=new FileOutputStream(filenameTemp);
-
try {
-
output.write(byteindata1);
-
output.write(byteindata2);
-
byte[] byteinfilepath = filePath.getBytes();
-
byte[] byteindata3 = data3.getBytes();
-
byte[] byteindata4 = data4.getBytes();
-
byte[] byteindata5 = data5.getBytes();
-
byte[] byteindata6 = data6.getBytes();
-
byte[] byteindatamonth = datamonth.getBytes();
-
byte[] byteindatatable = datatable.getBytes();
-
for (int i = 0; i < strarr.length; i++) {
-
//System.out.println(strarr[i].getName());
-
if (strarr[i].getName().equals("000input.ctl")) {
-
continue;
-
}
-
byte[] byteinstrname = strarr[i].getName().getBytes();
-
output.write(byteindata3);
-
output.write(byteinfilepath);
-
output.write(byteindata4);
-
output.write(byteinstrname);
-
output.write(byteindata5);
-
output.write(byteindata6);
-
}
-
output.write(byteindatamonth);
-
output.write(byteindatatable);
-
output.flush();
-
output.close();
-
} catch (IOException e) {
-
// TODO Auto-generated catch block
-
e.printStackTrace();
-
}
-
} catch (FileNotFoundException e) {
-
// TODO Auto-generated catch block
-
e.printStackTrace();
-
}
-
}
-
-
/*复制文件到指定目录下*/
-
static void copyFile(String path,String copyPath){
-
try{
-
//path: "f://downloads//kon.jpg"
-
FileInputStream input=new FileInputStream(path);//可替换为任何路径何和文件名
-
//copyPath: "f://kon.jpg"
-
FileOutputStream output=new FileOutputStream(copyPath);//可替换为任何路径何和文件名
-
int in=input.read();
-
while(in!=-1){
-
output.write(in);
-
in=input.read();
-
}
-
}catch (IOException e){
-
System.out.println(e.toString());
-
}
-
}
-
/*
-
* 通过递归得到某一路径下所有的目录及其文件
-
*/
-
static ArrayList<String> getFiles(ArrayList<String> filelist,String filePath){
-
File root = new File(filePath);
-
File[] files = root.listFiles();
-
for(File file:files){
-
if(file.isDirectory()){
-
getFiles(filelist,file.getAbsolutePath());
-
-
}else{
-
int a=0;
-
String fileParentPath=file.getParent();
-
for(String str:filelist){
-
if(str.endsWith(fileParentPath)){
-
a=1;
-
}
-
}
-
if(a==0){
-
filelist.add(file.getParent());
-
//System.out.println("显示:"+fileParentPath);
-
}
-
}
-
}
-
return filelist;
-
}
-
/*
-
* 添加问价后缀
-
*/
-
static void getFileNames(String path){
-
File file = new File(path);
-
if (file.exists()) {
-
File[] files = file.listFiles();
-
if (files.length == 0) {
-
System.out.println("文件夹是空的!");
-
return;
-
} else {
-
for (File file2 : files) {
-
if (file2.isDirectory()) {
-
getFileNames(file2.getAbsolutePath());
-
} else {
-
file2.renameTo(new File(file2.getParent() + "/" + file2.getName()+".txt"));
-
}
-
}
-
}
-
} else {
-
System.out.println("文件不存在!");
-
}
-
}
-
/*执行bat文件*/
-
/*指定bat执行目录*/
-
static void run_cmd(String strcmd,File dir) {
-
//
-
Runtime rt = Runtime.getRuntime(); //Runtime.getRuntime()返回当前应用程序的Runtime对象
-
Process ps = null; //Process可以控制该子进程的执行或获取该子进程的信息。
-
try {
-
ps = rt.exec(strcmd,null,dir); //该对象的exec()方法指示Java虚拟机创建一个子进程执行指定的可执行程序,并返回与该子进程对应的Process对象实例。
-
ps.waitFor(); //等待子进程完成再往下执行。
-
} catch (IOException e1) {
-
e1.printStackTrace();
-
} catch (InterruptedException e) {
-
// TODO Auto-generated catch block
-
e.printStackTrace();
-
}
-
-
int i = ps.exitValue(); //接收执行完毕的返回值
-
if (i == 0) {
-
System.out.println("执行完成.");
-
} else {
-
System.out.println("执行失败.");
-
}
-
-
ps.destroy(); //销毁子进程
-
ps = null;
-
}
-
/*不指定执行目录*/
-
// static void run_cmd(String strcmd) {
-
// //
-
// Runtime rt = Runtime.getRuntime(); //Runtime.getRuntime()返回当前应用程序的Runtime对象
-
// Process ps = null; //Process可以控制该子进程的执行或获取该子进程的信息。
-
// try {
-
// ps = rt.exec(strcmd); //该对象的exec()方法指示Java虚拟机创建一个子进程执行指定的可执行程序,并返回与该子进程对应的Process对象实例。
-
// ps.waitFor(); //等待子进程完成再往下执行。
-
// } catch (IOException e1) {
-
// e1.printStackTrace();
-
// } catch (InterruptedException e) {
-
// // TODO Auto-generated catch block
-
// e.printStackTrace();
-
// }
-
//
-
// int i = ps.exitValue(); //接收执行完毕的返回值
-
// if (i == 0) {
-
// System.out.println("执行完成.");
-
// } else {
-
// System.out.println("执行失败.");
-
// }
-
//
-
// ps.destroy(); //销毁子进程
-
// ps = null;
-
// }
-
/**/
- }
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29399342/viewspace-2138676/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29399342/viewspace-2138676/