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
Thanks
]]>
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,
Chey]]>
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"
$webApplication.AllowedInlineDownloadedMimeTypes.Add("application/octet-stream")
$webApplication.Update()
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?]]>
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?
Thanks,
John.]]>
I followed what is indicated in the thread http://forums.visokio.com/discussion/comment/10597/#Comment_10597 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.
]]>
Anyone wanting more info, or who knows somebody who may be interested please contact:
shoaib.ahmed@mediacom.com]]>
Datamanager 2 in classic used to be the way to do this.]]>
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?
Thanks,]]>
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!
Carena]]>
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!
]]>
I attached a screenshot, if you need any additional info please let me know. Thanks!]]>
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]]>
Thanks,
John.]]>
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!]]>
This week for the first time I keep getting "Server SSL error" when I try to update them.
Does anyone know why?
Thanks, John. ]]>
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.
Chris]]>
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!]]>
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.
Chris]]>
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,
Andy]]>
What does that mean?
Thanks,
John. ]]>
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 open API for getting results back:
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_batches_get_results.htm]]>
Console log:
Adblock etc. disabled on the page.
The first link returns a 404 status for me:
http://tc.visokio.com/modules/book/book.css
Just noticed as I had my console open from work elsewhere.]]>
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.
Chris]]>
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.]]>