用sqlldr批量导文本数据到oracle的一些经验

本文介绍如何将3T数据高效导入Oracle数据库的过程。针对数据量大、格式复杂等问题,采用分区表、批处理导入、Java辅助等方式提高导入效率,并解决了文件编码、空值处理等问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

最近工作将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生成的不完全是,主要是表的字段不一样,这个手动好改):

点击(此处)折叠或打开

  1. options(errors=999999999)
  2. load data
  3. characterset AL32UTF8
  4. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060114.txt'
  5. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060115.txt'
  6. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060116.txt'
  7. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060117.txt'
  8. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060118.txt'
  9. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060119.txt'
  10. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060120.txt'
  11. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060121.txt'
  12. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060122.txt'
  13. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060123.txt'
  14. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060200.txt'
  15. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060201.txt'
  16. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060202.txt'
  17. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060203.txt'
  18. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060204.txt'
  19. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060205.txt'
  20. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060206.txt'
  21. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060207.txt'
  22. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060208.txt'
  23. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060209.txt'
  24. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060210.txt'
  25. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060211.txt'
  26. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060212.txt'
  27. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060213.txt'
  28. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060214.txt'
  29. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060215.txt'
  30. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060216.txt'
  31. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060217.txt'
  32. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060218.txt'
  33. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060219.txt'
  34. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060220.txt'
  35. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060221.txt'
  36. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060222.txt'
  37. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060223.txt'
  38. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060300.txt'
  39. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060301.txt'
  40. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060302.txt'
  41. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060303.txt'
  42. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060304.txt'
  43. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060305.txt'
  44. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060306.txt'
  45. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060307.txt'
  46. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060308.txt'
  47. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060309.txt'
  48. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060310.txt'
  49. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060311.txt'
  50. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060312.txt'
  51. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060313.txt'
  52. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060314.txt'
  53. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060315.txt'
  54. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060316.txt'
  55. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060317.txt'
  56. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060318.txt'
  57. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060319.txt'
  58. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060320.txt'
  59. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060321.txt'
  60. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060322.txt'
  61. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060323.txt'
  62. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060400.txt'
  63. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060401.txt'
  64. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060402.txt'
  65. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060403.txt'
  66. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060404.txt'
  67. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060405.txt'
  68. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060406.txt'
  69. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060407.txt'
  70. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060408.txt'
  71. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060409.txt'
  72. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060410.txt'
  73. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060411.txt'
  74. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060412.txt'
  75. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060413.txt'
  76. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060414.txt'
  77. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060415.txt'
  78. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060416.txt'
  79. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060417.txt'
  80. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060418.txt'
  81. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060419.txt'
  82. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060420.txt'
  83. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060421.txt'
  84. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060422.txt'
  85. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060423.txt'
  86. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060500.txt'
  87. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060501.txt'
  88. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060502.txt'
  89. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060503.txt'
  90. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060504.txt'
  91. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060505.txt'
  92. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060506.txt'
  93. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060507.txt'
  94. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060508.txt'
  95. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060509.txt'
  96. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060510.txt'
  97. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060511.txt'
  98. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060512.txt'
  99. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060513.txt'
  100. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060514.txt'
  101. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060515.txt'
  102. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060516.txt'
  103. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060517.txt'
  104. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060518.txt'
  105. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060519.txt'
  106. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060520.txt'
  107. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060521.txt'
  108. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060522.txt'
  109. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060523.txt'
  110. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060600.txt'
  111. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060601.txt'
  112. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060602.txt'
  113. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060603.txt'
  114. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060604.txt'
  115. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060605.txt'
  116. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060606.txt'
  117. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060607.txt'
  118. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060608.txt'
  119. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060609.txt'
  120. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060610.txt'
  121. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060611.txt'
  122. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060612.txt'
  123. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060613.txt'
  124. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060614.txt'
  125. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060615.txt'
  126. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060616.txt'
  127. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060617.txt'
  128. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060618.txt'
  129. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060619.txt'
  130. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060620.txt'
  131. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060621.txt'
  132. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060622.txt'
  133. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060623.txt'
  134. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060700.txt'
  135. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060701.txt'
  136. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060702.txt'
  137. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060703.txt'
  138. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060704.txt'
  139. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060705.txt'
  140. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060706.txt'
  141. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060707.txt'
  142. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060708.txt'
  143. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060709.txt'
  144. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060710.txt'
  145. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060711.txt'
  146. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060712.txt'
  147. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060713.txt'
  148. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060714.txt'
  149. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060715.txt'
  150. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060716.txt'
  151. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060717.txt'
  152. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060718.txt'
  153. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060719.txt'
  154. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060720.txt'
  155. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060721.txt'
  156. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060722.txt'
  157. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060723.txt'
  158. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060800.txt'
  159. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060801.txt'
  160. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060802.txt'
  161. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060803.txt'
  162. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060804.txt'
  163. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060805.txt'
  164. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060806.txt'
  165. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060807.txt'
  166. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060808.txt'
  167. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060809.txt'
  168. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060810.txt'
  169. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060811.txt'
  170. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060812.txt'
  171. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060813.txt'
  172. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060814.txt'
  173. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060815.txt'
  174. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060816.txt'
  175. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060817.txt'
  176. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060818.txt'
  177. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060819.txt'
  178. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060820.txt'
  179. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060821.txt'
  180. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060822.txt'
  181. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060823.txt'
  182. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060900.txt'
  183. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060901.txt'
  184. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060902.txt'
  185. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060903.txt'
  186. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060904.txt'
  187. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060905.txt'
  188. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060906.txt'
  189. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060907.txt'
  190. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060908.txt'
  191. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060909.txt'
  192. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060910.txt'
  193. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060911.txt'
  194. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060912.txt'
  195. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060913.txt'
  196. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060914.txt'
  197. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060915.txt'
  198. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060916.txt'
  199. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060917.txt'
  200. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060918.txt'
  201. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060919.txt'
  202. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060920.txt'
  203. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060921.txt'
  204. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060922.txt'
  205. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015060923.txt'
  206. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061000.txt'
  207. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061001.txt'
  208. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061002.txt'
  209. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061003.txt'
  210. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061004.txt'
  211. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061005.txt'
  212. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061006.txt'
  213. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061007.txt'
  214. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061008.txt'
  215. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061009.txt'
  216. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061010.txt'
  217. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061011.txt'
  218. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061012.txt'
  219. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061013.txt'
  220. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061014.txt'
  221. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061015.txt'
  222. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061016.txt'
  223. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061017.txt'
  224. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061018.txt'
  225. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061019.txt'
  226. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061020.txt'
  227. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061021.txt'
  228. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061022.txt'
  229. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061023.txt'
  230. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061100.txt'
  231. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061101.txt'
  232. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061102.txt'
  233. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061103.txt'
  234. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061104.txt'
  235. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061105.txt'
  236. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061106.txt'
  237. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061107.txt'
  238. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061108.txt'
  239. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061109.txt'
  240. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061110.txt'
  241. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061111.txt'
  242. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061112.txt'
  243. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061113.txt'
  244. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061114.txt'
  245. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061115.txt'
  246. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061116.txt'
  247. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061117.txt'
  248. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061118.txt'
  249. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061119.txt'
  250. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061120.txt'
  251. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061121.txt'
  252. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061122.txt'
  253. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061123.txt'
  254. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061200.txt'
  255. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061201.txt'
  256. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061202.txt'
  257. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061203.txt'
  258. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061204.txt'
  259. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061205.txt'
  260. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061206.txt'
  261. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061207.txt'
  262. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061208.txt'
  263. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061209.txt'
  264. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061210.txt'
  265. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061211.txt'
  266. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061212.txt'
  267. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061213.txt'
  268. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061214.txt'
  269. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061215.txt'
  270. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061216.txt'
  271. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061217.txt'
  272. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061218.txt'
  273. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061219.txt'
  274. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061220.txt'
  275. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061221.txt'
  276. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061222.txt'
  277. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061223.txt'
  278. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061300.txt'
  279. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061301.txt'
  280. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061302.txt'
  281. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061303.txt'
  282. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061304.txt'
  283. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061305.txt'
  284. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061306.txt'
  285. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061307.txt'
  286. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061308.txt'
  287. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061309.txt'
  288. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061310.txt'
  289. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061311.txt'
  290. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061312.txt'
  291. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061313.txt'
  292. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061314.txt'
  293. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061315.txt'
  294. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061316.txt'
  295. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061317.txt'
  296. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061318.txt'
  297. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061319.txt'
  298. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061320.txt'
  299. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061321.txt'
  300. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061322.txt'
  301. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061323.txt'
  302. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061400.txt'
  303. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061401.txt'
  304. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061402.txt'
  305. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061403.txt'
  306. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061404.txt'
  307. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061405.txt'
  308. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061406.txt'
  309. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061407.txt'
  310. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061408.txt'
  311. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061409.txt'
  312. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061410.txt'
  313. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061411.txt'
  314. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061412.txt'
  315. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061413.txt'
  316. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061414.txt'
  317. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061415.txt'
  318. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061416.txt'
  319. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061417.txt'
  320. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061418.txt'
  321. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061419.txt'
  322. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061420.txt'
  323. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061421.txt'
  324. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061422.txt'
  325. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061423.txt'
  326. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061500.txt'
  327. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061501.txt'
  328. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061502.txt'
  329. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061503.txt'
  330. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061504.txt'
  331. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061505.txt'
  332. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061506.txt'
  333. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061507.txt'
  334. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061508.txt'
  335. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061509.txt'
  336. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061510.txt'
  337. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061511.txt'
  338. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061512.txt'
  339. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061513.txt'
  340. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061514.txt'
  341. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061515.txt'
  342. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061516.txt'
  343. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061517.txt'
  344. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061518.txt'
  345. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061519.txt'
  346. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061520.txt'
  347. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061521.txt'
  348. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061522.txt'
  349. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061523.txt'
  350. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061600.txt'
  351. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061601.txt'
  352. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061602.txt'
  353. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061603.txt'
  354. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061604.txt'
  355. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061605.txt'
  356. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061606.txt'
  357. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061607.txt'
  358. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061608.txt'
  359. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061609.txt'
  360. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061610.txt'
  361. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061611.txt'
  362. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061612.txt'
  363. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061613.txt'
  364. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061614.txt'
  365. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061615.txt'
  366. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061616.txt'
  367. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061617.txt'
  368. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061618.txt'
  369. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061619.txt'
  370. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061620.txt'
  371. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061621.txt'
  372. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061622.txt'
  373. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061623.txt'
  374. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061700.txt'
  375. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061701.txt'
  376. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061702.txt'
  377. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061703.txt'
  378. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061704.txt'
  379. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061705.txt'
  380. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061706.txt'
  381. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061707.txt'
  382. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061708.txt'
  383. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061709.txt'
  384. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061710.txt'
  385. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061711.txt'
  386. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061712.txt'
  387. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061713.txt'
  388. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061714.txt'
  389. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061715.txt'
  390. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061716.txt'
  391. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061717.txt'
  392. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061718.txt'
  393. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061719.txt'
  394. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061720.txt'
  395. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061721.txt'
  396. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061722.txt'
  397. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061723.txt'
  398. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061800.txt'
  399. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061801.txt'
  400. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061802.txt'
  401. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061803.txt'
  402. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061804.txt'
  403. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061805.txt'
  404. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061806.txt'
  405. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061807.txt'
  406. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061808.txt'
  407. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061809.txt'
  408. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061810.txt'
  409. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061811.txt'
  410. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061812.txt'
  411. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061813.txt'
  412. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061814.txt'
  413. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061815.txt'
  414. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061816.txt'
  415. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061900.txt'
  416. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061901.txt'
  417. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061902.txt'
  418. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061903.txt'
  419. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061904.txt'
  420. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061905.txt'
  421. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061906.txt'
  422. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061907.txt'
  423. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061908.txt'
  424. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061909.txt'
  425. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061910.txt'
  426. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061911.txt'
  427. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061912.txt'
  428. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061913.txt'
  429. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061914.txt'
  430. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061915.txt'
  431. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061916.txt'
  432. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061917.txt'
  433. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061918.txt'
  434. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061919.txt'
  435. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061920.txt'
  436. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061921.txt'
  437. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061922.txt'
  438. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015061923.txt'
  439. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062000.txt'
  440. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062001.txt'
  441. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062002.txt'
  442. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062003.txt'
  443. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062004.txt'
  444. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062005.txt'
  445. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062006.txt'
  446. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062007.txt'
  447. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062008.txt'
  448. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062009.txt'
  449. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062010.txt'
  450. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062011.txt'
  451. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062012.txt'
  452. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062013.txt'
  453. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062014.txt'
  454. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062015.txt'
  455. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062016.txt'
  456. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062017.txt'
  457. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062018.txt'
  458. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062019.txt'
  459. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062020.txt'
  460. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062021.txt'
  461. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062022.txt'
  462. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062023.txt'
  463. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062100.txt'
  464. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062101.txt'
  465. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062102.txt'
  466. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062103.txt'
  467. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062104.txt'
  468. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062105.txt'
  469. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062106.txt'
  470. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062107.txt'
  471. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062108.txt'
  472. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062109.txt'
  473. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062110.txt'
  474. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062111.txt'
  475. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062112.txt'
  476. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062113.txt'
  477. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062114.txt'
  478. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062115.txt'
  479. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062116.txt'
  480. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062117.txt'
  481. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062118.txt'
  482. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062119.txt'
  483. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062120.txt'
  484. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062121.txt'
  485. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062122.txt'
  486. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062123.txt'
  487. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062200.txt'
  488. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062201.txt'
  489. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062202.txt'
  490. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062203.txt'
  491. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062204.txt'
  492. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062205.txt'
  493. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062206.txt'
  494. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062207.txt'
  495. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062208.txt'
  496. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062209.txt'
  497. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062210.txt'
  498. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062211.txt'
  499. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062212.txt'
  500. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062213.txt'
  501. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062214.txt'
  502. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062215.txt'
  503. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062216.txt'
  504. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062217.txt'
  505. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062218.txt'
  506. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062219.txt'
  507. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062220.txt'
  508. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062221.txt'
  509. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062222.txt'
  510. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062223.txt'
  511. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062300.txt'
  512. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062301.txt'
  513. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062302.txt'
  514. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062303.txt'
  515. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062304.txt'
  516. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062305.txt'
  517. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062306.txt'
  518. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062307.txt'
  519. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062308.txt'
  520. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062309.txt'
  521. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062310.txt'
  522. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062311.txt'
  523. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062312.txt'
  524. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062313.txt'
  525. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062314.txt'
  526. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062315.txt'
  527. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062316.txt'
  528. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062317.txt'
  529. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062318.txt'
  530. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062319.txt'
  531. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062320.txt'
  532. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062321.txt'
  533. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062322.txt'
  534. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062323.txt'
  535. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062400.txt'
  536. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062401.txt'
  537. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062402.txt'
  538. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062403.txt'
  539. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062404.txt'
  540. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062405.txt'
  541. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062406.txt'
  542. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062407.txt'
  543. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062408.txt'
  544. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062409.txt'
  545. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062410.txt'
  546. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062411.txt'
  547. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062412.txt'
  548. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062413.txt'
  549. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062414.txt'
  550. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062415.txt'
  551. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062416.txt'
  552. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062417.txt'
  553. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062418.txt'
  554. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062419.txt'
  555. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062420.txt'
  556. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062421.txt'
  557. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062422.txt'
  558. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062423.txt'
  559. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062500.txt'
  560. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062501.txt'
  561. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062502.txt'
  562. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062503.txt'
  563. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062504.txt'
  564. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062505.txt'
  565. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062506.txt'
  566. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062507.txt'
  567. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062508.txt'
  568. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062509.txt'
  569. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062510.txt'
  570. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062511.txt'
  571. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062512.txt'
  572. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062513.txt'
  573. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062514.txt'
  574. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062515.txt'
  575. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062516.txt'
  576. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062517.txt'
  577. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062518.txt'
  578. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062519.txt'
  579. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062520.txt'
  580. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062521.txt'
  581. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062522.txt'
  582. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062523.txt'
  583. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062600.txt'
  584. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062601.txt'
  585. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062602.txt'
  586. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062603.txt'
  587. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062604.txt'
  588. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062605.txt'
  589. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062606.txt'
  590. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062607.txt'
  591. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062608.txt'
  592. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062609.txt'
  593. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062610.txt'
  594. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062611.txt'
  595. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062612.txt'
  596. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062613.txt'
  597. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062614.txt'
  598. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062615.txt'
  599. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062616.txt'
  600. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062617.txt'
  601. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062618.txt'
  602. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062619.txt'
  603. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062620.txt'
  604. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062621.txt'
  605. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062622.txt'
  606. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062623.txt'
  607. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062700.txt'
  608. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062701.txt'
  609. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062702.txt'
  610. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062703.txt'
  611. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062704.txt'
  612. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062705.txt'
  613. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062706.txt'
  614. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062707.txt'
  615. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062708.txt'
  616. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062709.txt'
  617. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062710.txt'
  618. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062711.txt'
  619. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062712.txt'
  620. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062713.txt'
  621. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062714.txt'
  622. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062715.txt'
  623. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062716.txt'
  624. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062717.txt'
  625. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062718.txt'
  626. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062719.txt'
  627. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062720.txt'
  628. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062721.txt'
  629. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062722.txt'
  630. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062723.txt'
  631. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062800.txt'
  632. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062801.txt'
  633. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062802.txt'
  634. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062803.txt'
  635. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062804.txt'
  636. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062805.txt'
  637. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062806.txt'
  638. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062807.txt'
  639. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062808.txt'
  640. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062809.txt'
  641. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062810.txt'
  642. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062811.txt'
  643. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062812.txt'
  644. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062813.txt'
  645. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062814.txt'
  646. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062815.txt'
  647. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062816.txt'
  648. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062817.txt'
  649. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062818.txt'
  650. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062819.txt'
  651. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062820.txt'
  652. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062821.txt'
  653. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062822.txt'
  654. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062823.txt'
  655. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062900.txt'
  656. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062901.txt'
  657. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062902.txt'
  658. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062903.txt'
  659. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062904.txt'
  660. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062905.txt'
  661. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062906.txt'
  662. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062907.txt'
  663. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062908.txt'
  664. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062909.txt'
  665. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062910.txt'
  666. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062911.txt'
  667. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062912.txt'
  668. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062913.txt'
  669. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062914.txt'
  670. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062915.txt'
  671. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062916.txt'
  672. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062917.txt'
  673. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062918.txt'
  674. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062919.txt'
  675. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062920.txt'
  676. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062921.txt'
  677. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062922.txt'
  678. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015062923.txt'
  679. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063000.txt'
  680. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063001.txt'
  681. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063002.txt'
  682. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063003.txt'
  683. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063004.txt'
  684. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063005.txt'
  685. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063006.txt'
  686. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063007.txt'
  687. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063008.txt'
  688. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063009.txt'
  689. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063010.txt'
  690. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063011.txt'
  691. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063012.txt'
  692. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063013.txt'
  693. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063014.txt'
  694. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063015.txt'
  695. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063016.txt'
  696. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063017.txt'
  697. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063018.txt'
  698. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063019.txt'
  699. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063020.txt'
  700. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063021.txt'
  701. infile 'E:\gpsdata\201506\weixingdingwei2\weixingdingwei2015063022.txt'
  702. append into table T_GPSDATA_WEIXINGDINGWEI
  703. fields terminated by ','
  704. OPTIONALLY ENCLOSED BY '"'
  705. ( terminated filler,
  706.   bus_id "nullif(:bus_id,'')",
  707.   line_id "nullif(:line_id,'')",
  708.   child_line_id "nullif(:child_line_id ,'')",
  709.   orgz_id,
  710.   lct_status,
  711.   lng,
  712.   lat,
  713.   lct_altitude,
  714.   lct_time "to_date(nullif(:lct_time,'null'),'''yyyy-mm-dd hh24:mi:ss''')",
  715.   lct_speed,
  716.   lct_direction,
  717.   edr_speed,
  718.   edr_miles
  719. )



第四步:在处理好的文件夹下,输入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的内容,只需修改路径,文件转换前后的格式,文件类型即可

点击(此处)折叠或打开

  1. package test;

  2. import java.io.File;
  3. import java.io.FileFilter;
  4. import java.io.FileInputStream;
  5. import java.io.FileOutputStream;
  6. import java.io.IOException;
  7. import java.io.InputStreamReader;
  8. import java.io.OutputStreamWriter;
  9. import java.util.ArrayList;
  10. import java.util.List;

  11. /**
  12.  * 批量转换文件编码
  13.  *
  14.  * @date 2014-10-23
  15.  *
  16.  * @author xsoftlab.net
  17.  */
  18. public class BatchConvertFileEncode {
  19.     /**
  20.      * 获取文件或文件夹 不存在则创建
  21.      *
  22.      * @param path
  23.      * 文件或文件夹路径
  24.      * @return 已有/新创建的文件
  25.      * @throws IOException
  26.      * 可能产生的异常
  27.      */
  28.     public static File getFile(String path) throws IOException {
  29.         File file = new File(path);
  30.         if (file.isDirectory()) {
  31.             if (!file.exists())
  32.                 file.mkdirs();
  33.         } else {
  34.             // 判断目标文件所在的目录是否存在
  35.             if (!file.getParentFile().exists())
  36.                 file.getParentFile().mkdirs();
  37.             if (!file.exists())
  38.                 file.createNewFile();
  39.         }
  40.         return file;
  41.     }

  42.     /**
  43.      * 递归查找指定后缀名的文件
  44.      *
  45.      * @param folder
  46.      * 目标文件夹
  47.      * @param suffix
  48.      * 目标后缀名
  49.      * @return 找到的文件集合
  50.      */
  51.     public static List<File> searchFile(File folder, final String suffix) {
  52.         List<File> result = new ArrayList<File>();
  53.         File[] subFolders = folder.listFiles(new FileFilter() {// 运用内部匿名类获得文件
  54.                     @Override
  55.                     public boolean accept(File pathname) {// 实现FileFilter类的accept方法
  56.                         if (pathname.isDirectory()
  57.                                 || (pathname.isFile() && pathname.getName()
  58.                                         .toLowerCase()
  59.                                         .endsWith(suffix.toLowerCase())))// 根据文件后缀名过滤
  60.                             return true;
  61.                         return false;
  62.                     }
  63.                 });
  64.         if (subFolders != null) {
  65.             for (File file : subFolders) {
  66.                 if (file.isFile()) {
  67.                     // 如果是文件则将文件添加到结果列表中
  68.                     result.add(file);
  69.                 } else {
  70.                     // 如果是文件夹,则递归调用本方法,然后把所有的文件加到结果列表中
  71.                     result.addAll(searchFile(file, suffix));
  72.                 }
  73.             }
  74.         }
  75.         return result;
  76.     }

  77.     /**
  78.      * 单个文件转换编码
  79.      *
  80.      * @param file
  81.      * 要转换的文件
  82.      * @param tarFile
  83.      * 转换后的文件
  84.      * @param charset
  85.      * 转换前的编码
  86.      * @param tarCharset
  87.      * 转换后的编码
  88.      * @throws IOException
  89.      * 可能出现的异常
  90.      */
  91.     public static void convertFileEncode(File file, File tarFile,
  92.             String charset, String tarCharset) throws IOException {
  93.         InputStreamReader reader = null;
  94.         OutputStreamWriter writer = null;
  95.         int length;
  96.         char[] b = new char[3 * 1024];
  97.         try {
  98.             // 打开文件输出流
  99.             reader = new InputStreamReader(new FileInputStream(file), charset);
  100.             writer = new OutputStreamWriter(new FileOutputStream(tarFile),
  101.                     tarCharset);
  102.             while ((length = reader.read(b)) != -1) {
  103.                 writer.write(b, 0, length);
  104.                 writer.flush();
  105.             }
  106.         } finally {
  107.             // 关闭文件流
  108.             if (reader != null)
  109.                 reader.close();
  110.             if (writer != null)
  111.                 writer.close();
  112.         }
  113.     }

  114.     /**
  115.      * 根据文件夹批量转换编码
  116.      *
  117.      * @param folder
  118.      * 要转换的文件夹
  119.      * @param tarFolder
  120.      * 输出文件夹
  121.      * @param charset
  122.      * 转换前的编码
  123.      * @param tarCharset
  124.      * 转换后的编码
  125.      * @param suffix
  126.      * 要转换的文件后缀名
  127.      * @throws IOException
  128.      * 可能出现的异常
  129.      */
  130.     public static void convertFileEncodeByFolder(String folder,
  131.             String tarFolder, String charset, String tarCharset, String suffix)
  132.             throws IOException {
  133.         String relTar = null;
  134.         List<File> result = searchFile(new File(folder), suffix);// 调用方法获得文件数组
  135.         System.out.println("找到 " + result.size() + " 个需要转换的文件");
  136.         // 文件尾部处理
  137.         if (!folder.endsWith("/") && !folder.endsWith("\\"))
  138.             folder += File.separator;
  139.         if (!tarFolder.endsWith("/") && !tarFolder.endsWith("\\"))
  140.             tarFolder += File.separator;
  141.         for (File file : result) {
  142.             // 使目标文件夹目录层次与源文件夹对应
  143.             relTar = tarFolder
  144.                     + file.getAbsolutePath().replace(folder.replace("/", "\\"),
  145.                             "");
  146.             convertFileEncode(file, getFile(relTar), charset, tarCharset);
  147.         }
  148.         System.out.println("转换成功!");
  149.     }

  150.     public static void main(String[] args) {
  151.         try {
  152.             convertFileEncodeByFolder("E:\\gpsdata\\201506\\weixingdingwei",
  153.                     "E:\\gpsdata\\201506\\weixingdingwei2", "UTF-16LE",
  154.                     "UTF-8", "txt");
  155.         } catch (IOException e) {
  156.             e.printStackTrace();
  157.         }
  158.     }
  159. }

zip3.java,其中zipPath是文件夹目录ctlfile是控制文件名称,oldstr,newstr意思是需要将文件名称内容为oldstr替换为newstr,
里面有些函数,比如重命名文件,比如自动创建控制文件(主要是为了不手动输入每个文件的位置名称)等,根据需要运行,注释不需要的功能即可


点击(此处)折叠或打开

  1. package test;

  2. import java.io.BufferedInputStream;
  3. import java.io.BufferedOutputStream;
  4. import java.io.BufferedWriter;
  5. import java.io.File;
  6. import java.io.FileInputStream;
  7. import java.io.FileNotFoundException;
  8. import java.io.FileOutputStream;
  9. import java.io.FileWriter;
  10. import java.io.FilenameFilter;
  11. import java.io.IOException;
  12. import java.util.ArrayList;
  13. import java.util.zip.ZipEntry;
  14. import java.util.zip.ZipInputStream;

  15. public class zip3 {

  16.     public static void main(String[] args) throws IOException {
  17. //     File dir = new File("F:\\ICDATA\\ic卡数据txt版\\201511\\20151108");
  18. //     String strcmd = "cmd /c start F:\\ICDATA\\ic卡数据txt版\\201511\\20151108\\000.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
  19. //     run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
  20.         
  21.         String zipPath="E:\\gpsdata\\201506\\weixingdingwei";
  22.         String ctlfile = "000input.ctl";
  23.         String oldstr = "卫星定位信息";
  24.         String newstr = "weixingdingwei";
  25.         ArrayList<String> filelist=getFiles(new ArrayList<String>(),zipPath);
  26.         
  27.         for(String str:filelist){
  28.             System.out.println(str);
  29.             
  30.             /*批量重命名文件*/
  31.             renameFile(str,oldstr,newstr);
  32.             
  33.             /*自动创建控制文件*/
  34. //         createCtlFile(ctlfile,str);
  35.             
  36.             /*自动拷贝bat文件*/
  37. //         copyFile("F:\\ICDATA\\icdatatxt\\000自动导入.bat",str+"\\000自动导入.bat");
  38.             
  39.             /*自动执行bat文件*/
  40. //         File dir = new File(str);
  41. //         String strcmd = "cmd /c start "+str+"\\000.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
  42. //     run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
  43. //     try {
  44. //                Thread.sleep(60000);
  45. //            } catch (InterruptedException e1) {
  46. //                e1.printStackTrace();
  47. //            }
  48.             
  49.             /*自动执行数据导入*/
  50. //         File dir = new File(str);
  51. //         String strcmd = "cmd /c start "+str+"\\000自动导入.bat"; //调用我们在项目目录下准备好的bat文件,如果不是在项目目录下,则把“你的文件名.bat”改成文件所在路径。
  52. //     run_cmd(strcmd,dir); //调用上面的run_cmd方法执行操作
  53. //     try {
  54. //                Thread.sleep(60000);
  55. //                break;
  56. //            } catch (InterruptedException e1) {
  57. //                e1.printStackTrace();
  58. //            }         
  59.             
  60.             /*自动删除000.txt文件*/
  61. //     File f = new File(str+"\\000.txt"); // 输入要删除的文件位置
  62. //     if(f.exists())
  63. //      f.delete();
  64. //     else
  65. //         System.out.println("未找到文件");
  66.                  
  67.         }
  68.         
  69.         
  70.     }
  71.     

  72.     static void renameFile(String path,String oldstr,String newstr)
  73.     {
  74.         File filename = new File(path);
  75.         File[] filelist = filename.listFiles();
  76.         for(File file:filelist){
  77.             String oldname = file.getName();
  78.             //System.out.println(oldname);
  79.             if (oldname.indexOf(".txt")!=-1) {
  80.                 if (oldname.indexOf(oldstr)!=-1) {
  81.                     String newname = oldname.replace(oldstr, newstr);
  82.                     System.out.println(newname);
  83.                     file.renameTo(new File(path+'\\'+newname));
  84.                 }
  85.             } else {
  86.                 System.out.println("不是txt类型文件");
  87.             }
  88.         }
  89.     }

  90.     /*创建一个指内容的ctl文件*/
  91.     static void createCtlFile(String ctlfile,String filePath) throws IOException{
  92.         String data1 = "load data\r\n";
  93.         String data2 = "characterset AL32UTF8\r\n";
  94.         String data3 = "infile '";
  95.         String data4 = "\\";
  96.         String data5 = "'";
  97.         String data6 = "\r\n";
  98.         String datamonth = "append into table T_GPSDATA_INSTATION\r\n";
  99.         String datatable = "fields terminated by ','\r\n" +
  100. "( terminated filler,\r\n" +
  101. " bus_id,\r\n" +
  102. " line_id,\r\n" +
  103. " child_line_id,\r\n" +
  104. " orgz_id,\r\n" +
  105. " lct_status,\r\n" +
  106. " lng,\r\n" +
  107. " lat,\r\n" +
  108. " lct_altitude,\r\n" +
  109. " lct_time " + "\""+"to_date(:lct_time,'''yyyy-mm-dd hh24:mi:ss''')"+"\",\r\n" +
  110. " lct_speed,\r\n" +
  111. " lct_direction,\r\n" +
  112. " edr_speed,\r\n" +
  113. " edr_miles,\r\n" +
  114. " time_in " + "\""+"to_date(:time_in,'''yyyy-mm-dd hh24:mi:ss''')"+"\",\r\n" +
  115. " next_stop_id\r\n" +
  116. ")";
  117.         String filenameTemp = filePath+"\\"+ctlfile;//文件路径+文件名称
  118.         System.out.println(filenameTemp);
  119.         File filename = new File(filePath);
  120.         File[] strarr = filename.listFiles();
  121.         File file = new File(filenameTemp);
  122.         if (!file.exists()) {
  123.             try {
  124.                 file.createNewFile();
  125.             } catch (IOException e) {
  126.                 // TODO Auto-generated catch block
  127.                 e.printStackTrace();
  128.             }
  129.         }

  130.         byte[] byteindata1 = data1.getBytes();
  131.         byte[] byteindata2 = data2.getBytes();
  132.         try {
  133.             FileOutputStream output=new FileOutputStream(filenameTemp);
  134.             try {
  135.                 output.write(byteindata1);
  136.                 output.write(byteindata2);
  137.                 byte[] byteinfilepath = filePath.getBytes();
  138.                 byte[] byteindata3 = data3.getBytes();
  139.                 byte[] byteindata4 = data4.getBytes();
  140.                 byte[] byteindata5 = data5.getBytes();
  141.                 byte[] byteindata6 = data6.getBytes();
  142.                 byte[] byteindatamonth = datamonth.getBytes();
  143.                 byte[] byteindatatable = datatable.getBytes();
  144.                 for (int i = 0; i < strarr.length; i++) {
  145.                     //System.out.println(strarr[i].getName());
  146.                  if (strarr[i].getName().equals("000input.ctl")) {
  147.                      continue;
  148.                  }
  149.                     byte[] byteinstrname = strarr[i].getName().getBytes();
  150.                     output.write(byteindata3);
  151.                     output.write(byteinfilepath);
  152.                     output.write(byteindata4);
  153.                     output.write(byteinstrname);
  154.                     output.write(byteindata5);
  155.                     output.write(byteindata6);
  156.                 }
  157.                 output.write(byteindatamonth);
  158.                 output.write(byteindatatable);
  159.                 output.flush();
  160.                 output.close();
  161.             } catch (IOException e) {
  162.                 // TODO Auto-generated catch block
  163.                 e.printStackTrace();
  164.             }
  165.         } catch (FileNotFoundException e) {
  166.             // TODO Auto-generated catch block
  167.             e.printStackTrace();
  168.         }
  169.     }

  170.     /*复制文件到指定目录下*/
  171.     static void copyFile(String path,String copyPath){
  172.         try{
  173.             //path: "f://downloads//kon.jpg"
  174.             FileInputStream input=new FileInputStream(path);//可替换为任何路径何和文件名
  175.             //copyPath: "f://kon.jpg"
  176.             FileOutputStream output=new FileOutputStream(copyPath);//可替换为任何路径何和文件名
  177.             int in=input.read();
  178.             while(in!=-1){
  179.             output.write(in);
  180.             in=input.read();
  181.             }
  182.             }catch (IOException e){
  183.             System.out.println(e.toString());
  184.             }
  185.     }
  186.     /*
  187.      * 通过递归得到某一路径下所有的目录及其文件
  188.      */
  189.     static ArrayList<String> getFiles(ArrayList<String> filelist,String filePath){
  190.      File root = new File(filePath);
  191.      File[] files = root.listFiles();
  192.      for(File file:files){
  193.      if(file.isDirectory()){
  194.      getFiles(filelist,file.getAbsolutePath());
  195.     
  196.          }else{
  197.              int a=0;
  198.              String fileParentPath=file.getParent();
  199.      for(String str:filelist){
  200.           if(str.endsWith(fileParentPath)){
  201.               a=1;
  202.           }
  203.      }
  204.      if(a==0){
  205.              filelist.add(file.getParent());
  206.          //System.out.println("显示:"+fileParentPath);
  207.      }
  208.      }
  209.      }
  210.      return filelist;
  211.     }
  212.     /*
  213.      * 添加问价后缀
  214.      */
  215.     static void getFileNames(String path){
  216.         File file = new File(path);
  217.         if (file.exists()) {
  218.             File[] files = file.listFiles();
  219.             if (files.length == 0) {
  220.                 System.out.println("文件夹是空的!");
  221.                 return;
  222.             } else {
  223.                 for (File file2 : files) {
  224.                     if (file2.isDirectory()) {
  225.                         getFileNames(file2.getAbsolutePath());
  226.                     } else {
  227.                          file2.renameTo(new File(file2.getParent() + "/" + file2.getName()+".txt"));
  228.                     }
  229.                 }
  230.             }
  231.         } else {
  232.             System.out.println("文件不存在!");
  233.         }
  234.     }
  235.     /*执行bat文件*/
  236.     /*指定bat执行目录*/
  237.     static void run_cmd(String strcmd,File dir) {
  238.         //
  239.          Runtime rt = Runtime.getRuntime(); //Runtime.getRuntime()返回当前应用程序的Runtime对象
  240.          Process ps = null; //Process可以控制该子进程的执行或获取该子进程的信息。
  241.          try {
  242.          ps = rt.exec(strcmd,null,dir); //该对象的exec()方法指示Java虚拟机创建一个子进程执行指定的可执行程序,并返回与该子进程对应的Process对象实例。
  243.          ps.waitFor(); //等待子进程完成再往下执行。
  244.          } catch (IOException e1) {
  245.          e1.printStackTrace();
  246.          } catch (InterruptedException e) {
  247.          // TODO Auto-generated catch block
  248.          e.printStackTrace();
  249.          }

  250.          int i = ps.exitValue(); //接收执行完毕的返回值
  251.          if (i == 0) {
  252.          System.out.println("执行完成.");
  253.          } else {
  254.          System.out.println("执行失败.");
  255.          }

  256.          ps.destroy(); //销毁子进程
  257.          ps = null;
  258.     }
  259.       /*不指定执行目录*/
  260. // static void run_cmd(String strcmd) {
  261. //     //
  262. //      Runtime rt = Runtime.getRuntime(); //Runtime.getRuntime()返回当前应用程序的Runtime对象
  263. //      Process ps = null; //Process可以控制该子进程的执行或获取该子进程的信息。
  264. //      try {
  265. //      ps = rt.exec(strcmd); //该对象的exec()方法指示Java虚拟机创建一个子进程执行指定的可执行程序,并返回与该子进程对应的Process对象实例。
  266. //      ps.waitFor(); //等待子进程完成再往下执行。
  267. //      } catch (IOException e1) {
  268. //      e1.printStackTrace();
  269. //      } catch (InterruptedException e) {
  270. //      // TODO Auto-generated catch block
  271. //      e.printStackTrace();
  272. //      }
  273. //
  274. //      int i = ps.exitValue(); //接收执行完毕的返回值
  275. //      if (i == 0) {
  276. //      System.out.println("执行完成.");
  277. //      } else {
  278. //      System.out.println("执行失败.");
  279. //      }
  280. //
  281. //      ps.destroy(); //销毁子进程
  282. //      ps = null;
  283. // }
  284.     /**/
  285. }




来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29399342/viewspace-2138676/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/29399342/viewspace-2138676/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值