http://forums.visokio.com/discussions/tagged/csv/feed.rss Mon, 30 Oct 17 12:15:27 -0400 Tagged with csv - Visokio Forums en-CA http://forums.visokio.com/discussion/3257/data-preparation-csv-cell-separator-more-than-1-character Tue, 18 Jul 2017 12:38:49 -0400 JamesPC 3257@/discussions ;%#£
then the likelihood of this appearing in the data is substantially smaller than a "," appearing.]]> http://forums.visokio.com/discussion/3251/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.
Thanks,
John.]]> http://forums.visokio.com/discussion/2951/google-adwords-importing-their-csv-output-into-omniscope Mon, 08 Jun 2015 06:50:51 -0400 daniel 2951@/discussions
The csvs won't load just by dragging and loading in the DataManager space and results in the data coming out with weird symbols. This is because the csvs follow a different set of encoding, you will have to amend this by selecting "UTF-16LE" and change the separator value to "\t". Also make sure to set the Header row accordingly (should be 6, this may vary).

See image below for what the configuration looks like, you can use the "Batch Append File" too but do check to make sure that the header rows are always on the same row number for each file.



]]> http://forums.visokio.com/discussion/2474/export-remove-thousands-separator-when-outputting-csvs Thu, 20 Feb 2014 11:28:21 -0500 joshlk 2474@/discussions
foo,boo,"10,000",16

When outputting CSVs from Omniscope, could there please be a option which removes the thousand separator in numbers so that quoting the numbers to enclose the separator commas within a comma de-limited file is not necessary?

Thanks]]> http://forums.visokio.com/discussion/2797/exports-need-csv-with-cell-quotes-but-dont-see-cell-quotess Fri, 19 Dec 2014 12:51:07 -0500 tjbate 2797@/discussions http://forums.visokio.com/discussion/2418/export-view-data-from-browser-versions Wed, 04 Dec 2013 12:40:26 -0500 richard 2418@/discussions
To enable this functionality for all files, launch Omniscope Server and navigate to Mobile Web Server > Config > Default folder configuration > Edit > Anonymous permission > Edit. On the permissions dialogue box (shown below) turn on Export view data.



All views will now display a button for exporting their underlying dataset. The output dataset will respect any aggregation settings configured in the view.

]]> http://forums.visokio.com/discussion/2400/performance-importing-from-csv...any-memory-guideliness Fri, 08 Nov 2013 12:59:58 -0500 cmollo 2400@/discussions
I have read other posts about users processing more than 5.4 million records, so I think it is quite possible for Ominscope to process this large file I have, right?

I have also read http://www.visokio.com/kb/omniscope-memory-allocation.

My main question is: are there any guidelines on how much memory Omniscope needs as a function of records/fields. I realize this is probably one of those many "it depends" situations, but even rough guidelines (+/- 1 or 2 GB) would help.

If there are no guidelines, can I send you my .iok file (there are only 6 blocks: a File Source block, 3 Field Organizer blocks, a Record Filter block, and a Expand Values block) and a sample of the input file, which you can expand to about 5 million records (or I can ftp the whole file), and you can run it and let me know how much memory Omniscope uses?

Thanks! Chris
]]> http://forums.visokio.com/discussion/788/data-locale-float-localization-when-importing-from-csv Mon, 23 May 2011 05:24:52 -0400 fjuan 788@/discussions
I'd like to merge data into an omniscope file from a CSV file with this format:

product, code, sales
cofee, code_01, 1234.56
te, code_01, 78.9

Everything goes perfect when I'm using the English locaized version but number's are not correctly imported on the Spanish one as the dot is completly ignored

Is there an CSV standard format that visokio understand in any localization?

Thanks in advance
Francisco ]]>