• ExcelIntegrationAhDevNotes

Excel Integration - AH Development Notes

• Back

Development Sessions

2010-03-10

• Exported all mod*.bas file, cleaned up the formatting and reloaded them into Lib, which I checked back into CVS.
• Formatting conventions notes:
  • Added header with module name, project name, CVS ID tage at the start of each module

  • Added end comment at the end of each file

  • Use 2-spaces for indentation
  • When lines are continued, then indent to match preceding line or indent 4 spaces
• Next up:
  • Cleanup background colors in layout
  • Fix writing of user defined fields and title columns
  • Start implementing formulas

2010-03-11

Questions for lunchtype Skype session

1. Is there a any particular reason that statement Attribute VB_Name = "modXmlUtils" appears at the very start of the module? Can it be after the function header and CVS tag? Answer: automatically placed by VBA.

2. A user's login can expire from the server side, due to a timeout. What do we do on the client side? Should we maintain a variable contain the time that the login was last checked and then explicitly check with the server to see the user is still logged in if the time is more than x hours ago? Answer: Yes, we need to deal with this.

Changes

1. Lib Bau2-Header: Fixed //userDefinedFields/name --> /record/userDefinedFields/name

2. Lib Bau2-Header: Fixed verteiler user defined fields names with RevA, which should have been RevB or RevC

3. modHeader processHeader: Added case for FIELD_USER_DEF, with same code as FIELD_DIRECT

4. Lib RevA, RevB, RevC -header: change col A userDefinedField/name --> userDefinedField

Check-in 13:00

1. Baseline: Able to read '7119' test case data including, including the display of all user defined fields for all revisions.
2. Update fails due to server side validation errors. It also appears that the RevC revisioTypeId field updated in the database when it shouldn't

2010.03.12

1. Lots of Wiki updates. I have verified the Requirements and Use Cases against our specification document, and can confirm that 99% of the stuff need for a dirst deliver is now in our Wiki page.

2. Added REST processing for prozessStatus, which contains all entries for the status menus (and the menu list ids)

   • Path is: attributes/prozessStatus/list?format=xml
3. Made changes to Lib, checking in two versions. The changes are:

   • r1.26 - Changed the search form layout and added missing fields (it's now really big

   • r1.15 - Leaned up the Bau2 layout, the merged cells were corrupted.

Note that I did not export this with CodeClean, so I suggest you do not import prior to starting work. I note that CodeClean gives me files like Tabelle1, and I suspect there are some language issues. We'd better discuss this to make sure we never overwrite changes or lose updates.