DBIMPORT-3.1 สำหรับ HCIS [2007-10-18]
ระบบฐานข้อมูลสาธารณสุขระดับจังหวัด (PROVIS)
Data Import Started.
Searching for ZIP files......
Please wait while DBIMPORT importing data......
Importing data into table women .....
Importing data into table nutri .....
Importing data into table drug .....
Importing data into table card .....
Importing data into table epi .....
Importing data into table diag .....
Importing data into table pp .....
Importing data into table person .....
Importing data into table appoint .....
Importing data into table death .....
Importing data into table proced .....
Importing data into table anc .....
Importing data into table fp .....
Importing data into table surveil .....
Importing data into table mch .....
Importing data into table chronic .....
Importing data into table home .....
Importing data into table service .....
Data Import Finished.
------------------------------------------------------------------------
You have new mail in /var/spool/mail/root
[root@hosxp script]#
----------------------------------------------------------------------------------------------------------------------
Data Import of E_PCU_200711110608_20071115_20071115.zip
Start Time: 15/11/2007 21:16:27
Finish Time: 15/11/2007 21:17:01
Data Set : women
=========================================
Insert : 122 record(s)
Update : 1 record(s)
ERROR : 253 record(s)
Error: 1062 - Duplicate entry '11278-371020' for key 1
Error: 1062 - Duplicate entry '11278-171020' for key 1
Error: 1062 - Duplicate entry '11278-171990' for key 1
Error: 1062 - Duplicate entry '11278-571029' for key 1
Error: 1062 - Duplicate entry '11278-171990' for key 1
Error: 1062 - Duplicate entry '11278-371020' for key 1
Error: 1062 - Duplicate entry '11278-371020' for key 1
Error: 1062 - Duplicate entry '11278-371020' for key 1
Error: 1062 - Duplicate entry '11278-571029' for key 1
Error: 1062 - Duplicate entry '11278-671025' for key 1
Error: 1062 - Duplicate entry '11278-371020' for key 1
......
There are so many errors in this text file.
Data Set : nutri
=========================================
Insert : 151 record(s)
Update : 1 record(s)
ERROR : 307 record(s)
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171990-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
Error: 1062 - Duplicate entry '11278-171930-20071101' for key 1
......
There are so many errors in this text file.
Data Set : drug
=========================================
Insert : 1,819 record(s)
Update : 42 record(s)
ERROR : 5,906 record(s)
Error: 1062 - Duplicate entry '11278-000000-1-' for key 1
Error: 1062 - Duplicate entry '11278-310220-2-' for key 1
Error: 1062 - Duplicate entry '11278-310220-2-' for key 1
Error: 1062 - Duplicate entry '11278-310220-2-' for key 1
Error: 1062 - Duplicate entry '11278-310220-2-' for key 1
Error: 1062 - Duplicate entry '11278-310220-2-' for key 1
Error: 1062 - Duplicate entry '11278-371060-3-' for key 1
Error: 1062 - Duplicate entry '11278-371060-3-' for key 1
Error: 1062 - Duplicate entry '11278-371060-3-' for key 1
Error: 1062 - Duplicate entry '11278-371060-3-' for key 1
Error: 1062 - Duplicate entry '11278-371060-3-' for key 1
......
There are so many errors in this text file.
Data Set : card
=========================================
Insert : 1,952 record(s)
Update : 0 record(s)
ERROR : 1,328 record(s)
Error: 1062 - Duplicate entry '11278-001167' for key 1
Error: 1062 - Duplicate entry '11278-006517' for key 1
Error: 1062 - Duplicate entry '11278-000080' for key 1
Error: 1062 - Duplicate entry '11278-001270' for key 1
Error: 1062 - Duplicate entry '11278-000085' for key 1
Error: 1062 - Duplicate entry '11278-001437' for key 1
Error: 1062 - Duplicate entry '11278-006517' for key 1
Error: 1062 - Duplicate entry '11278-006514' for key 1
Error: 1062 - Duplicate entry '11278-006514' for key 1
Error: 1062 - Duplicate entry '11278-000402' for key 1
Error: 1062 - Duplicate entry '11278-000759' for key 1
......
There are so many errors in this text file.
Data Set : epi
=========================================
Insert : 80 record(s)
Update : 0 record(s)
ERROR : 2 record(s)
Error: 1062 - Duplicate entry '11278-171930-159-HBV' for key 1
Error: 1062 - Duplicate entry '11278-171930-156-HBV' for key 1
Data Set : diag
=========================================
Insert : 3,576 record(s)
Update : 0 record(s)
ERROR : 145 record(s)
Error: 1062 - Duplicate entry '11278-311010-25-Z480' for key 1
Error: 1062 - Duplicate entry '11278-371020-26-Z480' for key 1
Error: 1062 - Duplicate entry '11278-371020-43-J029' for key 1
Error: 1062 - Duplicate entry '11278-371020-21-I10' for key 1
Error: 1062 - Duplicate entry '11278-371020-54-I10' for key 1
Error: 1062 - Duplicate entry '11278-171930-135-J00' for key 1
Error: 1062 - Duplicate entry '11278-371020-177-I10' for key 1
Error: 1062 - Duplicate entry '11278-371020-187-Z480' for key 1
Error: 1062 - Duplicate entry '11278-371020-82-Z480' for key 1
Error: 1062 - Duplicate entry '11278-371020-142-Z000' for key 1
Error: 1062 - Duplicate entry '11278-371020-137-I10' for key 1
......
There are so many errors in this text file.
Data Set : pp
=========================================
Insert : 5 record(s)
Update : 0 record(s)
ERROR : 12 record(s)
Error: 1062 - Duplicate entry '11278-007193' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-171930' for key 1
Error: 1062 - Duplicate entry '11278-771930' for key 1
......
There are so many errors in this text file.
Data Set : person
=========================================
Insert : 1,952 record(s)
Update : 0 record(s)
ERROR : 653 record(s)
Error: 1062 - Duplicate entry '11278-000003' for key 1
Error: 1062 - Duplicate entry '11278-000003' for key 1
Error: 1062 - Duplicate entry '11278-000004' for key 1
Error: 1062 - Duplicate entry '11278-000004' for key 1
Error: 1062 - Duplicate entry '11278-000005' for key 1
Error: 1062 - Duplicate entry '11278-000010' for key 1
Error: 1062 - Duplicate entry '11278-000011' for key 1
Error: 1062 - Duplicate entry '11278-000012' for key 1
Error: 1062 - Duplicate entry '11278-000012' for key 1
Error: 1062 - Duplicate entry '11278-000012' for key 1
Error: 1062 - Duplicate entry '11278-000014' for key 1
......
There are so many errors in this text file.
Data Set : appoint
=========================================
Insert : 662 record(s)
Update : 0 record(s)
ERROR : 122 record(s)
Error: 1062 - Duplicate entry '11278-371020-74-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-72-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-131-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-177-01' for key 1
Error: 1062 - Duplicate entry '11278-000000-186-01' for key 1
Error: 1062 - Duplicate entry '11278-360020-6-01' for key 1
Error: 1062 - Duplicate entry '11278-360020-6-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-160-01' for key 1
Error: 1062 - Duplicate entry '11278-571029-169-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-197-01' for key 1
Error: 1062 - Duplicate entry '11278-371020-196-01' for key 1
......
There are so many errors in this text file.
Data Set : death
=========================================
Insert : 1 record(s)
Update : 0 record(s)
ERROR : 0 record(s)
Data Set : proced
=========================================
Insert : 650 record(s)
Update : 0 record(s)
ERROR : 340 record(s)
Error: 1062 - Duplicate entry '11278-371020-32-' for key 1
Error: 1062 - Duplicate entry '11278-571029-111-' for key 1
Error: 1062 - Duplicate entry '11278-571029-111-' for key 1
Error: 1062 - Duplicate entry '11278-171930-122-' for key 1
Error: 1062 - Duplicate entry '11278-371020-131-' for key 1
Error: 1062 - Duplicate entry '11278-371020-131-' for key 1
Error: 1062 - Duplicate entry '11278-371020-131-' for key 1
Error: 1062 - Duplicate entry '11278-371060-120-' for key 1
Error: 1062 - Duplicate entry '11278-371060-120-' for key 1
Error: 1062 - Duplicate entry '11278-366010-162-' for key 1
Error: 1062 - Duplicate entry '11278-366010-162-' for key 1
......
There are so many errors in this text file.
Data Set : anc
=========================================
Insert : 101 record(s)
Update : 2 record(s)
ERROR : 54 record(s)
Error: 1062 - Duplicate entry '11278-000000-20071101' for key 1
Error: 1062 - Duplicate entry '11278-371010-20071102' for key 1
Error: 1062 - Duplicate entry '11278-371050-20071102' for key 1
Error: 1062 - Duplicate entry '11278-371020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-371020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-171020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-371020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-172010-20071102' for key 1
Error: 1062 - Duplicate entry '11278-171020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-171020-20071102' for key 1
Error: 1062 - Duplicate entry '11278-371050-20071105' for key 1
......
There are so many errors in this text file.
Data Set : fp
=========================================
Insert : 18 record(s)
Update : 0 record(s)
ERROR : 0 record(s)
Data Set : surveil
=========================================
Insert : 15 record(s)
Update : 0 record(s)
ERROR : 0 record(s)
Data Set : mch
=========================================
Insert : 24 record(s)
Update : 0 record(s)
ERROR : 1 record(s)
Error: 1062 - Duplicate entry '11278-000000-2' for key 1
Data Set : chronic
=========================================
Insert : 269 record(s)
Update : 0 record(s)
ERROR : 19 record(s)
Error: 1062 - Duplicate entry '11278-000005-002' for key 1
Error: 1062 - Duplicate entry '11278-000012-001' for key 1
Error: 1062 - Duplicate entry '11278-000012-001' for key 1
Error: 1062 - Duplicate entry '11278-000022-001' for key 1
Error: 1062 - Duplicate entry '11278-000057-001' for key 1
Error: 1062 - Duplicate entry '11278-000057-002' for key 1
Error: 1062 - Duplicate entry '11278-000101-002' for key 1
Error: 1062 - Duplicate entry '11278-000105-002' for key 1
Error: 1062 - Duplicate entry '11278-000108-001' for key 1
Error: 1062 - Duplicate entry '11278-000131-002' for key 1
Error: 1062 - Duplicate entry '11278-000141-001' for key 1
......
There are so many errors in this text file.
Data Set : home
=========================================
Insert : 2 record(s)
Update : 0 record(s)
ERROR : 0 record(s)
Data Set : service
=========================================
Insert : 2,477 record(s)
Update : 2 record(s)
ERROR : 801 record(s)
Error: 1062 - Duplicate entry '11278-371020-4' for key 1
Error: 1062 - Duplicate entry '11278-371020-8' for key 1
Error: 1062 - Duplicate entry '11278-371020-16' for key 1
Error: 1062 - Duplicate entry '11278-371020-31' for key 1
Error: 1062 - Duplicate entry '11278-371020-38' for key 1
Error: 1062 - Duplicate entry '11278-171990-45' for key 1
Error: 1062 - Duplicate entry '11278-000000-44' for key 1
Error: 1062 - Duplicate entry '11278-371020-72' for key 1
Error: 1062 - Duplicate entry '11278-371020-74' for key 1
Error: 1062 - Duplicate entry '11278-171930-79' for key 1
Error: 1062 - Duplicate entry '11278-371010-87' for key 1
......
There are so many errors in this text file.
หัวข้อ: DBIMPORT-3.1 สำหรับ HCIS [2007-10-18] VS hosxp 18 แฟ้ม (อ่าน 3672 ครั้ง)