General Mon, 30 Oct 17 11:28:22 -0400 General en-CA Hosting Mobile Reports on Amazon EC2 Thu, 26 Oct 2017 15:49:33 -0400 MatthewLiddle 3271@/discussions
I am experimenting with hosting Omniscope Server on Amazon EC2 platform. However I was wondering if there is a step by step guide available?

I have managed to successfully set up an EC2 Instance and install Omniscope, however I'm struggling to 'see' the report from outside the EC2 Ecosystem. I'm keen to test 2.9 Server but also see how 3.0 performs

Does anyone have any advice (FYI I have created an instance using Windows server 2016)

On a separate note, how have people found the performance of EC2 at processing mobile reports? I like the idea of auto scaling if demand peaks


Thousands separator formatting : Commas in numbers Tue, 10 Oct 2017 05:49:51 -0400 Cheyam 3269@/discussions
Is there a way to stop Omniscope from putting commas in every single number field interpreted by every block in the application?

- I have an R block in which output_data contains a number of integer columns. When they are retrieved from the R dataframe and processed in Omni theyre all get given commas. There are too many fields of differing types to go in and manually remove the commas from each integer field.
- When you have integers over three digits and try merge with another field without commas in the numbers the ones with commas do not merge with the ones without commas.
- When I have this fairly simple formula:'=COUNTIF(A:A,A' & (CURRENTROW()+ 2) & ')' in a field organizer I am returned with =COUNTIF(A:A,A1,071). (I know its sloppy to inject excel formulae like this but bear with me)

If I asked colleagues of mine they would agree that the frustrations and issues caused by this feature are multiples of this. Is there any way this can be addressed? Commas in numbers is a display feature and shouldnt exist in the datamanager. A suitable solution would be to stop the application putting commas in all formulae by default.

Thank you,
Open and edit .iok files directly from browser in SharePoint 2013 Thu, 05 Oct 2017 09:14:59 -0400 saintmarino 3268@/discussions
In previous version of SharePoint 2007, they would simply open these files directly by clicking on them, making necessary changes, and saving them directly in SharePoint. However, this does not work in SharePoint 2013.

When users click the file, they get options to Save and Cancel, which does not serve the purpose. We have tried adding the file extension .iok and the MIME type "application/octet-stream" in IIS, and allowing the same to be opened directly from browser by running the following powershell script:-

$webApplication = Get-SPWebApplication "our web application name"

This does allow users to open the file directly in Omniscope, but they are unable to save the changes they make back to SharePoint. Kindly assist.

There is a second requirement, where we do not want to allow any other file type to be opened from browser other than .iok files. However, using the MIME type "application/vnd.visokio.omniscope-iok" does not work, we need to use "application/octet-stream". Any suggestions?]]>
SearchRegex Formula not working Mon, 18 Sep 2017 06:30:00 -0400 JohnMR 3267@/discussions
I'm trying to use Searchregex formula to pull

=searchregex("^.{3}[A-Za-z0-9 ]+\K.",[Campaing],1)

Searchregex usually works but not when I add the "\" in \K I get an error: Error with formula: Invalid text """ - an open bracket, literal number, reference or function was expected.

When I remove the slash the formula works but I need that slash in it. Why is this not working?
Exporting Pivot view data into xls Fri, 25 Aug 2017 08:14:37 -0400 enrico68 3265@/discussions
I followed what is indicated in the thread but I've been able only to extract the details of the elementary records that are the base for the pivot composition.

Is it possible to extract the data as shown in the pivot table?

Since the pivot table is very big I would like to avoid to use the method of selecting cells on the pivot and use the cut and paste option.

Job Opportunity Tue, 22 Aug 2017 10:31:28 -0400 aaronlewin 3264@/discussions
Anyone wanting more info, or who knows somebody who may be interested please contact:]]>
Batch Publishing: Dynamic Content in Message Bodies (2.8+) Tue, 13 Sep 2011 08:17:14 -0400 ddemarco 986@/discussions Omniscope Classic transition to 3.0 Tue, 08 Aug 2017 12:28:22 -0400 bfromson1 3263@/discussions
Datamanager 2 in classic used to be the way to do this.]]>
Value order for Text fields: Filter order/sorting Wed, 10 May 2017 06:08:55 -0400 luukvanm 3240@/discussions
What is the basic sorting for an filter? A customer of us wants to have the filter ordered alphabetically, I have found the option in the attachment to fix the ordering. But I was wondering, if a new value will be added to the filter, will this also be alphabetically sorted or will the new value be added at the last position in the filter?

Search and Replace: Large Amount of Data Mon, 31 Jul 2017 09:39:04 -0400 CarenaLi 3260@/discussions I am trying to do search and replace in my data,
e.g. in my data it shows "yt", then I need to replace it as "YouTube".

I have an Excel file of all short codes and their full names.
Is there any quicker way to do so?
Many thanks!
Data Manager: Exporting multiple *.iok files to *.xls Tue, 01 Aug 2017 07:36:58 -0400 tron05 3261@/discussions
My level of understanding Visokio is very basic. I have a limited use for visokio and am hoping a solution to the below stated problem exists. I use Visokio Omniscope 2.9 viewer.
Problem: A set of *.iok files are published to a folder. I need to export each of the .iok files to .xls and load the .xls files to a database.
Currently I go into each iok file and go through the general export process from File menu. I was wondering if there was a automated way to export all iok files to xls. Is it possible to automate the process with a batch script?
Thanks for any help!
Memory management: 32-bit limit exceeded on 64 bit machine? Fri, 13 Jul 2012 13:55:24 -0400 Alexander 1650@/discussions As it is in the command screen, and not in Omniscope itself, I cannot send an error report.

I attached a screenshot, if you need any additional info please let me know. Thanks!]]>
Category field data type consistency Mon, 19 Jun 2017 12:53:43 -0400 bernardpi 3252@/discussions
We are testing some reports against multiple data sets with the same structure (same fields) but different data points and believed that the "category" field data type applied to fields with a certain number of discrete text values (under 500?) - however, we are finding inconsistencies in the way these are interpreted with some fields being read as data type text and others data type category. We are querying from an ingres database if that helps.

Is there a way to guarantee the output data type value that then ultimately drives that type the filter is? Like some rules to follow? (Selectable options as opposed to text search boxes). We are finding that selecting category data type on the field is not enough if the data points underneath change.

Thanks for your help in advance]]>
Data Manager: Dates coming out wrong in a csv Fri, 16 Jun 2017 09:58:03 -0400 JohnMR 3251@/discussions I've created a file that has dates info. When I pull the dates in the UK format (dd/MM/yyyy) everything is fine but if I use the field organiser to change to US format (MM/dd/yyyy) the csv date column is half in dates (if you use show formula it's a number like 42045) but half is no dates (if you go to show formulas it's 02/10/2015). Why is this happening? It doesn't happen if I use UK dates.
Data Discordance caused by Google Analytics API Fri, 16 Jun 2017 04:57:49 -0400 CarenaLi 3250@/discussions
Thanks for reading this and hope you are well.

Recently we have experienced data discordance between the numbers pulled through Omniscope and the actual ones showing on Google Analytics.

Does anyone have the same issue?

Many thanks!]]>
DoubleClick and GA - "Server SSL error" Fri, 12 May 2017 06:53:08 -0400 JohnMR 3242@/discussions I've been running Omniscope reports through the DoubleCLick and Google Analytics for about a year now.
This week for the first time I keep getting "Server SSL error" when I try to update them.

Does anyone know why?
Thanks, John. ]]>
Flashtalking connector issues Fri, 03 Feb 2017 06:03:23 -0500 chris 3212@/discussions
The Flashtalking block is currently not working. This is due to an upgrade to the Flashtalking API. We have discussed this issue with Flashtalking and have implemented a fix. The fix is currently being tested in a private release, and will be integrated shortly.

Appologies for the inconvenience.

Data Visualisation: Stacking Bar Chart? Wed, 17 May 2017 05:59:22 -0400 MattBoxall 3244@/discussions
I'm trying to get a stacked chart to measure 3 stages of timeliness but I can't get it to work. I've attached an excel with a demo of the data and also a chart that to give you an idea, do you have advise? i would upload the iok but it's got too much sensitive data in it!]]>
Twitter report with more than 200 items? Sat, 06 May 2017 05:39:36 -0400 sherriff 3239@/discussions 3.0: New DoubleClick connector Fri, 28 Apr 2017 09:47:02 -0400 chris 3237@/discussions
We have now added a DoubleClick connector to Omniscope 3.

This connector contains all the functionality of the DoubleClick connector in Omniscope 2.9, with some improvements to performance and the authentication process.

If you would like to test this connector and/or you have some additional requirements for the new connector (for example adding support for additional report types). Please let us know.

Bar view label behaviour differs between desktop and mobile Fri, 21 Apr 2017 04:59:32 -0400 bernardpi 3229@/discussions ]]> Importing text file Wed, 22 Mar 2017 09:20:04 -0400 AndyDDUK 3223@/discussions I'm importing a text file (sources menu => data file).
On import, the data has not been delimited and so appears in one cell (per row).

I can see the 'text, delimited' option but not the means to specify exactly how the data has been delimited...

Please advise next steps

Many thanks,
Server Problem - "No linked source configured" Wed, 08 Mar 2017 06:41:53 -0500 JohnMR 3219@/discussions turning to refresh data with a server license but I keep getting the error "No linked source configured".
What does that mean?
John. ]]>
Functions : Excel Equivalent to TODAY() Mon, 20 Feb 2017 06:34:24 -0500 mttwnxn 3216@/discussions Batch export - Excel font settings Sat, 18 Feb 2017 13:25:38 -0500 enrico68 3215@/discussions I'd like to know if it's possible to create these files imposing a particular font (different from xlsx standard one).

This is because this automatically created xlsx files will be used to populate ppt documents passing specific data and these presentation will have to satisfy company defined standards.]]>
Salesforce data edit: Get Batch Results Tue, 07 Feb 2017 13:35:42 -0500 EricStewart 3213@/discussions
Salesforce open API for getting results back:]]>
Missing resources on website Fri, 27 Jan 2017 07:55:24 -0500 CRead 3208@/discussions
Console log:
Adblock etc. disabled on the page.
The first link returns a 404 status for me:

Just noticed as I had my console open from work elsewhere.]]>
Testing New Google AdWords Connector Mon, 12 Aug 2013 08:49:20 -0400 chris 2281@/discussions
We are now in a position to test a new Omniscope Google AdWords connector.

The Google AdWords API is quite large, and unfortunately we are not Google AdWords users ourselves, so before we start development we need to gather requirements and prioritise key functionality.

If a Google AdWords connector is something you would be interested in, and if you would be prepared to help us develop this connector, please tell us:

  • What would you like the connector to do? What types of reports do you want to download?
  • What options would you like to see? Please base this on other connectors such as GoogleAnalytics. The more specific the better, for example "A dropdown to select campaign", "A dropdown to select keywords" etc. We would like you to tell us how the Google AdWords connector should work.
  • Would you be able to help us out with development by arranging a short screen-sharing session and demonstrating how you use the Google AdWords online application? This will help us get a better understanding of the types of queries being undertaken on the Google AdWords platform and how these might translate to an Omniscope connector.
  • Are you able to provide us with a test account that we can use to develop the connector?

Once we have gathered enough requirements we will develop and deploy the connector. This will initially be made available only to users who have registered interest on this forum or who have contacted us privately. Once the connector has been sufficiently tested we will make it available to all Omniscope users.

Data Validation: Adding Leading Zeros Wed, 23 Nov 2016 10:45:42 -0500 aa1708 3190@/discussions Small visual bug in omni mobile + workaround Mon, 31 Oct 2016 14:59:46 -0400 CRead 3183@/discussions

I have the following CSS, which doesn't remove it:
* {overflow: hidden;}
html {overflow: hidden;}
body {overflow: hidden;}

(cut down from reality, but you get the idea).

I sometimes manage to remove it with jQuery (already in use in view):

$('.nested', window.parent.document).css({overflow: 'hidden'});

But that won't work if the iframe is on a different domain (for whatever reason). It also flashes up on load, even with the code at the top.

I could, of course, use the override css feature in 3.0, but I'm not able to use that for all files as of yet.]]>