{"id":33021,"date":"2017-09-21T03:01:25","date_gmt":"2017-09-20T17:01:25","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=33021"},"modified":"2017-09-21T07:10:01","modified_gmt":"2017-09-20T21:10:01","slug":"spreadsheet-and-xml-global-substitution-accountability-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/spreadsheet-and-xml-global-substitution-accountability-tutorial\/","title":{"rendered":"Spreadsheet and XML Global Substitution Accountability Tutorial"},"content":{"rendered":"
\"Spreadsheet<\/a>

Spreadsheet and XML Global Substitution Accountability Tutorial<\/p><\/div>\n

Today we address some accountability improvements to the XML Global Substitution web application we last left off with at Spreadsheet and XML Global Substitution Genericization Tutorial<\/a>. You may recall, then, that we had a two step procedure of …<\/p>\n

    \n
  1. From filespec create CSV mapping (global_substitution.csv) for second part via section tags containing role=”paragraph” and old_label=”[OldLabel]” and label=”[NewLabel]” all before section tag end<\/li>\n
  2. From input index file and CSV above create Korn Shell (ksh) file that runs … ksh -x global_substitution.ksh … to update for new index file (but backup yourself first)<\/li>\n<\/ol>\n

    … where, if that sounds a bit new to you, that is because we bit the bullet, and renamed the web application with the more apt name “global_substitution” wherever, earlier on, we had the name “tr_mapping”. And this is a fairly big topic regarding “accountability”. To us, “accountability” is mainly about being able to revisit some software, work out what it does, and be confident to use it when and if and how it is applicable to an issue you have and\/or a job you want done.<\/p>\n

    “Accountability” with respect to any application goes hand in hand with listening to the client as to how their life can be made easier because of your application’s workings. With our XML “global substitution” work we’ve had quite a few user driven changes of recent times, and we decided to assemble them into a blog posting today. First off, what files are involved as inputs, where bold<\/b> parts are new since that last incarnation …<\/p>\n