Topic: NBN Exchange Addin
Can I suggest a few changes to the NBN Exchange Addin if budget allows?
1. Automatically remove spaces from Grid Reference fields. This is something the R6 user interface seems to do, so when looking at Sample and Survey Event grid references they have no spaces, but the database fields behind them do. Spaces cause errors in the NBN Record Cleaner so it would be good to remove them in the Addin.
2. Provide a user option to automatically truncate the Comments field at 255 characters. Again the NBN Record Cleaner reports this as an error which currently means we have to open the extract file, search for all comments > 255 chars and truncate them manually. Although some users will want to shorten them 'intelligently' it would be nice to have a simple option to just chop them at 255 chars.
3. Provide a user option to remove all double-quote characters from the Comments field. Not only does the NBN Record Cleaner have problems if there are unmatched double-quotes, which is a pain if users have used a double quote to indicate inches (e.g. 6-8" long) but it seems the NBN Record Cleaner also doesn't like multiple sets of double quotes in the same Comment, even if they are matched. So an option to remove them all would be good.
Andy Foy Consulting