Self-service data importing

摘要

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.

主权项

1. 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.