Conversion of data from a first file type to a second file type for use by a telecommunications equipment inventory system

A computer system that uploads information regarding telecommunications equipment inventory, comprising:

• a network interface;
• a processor that (I) receives a first data file that includes a plurality of categories of data regarding the telecommunications equipment inventory, the plurality of categories of data being arranged in a first format, wherein the first data file includes financial data related to the telecommunications equipment, the first data file being configured specifically for use in inventorying the telecommunications equipment for financial reporting, (II) extracts a subset of the plurality of categories of data, including extracting the subset from the intermediate data file, (III) converts the first data file to an intermediate data file of a third type, (IV) performs a logical operation to ensure that items in a field of the first data file are in a proper format, (V) arranges the subset into a second format that is different than the first format, (VI) creates a second data file of a second type configured specifically for use in inventorying the telecommunications equipment for physical location tracking, wherein:
• (a) the second data file has different content than the first data file, (b) the second data file is different than the first type, (c) the second data file contains the subset being arranged into the second format differing from the first format, (d) the second data file is arranged in a manner differing from a manner in which the first data file is arranged, (e) the first data file lacks data indicating a physical location of the telecommunications equipment, and (f) the second data file includes data indicating at least one physical location of the telecommunications equipment, (VI) uploads the second data file via the network interface as input into an inventory system that makes a determination about the telecommunications equipment based on the physical location of the telecommunications equipment, and (VII) in response to determining in performing the logical operation to ensure that items in the field of the first data file are not in the proper format, (a) records a current data line of an item being in an improper format to an invalid entries file arranged like the first data file is arranged and (b) uploads the invalid entries file via the network interface as input to the inventory system.

A computer-implemented method of uploading information regarding telecommunications equipment inventory, comprising:

• receiving a first data file that includes a plurality of categories of data regarding the telecommunications equipment inventory, the plurality of categories of data being arranged in a first format, wherein the first data file includes financial data related to the telecommunications equipment, the first data file being configured specifically for use in inventorying the telecommunications equipment for financial reporting;
• converting the first data file to an intermediate data file of a third type;
• extracting a subset of the plurality of categories of data, including extracting the subset from the intermediate data file;
• performing a logical operation to ensure that items in a field of the first data file are in a proper format;
• arranging the subset into a second format configured specifically for use in inventorying the telecommunications equipment for physical location tracking that is different than the first format;
• creating a second data file of a second type configured specifically for use in inventorying the telecommunications equipment for physical location tracking, wherein:
• the second data file has different content than the first data file;
• the second data file is different than the first type;
• the second data file contains the subset being arranged into the second format differing from the first format;
• the second data file is arranged in a manner differing from a manner in which the first data file is arranged;
• the first data file lacks data indicating a physical location of the telecommunications equipment;
• and
• the second data file includes data indicating physical location of the telecommunications equipment;
• uploading the second data file via a network interface as input into an inventory system that makes a determination about the telecommunications equipment based on the physical location of the telecommunications equipment;
• and
• in response to determining in performing the logical operation to ensure that items in the field of the first data file are not in the proper format:
• recording a current data line of an item being in an improper format to an invalid entries file arranged like the first data file is arranged;
• and
• uploading the invalid entries file via the network interface as input to the inventory system.