Tagged with validation - Visokio Forums http://forums.visokio.com/discussions/tagged/validation/feed.rss Mon, 30 Oct 17 18:51:43 -0400 Tagged with validation - Visokio Forums en-CA Idea: Data Validation http://forums.visokio.com/discussion/2974/idea-data-validation- Tue, 21 Jul 2015 12:25:52 -0400 benjamin 2974@/discussions
I'm a using the data validation block in omniscope and it would be useful for the following:

1.To have the ability to have more than one custom rule
2.To be able to link rules broken or custom rules defined to specific reports emailed.

For instance currently (unless you use Error,Success and warning as separate flags for email reports then you have three) you cannot trigger a certain email report by a specific custom/schema/rules failed.It would be useful to say for instance if you have two column a list of names and values, if values >1000 and names is blank to be emailed separately

Of course i can add in multiple validation blocks however if you are doing 10+ validation this makes data manager look messy

My idea would be to have either a numbering scheme or name for each of the custom rules, rules, schema and then in the reporting each email categorized could specify which numbered or named custom rule or schema it should be triggered by

Thanks


]]> Refresh: Maintaining value sort orders/shapes? http://forums.visokio.com/discussion/2224/refresh-maintaining-value-sort-ordersshapess Wed, 03 Jul 2013 06:28:01 -0400 Alfonso 2224@/discussions
I'm using Data > Manage Fields > {field options}> Value order colours & shapes

It works fine during a session, but when I do data refresh the order disappear, and also the colours and shapes settings, because new data comes in. (I'm using a cache deletion in the data refresh...)

Is there any method to maintain the order and marker shape settings I made before the refresh?.

Thanks in advance, Alfonso]]> Validation: Formulae to validate incoming value format in a field? http://forums.visokio.com/discussion/2126/validation-formulae-to-validate-incoming-value-format-in-a-fields Tue, 07 May 2013 07:11:51 -0400 Barcl 2126@/discussions byte 1 should be alphabetic
bytes 2-5 should be numeric
byte 6 should be alphabetic
bytes 7-10 should be numeric

In order to verify that format I created a new field with the following formula:

IF ([Codice Monitoraggio]=null,null,
LEN([Codice Monitoraggio])!=10,"lunghezza errata",
(LEFT([Codice Monitoraggio],1))<"A","Formato errato",<br /> (LEFT([Codice Monitoraggio],1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 2, 4))<"0000","Formato errato",<br /> (MID([Codice Monitoraggio], 2, 4))>"9999","Formato errato",
(MID([Codice Monitoraggio], 6,1))<"A","Formato errato",<br /> (MID([Codice Monitoraggio], 6,1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 7, 4))<"0000","Formato errato",<br /> (MID([Codice Monitoraggio], 7, 4))>"9999","Formato errato",
null
)

I was wandering if I can find a better way to verify those values.

Do you believe it is possible to use a JavaScript based on Regular Expressions (RegEx) with the match function? I'm not a Javascript expert... I was trying to find a PHP ereg equivalent in Java?

Thanks.]]> Validate Data: proceed only if minimum number of rows exist? http://forums.visokio.com/discussion/1973/validate-data-proceed-only-if-minimum-number-of-rows-exists Wed, 09 Jan 2013 03:44:21 -0500 MartijnVisser 1973@/discussions
Best, Martijn]]>