Method and apparatus for generating CSV-formatted extract file

• US 7,925,662 B2
• Filed: 07/12/2004
• Issued: 04/12/2011
• Est. Priority Date: 07/11/2003
• Status: Expired due to Fees

• Current Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: McCullough, Peter G., Buckley, Frederick H., Gauthey, Philippe, van Kan, Jan
• Primary Examiner(s): Rones; Charles
• Assistant Examiner(s): ORTIZ DITREN, BELIX M
• Application Number:
  US10/889,231
• Publication Number:
  US 20050131928A1
• Time in Patent Office: 2,465 Days
• Field of Search: 707/769, 707/709
• US Class Current: 707/769
• CPC Class Codes: G06F 16/10 File systems; File servers

Abstract

Methods, systems, apparatus and computer-readable media are disclosed for generating extract files. A first example method is disclosed for generating an extract file. The method includes receiving a data request and analyzing the data request to identify at least one record of at least one file containing data associated with the data request. The method also includes extracting the identified records and formatting the identified records according to a comma separated value format. The method further includes outputting an extract file containing the formatted records. Other methods, apparatus, systems and computer readable media are disclosed for generating extract files.

Claims

1. A computer-implemented method for generating an extract file, comprising:

receiving a request to generate a non-proprietary file that includes a plurality of extracted records associated with a proprietary software application, and in response, requesting at least one proprietary file from a software tool;

receiving the at least one proprietary file from the software tool, the at least one proprietary file comprising the plurality of extracted records associated with the request, the proprietary file having an application specific format associated with the software tool;

formatting, using a processor the extracted records according to a comma separated value format; and

generating the non-proprietary file containing the formatted records.

2. The method of claim 1, wherein the at least one proprietary file includes a master control file.

3. The method of claim 1, wherein the at least one proprietary file includes a package file.

4. The method of claim 1, wherein the step of receiving the request includes receiving the request from a user.

5. The method of claim 1, wherein the step of receiving the request includes receiving the request from an application.

6. The method of claim 1, wherein the step of receiving the request includes receiving the request in a source coding language.

7. The method of claim 1, wherein the step of receiving at least one proprietary file includes calling an Application Programming Interface (API) to obtain one or more API responses containing the requested data.

8. The method of claim 7, wherein the step of formatting includes formatting the one or more API responses.

18. The method of claim 1, further comprising:

requesting that the extracted records be written to the proprietary file having the application specific format; and

determining the application specific format of the proprietary file.

20. The method of claim 1, wherein the software tool automates management of a software development process from initial design through distribution.

9. An apparatus for generating an extract file, comprising:

a processor;

a memory connected to said processor storing a program to control the operation of said processor;

the processor operative with the program in the memory to;

receive a request to generate a non-proprietary file that includes a plurality of extracted records associated with a proprietary software application, and in response, request at least one proprietary file from a software tool;

receive the at least one proprietary file from the software tool, the at least one proprietary file comprising the plurality of extracted records associated with the request, the proprietary extract file having an application specific format associated with the software tool;

format the extracted records according to a comma separated value format; and

generate the non-proprietary file containing the formatted records.

10. The apparatus of claim 9, wherein the at least one proprietary file includes a master control file.

11. The apparatus of claim 9, wherein the at least one proprietary file includes a package file.

12. The apparatus of claim 9, wherein the processor is further operative with the program in the memory to receive the request from a user.

13. The apparatus of claim 9, wherein the processor is further operative with the program in the memory to receive the request from an application.

14. The apparatus of claim 9, wherein the processor is further operative with the program in the memory to receive the request in a source coding language.

15. The apparatus of claim 9, wherein the processor is further operative with the program in the memory to call an Application Programming Interface (API) to obtain one or more API responses containing the requested data.

16. The apparatus of claim 15, wherein the processor is further operative with the program in the memory to format the one or more API responses.

19. The apparatus of claim 9, wherein the processor is further operative with the program in the memory to:

request that the extracted records be written to the proprietary file having the application specific format; and

determine the application specific format of the proprietary file.

21. The apparatus of claim 9, wherein the software tool automates management of a software development process from initial design through distribution.

17. A computer-readable storage medium encoded with processing instructions for generating an extract file, the processing instructions for directing a computer to perform the steps of:

receiving a request to generate a non-proprietary file that includes a plurality of extracted records associated with a proprietary software application, and in response, requesting at least one proprietary file from a software tool;

receiving the at least one proprietary file from the software tool, the at least one proprietary extract file comprising the plurality of extracted records associated with the request, the at least one proprietary file having an application specific format associated with the software tool;

formatting the extracted records according to a comma separated value format; and

generating the non-proprietary file containing the formatted records.