CN110597898A - Middleware method and device for attendance machine card punching data integration - Google Patents
Middleware method and device for attendance machine card punching data integration Download PDFInfo
- Publication number
- CN110597898A CN110597898A CN201910880632.4A CN201910880632A CN110597898A CN 110597898 A CN110597898 A CN 110597898A CN 201910880632 A CN201910880632 A CN 201910880632A CN 110597898 A CN110597898 A CN 110597898A
- Authority
- CN
- China
- Prior art keywords
- attendance machine
- personnel
- data
- card punching
- information
- 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
- 238000004080 punching Methods 0.000 title claims abstract description 45
- 238000000034 method Methods 0.000 title claims abstract description 30
- 230000010354 integration Effects 0.000 title claims abstract description 25
- 238000013507 mapping Methods 0.000 claims abstract description 39
- 230000001360 synchronised effect Effects 0.000 claims abstract description 20
- 230000000977 initiatory effect Effects 0.000 claims description 6
- 238000009434 installation Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 2
- 238000005516 engineering process Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000007639 printing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C1/00—Registering, indicating or recording the time of events or elapsed time, e.g. time-recorders for work people
- G07C1/10—Registering, indicating or recording the time of events or elapsed time, e.g. time-recorders for work people together with the recording, indicating or registering of other data, e.g. of signs of identity
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Time Recorders, Dirve Recorders, Access Control (AREA)
Abstract
The invention discloses a middleware method and device for attendance machine card punching data integration, and belongs to the technical field of business processing. The middleware method for attendance machine card punching data integration comprises the following steps: s1, configuring a synchronous mode of the attendance machine, and setting synchronous parameters; s2, configuring personnel mapping information; and S3, installing different data components to the corresponding attendance machine database, and configuring task information. The middleware method for attendance machine card punching data integration can solve the problem that an enterprise is difficult to adapt to an attendance system due to different interface specifications of attendance machines, different models and the like, and has good popularization and application values.
Description
Technical Field
The invention relates to the technical field of business processing, and particularly provides a middleware method and device for attendance machine card punching data integration.
Background
The related products of the attendance machine are industrial products in the sixties and seventies of the nineteenth century, and the attendance machine is subject to the first generation of card-inserting type attendance machine and the second generation of bar code attendance machine, and the attendance machine based on the optical principle and the printing technology provides accurate card punching records for factories and mine factories for the first time. The third generation attendance machine is developed in the 90 and 00 years, is also an attendance machine which is used in a large amount in the current market, and is a magnetic card type attendance machine, and the attendance machine is developed in the initial stage of the internet era and has certain data storage capacity and communication capacity. By the late stage of the 00 s to the early stage of the 10 s, more professional attendance checking equipment based on biological characteristics, human faces, fingerprints and the like occupy a large amount of markets in subsequent production, and original card punching records can gradually form some simple analysis statistical tables and provide certain decision data for enterprises. Nowadays, attendance machines are not limited to simple biological characteristics, are more paas solutions based on face recognition and biological recognition, and are more accurate, faster and more convenient than third-generation attendance machines.
With the development of science and technology, internet technology and standards become more standard with the deepening of technology, but a phenomenon is brought, more professional attendance data analysis software is generally well integrated when acquiring new technology aiming at the original attendance record, but an integration platform is very important aiming at attendance machine systems with different synchronization strategies used by various attendance machines, on one hand, the data acquired by unified interfaces is orderly data which can be analyzed by the attendance analysis software, and on the other hand, different attendance machine types and different interfaces provided by the software need to be flexibly coped with.
Disclosure of Invention
The technical task of the invention is to provide a middleware method for attendance machine card punching data integration, which can solve the problem that an enterprise is difficult to adapt to the attendance system due to different interface specifications of attendance machines, different models and the like.
The invention further provides a middleware device for attendance machine card punching data integration.
In order to achieve the purpose, the invention provides the following technical scheme:
a middleware method for attendance machine card punching data integration comprises the following steps:
s1, configuring a synchronous mode of the attendance machine, and setting synchronous parameters;
s2, configuring personnel mapping information;
and S3, installing different data components to the corresponding attendance machine database, and configuring task information.
Preferably, the configuration attendance machine synchronization mode comprises a WebService mode and a database intermediate table mode.
Preferably, the WebService mode is suitable for a mode of actively initiating a request to the middleware, configuring built-in parameters of the attendance machine and setting the server.
Preferably, the database intermediate table mode needs to configure corresponding table information and field information of the personnel table and the card punching table in the corresponding attendance machine database, and needs to register the attendance machine and apply for the outer _ token in the middleware platform.
Preferably, the configuration staff mapping information supports batch setting of data of the reference staff field as a mapping relation, and supports data information of individual setting staff.
Preferably, in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, the employee number, the ID, the identity card number and the mobile phone number are directly matched, and the corresponding personnel are automatically identified.
A middleware device for attendance machine card punching data integration comprises the following modules:
the attendance machine synchronous mode configuration module is used for configuring an attendance machine synchronous mode and setting synchronous parameters;
the personnel mapping information configuration module is used for configuring personnel mapping information;
and the attendance machine task information configuration module is used for installing different data components to the corresponding attendance machine database and configuring task information.
Preferably, the attendance machine synchronization mode configuration module configures attendance machine synchronization modes including a WebService mode and a database intermediate table mode, wherein the WebService mode is suitable for a mode of actively initiating a request to the middleware, configuring attendance machine built-in parameters and setting a server; the database intermediate table mode needs to configure corresponding table information and field information of a personnel table and a card punching table in a corresponding attendance machine database, and in addition, the attendance machine needs to be registered and applied for an outer _ token in a middleware platform.
Preferably, the personnel mapping information configuration module configures personnel mapping information to support the batch setting of data of cited personnel fields as a mapping relation and simultaneously supports the individual setting of data information of personnel; and in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, and the personnel job number, the ID, the identification number and the mobile phone number are directly matched to automatically identify the corresponding personnel.
Compared with the prior art, the attendance machine card punching data integration middleware method has the following outstanding beneficial effects:
the middleware method for attendance machine card punching data integration supports multiple data synchronization modes, and interface configuration is flexible;
secondly, dynamically analyzing the service data and automatically associating the service data with personnel;
third, support the data to hijack the light touch, do not influence the original system to use;
(IV) data forwarding is accurate in real time;
and (V) the attendance card punching data is docked by the attendance machine suppliers of multiple models and brands, a synchronous data mechanism ensures that the data is not lost in the transmission process, the problem that the attendance system is difficult to adapt to due to different interface specifications of different attendance machines, different models and the like of enterprises is solved, and the method has good popularization and application values.
Drawings
Fig. 1 is a flow chart of a middleware method for attendance machine card punching data integration.
Detailed Description
The middleware method and device for attendance machine card punching data integration according to the present invention will be further described in detail with reference to the accompanying drawings and embodiments.
Examples
The invention discloses a middleware method for attendance machine card punching data integration, which comprises the following steps:
s1, configuring a synchronous mode of the attendance machine, and setting synchronous parameters.
The configuration attendance machine synchronization mode comprises a WebService mode and a database intermediate table mode.
The method is suitable for a mode of actively initiating a request to the middleware in a WebService mode, and comprises the steps of configuring built-in parameters of the attendance machine, setting a server, and https: xx.xx.xx.xx:8000/open _ api/sync _ machine _ data.
The database intermediate table mode needs to configure corresponding table information and field information of a personnel table and a card punching table in a corresponding attendance machine database, and in addition, the attendance machine needs to be registered and applied for an outer _ token in a middleware platform.
And S2, configuring personnel mapping information.
The configuration personnel mapping information supports the batch setting of data of the quoted personnel fields as mapping relations, and simultaneously supports the data information of the individual setting personnel. And in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, and the personnel job number, the ID, the identification number and the mobile phone number are directly matched to automatically identify the corresponding personnel.
And S3, installing different data components to the corresponding attendance machine database, and configuring task information.
The specific implementation process is as follows:
1. middleware platform registers attendance machine information, defines attendance machine integrated mode, wherein:
key: device unique identification number: the unique serial numbers of different attendance machines are used for identifying which attendance machine the card punching data comes from;
mode: the attendance machine integration mode can be selected, the attendance machine hijacking mode can be selected, and the attendance machine database can be selected;
url: for the attendance machine hijacking mode, a data address after attendance machine data hijacking is required to be configured.
2. Database configuration information
A. A punch-down form or view configuration.
B. The configuration of the field information is carried out,
employee _ field person mapping field
machine _ key, attendance machine unique identification number registered in the function
punch _ field punch time field
in _ out _ field the in and out identification field.
C. The sql configuration is synchronized.
3. And installing a data synchronization component to guide a corresponding attendance machine database and configuring task information.
The middleware device for attendance machine punch-card data integration comprises an attendance machine synchronous mode configuration module, a personnel mapping information configuration module and an attendance machine task information configuration module.
And the attendance machine synchronous mode configuration module is used for configuring the attendance machine synchronous mode and setting synchronous parameters.
The attendance machine synchronization mode configuration module configures attendance machine synchronization modes comprising a WebService mode and a database intermediate table mode, wherein the WebService mode is suitable for a mode of actively initiating a request to the middleware, configuring built-in parameters of the attendance machine, and setting by the server; the database intermediate table mode needs to configure corresponding table information and field information of a personnel table and a card punching table in a corresponding attendance machine database, and in addition, the attendance machine needs to be registered and applied for an outer _ token in a middleware platform.
And the personnel mapping information configuration module is used for configuring personnel mapping information.
The personnel mapping information configuration module configures personnel mapping information to support the data of the cited personnel fields to be set in batches as a mapping relation and simultaneously supports the data information of the personnel to be set independently; and in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, and the personnel job number, the ID, the identification number and the mobile phone number are directly matched to automatically identify the corresponding personnel.
And the attendance machine task information configuration module is used for installing different data components to the corresponding attendance machine database and configuring task information.
The above-described embodiments are merely preferred embodiments of the present invention, and general changes and substitutions by those skilled in the art within the technical scope of the present invention are included in the protection scope of the present invention.
Claims (9)
1. A middleware method for attendance machine card punching data integration is characterized in that: the method comprises the following steps:
s1, configuring a synchronous mode of the attendance machine, and setting synchronous parameters;
s2, configuring personnel mapping information;
and S3, installing different data components to the corresponding attendance machine database, and configuring task information.
2. The attendance machine card punching data integration middleware method according to claim 1, characterized in that: the configuration attendance machine synchronization mode comprises a WebService mode and a database intermediate table mode.
3. The attendance machine card punching data integration middleware method according to claim 2, characterized in that: the method is suitable for a mode of actively initiating a request to the middleware in a WebService mode, and is used for configuring built-in parameters of the attendance machine and setting the server.
4. The attendance machine card punching data integration middleware method according to claim 3, characterized in that: the database intermediate table mode needs to configure corresponding table information and field information of a personnel table and a card punching table in a corresponding attendance machine database, and in addition, the attendance machine needs to be registered and applied for an outer _ token in a middleware platform.
5. The attendance machine card punching data integration middleware method according to claim 4, characterized in that: the configuration personnel mapping information supports batch setting of data of the quoted personnel fields as mapping relations, and simultaneously supports individual setting of data information of personnel.
6. The attendance machine card punching data integration middleware method according to claim 5, characterized in that: and in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, and the personnel job number, the ID, the identification number and the mobile phone number are directly matched to automatically identify the corresponding personnel.
7. The utility model provides an attendance machine data integration's middleware device that punches card which characterized in that: the system comprises the following modules:
the attendance machine synchronous mode configuration module is used for configuring an attendance machine synchronous mode and setting synchronous parameters;
the personnel mapping information configuration module is used for configuring personnel mapping information;
and the attendance machine task information configuration module is used for installing different data components to the corresponding attendance machine database and configuring task information.
8. The attendance machine card punching data integrated middleware device according to claim 7, wherein: the attendance machine synchronization mode configuration module configures attendance machine synchronization modes comprising a WebService mode and a database intermediate table mode, wherein the WebService mode is suitable for a mode of actively initiating a request to the middleware, configuring built-in parameters of the attendance machine, and setting by the server; the database intermediate table mode needs to configure corresponding table information and field information of a personnel table and a card punching table in a corresponding attendance machine database, and in addition, the attendance machine needs to be registered and applied for an outer _ token in a middleware platform.
9. The attendance machine card punching data integrated middleware device according to claim 8, wherein: the personnel mapping information configuration module configures personnel mapping information to support the data of the cited personnel fields to be set in batches as a mapping relation and simultaneously supports the data information of the personnel to be set independently; and in the card punching data sorting process, the data of the mapping information of the installation configuration personnel directly reads the identity of the configuration information identification personnel and the card punching data of the mapping data of the non-configuration personnel, and the personnel job number, the ID, the identification number and the mobile phone number are directly matched to automatically identify the corresponding personnel.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910880632.4A CN110597898A (en) | 2019-09-18 | 2019-09-18 | Middleware method and device for attendance machine card punching data integration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910880632.4A CN110597898A (en) | 2019-09-18 | 2019-09-18 | Middleware method and device for attendance machine card punching data integration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110597898A true CN110597898A (en) | 2019-12-20 |
Family
ID=68860649
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910880632.4A Pending CN110597898A (en) | 2019-09-18 | 2019-09-18 | Middleware method and device for attendance machine card punching data integration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110597898A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005222273A (en) * | 2004-02-05 | 2005-08-18 | Kunio Aso | Attendance management system, attendance management method, attendance management server, and portable terminal unit |
| CN101226651A (en) * | 2008-02-01 | 2008-07-23 | 中兴通讯股份有限公司 | Mobile terminal with check on work attendance function, check on work attendance system as well as method thereof |
| CN106453541A (en) * | 2016-09-30 | 2017-02-22 | 厦门中控生物识别信息技术有限公司 | Data synchronization method, server and data synchronization system |
| WO2019100385A1 (en) * | 2017-11-27 | 2019-05-31 | 齐心商用设备(深圳)有限公司 | Attendance machine and attendance method for attendance machine |
| CN209231993U (en) * | 2019-01-24 | 2019-08-09 | 刘磊 | A kind of smart classroom comprehensive management system |
-
2019
- 2019-09-18 CN CN201910880632.4A patent/CN110597898A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005222273A (en) * | 2004-02-05 | 2005-08-18 | Kunio Aso | Attendance management system, attendance management method, attendance management server, and portable terminal unit |
| CN101226651A (en) * | 2008-02-01 | 2008-07-23 | 中兴通讯股份有限公司 | Mobile terminal with check on work attendance function, check on work attendance system as well as method thereof |
| CN106453541A (en) * | 2016-09-30 | 2017-02-22 | 厦门中控生物识别信息技术有限公司 | Data synchronization method, server and data synchronization system |
| WO2019100385A1 (en) * | 2017-11-27 | 2019-05-31 | 齐心商用设备(深圳)有限公司 | Attendance machine and attendance method for attendance machine |
| CN209231993U (en) * | 2019-01-24 | 2019-08-09 | 刘磊 | A kind of smart classroom comprehensive management system |
Non-Patent Citations (2)
| Title |
|---|
| 朱剑辉等: "基于Qt和ARM平台的RFID考勤系统的设计", 《仪表技术》 * |
| 韦庆进等: "人事管理系统与考勤机接口实现研究", 《软件导刊》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109408337B (en) | Interface operation and maintenance method and device | |
| CN110705664A (en) | Internet of things-based RFID (radio frequency identification) intelligent tool management system | |
| CN110489699B (en) | Asynchronous data acquisition method and system | |
| CN103516591B (en) | The implementation method of enterprise's address list and device in immediate communication platform | |
| US20110161132A1 (en) | Method and system for extracting process sequences | |
| CN108073688B (en) | Data migration method and device | |
| CN101453358B (en) | Sql sentence audit method and system for oracle database binding variable | |
| CN111897863A (en) | Multi-source heterogeneous data fusion and convergence method | |
| US20200402076A1 (en) | Data processing method and apparatus, and storage medium | |
| CN101561806B (en) | Information extraction and audit method of DB2 database operation, device and system thereof | |
| CN111831755B (en) | Cross-database data synchronization method, system, medium and device | |
| CN112162960A (en) | Health government affair information sharing method, device and system | |
| CN112965979A (en) | User behavior analysis method and device and electronic equipment | |
| CN104794524A (en) | Intelligent electronic counting system and method applied to pre-sewing processes | |
| CN111210535A (en) | Intelligent inspection system for scheduling master station system equipment | |
| CN110442647A (en) | Data consistency synchronous method, device and computer readable storage medium | |
| CN110597898A (en) | Middleware method and device for attendance machine card punching data integration | |
| CN109492602B (en) | Process timing method and system based on human body language | |
| CN104216986B (en) | The device and method of pre-operation raising efficiency data query is carried out with the data update cycle | |
| CN109377143A (en) | Operation trace acquisition system, acquisition method, management system and management method | |
| CN114691782A (en) | Database table increment synchronization method and device and storage medium | |
| CN210776748U (en) | Internet of things-based RFID (radio frequency identification) intelligent tool management system | |
| CN106230618A (en) | A kind of system journal centralized processing system | |
| CN111913821A (en) | Method for realizing cross-data-source real-time data stream production consumption | |
| CN111126946A (en) | Modeling method and device for data tracing of information system |
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: 20191220 |