US 9,519,887 B2Granted

Self-service data importing

AssigneeBank of America Corporation

InventorsNorman Hennessy, Amitha Kshirsagar, Gustavo A. Liriano

Life of this patent

Estimating the term…

Loading patent…

Abstract

Aspects of the disclosure relate to methods, systems, and apparatuses for self-service data importing. In some aspects, a user may interact with a data importing server to import data into a database and/or manipulate existing data and/or data associations in the database. The data importing server may contain files or scripts of different specifications or processes to perform for a plurality of predefined jobs. The user may interact with the data importing server via a user interface. The user interface may outline each step in the process and enable steps only after the user has completed a previous, prerequisite step. The user interface may provide user selectable buttons to input user commands, and the user selectable buttons may initially be disabled and become enabled after the user or the system performs the corresponding prerequisite step.

Claims20

Dependent claims

A method, comprising:

presenting, by a computing device, a list of predefined jobs to a user;
enabling user selection of a job to execute from the list of predefined jobs;
receiving user input selecting a job to execute from the list of predefined jobs;
loading requirements from a script stored in the computing device and specifying parameters for the selected job;
determining, based on the script and a job type, whether the selected job requires an input file based on stored requirements for the selected job;
in response to determining that the selected job requires an input file, enabling selection of an input file;
receiving a user selection of an input file;
determining whether the input file is valid for the selected job including validating a file name and file type of the input file;
receiving a user command to execute the selected job in a test environment;
in response to receiving the user command and validating the file name and file type of the input file, loading the input file, sending the input file to a server in the test environment, and initiating execution of the selected job in the test environment;
after initiating execution of the selected job in the test environment, enabling user certification that the executed job and selected input file passed at least one test in the test environment;
receiving user certification that the executed job and selected input file passed the at least one test in the test environment;
and
after receiving the user certification, sending the input file to a real-time production environment different from the test environment and initiating execution of the selected job in the real-time production environment.

11 more elements

An apparatus, comprising:

at least one processor;
and
a memory storing computer-readable instructions that, when executed by the at least one processor, cause the apparatus to:
present a list of predefined jobs to a user;
enable user selection of a job to execute from the list of predefined jobs;
receive user input selecting a job to execute from the list of predefined jobs;
loading requirements from a script stored in the apparatus and specifying parameters for the selected job;
determine, based on the script and a job type, whether the selected job requires an input file based on stored requirements;
in response to determining that the selected job requires an input file, enable selection of an input file;
receive a selection of an input file;
determine whether the input file is valid for the selected job including validating a file name and file type of the input file;
receive a user command to execute the selected job in a test environment;
in response to receiving the user command and validating the file name and file type of the input file, load the input file, send the input file to a server in the test environment, and initiate execution of the selected job to in the test environment;
after initiating execution of the selected job in the test environment, enable user certification that the executed job and selected input file passed the at least one test in the test environment;
receive user certification that the executed job and selected input file passed the at least one test in the test environment;
and
after receiving the user certification, sending the input file to a real-time production environment and initiating execution of the selected job in the real-time production environment.

14 more elements

One or more non-transitory computer-readable media having computer-executable instructions stored thereon that, when executed, cause at least one computing device to:

present a list of predefined jobs to a user;
enable user selection of a job to execute from the list of predefined jobs;
receive user input selecting a job to execute from the list of predefined jobs;
loading requirements from a script stored in the at least one computing device and specifying parameters for the selected job;
determine, based on the script and a job type, whether the selected job requires an input file based on stored requirements for the selected job;
in response to determining that the selected job requires an input file, enable selection of an input file;
receive a user selection of an input file;
determine whether the input file is valid for the selected job including validating a file name and file type of the input file;
receive a user command to execute the selected job in a test environment;
in response to receiving the user command and validating the file name and file type of the input file, load the input file, send the input file to a server in the test environment, and initiate execution of the selected job in the test environment;
after initiating execution of the selected job in the test environment, enable user certification that the executed job and selected input file passed at least one test in the test environment;
receive user certification that the executed job and selected input file passed the at least one test in the test environment;
and
after receiving the user certification, send the input file to a real-time production environment and initiate execution of the selected job in the real-time production environment.

11 more elements

Dependencies are inferred from the claim text.