Tagged with validation - Visokio Forums

Idea: Data Validation

benjamin — Tue, 21 Jul 2015 12:25:52 -0400

Hi

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?

Alfonso — Wed, 03 Jul 2013 06:28:01 -0400

Hi,

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?

Barcl — Tue, 07 May 2013 07:11:51 -0400

Hi - I need to check that a field contains only values formatted in a given way. For example we have a field which should contains values with the following format:
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",
(LEFT([Codice Monitoraggio],1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 2, 4))<"0000","Formato errato",
(MID([Codice Monitoraggio], 2, 4))>"9999","Formato errato",
(MID([Codice Monitoraggio], 6,1))<"A","Formato errato",
(MID([Codice Monitoraggio], 6,1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 7, 4))<"0000","Formato errato",
(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?

MartijnVisser — Wed, 09 Jan 2013 03:44:21 -0500

Hi - Is it possible to have Omniscope check if at least X rows exist before proceeding to the next block?

Best, Martijn