CN108121818B

CN108121818B - Card holder basic information importing method

Info

Publication number: CN108121818B
Application number: CN201711475030.8A
Authority: CN
Inventors: 杨维国; 卢涛; 崔永刚; 李旭; 黄鹤飞; 刘焱; 朱永锋; 朱江漫
Original assignee: Newcapec Electronics Co Ltd
Current assignee: Newcapec Electronics Co Ltd
Priority date: 2017-12-29
Filing date: 2017-12-29
Publication date: 2022-01-28
Anticipated expiration: 2037-12-29
Also published as: CN108121818A

Abstract

The invention provides a method for importing basic information of a cardholder, which comprises the following steps: exporting a basic information data Excel template of a card holder to the local by an operation terminal; the operation terminal analyzes the selected Excel data into the data preparation system and imports the analyzed Excel data into a data preparation system intermediate library; and after the data preparation system audits the data imported into the intermediate library, importing the data into the formal library after the audit is passed. The process is more optimized, information is rapidly and accurately led into the data preparation system, the error rate is low, repeated rework and error correction are not needed, and the entry efficiency is improved.

Description

Card holder basic information importing method

Technical Field

The invention belongs to the technical field of traffic cardholder base information management, and particularly relates to a cardholder basic information importing method.

Background

The public transportation system in the city of the whole country is gradually interconnected and intercommunicated with a communication department, an application system in the public transportation industry is directly connected with a commission platform, and a commission level system is used for directly carrying out clearing and settlement processing on interconnection and intercommunicating transaction data. With the increasing access of public transportation systems in cities to clearing platforms of the department of transportation, in order to reduce the pressure of clearing platforms of the ministry of commission, the operation end is required to complete the import of the basic information of cardholders, and the batch import of the basic information of the transportation cardholders is to import the personal information of a business system into a data preparation system for subsequent statistics, modification and reference.

Disclosure of Invention

To address the above-mentioned issues, the following presents a simplified summary in order to provide a basic understanding of some aspects of the disclosed embodiments. This summary is not an extensive overview and is intended to neither identify key/critical elements nor delineate the scope of such embodiments. Its sole purpose is to present some concepts in a simplified form as a prelude to the more detailed description that is presented later.

The invention adopts the following technical scheme:

in some optional embodiments, a cardholder basic information importing method is provided, including: exporting a basic information data Excel template of a card holder to the local by an operation terminal; the operation terminal analyzes the selected Excel data into the data preparation system and imports the analyzed Excel data into a data preparation system intermediate library; and after the data preparation system audits the data imported into the intermediate library, importing the data into the formal library after the audit is passed.

In some optional embodiments, the cardholder basic information importing method further includes, before the method: the data preparation system performs data preparation.

In some optional embodiments, the process of data preparation by the data preparation system comprises: calling a key interface to obtain an authentication code; preparing data for all cards without prepared data to obtain a secret key; and associating the acquired key with the data.

In some optional embodiments, the method for importing the basic information of the cardholder further includes: and the operation terminal clears the data of the intermediate database of the basic information of the card holder.

In some optional embodiments, the cardholder basic information comprises: cardholder name, cardholder contact, card number, physical card number, and manufacturer name.

The invention has the following beneficial effects: the process is more optimized, information is rapidly and accurately led into the data preparation system, the error rate is low, repeated rework and error correction are not needed, and the entry efficiency is improved.

For the purposes of the foregoing and related ends, the one or more embodiments include the features hereinafter fully described and particularly pointed out in the claims. The following description and the annexed drawings set forth in detail certain illustrative aspects and are indicative of but a few of the various ways in which the principles of the various embodiments may be employed. Other benefits and novel features will become apparent from the following detailed description when considered in conjunction with the drawings and the disclosed embodiments are intended to include all such aspects and their equivalents.

Drawings

Fig. 1 is a flow chart diagram of a method for importing basic information of a cardholder according to the present invention.

Detailed Description

The following description and the drawings sufficiently illustrate specific embodiments of the invention to enable those skilled in the art to practice them. Other embodiments may incorporate structural, logical, electrical, process, and other changes. The examples merely typify possible variations. Individual components and functions are optional unless explicitly required, and the sequence of operations may vary. Portions and features of some embodiments may be included in or substituted for those of others. The scope of embodiments of the invention encompasses the full ambit of the claims, as well as all available equivalents of the claims.

As depicted in fig. 1, in some demonstrative embodiments, a cardholder basic information import method is provided, including:

101: the data preparation system performs data preparation. The data preparation system is used for preparing card issuing data for the bus card issuing platform, generating personalized card making data for each card, and safely providing the personalized card making data to the card making system for card making after the personalized data is safely processed.

The data preparation process of the data preparation system comprises the following steps:

firstly, calling a key interface to obtain an authentication code, and calling the key interface for the first time every day to update the authentication code;

secondly, preparing data for all cards without prepared data to obtain a secret key;

and finally, associating the acquired key with the data, and completing the data preparation process after associating the data after acquiring the key data.

102: and importing the corresponding relation between the physical card number and the card number, and acquiring the card number according to the physical card number when washing the card.

103: the operation terminal exports the basic information data Excel template of the card holder to the local, and the operation terminal is a computer used by a worker.

104: the operation terminal empties the intermediate database of the basic information of the card holder, and the intermediate database is emptied before importing the data each time.

105: and the operation terminal analyzes the selected Excel data into the data preparation system and imports the analyzed Excel data into a data preparation system intermediate library.

106: and after the data preparation system checks the data imported into the intermediate library, the data is imported into a formal library after the data is checked, and the operation of importing the basic information of the card holder is completed.

The basic information of the cardholder comprises: cardholder name, cardholder contact, card number, physical card number, and manufacturer name.

Those of skill would further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the overall system. 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 disclosure.

Claims

1. The method for importing the basic information of the cardholder is characterized by comprising the following steps:

exporting a basic information data Excel template of a card holder to the local by an operation terminal;

the operation terminal analyzes the selected Excel data into the data preparation system and imports the analyzed Excel data into a data preparation system intermediate library;

the data preparation system checks the data imported into the intermediate library and then imports the formal library after the data are passed through the check;

the method for importing the basic information of the cardholder comprises the following steps: the data preparation system performs data preparation;

calling a key interface to obtain an authentication code;

preparing data for all cards without prepared data to obtain a secret key;

associating the acquired key with data;

the operation terminal clears the data of the intermediate database of the basic information of the card holder;