Tagged with datamanager - Visokio Forums http://forums.visokio.com/discussions/tagged/datamanager/feed.rss Mon, 30 Oct 17 15:47:37 -0400 Tagged with datamanager - Visokio Forums en-CA DataManager - Block size Change http://forums.visokio.com/discussion/3128/datamanager-block-size-change Fri, 20 May 2016 08:12:35 -0400 danshine07 3128@/discussions Performance: DataManager Aggregation block operation (2.9-Plus) http://forums.visokio.com/discussion/3011/performance-datamanager-aggregation-block-operation-2.9-plus Wed, 07 Oct 2015 16:34:17 -0400 mraburgess 3011@/discussions
It has been running for 2 days now yet is only using 6GB of my 64GB RAM (windows 10 pro, Xeon 8 core processor, Omniscope version 2.9 build 1765 (rc) [plus] x64)

Is there anything i can do to make aggregate use the available RAM more intelligently - i have other files use far more of the RAM, but always have this issue with aggregation.

thanks]]>
DataManager: Importing Data without columns headers http://forums.visokio.com/discussion/3027/datamanager-importing-data-without-columns-headers Tue, 10 Nov 2015 11:12:47 -0500 aknotts 3027@/discussions
We have a project where we are sent text files of raw data with no header row and we get a separate file which has the column headers in. I need to append the column headers to the top of the raw data so I can use it. I don't want to put a field organiser and manually go through and add the column names The assumption is that the order in the headers file is in the same order as the data.

Has anybody done this before and how did you get over it? I have attached a method I'm looking at but ideally I don't want to have to write out a file and read it back in again (especially as the files are in excess of 2million rows).

Thanks

Andy]]>
DataManager: Email Output only on Fridays? http://forums.visokio.com/discussion/2999/datamanager-email-output-only-on-fridayss Wed, 02 Sep 2015 10:25:28 -0400 benjamin 2999@/discussions
I would like this block to only publish on a specific day during the week. However the file refresh will run daily. Also the XML file after the file has refreshed and saves call another XML and I would like this to continue.

How do i get the email output block to only publish on a Friday?

I have tried custom validation in the Validate Data block and to fail if not a Fri, but such failure then stops the dependent XML running even if i don't have "propagate failure" in the XML.

Any advise would be appreciated

Thanks, Ben]]>
Unstructured Data transformation: Reading in Transactional data http://forums.visokio.com/discussion/2740/unstructured-data-transformation-reading-in-transactional-data Tue, 07 Oct 2014 07:41:48 -0400 freddiewalker 2740@/discussions I have some transactional data I would like to read into Omniscope if possible.. If not, any ideas of other programs/software I could potentially use would be appreciated.
I have attached an excel file with a few quick examples of the data (and its breakdown). Ideally I would like to read in each separate transaction into an amount of records that corresponds to how many products there are in that transaction. So for each product I would have date/time/payment method/units/value/multibuy information etc...

Would this be possible on Omniscope?
Many thanks.]]>