COMPUTER CODE GENERATION METHOD AND SYSTEM

• US 20080115105A1
• Filed: 11/10/2006
• Published: 05/15/2008
• Est. Priority Date: 11/10/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Garrett, Andrew John, Martin, James A.
• Granted Patent: US 8,028,270 B2
• Time in Patent Office: Days
• US Class Current: 717/106
• CPC Class Codes: G06F 8/30 Creation or generation of source code

Abstract

A software generation method and system. The method includes receiving by a computing system, a first data file including first data associated with an entity. The first data file includes a first file format. The first data file is converted to a second data file including a second file format. The second data file includes the first data. A data dictionary including second data is generated. Computer source code is generated within the data dictionary. The computer source code is generated from the second data. The computer source code is transferred from the data dictionary to an import agent source code editor of a software application.

Claims

1. A software generation method comprising:

receiving, by a computing system, a first data file comprising first data associated with an entity, said first data file comprising a first file format;

converting, by said computing system, said first data file into a second data file comprising a second file format, said second data file comprising said first data;

generating, by said computing system, a data dictionary file comprising second data;

automatically generating within said data dictionary, by said computing system, computer source code from said second data of said data dictionary file; and

transferring, by said computing system, said computer source code from said data dictionary to a software application, wherein said transferring comprises retrieving a copy of said computer source code from said data dictionary and transferring said copy into an import agent source code editor of said software application.

2. The method of claim 1, further comprising:

executing by said software application, said copy of said computer source code, said executing said copy of said computer source code comprising issuing a first command and a second command, said first command for retrieving a portion of said first data from said second data file;

automatically retrieving in response to said first command, by said software application, said portion of said first data from said second data file; and

processing in response to said second command, by said software application, said portion of said first data that has been automatically retrieved.

3. The method of claim 2, wherein said processing said portion of said first data comprises placing said portion of said first data into a document stored within said computing system.

4. The method of claim 2, wherein said processing said portion of said first data comprises performing a calculation on said portion of said first data.

5. The method of claim 1, wherein said first data file comprises a spreadsheet data file.

6. The method of claim 1, wherein said second data file comprises a comma-separated value file comprising a first set of columns and rows, wherein said data dictionary file comprises a spreadsheet file comprising a second set of columns and rows, and wherein each row of said second set is associated with a different column of said first set.

7. The method of claim 1, wherein said automatically generating comprises applying formulas to associated sections of said second data of said data dictionary file.

8. The method of claim 1, wherein said software application comprises a database software application.

9. The method of claim 1, wherein said computer source code comprises statements selected from the group consisting of DIM statements, parse statements, and field value assignment statements.

10. A computing system comprising a processor coupled to a computer-readable memory unit, said memory unit comprising instructions that when executed by the processor implement a software generation method, said method comprising:

receiving, by a computing system, a first data file comprising first data associated with an entity, said first data file comprising a first file format;

converting, by said computing system, said first data file into a second data file comprising a second file format, said second data file comprising said first data;

generating, by said computing system, a data dictionary file comprising second data;

automatically generating within said data dictionary, by said computing system, computer source code from said second data of said data dictionary file; and

transferring, by said computing system, said computer source code from said data dictionary to a software application, wherein said transferring comprises retrieving a copy of said computer source code from said data dictionary and transferring said copy into an import agent source code editor of said software application.

11. The computing system of claim 10, wherein said method further comprises:

executing by said software application, said copy of said computer source code, said executing said copy of said computer source code comprising issuing a first command and a second command, said first command for retrieving a portion of said first data from said second data file;

automatically retrieving in response to said first command, by said software application, said portion of said first data from said second data file; and

processing in response to said second command, by said software application, said portion of said first data that has been automatically retrieved.

12. The computing system of claim 11, wherein said processing said portion of said first data comprises placing said portion of said first data into a document stored within said computing system.

13. The computing system of claim 11, wherein said processing said portion of said first data comprises performing a calculation on said portion of said first data.

14. The computing system of claim 10, wherein said second data file comprises a comma-separated value file comprising a first set of columns and rows, wherein said data dictionary file comprises a spreadsheet file comprising a second set of columns and rows, and wherein each row of said second set is associated with a different column of said first set.

15. The computing system of claim 10, wherein said automatically generating comprises applying formulas to associated sections of said second data of said data dictionary file.

16. The computing system of claim 10, wherein said software application comprises a database software application.

17. The computing system of claim 10, wherein said computer source code comprises statements selected from the group consisting of DIM statements, parse statements, and field value assignment statements.

18. A computer program product, comprising a computer usable medium comprising a computer readable program code embodied therein, said computer readable program code adapted to implement a software generation method within a computing system, said method comprising:

receiving, by a computing system, a first data file comprising first data associated with an entity, said first data file comprising a first file format;

converting, by said computing system, said first data file into a second data file comprising a second file format, said second data file comprising said first data;

generating, by said computing system, a data dictionary file comprising second data;

automatically generating within said data dictionary, by said computing system, computer source code from said second data of said data dictionary file; and

transferring, by said computing system, said computer source code from said data dictionary to a software application, wherein said transferring comprises retrieving a copy of said computer source code from said data dictionary and transferring said copy into an import agent source code editor of said software application.

19. The computer program product of claim 18, wherein said method further comprises:

executing by said software application, said copy of said computer source code, said executing said copy of said computer source code comprising issuing a first command and a second command, said first command for retrieving a portion of said first data from said second data file;

automatically retrieving in response to said first command, by said software application, said portion of said first data from said second data file; and

processing in response to said second command, by said software application, said portion of said first data that has been automatically retrieved.

20. The computer program product of claim 19, wherein said processing said portion of said first data comprises placing said portion of said first data into a document stored within said computing system.

21. The computer program product of claim 19, wherein said processing said portion of said first data comprises performing a calculation on said portion of said first data.

22. The computer program product of claim 18, wherein said first data file comprises a spreadsheet data file.

23. The computer program product of claim 18, wherein said second data file comprises a comma-separated value file comprising a first set of columns and rows, wherein said data dictionary file comprises a spreadsheet file comprising a second set of columns and rows, and wherein each row of said second set is associated with a different column of said first set.

24. The computer program product of claim 18, wherein said automatically generating comprises applying formulas to associated sections of said second data of said data dictionary file.

25. The computer program product of claim 18, wherein said software application comprises a database software application.

26. The computer program product of claim 18, wherein said computer source code comprises statements selected from the group consisting of DIM statements, parse statements, and field value assignment statements.

27. A process for integrating computing infrastructure, comprising integrating computer-readable code into a computing system, wherein the code in combination with the computing system is capable of performing a software generation method comprising:

receiving, by a computing system, a first data file comprising first data associated with an entity, said first data file comprising a first file format;

converting, by said computing system, said first data file into a second data file comprising a second file format, said second data file comprising said first data;

generating, by said computing system, a data dictionary file comprising second data;

automatically generating within said data dictionary, by said computing system, computer source code from said second data of said data dictionary file; and

transferring, by said computing system, said computer source code from said data dictionary to a software application, wherein said transferring comprises retrieving a copy of said computer source code from said data dictionary and transferring said copy into an import agent source code editor of said software application.

28. The process of claim 27, wherein said method further comprises:

executing by said software application, said copy of said computer source code, said executing said copy of said computer source code comprising issuing a first command and a second command, said first command for retrieving a portion of said first data from said second data file;

automatically retrieving in response to said first command, by said software application, said portion of said first data from said second data file; and

processing in response to said second command, by said software application, said portion of said first data that has been automatically retrieved.

29. The process of claim 28, wherein said processing said portion of said first data comprises placing said portion of said first data into a document stored within said computing system.

30. The process of claim 28, wherein said processing said portion of said first data comprises performing a calculation on said portion of said first data.

31. The process of claim 27, wherein said first data file comprises a spreadsheet data file.

32. The process of claim 27, wherein said second data file comprises a comma-separated value file comprising a first set of columns and rows, wherein said data dictionary file comprises a spreadsheet file comprising a second set of columns and rows, and wherein each row of said second set is associated with a different column of said first set.

33. The process of claim 27, wherein said automatically generating comprises applying formulas to associated sections of said second data of said data dictionary file.

34. The process of claim 27, wherein said software application comprises a database software application.

35. The process of claim 27, wherein said computer source code comprises statements selected from the group consisting of DIM statements, parse statements, and field value assignment statements.