Customization and Integration

[SSCIT]

MAS500 v7.3

I have noticed that upon opening previously created Customizer code there are blocks of spaces that seem to have been inserted into random parts of the code.  Sometimes the spaces even end up inside assigned values for text variables.  Very frustrating.  The worst part, is that some blocks of spaces end up 100's of spaces long and begin to negatively impact the code.  I belive there are occasional CRs and LFs inserted as well.  Recently, I opened customizer, added one line of code, and when I tried saving I began getting errors unrelated to my addition.  The probelm was the phantom spaces and CRLFs added themselves to other subs and caused the code validation to fail.  It took me over an hour to go through everything and clean it up so it will run.

Are others experiencing this?  Is there a solution? 

Thanks for your input.

[LouDavis]

check out this thread to see if the issue is similar

http://community.sagemas.com/t5/Customization-and-Integration/Upgrade-to-7-30-and-Customizer/td-p/45...

[SSCIT]

Yep, read that before posting actually.  There didn't seem to be an resolution, though.  We started on 7.3 and all customizations were made directly in 7.3.  I believe that other user suspected her issues began in her upgrade from 7.2 to 7.3...

For me, it looks like the problem lies in 7.3.

My frustration is that the erroneous spaces and such occasionally either break my code or cause data to become inconsistent (I may set combobox items in customizer for data consistency, only to find 'same' values can have different number of spaces (reporting/query headache))

[LouDavis]

The original poster wound up using Notepad to clean up all his scripts in order to get them to work again.  Seems to have worked for him..

[SSCIT]

lol.  and using Notepad to review and clean up customized forms, many containing hundreds of lines of code spread across a dozen or more objects, is not much of a fix.  Especially when the spaces continue to get added (even subs that I have previously cleaned up continue to get infected - it's never ending...)

Is this corrected in 7.4?  Is this even a widespread issue or is it just a few of us that suffer from this?

[mateusstock]

Ive had code that would do that.

I use two things as a workaround:

First, I use Visual Studio with VB.NET to do all my coding, keeping all the original code in vb files. If anything happens I can revert to whatever I had before. The Visual Studio IDE is also really good to help you code! It even formats and intellisenses for you.

Second, I have a SQL script that runs on the Customizer tables to clean any  "bad" characters. It will usually do the trick.

[JohnHanrahan]

I actually wrote a quickie program to load scripts so I could review them (I read directly out of the database).  However it is something of a pain and I never finished the project.  It is definitely difficult to track your code in MAS once you have more than a few custom scripts.  Sage says that they are planning extensive enhancements to customizer (I forget whether it's the next version or the one after next). 

Good luck, notepad rocks!

John

[trodman]

I have the same problem with Customizer.  Our VAR did a customization for us using the scripting feature of Customizer on the View/Edit Vouchers screen.  Recently I tried using Customizer on that screen to change the tab sequence of two fields (never opened the Script Editor).  When I relaunch the screen I now get an error related to the scripting code.  Doesn't make sense that the scripting code would change when I never even opened the Script Editor screen.

[SSCIT]

Well, at least I know it's not just me

Thanks.