blog

iMIS Community going away?

It's been announced that iMIS Community will be frozen at the end of the year, and will be retired at some point in the future. I find this very discouraging, as I refer to the site about 4-5 times a week. There's a wealth of important knowledge here that doesn't seem to exist in the documentation. (The docs even refer to this site in places.)

There's not a lot of new activity, but I'm not sure that's a good measurement of its usefulness. The posts that are already here cover a lot of important fundamentals. Some main areas that I visit often:

IMIS Desktop AR/Cash Crystal Report Errors

As of today (9th August) the iMIS desktop throws errors when running AR/Cash crystal reports. The errors are similar to "Exception: Source=ASICrystalCtrl Name=CrystAX_InitReport Msg=Object Variable or With block variable not set"
This seems to have impacted iMIS versions from 15.2 to 20.2. and applies to those crystal reports with parameters, including trial balance; AR Statements; AR invoices. UPDATE - As at start of day 10th August the issue is no more - confirmed on iMIS 15.2 and iMIS 20.2.

Automated Banking Reconciliations

Client wants to be able to automate bank reconciliations. Download statements from banks; upload into iMIS and automatically receipt against open invoices or create unapplied transactions against member accounts in ARCash, Dues, Events and Orders.

This is a common requirement for several clients in iMIS20-300 but only now do we have the funding to go ahead and build a generic .Net module as an add-on to the Staff View to accomplish this. We want the solution to be reusable for other clients across Australia/NZ. Before we finalise the specs let me know if you might have any interest in this functionality. We will have the specs finalised by end of June 2016. Below is a high-level plan of the functionality -

ASITableSizes stored procedure

As the name suggests, here's a stored procedure that will sort all the tables in a database by row count descending, then data size, then index size.   It's handy for looking for unusually large  tables and indexes.  Once you've created the stored proc using the attached script, invoke it like this:

ASITableSizes

Sample results:

Search all uniqueidentifier columns in a database for a value

*

*

*

THIS CONTENT MOVED TO Developer Resources and is NOT CURRENT.

*

*

*

Another variation on http://www.imiscommunity.com/search_all_datetime_columns_in_a_database_f...

...for those times you need to find occurrences of a GUID value in the database.  The attached script also includes a query for the special case of the value in the ParameterValue column of the SystemConfig table.

Once you've created the stored proc, invoke it like this, for whatever value you need:

SearchAllTables_uniqueidentifier '8E5C7C1D-170B-4294-B646-2E60D2091DF8'

Sample results:

Issue with Custom Business Objects and Panel Editor

Hi there,

Have come across what I believe to be an issue with how the Panel Editor handles custom business objects vs standard business objects (automatically generated based on User Defined tables). This may or may not be a bug - it may be a limitation around custom business objects in general. What I would like to know is if anyone else has come across this and what your solution was.

iBO PayDues Method No Longer Updating Trans.BT_ID but Trans.ST_ID is Populated

Normal
0

false
false
false

EN-US
X-NONE
X-NONE

Hi All,

But I'm sure myname+@mydomain.com is a valid email address.

Fielded a recent SMR regarding an unusual email address with a "+" (plus sign) in it right before the @. Henry suggested my response would make a good iMISCommunity.com article.

This is not a bug but is working as designed and documented. The iMIS documentation says the default regex allows “+” as long as it’s followed by an alphabet character, a number, or “_”, i.e. [a-zA-Z0-9_]. The regex is there and editable so clients can customize it. http://help.imis.com/20.2/Understanding_iMIS_Features/Staff_Settings/Contacts.htm
There are lots of “valid” email address rules and validators, and lots of disagreement on what those valid rules are. The Internet Engineering Task Force (IETF) RFC 2822 is pretty much the definitive source.

Everywhere has unique email rules that don’t allow certain characters.
Gmail doesn’t allow “-“ (dash) in the name portion (local-part) of an email address but AT&T does.
AT&T doesn’t allow “.” in the name portion (local-part) but Gmail does.
I bet neither allows a “+” at the end or a name, if they allow “+” at all. I confirmed that Gmail doesn't allow it. Gmail allows "letters (a-z), numbers, and periods" only.

  http://www.imiscommunity.com/system/files/email_with_plus.png

The default regex expression could be adjusted to remove the requirement that the name part have at least 1 [a-zA-Z0-9_] after a special character.

2 regex strings I found for email that seem more all-inclusive are below:

^(?!\.)("([^"\r\\]|\\["\r\\])*"|([-a-z0-9!#$%&'*+/=?^_`{|}~] |(?@[a-z0-9][\w\.-]*[a-z0-9]\.[a-z][a-z\.]*[a-z]$
http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-address-until-i.aspx Seems like there might be issues with this one. Seems to be missing some “)s” but my regex mojo is not what it used to be.

So here is one from Microsoft.
^(?(")(".+?(?<!\\)"@)|(([0-9a-z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-z])@))(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-z][-\w]*[0-9a-z]*\.)+[a-z0-9][\-a-z0-9]{0,22}[a-z0-9]))$
https://msdn.microsoft.com/en-us/library/01escwtf(v=vs.110).aspx

both assume RegexOptions.IgnoreCase are on.

Remove hiberfil.sys to save diskspace

If you are short on disk and don't use or just don't like Windows Hibernation Mode, you can turn if off and save the disk space used by hiberfil.sys. This is a file that Windows reserves on your C:\ drive that equal to the amount of RAM you have so that it can store your machine's state. You can't otherwise delete this file, Windows either won't let you or will put it back. We have found getting rid of file particularly helpful on VMs where the hibernation option is essentially useless. Here's how ...

Staff view - Activities recording

Client has a need to record the activity author against the activity, when adding an activity via staff view.
When adding an activity via Desktop, the author is by default entered into the SOURCE_CODE field, but not so when adding an activity via staff view.
Has anyone got a solution? Or a workaround?

Syndicate content