CN111367982A

CN111367982A - Method and device for importing TRIRIGA basic data, computer equipment and storage medium

Info

Publication number: CN111367982A
Application number: CN202010156542.3A
Authority: CN
Inventors: 高杰; 彭利科; 邓裕; 雍骁
Original assignee: Shenzhen Wanwuyun Technology Co ltd
Current assignee: Shenzhen Wanwuyun Technology Co ltd
Priority date: 2020-03-09
Filing date: 2020-03-09
Publication date: 2020-07-03
Anticipated expiration: 2040-03-09
Also published as: CN111367982B

Abstract

The invention relates to a method, a device, computer equipment and a storage medium for importing TRIRIGA basic data; the method comprises the following steps: acquiring user login information, and performing authority setting and project switching according to the user login information; acquiring an import data template according to the permission setting and the project switching; acquiring data filled by a user according to the imported data template; judging whether the data filled by the user is accurate or not; if not, feeding back a data error prompt; and if so, importing the data filled by the user into TRIRIGA. The invention improves the data import performance and user experience, does not need to convert text files during import, reduces the manual repeated checking and verification, reduces the labor cost, meets the requirement of simultaneously and quickly online a large number of projects, and improves the efficiency.

Description

Method and device for importing TRIRIGA basic data, computer equipment and storage medium

Technical Field

The invention relates to the technical field of TRIRIGA data import, in particular to a method, a device, computer equipment and a storage medium for importing TRIRIGA basic data.

Background

In recent years, enterprise and business expansion is rapid, including enterprise headquarters comprehensive facility management service and business property service, a digital platform adaptive to enterprise and enterprise business needs to be built urgently, and a set of digital solution surrounding the whole life cycle of real estate management is created.

However, the conventional real estate management has the following problems: 1. the user experience is poor, the data is imported and collected by EXCEL, and the data needs to be converted into TXT text files during import; 2. the workload of workers is large, and data collection and import need to be checked and verified manually and repeatedly; 3. the efficiency is low, the performance is poor, and a large number of projects need to be imported and brought online simultaneously; therefore, the demand cannot be satisfied.

Disclosure of Invention

The invention aims to overcome the defects of the prior art and provides a method, a device, a computer device and a storage medium for importing TRIRIGA basic data.

In order to achieve the purpose, the invention adopts the following technical scheme:

a method for importing basic data of TRIRIGA, comprising the steps of:

acquiring user login information, and performing authority setting and project switching according to the user login information;

acquiring an import data template according to the permission setting and the project switching;

acquiring data filled by a user according to the imported data template;

judging whether the data filled by the user is accurate or not;

if not, feeding back a data error prompt;

and if so, importing the data filled by the user into TRIRIGA.

The further technical scheme is as follows: in the step of judging whether the data filled by the user is accurate or not, adopting a redis consumer mode to judge and check the data filled by the user, acquiring the procss information of the data filled by the user from a redis message queue, and modifying the T _ process record state into a check state; the method comprises the following steps:

calling a file format service interface to carry out format verification; if the verification is successful, inserting t _ logs to record t _ validerrors according to the interface return value; if the verification fails, inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: the verification fails;

inserting a t _ logs record t _ validerrors record according to the interface return value, and calling a template value format check interface; if the verification is successful, inserting the record passing the verification into a database; if the verification fails, inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: the verification fails;

inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: and (4) successfully checking, waiting for importing, automatically recording the import success times by the system, and automatically generating an import report detail record by the system after the user imports to use an import log and error analysis.

The further technical scheme is as follows: in the step of judging whether the data filled by the user is accurate, the template format, the data format, the repeated data and the associated data in the data filled by the user are judged.

The further technical scheme is as follows: if so, after the step of importing the data filled by the user into TRIRIGA, the method also comprises the following steps: and when the data filled by the user is imported into TRIRIGA, a prompt for successful import of the data fed back by the user is given.

Device for importing TRIRIGA-based data, comprising: the device comprises an acquisition setting switching unit, a first acquisition unit, a second acquisition unit, a judgment unit, a feedback unit and a lead-in unit;

the acquisition setting switching unit is used for acquiring user login information and carrying out authority setting and project switching according to the user login information;

the first acquisition unit is used for acquiring an import data template according to authority setting and project switching;

the second acquisition unit is used for acquiring data filled by a user according to the imported data template;

the judging unit is used for judging whether the data filled by the user is accurate or not;

the feedback unit is used for feeding back a data error prompt;

and the importing unit is used for importing the data filled by the user into TRIRIGA.

The further technical scheme is as follows: in the judging unit, a redis consumer mode is adopted to judge and check the data filled by the user, the process information of the data filled by the user is acquired from a redis message queue, and the T _ process recording state is modified to be in checking.

The further technical scheme is as follows: and the judging unit judges the template format, the data format, the repeated data and the associated data in the data filled by the user.

The further technical scheme is as follows: further comprising: and the completion feedback unit is used for feeding back a data import success prompt for the user when the data filled by the user is imported into TRIRIGA to be completed.

A computer device comprising a memory having a computer program stored thereon and a processor implementing the method of importing TRIRIGA base data as described above when the computer program is executed by the processor.

A storage medium storing a computer program comprising program instructions which, when executed by a processor, implement the method of importing TRIRIGA base data as described above.

Compared with the prior art, the invention has the beneficial effects that: through obtaining user login information, authority setting and project switching are carried out, data filled by a user according to a leading-in data template are obtained, the data filled by the user are judged, then the data filled by the user are led into TRIRIGA, data leading-in performance and user experience are improved, text files do not need to be converted during leading-in, manual repeated checking and verification are reduced, labor cost is reduced, the requirement that a large number of projects are rapidly on line is met, efficiency is improved, and the requirement can be better met.

The invention is further described below with reference to the accompanying drawings and specific embodiments.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic flow chart of a method for importing basic data of TRIRIGA according to an embodiment of the present invention;

fig. 2 is a schematic block diagram of an apparatus for importing basic data of a TRIRIGA according to an embodiment of the present invention;

FIG. 3 is a schematic block diagram of a computer device provided by an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

Referring to the embodiments shown in fig. 1 to 3, in which, referring to fig. 1, the invention discloses a method for importing basic data of TRIRIGA, comprising the following steps:

s1, obtaining user login information, and setting authority and switching items according to the user login information;

the TRIRIGA is a facility operation and maintenance management system, has the functions of business analysis, key alarm, automation process and the like, and is beneficial to improving the visibility, the control power and the automation level of the requirements of real estate management, capital projects, space management, facility maintenance and energy management.

In this embodiment, basic information of the project needing to be online is collected through the EXCEL file, such as: project, employee, supplier organization and personnel, building, floor, space request type configuration, equipment, etc.

S2, acquiring an import data template according to the authority setting and the project switching;

s3, acquiring data filled by the user according to the imported data template;

in this embodiment, after the user fills in data, the user clicks a File on a page of a login system to upload, that is, a File upload Check interface File Check Service (File Check Service) is called to perform a Check, which includes two cases of a Check success and a Check failure;

1. and (4) successful verification:

1.1 uploading user filling data to an Aliyun OSS (cloud server), and updating an os _ file _ path field in a t _ process table;

1.2 inserting t _ logs record according to the return value of the File Check Service interface;

1.3 inserting t _ validerrors records according to the return value of the File Check Service;

1.4 updating operation _ times (operation time), version _ batch (version batch processing), operation _ state (operation state), operation _ state _ desc (operation state description) in the t _ process table, and modifying the state into: uploading successfully;

1.5 calling a redis (a log-type and Key-Value database which is open-source, written by using ANSI C language, supports network, can be based on memory and can be persistent, and provides API of multiple languages) producer interface, and putting ID of T _ process into a redis queue;

2. and (3) failure of verification:

2.1 inserting t _ logs record according to the return value of the File Check Service interface,

2.2 inserting t _ valirors records according to the return value of the File Check Service;

2.3 updating operation _ times, version _ batch, operation _ state and operation _ state _ desc in the t _ process table, and modifying the state as follows: the upload failed;

2.4 the user may choose to upload the filling data as a single file or as a batch file.

S4, judging whether the data filled by the user is accurate;

in the embodiment, a redis consumer mode is adopted to judge and check data filled by a user, process (processing) information of the data filled by the user is acquired from a redis message queue, and a T _ process record state is modified to be in checking; the method comprises the following steps: 1. calling a file format service interface to carry out format verification; if the verification is successful, inserting t _ logs to record t _ validerrors according to the interface return value; if the verification fails, inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: the verification fails; 2. inserting a t _ logs record t _ validerrors record according to the interface return value, and calling a template value format check interface; if the verification is successful, inserting the record passing the verification into a database; if the verification fails, inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: the verification fails; 3. inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: and (4) successfully checking, waiting for importing, automatically recording the import success times by the system, and automatically generating an import report detail record by the system after the user imports to use an import log and error analysis.

In this embodiment, in the step S4, the template format, the data format, the repeated data, and the associated data in the data filled by the user are determined.

Wherein, when the template format is wrong:

possibly, the uploaded Excel file has 9 columns in total, and the standard template has 8 columns in total;

and (3) analysis: other data are in the Excel file table, and the Excel file table is deleted and then uploaded for verification;

for example: in the x-th row and the x-th column, if the x cells are inconsistent with the template content, the standard template is required to be used for uploading again; and (3) analysis: the header is modified, please use the standard template.

Wherein, when the data format is wrong:

for example: in the x-th row and the x-th column, the x unit cell is a mandatory item, and the mandatory item is required to be refilled;

and (3) analysis: filling the necessary cells without filling;

for example: on the x-th line, the x cell of the x-th column is in a text format and is required to be refilled;

and (3) analysis: there is no filling in according to the field format of the header hint.

Wherein, when the duplicate data is found:

for example: the x unit cell of the x row and the x column is a repeated item which already exists in the system and is required to be refilled;

and (3) analysis: the data is successfully imported and cannot be repeatedly imported, and the data is deleted and then uploaded for verification.

Wherein, when the associated data has errors:

for example: the x unit cell of the x row and the x column, namely Liqu does not belong to the staff in the current project, and the data is required to be confirmed whether to be a reasonable report object or not;

and (3) analysis: the internal employee template does not have the employee data of Liqu;

for example: the x unit grid of the x row and the x column, the department (engineering department) does not exist, and the department is required to be refilled;

and (3) analysis: the department template has no data for the project department.

S5, if not, feeding back a data error prompt;

in this embodiment, the step S5 includes: and red font marking is carried out on the error data to be used as a data error prompt, so that a user can modify the data conveniently, after the data is modified, the data is clicked and stored and then uploaded, after the data is verified, the data enters a state to be imported, and the user can preview the data.

When the user operates on the page, the operation selection comprises the following steps: 1. and 2, importing again, namely uploading the calling file to a related interface, and 2, importing, namely calling a redis producer interface to put the related record ID associated under the t _ process into a redis queue, and modifying the state of the t _ process into import.

And S6, if yes, importing the data filled by the user into TRIRIGA.

Wherein, after the step of S6, the method further comprises: when the data filled by the user is imported into TRIRIGA, a prompt for successful import of the data fed back by the user is given, and in the embodiment, the prompt for successful import is a popup completion interface, which is simple and clear.

In this embodiment, the specific operations of importing data into TRIRIGA are as follows: 1. acquiring a record ID queried according to t _ process from a redis message queue by using a redis consumer mode, and importing by adopting multithreading; 2. calling a tririga-servlet interface to import data, inserting t _ logs record t _ validerrors record according to an interface return value on a record corresponding to a spec _ id channel for importing each piece of tririga business data needing to be written back, and updating the s state in the t _ process table to be modified as follows: the import is successful; when the import fails, inserting t _ logs record t _ validerrors record according to the interface return value, and updating the s state in the t _ process table to be modified as follows: and (4) introducing errors, uploading again, and calling a file uploading process.

According to the method and the device, the login information of the user is acquired, the authority setting and the project switching are carried out, the data filled by the user according to the imported data template is acquired, the data filled by the user is judged, and then the data filled by the user is imported into TRIRIGA, so that the data import performance and the user experience are improved, text files do not need to be converted during import, manual repeated checking and verification are reduced, the labor cost is reduced, the requirement of rapidly online a large number of projects is met, the efficiency is improved, and the requirement can be better met.

The invention integrates and accesses a plurality of business systems such as customer call centers, finance, mobile portals and the like, improves service efficiency, improves customer experience, realizes the fusion and unification of various management businesses such as customer service, projects, operation and maintenance services and the like of customers, owners and companies, establishes an operation and maintenance system and a management flow taking project management as a core, enables the management standards, systems and flows of the projects to fall on the ground, standardizes the related work of the management and control of the projects, improves the effects of project operation and customer service, meets the requirement of all physical business enterprises on realizing the rapidness of the projects, simply leads related basic data such as personnel, organization, projects, buildings, floors, spaces, equipment inventory, request classes and the like into a TRIRIGA system, realizes the rapid online of the projects, meets the digital requirement and realizes the cost reduction.

Referring to fig. 2, the present invention further discloses a device for importing basic data of TRIRIGA, including: an acquisition setting switching unit 10, a first acquisition unit 20, a second acquisition unit 30, a judgment unit 40, a feedback unit 50, and an introduction unit 60;

the acquisition setting switching unit 10 is configured to acquire user login information, and perform permission setting and item switching according to the user login information;

the first obtaining unit 20 is configured to obtain an import data template according to authority setting and item switching;

the second obtaining unit 30 is configured to obtain data that is filled by a user according to the imported data template;

the judging unit 40 is used for judging whether the data filled by the user is accurate or not;

the feedback unit 50 is used for feeding back a data error prompt;

the importing unit 60 is configured to import data filled by a user into TRIRIGA.

In the determining unit 40, a redis consumer mode is adopted to perform determination and verification on data filled by a user, obtain the process information of the data filled by the user from a redis message queue, and modify the T _ process record state into verification.

In the determining unit 40, the template format, the data format, the repeated data, and the associated data in the data filled by the user are determined.

Wherein, the feedback unit 50 includes: and marking the error data by red font to be used as a data error prompt.

Wherein, the device still includes: and a completion feedback unit 70, configured to feed back a prompt for success of data import to the user when the data import TRIRIGA filled by the user is completed.

It should be noted that, as can be clearly understood by those skilled in the art, the specific implementation process of the apparatus for importing basic data of TRIRIGA and each unit may refer to the corresponding description in the foregoing method embodiment, and for convenience and brevity of description, no further description is provided herein.

The means for importing the TRIRIGA base data may be implemented in the form of a computer program that is executable on a computer device as shown in fig. 3.

Referring to fig. 3, fig. 3 is a schematic block diagram of a computer device according to an embodiment of the present application; the computer device 500 may be a terminal or a server, where the terminal may be an electronic device with a communication function, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a personal digital assistant, and a wearable device. The server may be an independent server or a server cluster composed of a plurality of servers.

Referring to fig. 3, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.

The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032 comprises program instructions that, when executed, cause the processor 502 to perform a method of importing TRIRIGA-based data.

The processor 502 is used to provide computing and control capabilities to support the operation of the overall computer device 500.

The internal memory 504 provides an environment for running the computer program 5032 in the non-volatile storage medium 503, and when the computer program 5032 is executed by the processor 502, the processor 502 may be enabled to execute a method for importing TRIRIGA-based data.

The network interface 505 is used for network communication with other devices. Those skilled in the art will appreciate that the configuration shown in fig. 3 is a block diagram of only a portion of the configuration associated with the present application and does not constitute a limitation of the computer device 500 to which the present application may be applied, and that a particular computer device 500 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

It should be understood that, in the embodiment of the present Application, the Processor 502 may be a Central Processing Unit (CPU), and the Processor 502 may also be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

It will be understood by those skilled in the art that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program instructing associated hardware. The computer program includes program instructions, and the computer program may be stored in a storage medium, which is a computer-readable storage medium. The program instructions are executed by at least one processor in the computer system to implement the flow steps of the embodiments of the method described above.

Accordingly, the present invention also provides a storage medium. The storage medium may be a computer-readable storage medium. The storage medium stores a computer program, wherein the computer program comprises program instructions which, when executed by a processor, implement the above-described method of importing TRIRIGA base data.

The storage medium may be a usb disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk, which can store various computer readable storage media.

Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative. For example, the division of each unit is only one logic function division, and there may be another division manner in actual implementation. For example, various elements or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented.

The steps in the method of the embodiment of the invention can be sequentially adjusted, combined and deleted according to actual needs. The units in the device of the embodiment of the invention can be merged, divided and deleted according to actual needs. In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a terminal, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention.

The technical contents of the present invention are further illustrated by the examples only for the convenience of the reader, but the embodiments of the present invention are not limited thereto, and any technical extension or re-creation based on the present invention is protected by the present invention. The protection scope of the invention is subject to the claims.

Claims

1. A method for importing TRIRIGA-based data, comprising the steps of:

acquiring data filled by a user according to the imported data template;

judging whether the data filled by the user is accurate or not;

if not, feeding back a data error prompt;

and if so, importing the data filled by the user into TRIRIGA.

2. The method for importing basic data of TRIRIGA as claimed in claim 1, wherein in the step of "determining whether the data filled by the user is accurate", a redis consumer model is adopted to perform determination and verification on the data filled by the user, process information of the data filled by the user is obtained from a redis message queue, and the recording state of T _ process is modified to be in verification; the method comprises the following steps:

3. The method of claim 2, wherein the step of determining whether the data filled by the user is accurate comprises determining a template format, a data format, repeated data, and associated data in the data filled by the user.

4. The method of importing basic data of TRIRIGA as claimed in claim 1, wherein the step of importing the data filled by the user into TRIRIGA if yes further comprises: and when the data filled by the user is imported into TRIRIGA, a prompt for successful import of the data fed back by the user is given.

5. An apparatus for importing TRIRIGA-based data, comprising: the device comprises an acquisition setting switching unit, a first acquisition unit, a second acquisition unit, a judgment unit, a feedback unit and a lead-in unit;

the feedback unit is used for feeding back a data error prompt;

6. The apparatus of claim 5, wherein the determining unit determines and verifies the data filled by the user in a redis consumer model, obtains the process information of the data filled by the user from a redis message queue, and modifies the T process record state to be in verification.

7. The apparatus for importing TRIRIGA base data according to claim 6, wherein the determining unit determines a template format, a data format, duplicate data, and associated data in the data filled by the user.

8. The apparatus for importing TRIRIGA-based data according to claim 5, further comprising: and the completion feedback unit is used for feeding back a data import success prompt for the user when the data filled by the user is imported into TRIRIGA to be completed.

9. Computer arrangement, characterized in that the computer arrangement comprises a memory, on which a computer program is stored, and a processor, which when executing the computer program implements the method of importing TRIRIGA-based data according to any of claims 1-4.

10. A storage medium, characterized in that the storage medium stores a computer program comprising program instructions which, when executed by a processor, implement the method of importing TRIRIGA base data according to any one of claims 1 to 4.