Today I was notified that my recent blog apab2xlsx – Generate Your Professional Excel Spreadsheet from ABAP is on the SDN home page.
I have updated the activities report and corrected a minor (or not such a minor) bug.
Previously the report used to submit numbers with dot as decimal separator. However, the web time report accepts comma as decimal separator. So, make sure you sent in previous uploads numbers decimals and not hundreds.
Ivan suggested that I added the functionality to fill in the selected rows with some same data. This is handy if you worked the whole month on just one project. Now, you do not have to fill in each single row of data with the same project name. You just select the rows, find the project combo box in the table under the rows section and choose the project. All the selected rows will obtain the value of the selected project.
To know more about the application and to download it follow this link:
Feel free to contact me in case of troubles, difficulties or found bugs. 🙂
Activities report manager is an Infopath solution which automates the work with the Techedge web time report. It is dedicated to my colleagues who work in Techedge.
This project was experimental. I wanted to discover deeper the functionalities of Infopath and the opportunities for creating automation applications.
The project could have been published a couple of weeks earlier, however, in the phase of final testing I discovered that it posted data on the web time report disregarding the month’s state. This means that basically it could submit data to the web time report for any period of any year. So, it took me some time to implement additional conditions to make the submitting of data available only for the open months.
How this works
Check the presentation video to see it in action:
For working with the application you need Infopath 2007 and .NET framework 2.0 installed. After the installation you will find an .XSN file which is an Infopath template. Based on it you can create new documents with your data (xml file).
If you liked the tool and wish to download it feel free to do it. We provide it free of charge. Use and enjoy!
here you can find a set of instructions on how to use the Time and Expenses Excel reports.
The Time Excel report can be found here:
The Expenses Excel report can be found here:
today I made some minor updates to TECHEDGE Time and Expense Excel reports. Basically, Ivan found out that from our Techedge office the timereport on the URL .it does not work. So, I just inserted a timeout of 30 seconds. Therefore, if you run a function of loading data on the web or updating the projects list, after 30 seconds it will throw an error if the ie is still busy.
So, now thanks to Ivan we eliminated one more bug. 🙂
These Excel reports are available at:
You might also want to see the previous post about the updates: