CN108280223A - DBF data for College Enrollment import platform and introduction method - Google Patents
DBF data for College Enrollment import platform and introduction method Download PDFInfo
- Publication number
- CN108280223A CN108280223A CN201810136193.1A CN201810136193A CN108280223A CN 108280223 A CN108280223 A CN 108280223A CN 201810136193 A CN201810136193 A CN 201810136193A CN 108280223 A CN108280223 A CN 108280223A
- Authority
- CN
- China
- Prior art keywords
- dbf
- data
- field
- files
- import
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Processing platform is imported the invention discloses a kind of DBF data for College Enrollment and processing method, the platform include：DBF compressed package uploading modules, for uploading admission information DBF compressed packages to school's Enrollment System；Data match module is matched for will import the data field in the DBF files of basis with the data name in basic code table, and update imports the correspondence of data after successful match；Information import modul, for importing admission information DBF data in school's Enrollment System.The present invention is synchronized imports entirety DBF files using compressed package, reduce the process converted using third party's tool, using page flow in matching system basic data, reduce the workload changed by hand in excel, and may be reused, increase working efficiency and user experience, import information is handled by ActiveMQ, improves treatment effeciency.
Description
Technical field
The present invention relates to data leading-in technique fields, and in particular to a kind of DBF data for College Enrollment import platform
And introduction method.
Background technology
It needs the admission information DBF files that Bureau of Education provides importeding into system enrollment in current school's Enrollment System
In, for the admission information file of Education Commission of province, DBF conversion excel tools are provided, the code table correspondence of each school needs
It is corresponding with system that excel is manually adjusted manually, in excel format import systems after corresponding to.
In addition DBF files are converted into excel using crossover tool, manual modification correspondence is needed to make in DBF files
Corresponding code table it is corresponding with the code table in system, heavy workload, time-consuming, and correspondence cannot be multiplexed, again import when need
Re-start correspondence.
Invention content
The purpose of the present invention is to provide a kind of DBF data for College Enrollment to import platform and introduction method, solves
DBF files are converted into excel using crossover tool, need manual modification correspondence make the corresponding code table in DBF files with
Code table in system corresponds to, and heavy workload, time-consuming, and correspondence cannot be multiplexed, and needs to re-start correspondence when importing again
The problem of.
In order to solve the above technical problems, the present invention uses following technical scheme：
A kind of DBF data for College Enrollment import processing platform, and the platform includes：
DBF compressed package uploading modules for uploading admission information DBF compressed packages to school's Enrollment System, and verify admission
Whether information DBF compressed packages format matches with school Enrollment System, when admission information DBF compressed packages are matched with school Enrollment System
When, whether verification basis DBF files are complete, while verifying whether the basic data field in basic DBF files belongs to necessary
By DBF compressed packages include in DBF to be uploaded compresses the package list after the completion of verification with field；
Data match module, for the data field in the DBF files of basis and the data name in basic code table will to be imported
It is matched, and update imports the correspondence of data after successful match；
Information import modul, for importing admission information DBF data in school's Enrollment System.
Preferably, the basis DBF files include level DBF, study form DBF, the corresponding DBF of profession, student information
DBF；The basic data field includes the study form field in study form DBF, the level field in level DBF, profession
Specialty field in corresponding DBF；The basis code table is the database for preserving study form title, hierarchy name and major name
Table.
A kind of DBF data for College Enrollment import processing method, include the following steps：
S1：DBF compressed package uploading modules upload admission information DBF compressed packages to school's Enrollment System, and verify admission letter
Whether breath DBF compressed packages format matches with school Enrollment System, when admission information DBF compressed packages are matched with school Enrollment System
When, whether verification basis DBF files are complete, while verifying whether the basic data field in basic DBF files belongs to necessary
By DBF compressed packages include in DBF to be uploaded compresses the package list after the completion of verification with field；
S2：Data match module will import basis DBF files in data field with basis code table in data name into
Row matching, and update imports the correspondence of data after successful match；
S3：Information import modul imports admission information DBF data in school's Enrollment System.
Preferably, in the above method, the basis DBF files include level DBF, study form DBF, profession correspondence
DBF, student information DBF；The basis DBF files include level DBF, study form DBF, the corresponding DBF of profession, student information
DBF；The basic data field includes the study form field in study form DBF, the level field in level DBF, profession
Specialty field in corresponding DBF.
Preferably, in the above method, the verification admission information DBF compressed packages format in the S1 steps is recruited student with school
The whether matched specific method of system is：DBF compressed package files name is matched with the province in school Enrollment System, is matched
DBF compressed packages are uploaded to temporary file server after success and are decompressed, it is whether complete that basis DBF files are verified after decompression.
Preferably, whether the basic data field verified in the above method, in the S1 steps in the DBF files of basis belongs to
In must the specific method of matching field be：After basic DBF file verifications are complete, DBF files are reflected using javadbf packets
It penetrates in pairs as and according to province title is saved in database,
Then study form of the study form field in the corresponding DBF files of profession in study form DBF files is verified
Field whether there is, and there is then study form field is necessary matching field；
Level field of the level field in the corresponding DBF files of profession in verification level DBF files whether there is, and exist
Then level field is necessary matching field；
Specialty field of the specialty field in student information DBF in the corresponding DBF files of verification profession whether there is, and exist
Then specialty field is necessary matching field.
Preferably, in the above method, data match module will import the data in the DBF files of basis in the S2 steps
Field carries out matched specific method with the data name in basic code table：
According to the study form title in the study form DBF of importing and the study form title progress in basic code table
Match, the correspondence of update importing study form after successful match；
It is matched with the hierarchy name in basic code table according to the hierarchy name in the level DBF of importing, successful match
Update imports the correspondence of level afterwards；
It is matched and is led with the major name in basic code table according to the major name in the corresponding DBF of the profession of importing
Level in the corresponding DBF of profession entered is identical as the level belonging to the major name in basic code table, updates and leads after successful match
Enter the correspondence of profession.
Preferably, in the above method, preservation whether again matching status is also needed to before the S2 steps；
It needs to match again if matching status is shown again, the data in the DBF files of basis will be imported by entering S2 steps
Field is matched with the data name in basic code table；
If matching status, which is shown, again to match again, need verification upload DBF compressed packages whether on
Biography preserved, if the correspondence for preserving study form, level and profession, needed if not preserving enter S2 steps into
Row matches again.
Preferably, importing the data field in the DBF files of basis and basic code table in the above method, in the S2 steps
In data name carry out show that study form relation list, hierarchical relationship list and professional relationship arrange after matching is completed respectively
Table, and set study form relation list, hierarchical relationship list and professional relationship list to manual editing's state.
Preferably, in the above method, the information import modul in the S3 steps, which imports admission information DBF data, to be learned
Specific method in the Enrollment System of school is：Admission information into school's Enrollment System imports, and the grade imported is selected to carry out
Admission information imports, and sends a message to ActiveMQ and carry out asynchronous process；
The flow of the asynchronous process is：
S31：The grade that selection imports is verified whether, such as without selection grade's message notifying " grade please be select "；
S32：Preservation whether again matching status is verified whether, such as without preserving message notifying " action type is indefinite "；
S33：The dbf compressed packages imported are verified, message notifying " correct dbf file please be import " is such as not present；
S34：Verification imports data integrity, the date of birth of the student of every importing of verification, gender, nationality, student's class
Type, type of credential, certificate number, province, city/district, examinee number, admission level, admission profession, admission study form, student come
Source, political affiliation, post whether there is and in system matches, preserve error message；
S35：The student data being verified is imported into tables of data；
S36：Preserve this matched correspondence；
S37：Import information Excel tables are generated, exists in table and imports successfully and import failure student's record, according to
The failure cause prompted in detail in S34 steps, in the message heart download.
Compared with prior art, the beneficial effects of the invention are as follows：
The present invention is synchronized imports entirety DBF files using compressed package, reduces the process converted using third party's tool, makes
With page flow in matching system basic data, reduce the workload changed by hand in excel, and may be reused, increases
Working efficiency and user experience are added, import information are handled by ActiveMQ, improves treatment effeciency.
Description of the drawings
Fig. 1 is that the compressed package of the present invention uploads the flow chart of flow.
Fig. 2 is the again matched flow chart of the present invention.
Fig. 3 is the Data Matching flow chart of the present invention.
Fig. 4 is the flow chart that the information of the present invention imports.
Specific implementation mode
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
One embodiment of the importing processing platform of the present invention is that the platform includes：DBF compressed package uploading modules are used
In upload admission information DBF compressed packages to school's Enrollment System, and verify admission information DBF compressed packages format and enrollment system of school
Whether system matches, and when admission information DBF compressed packages and school Enrollment System match, whether complete, together if verifying basis DBF files
When verification basis DBF files in basic data field whether belong to necessary matching field, DBF compressed packages are shown after the completion of verification
Show in DBF to be uploaded compresses the package list；
Data match module, for the data field in the DBF files of basis and the data name in basic code table will to be imported
It is matched, and update imports the correspondence of data after successful match；
Information import modul, for importing admission information DBF data in school's Enrollment System.
Further, for another embodiment of above-mentioned platform, the basis DBF files include level DBF, study shape
The corresponding DBF of formula DBF, profession, student information DBF；The basic data field includes the study form word in study form DBF
Section, the level field in level DBF, profession corresponds to the specialty field in DBF；The basis code table is to preserve study form name
Claim, the database table of hierarchy name and major name.
Actually basis DBF files can also include foreign language languages DBF, schooling DBF and nationality DBF and other
With the relevant attribute DBF files of student's essential information, the method that when matching uses is almost the same.
Referring to the flow chart in Fig. 1~4, the DBF data for College Enrollment of the invention import one of processing method
In embodiment, include the following steps：
S1：DBF compressed package uploading modules upload admission information DBF compressed packages to school's Enrollment System, and verify admission letter
Whether breath DBF compressed packages format matches with school Enrollment System, when admission information DBF compressed packages are matched with school Enrollment System
When, whether verification basis DBF files are complete, while verifying whether the basic data field in basic DBF files belongs to necessary
By DBF compressed packages include in DBF to be uploaded compresses the package list after the completion of verification with field；
S2：Data match module will import basis DBF files in data field with basis code table in data name into
Row matching, and update imports the correspondence of data after successful match；
S3：Information import modul imports admission information DBF data in school's Enrollment System.
Further, for another embodiment in the above method, the basis DBF files include level DBF, study
The corresponding DBF of form DBF, profession, student information DBF；The basis DBF files include level DBF, study form DBF, profession it is right
Answer DBF, student information DBF；The basic data field includes the study form field in study form DBF, in level DBF
Level field, profession correspond to the specialty field in DBF.
Further, for another embodiment in the above method, the verification admission information DBF pressures in the S1 steps
Contracting packet format is with the school whether matched specific method of Enrollment System：It will be in DBF compressed package files name and school's Enrollment System
Province matched, DBF compressed packages are uploaded to temporary file server after successful match and are decompressed, after decompression verify basis
Whether DBF files are complete.
Further, for another embodiment in the above method, in the S1 steps in verification basis DBF files
Basic data field whether belong to must the specific method of matching field be：After basic DBF file verifications are complete, use
Javadbf packets by DBF File Mappings in pairs as and according to province title is saved in database,
Then study form of the study form field in the corresponding DBF files of profession in study form DBF files is verified
Field whether there is, and there is then study form field is necessary matching field；
Level field of the level field in the corresponding DBF files of profession in verification level DBF files whether there is, and exist
Then level field is necessary matching field；
Specialty field of the specialty field in student information DBF in the corresponding DBF files of verification profession whether there is, and exist
Then specialty field is necessary matching field.
Further, for another embodiment in the above method, data match module will import in the S2 steps
Data field in basic DBF files carries out matched specific method with the data name in basic code table is：
According to the study form title in the study form DBF of importing and the study form title progress in basic code table
Match, the correspondence of update importing study form after successful match；
It is matched with the hierarchy name in basic code table according to the hierarchy name in the level DBF of importing, successful match
Update imports the correspondence of level afterwards；
It is matched and is led with the major name in basic code table according to the major name in the corresponding DBF of the profession of importing
Level in the corresponding DBF of profession entered is identical as the level belonging to the major name in basic code table, updates and leads after successful match
Enter the correspondence of profession.
Further, for another embodiment in the above method, whether the S2 steps also need to preserve before and weigh
New matching status；
It needs to match again if matching status is shown again, the data in the DBF files of basis will be imported by entering S2 steps
Field is matched with the data name in basic code table；
If matching status, which is shown, again to match again, need verification upload DBF compressed packages whether on
Biography preserved, if the correspondence for preserving study form, level and profession, needed if not preserving enter S2 steps into
Row matches again.
Further, it for another embodiment in the above method, is imported in the DBF files of basis in the S2 steps
Data field carries out showing that study form relation list, level close after matching completion respectively with the data name in basic code table
Series of tables and professional relationship list, and set study form relation list, hierarchical relationship list and professional relationship list to hand
Dynamic editing mode.
Further, for another embodiment in the above method, the information import modul in the S3 steps will record
The specific method that breath DBF data of winning the confidence import in school Enrollment System is：Admission information into school's Enrollment System imports, and
The grade that selection imports carries out admission information importing, and sends a message to ActiveMQ and carry out asynchronous process；
The flow of the asynchronous process is：
S31：The grade that selection imports is verified whether, such as without selection grade's message notifying " grade please be select "；
S32：Preservation whether again matching status is verified whether, such as without preserving message notifying " action type is indefinite "；
S33：The dbf compressed packages imported are verified, message notifying " correct dbf file please be import " is such as not present；
S34：Verification imports data integrity, the date of birth of the student of every importing of verification, gender, nationality, student's class
Type, type of credential, certificate number, province, city/district, examinee number, admission level, admission profession, admission study form, student come
Source, political affiliation, post whether there is and in system matches, preserve error message；
S35：The student data being verified is imported into tables of data；
S36：Preserve this matched correspondence；
S37：Import information Excel tables are generated, exists in table and imports successfully and import failure student's record, according to
The failure cause prompted in detail in S34 steps, in the message heart download.
Practical application is illustrated, and as shown in figures 1-4, the flow for importing processing method is：
1, dbf compressed packages are uploaded
Backstage can verify compressed package files name and be matched with province in system in upload procedure, prompt that it fails to match
" province is not present ", current province compressed package prompt " province is existing " in DBF the package lists to be uploaded, successful match compression
Packet can upload to temporary file server and decompress, after decompression verify file in the presence or absence of TD_CCDM.DBF (level DBF),
TD_XXXSDM.DBF (study form DBF), T_JHK.DBF (the corresponding DBF of profession), T_TDD.DBF (student information DBF) file,
If any file, there is no prompts " lacking XXXX files " (XXXX represents specific file name), and javadbf is used after being verified
Dbf file is mapped to object and is saved in database according to province title, verification file TD_ after data is preserved
XXXSDM XXXSDM in file T_JHK.DBF whether there is in XXXSDM.DBF, exist, current behavior must be equipped with, and not deposit
It is necessarily matched in then current behavior.CCDM (level coding) is in file T_JHK.DBF in verification file TD_CCDM.DBF
CCDM (level coding) whether there is, and exist, and current behavior must be equipped with, and there is no then current behaviors necessarily to match.Verification
ZYDM in file T_JHK.DB (profession coding) ZYDM (profession coding) in file T_TDD.DBF whether there is, exist then when
Preceding field must be equipped with, and there is no then present fields necessarily to match.Page prompts " upper transmitting file success " pressure after the completion of verification
Contracting packet is shown in DBF the package lists to be uploaded.
Wherein the following table 1 is TD_CCDM.DBF (level DBF), table 2 is TD_XXXSDM.DBF (study form DBF), table 3 is
T_JHK.DBF (the corresponding DBF of profession), table 4 are T_TDD.DBF (student information DBF), table 5 is profession basis code table, table 6 is
Habit form basis code table, table 7 are level basis code table.
Table 1
Table 2
Table 3
Table 4
Table 5
Table 6
Table 7
2, it chooses whether to match again
Whether again system preserves matching status.
3, coupling learning form
It into coupling learning form, first determines whether the whether again matching status preserved, such as needs to match again, according to leading
XXXS (study form) in the TD_XXXSDM.DBF (study form code table) entered and the study shape in the code table of study form basis
Formula title is matched, and successful match update imports the correspondence of study form.It need not such as match, be needed in verification again
Whether original uploaded in the province of biography preserved, and preserved the direct correspondence using preservation, did not preserve and need weight
Newly carry out matching correspondence.
Study form relation list is shown after the completion of matching, manual editing can import study form and basic code in lists
Study form in table establishes correspondence.
Study form relationship can be reverted to state before manual editing by reset button.
Previous step returns to province and compresses the package list.(note：After previous step, if matching status does not change, manual editing
Data preserve, and matching status, which changes, re-starts matching.)
First verify that in study form relation list in next step whether must matching status be yes data whether with basis
There are correspondences for code table, if any there are no corresponding prompt, " study form does not match completely needed for profession, please match necessary
Occurrence ", it is all corresponding to enter matching hierarchy.
4, matching hierarchy
Into matching hierarchy, first determines whether the whether again matching status preserved, such as need to match again, according to importing
CC (hierarchy name) in TD_CCDM.DBF (level code code table) is matched with the hierarchy name in the code table of level basis,
Successful match update imports the correspondence of level.It need not such as match again, need the province that verification uploads whether original
It was preserved through uploading, preserved the direct correspondence using preservation, do not preserved and need to re-start matching correspondence.
Show levels relation list after the completion of matching manual editing can import level and the layer in basic code table in lists
It is secondary that foundation should be related to.
Hierarchical relationship can be reverted to state before manual editing by reset button.
Previous step returns to coupling learning form list.(note：After previous step, if matching status does not change, compile manually
It collects data to preserve, matching status, which changes, re-starts matching.)
First verify that in hierarchical relationship list in next step whether must matching status be yes data whether with basic code table
There are correspondence, if any there are no corresponding prompt " level does not match completely needed for profession, please match necessary occurrence ",
It is all corresponding to enter matching profession.
5, matching profession
Into matching profession, first determines whether the whether again matching status preserved, such as need to match again, according to importing
ZYMC (major name) in T_JHK.DBF (the corresponding code table of profession) is matched simultaneously with the major name in profession basis code table
And the CCDM (level number) in the T_JHK.DBF (the corresponding code table of profession) imported is identical as level belonging to profession in code table,
Professional correspondence is imported with being successfully updated.It need not such as match again, need the province that verification uploads whether original
Upload preserved, and preserved the direct correspondence using preservation, did not preserve and need to re-start matching correspondence.
Matching after the completion of show professional relationship list, can in lists manual editing import profession with basis code table in it is special
Industry should be related to foundation.
Professional relationship can be reverted to state before manual editing by reset button.
Previous step returns to matching hierarchy list.(note：After previous step, if matching status does not change, manual editing's number
According to preservation, matching status, which changes, re-starts matching.)
First verify that in professional relationship list in next step whether must matching status be yes data whether with basic code table
There are correspondence, if any there are no corresponding prompt " profession needed for student does not match completely, please match must occurrence ",
All the corresponding admission information that enters imports.
6, admission information imports
It is imported into admission information, selects the student grade to be imported, clicked admission and import, send a message to ActiveMQ
Carry out asynchronous process.
The flow of asynchronous process is：
The first step：The grade that selection imports is verified whether, such as without selection grade's message notifying " grade please be select ".
Second step：Verify whether preservation whether again matching status, such as " action type is unknown without preserving message notifying
Really ".
Third walks：The DBF compressed packages imported are verified, message notifying " correct dbf file please be import " is such as not present.
4th step：Verification imports data integrity, the date of birth of the student of every importing of verification, gender, nationality, student
Type, type of credential, certificate are good, province, city/district, examinee number, admission level, admission profession, enroll study form, student
Source, political affiliation, post whether there is and in system matches, preserve error message.
5th step：The student data being verified is imported into tables of data.
6th step：Preserve this matched correspondence.
7th step：Import information Excel tables are generated, exists in table and imports successfully and import failure student's record, root
Failure cause is prompted in detail according to step 4, and the heart is downloaded in the message.
Platform through the invention is synchronous with method to import entirety DBF files using compressed package, reduces using third party
The process of tool conversion reduces the workload changed by hand in excel using page flow in matching system basic data,
And may be reused, working efficiency and user experience are increased, import information is handled by ActiveMQ, improves processing
Efficiency.
" one embodiment ", " another embodiment ", " embodiment ", " preferred embodiment " spoken of in the present specification
Deng, refer to combine the embodiment description specific features, structure or feature be included in the application generality description at least
In one embodiment.It is not centainly to refer to the same embodiment that statement of the same race, which occur, in multiple places in the description.Further
For, when describing a specific features, structure or feature in conjunction with any embodiment, what is advocated is to combine other embodiment
To realize that this feature, structure or feature are also fallen within the scope of the present invention.
Although reference be made herein to invention has been described for multiple explanatory embodiments of the invention, however, it is to be understood that
Those skilled in the art can be designed that a lot of other modification and implementations, these modifications and implementations will be fallen in this Shen
It please be within disclosed scope and spirit.More specifically, disclose in the application, drawings and claims in the range of, can
With the building block and/or a variety of variations and modifications of layout progress to theme combination layout.In addition to building block and/or layout
Outside the modification and improvement of progress, to those skilled in the art, other purposes also will be apparent.
Claims (10)
1. a kind of DBF data for College Enrollment import processing platform, it is characterised in that：The platform includes：DBF compressed packages
Uploading module for uploading admission information DBF compressed packages to school's Enrollment System, and verifies admission information DBF compressed package formats
Whether matched with school Enrollment System, when admission information DBF compressed packages are matched with school Enrollment System, verification basis DBF is literary
Whether part is complete, while verifying whether the basic data field in basic DBF files belongs to necessary matching field, after the completion of verification
Include in DBF to be uploaded compresses the package list by DBF compressed packages；Data match module, for that will import in the DBF files of basis
Data field matched with the data name in basic code table, and update imports the corresponding of data and closes after successful match
System；
Information import modul, for importing admission information DBF data in school's Enrollment System.
2. the DBF data according to claim 1 for College Enrollment import processing platform, it is characterised in that：The base
Plinth DBF files include level DBF, study form DBF, the corresponding DBF of profession, student information DBF；The basic data field includes
Study form field in study form DBF, the level field in level DBF, the specialty field in the corresponding DBF of profession；It is described
Basic code table is to preserve study form title, the database table of hierarchy name and major name.
3. a kind of DBF data for College Enrollment import processing method, it is characterised in that：Include the following steps：
S1：DBF compressed package uploading modules upload admission information DBF compressed packages to school's Enrollment System, and verify admission information DBF
Whether compressed package format matches with school Enrollment System, when admission information DBF compressed packages are matched with school Enrollment System, verification
Whether basic DBF files are complete, while verifying whether the basic data field in basic DBF files belongs to necessary matching field,
By DBF compressed packages include in DBF to be uploaded compresses the package list after the completion of verification；
S2：Data match module will import the data field in the DBF files of basis and the data name progress in basic code table
Match, and update imports the correspondence of data after successful match；
S3：Information import modul imports admission information DBF data in school's Enrollment System.
4. the DBF data according to claim 3 for College Enrollment import processing method, it is characterised in that：The base
Plinth DBF files include level DBF, study form DBF, the corresponding DBF of profession, student information DBF；The basis DBF files include
The corresponding DBF of level DBF, study form DBF, profession, student information DBF；The basic data field includes in study form DBF
Study form field, the level field in level DBF, the specialty field in the corresponding DBF of profession.
5. the DBF data according to claim 4 for College Enrollment import processing method, it is characterised in that：The S1
Verification admission information DBF compressed packages format in step is with the school whether matched specific method of Enrollment System：DBF is compressed
APMB package name is matched with the province in school Enrollment System, and DBF compressed packages are uploaded to temporary file clothes after successful match
Business device simultaneously decompresses, and it is whether complete that basis DBF files are verified after decompression.
6. the DBF data according to claim 5 for College Enrollment import processing method, it is characterised in that：The S1
Verified in step the basic data field in the DBF files of basis whether belong to must the specific method of matching field be：Work as basis
After DBF file verifications are complete, using javadbf packets by DBF File Mappings in pairs as and according to province title is saved in data
In library,
Then study form field of the study form field in the corresponding DBF files of profession in study form DBF files is verified
It whether there is, there is then study form field is necessary matching field；
Level field of the level field in the corresponding DBF files of profession in verification level DBF files whether there is, and there is then layer
Secondary field is must matching field；
Specialty field of the specialty field in student information DBF in the corresponding DBF files of verification profession whether there is, and exist then specially
Industry field is must matching field.
7. the DBF data according to claim 6 for College Enrollment import processing method, it is characterised in that：The S2
Data match module is matched the data field in the DBF files of basis is imported with the data name in basic code table in step
Specific method be：
It is matched with the study form title in basic code table according to the study form title in the study form DBF of importing,
Update imports the correspondence of study form after successful match；
It is matched with the hierarchy name in basic code table according to the hierarchy name in the level DBF of importing, after successful match more
The new correspondence for importing level；
It is matched and is imported with the major name in basic code table according to the major name in the corresponding DBF of the profession of importing
Level in the corresponding DBF of profession is identical as the level belonging to the major name in basic code table, and update importing is special after successful match
The correspondence of industry.
8. the DBF data according to claim 7 for College Enrollment import processing method, it is characterised in that：The S2
Preservation whether again matching status is also needed to before step；
It needs to match again if matching status is shown again, the data field in the DBF files of basis will be imported by entering S2 steps
It is matched with the data name in basic code table；
If matching status, which is shown, again to match again, the DBF compressed packages that verification uploads is needed whether to upload guarantor
It deposited, if the correspondence for preserving study form, level and profession needs to carry out weight into S2 steps if not preserving
New matching.
9. the DBF data according to claim 8 for College Enrollment import processing method, it is characterised in that：The S2
The data field imported in the DBF files of basis in step with the data name in basic code table show respectively after matching completion
Dendrography practises form relation list, hierarchical relationship list and professional relationship list, and study form relation list, hierarchical relationship are arranged
Table and professional relationship list are set as manual editing's state.
10. the DBF data according to claim 9 for College Enrollment import processing method, it is characterised in that：The S3
The specific method that admission information DBF data import in school's Enrollment System is by information import modul in step：Into school
The admission information of Enrollment System imports, and the grade imported is selected to carry out admission information importing, and sends a message to ActiveMQ
Carry out asynchronous process；
The flow of the asynchronous process is：
S31：The grade that selection imports is verified whether, if not selecting a grade message notifying " grade please be select "；
S32：Preservation whether again matching status is verified whether, if not preserving message notifying " action type is indefinite "；
S33：The dbf compressed packages imported are verified, if message notifying " correct dbf file please be import " is not present；
S34：Verification imports data integrity, verifies the date of birth of the student of every importing, gender, nationality, student's type, demonstrate,proves
Part type, certificate number, province, city/district, examinee number, admission level, admission profession, admission study form, student source, political affairs
Looks are controlled, post whether there is and in system matches, preserve error message；
S35：The student data being verified is imported into tables of data；
S36：Preserve this matched correspondence；
S37：Import information Excel tables are generated, according to the failure cause prompted in detail in S34 steps, in the message heart download.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810136193.1A CN108280223A (en) | 2018-02-09 | 2018-02-09 | DBF data for College Enrollment import platform and introduction method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810136193.1A CN108280223A (en) | 2018-02-09 | 2018-02-09 | DBF data for College Enrollment import platform and introduction method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108280223A true CN108280223A (en) | 2018-07-13 |
Family
ID=62808172
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810136193.1A Pending CN108280223A (en) | 2018-02-09 | 2018-02-09 | DBF data for College Enrollment import platform and introduction method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108280223A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109284260A (en) * | 2018-10-16 | 2019-01-29 | 平安证券股份有限公司 | Large data files read method, device, computer equipment and storage medium |
| CN110544071A (en) * | 2019-08-13 | 2019-12-06 | 广州番禺职业技术学院 | enrollment admission score management system |
| CN110597771A (en) * | 2019-08-14 | 2019-12-20 | 平安证券股份有限公司 | Method, device and equipment for quickly importing DBF file and readable storage medium |
| CN114385572A (en) * | 2022-01-14 | 2022-04-22 | 中国建设银行股份有限公司 | Method and equipment for converting Java object list and DBF file |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104463410A (en) * | 2014-10-27 | 2015-03-25 | 长春嘉诚网络工程有限公司 | Coordination work platform based on fine management |
| CN104463401A (en) * | 2013-11-25 | 2015-03-25 | 北京建筑大学 | Method and system for managing admission information |
| CN107330096A (en) * | 2017-07-05 | 2017-11-07 | 恒生电子股份有限公司 | Document handling method and device, computer-readable recording medium and electronic equipment |
| CN107622460A (en) * | 2017-09-13 | 2018-01-23 | 正方软件股份有限公司 | One key files method and system |
-
2018
- 2018-02-09 CN CN201810136193.1A patent/CN108280223A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104463401A (en) * | 2013-11-25 | 2015-03-25 | 北京建筑大学 | Method and system for managing admission information |
| CN104463410A (en) * | 2014-10-27 | 2015-03-25 | 长春嘉诚网络工程有限公司 | Coordination work platform based on fine management |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN107330096A (en) * | 2017-07-05 | 2017-11-07 | 恒生电子股份有限公司 | Document handling method and device, computer-readable recording medium and electronic equipment |
| CN107622460A (en) * | 2017-09-13 | 2018-01-23 | 正方软件股份有限公司 | One key files method and system |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109284260A (en) * | 2018-10-16 | 2019-01-29 | 平安证券股份有限公司 | Large data files read method, device, computer equipment and storage medium |
| CN109284260B (en) * | 2018-10-16 | 2023-10-13 | 平安证券股份有限公司 | Big data file reading method and device, computer equipment and storage medium |
| CN110544071A (en) * | 2019-08-13 | 2019-12-06 | 广州番禺职业技术学院 | enrollment admission score management system |
| CN110544071B (en) * | 2019-08-13 | 2023-09-05 | 广州番禺职业技术学院 | Admission admission score management system |
| CN110597771A (en) * | 2019-08-14 | 2019-12-20 | 平安证券股份有限公司 | Method, device and equipment for quickly importing DBF file and readable storage medium |
| CN110597771B (en) * | 2019-08-14 | 2023-09-05 | 平安证券股份有限公司 | Method, device, equipment and readable storage medium for quickly importing DBF (digital binary flash) files |
| CN114385572A (en) * | 2022-01-14 | 2022-04-22 | 中国建设银行股份有限公司 | Method and equipment for converting Java object list and DBF file |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108280223A (en) | DBF data for College Enrollment import platform and introduction method | |
| US10262658B2 (en) | Voice recognition method and system | |
| CN104852990B (en) | A kind of information processing method and intelligent home control system | |
| CN104021149A (en) | Teaching courseware construction method based on meta-knowledge points | |
| WO2021159898A1 (en) | Privacy protection-based deep learning method, system and server, and storage medium | |
| CN111708825A (en) | Data processing method, device and equipment based on block chain and readable storage medium | |
| CN103903188A (en) | Controlling method of configuration file of intelligent transformer substation system | |
| CN102707948B (en) | Source code generation method | |
| CN104468457A (en) | User logging-in method based on unified user system and registering method | |
| CN110489536B (en) | Group question-answering method and group question-answering system | |
| CN113626438B (en) | Data table management method, device, computer equipment and storage medium | |
| CN116050548B (en) | Federal learning method and device and electronic equipment | |
| WO2020134706A1 (en) | Data transmission checking method and system, computer device and storage medium | |
| CN108170466A (en) | A kind of C/C++ bugs self-repairing methods based on program synthesis | |
| CN106557325A (en) | A kind of extendible user's information defines method and system | |
| CN103164532A (en) | Classification and partitioning extract method of power grid model data and system | |
| CN110048874B (en) | Method and device for verifying video networking terminal | |
| CN106095754A (en) | A kind of medical terminology dictionary part-of-speech tagging method | |
| CN107590256A (en) | Heterogeneous database synchronization method and device | |
| CN105488219A (en) | Automatic webpage information entering method and system | |
| US20160253439A1 (en) | Methods For Converting Circuits In Circuit Simulation Programs | |
| CN114138813A (en) | Attribute configuration method and related device | |
| JP2017098673A (en) | Data compression collection system and method | |
| CN111339189A (en) | Data processing method and device and computer readable storage medium | |
| CN113434584B (en) | Data processing method and device for power equipment and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180713 |