Import CSV into SView

Post Reply
matt-c
Posts: 28
Joined: Wed Jul 06, 2016 3:54 pm

Import CSV into SView

Post by matt-c »

Are there any limitations with this?

I'm trying to pull in a CSV (sample below), it has around 180000 rows.
Get errors with SNet failing and if i do manage to get the file in it seems to not have all the data there.


TIME,rpm,map1,vehiclespeed,tps1,act1,vbat,ect1,fuelfinalpri1,fuelmltcll1,lam1,eot1,fp1,gear,eop1
0.000,1013.000,320.000,0.000,3.015,40.000,13.668,90.400,1.439,0.849,0.883,97.600,2.702,N,1.659
0.020,1006.000,323.000,0.000,3.015,40.000,13.706,90.400,1.439,0.849,0.886,97.600,2.702,N,1.659
0.041,999.000,326.000,0.000,3.125,40.000,13.728,90.400,1.439,0.849,0.889,97.600,2.702,N,1.659
0.067,990.000,329.000,0.000,3.125,40.000,13.723,90.300,1.436,0.849,0.893,97.600,2.706,N,1.640
RICE RACING
Posts: 448
Joined: Mon Feb 24, 2014 1:08 am

Re: Import CSV into SView

Post by RICE RACING »

If its a big file and assuming you have used an editor first to get it into the right format?
then its normal for it to hang up, what you have to do is let it do its thing, will eventually get there as it crunches through it I have found.
hang up.jpg
hang up.jpg (294.2 KiB) Viewed 3165 times
time.jpg
time.jpg (476.56 KiB) Viewed 3165 times
works eventually.jpg
works eventually.jpg (673.16 KiB) Viewed 3165 times
http://www.riceracing.com.au
https://www.youtube.com/riceracingdonmega
Real turbo road cars fast > reliable > durable
Water Injection Specialist
RICE RACING
Posts: 448
Joined: Mon Feb 24, 2014 1:08 am

Re: Import CSV into SView

Post by RICE RACING »

635,102 rows in that example ;) works fine *eventually*
http://www.riceracing.com.au
https://www.youtube.com/riceracingdonmega
Real turbo road cars fast > reliable > durable
Water Injection Specialist
matt-c
Posts: 28
Joined: Wed Jul 06, 2016 3:54 pm

Re: Import CSV into SView

Post by matt-c »

OK, that's promising that a larger file than mine works.

It's in CSV is there any other requirements for correct format?
RICE RACING
Posts: 448
Joined: Mon Feb 24, 2014 1:08 am

Re: Import CSV into SView

Post by RICE RACING »

Thankfully don't have to do too many but every now and then a clown rocks up with a Mowreck turd or other nugget that I have to take a look at and their software is so mega shit that I just have to go through this process :(

Just make sure you get rig of all the ID data at start, same for VBOX files, same process.
Can be things like too many numbers after a decimal point etc, just use find replace and you will smash through it pretty quickly.
I also like to delete irrelevant rows in Xcel too helps.

But yes its normal for it to show the message, just wait a while and it will come good on its own.
screenshot.1.jpg
screenshot.1.jpg (969.49 KiB) Viewed 3159 times
http://www.riceracing.com.au
https://www.youtube.com/riceracingdonmega
Real turbo road cars fast > reliable > durable
Water Injection Specialist
matt-c
Posts: 28
Joined: Wed Jul 06, 2016 3:54 pm

Re: Import CSV into SView

Post by matt-c »

Unfortunately every time i get the message that connection to Snet server has been lost and that the program will exit :?
stevieturbo
Posts: 1321
Joined: Sun Dec 07, 2008 2:04 pm

Re: Import CSV into SView

Post by stevieturbo »

importing .csv into Sview is a PITA.

And I think you manually need to select "time" first...and then in the next option manually click all the values you wish to import ? If you get that bit wrong I think it exits the way you say.
I struggled for ages when I first bought the Plex dash as I had hoped to use it to improve the logging on the S6...by using the Plex instead. But it was just a nightmare to get the .csv files into Sview I never bothered.
Then bought an S8 instead so I could have plenty of logging.

SView is superb, but for .csv and random log files I just use Megalogviewer
matt-c
Posts: 28
Joined: Wed Jul 06, 2016 3:54 pm

Re: Import CSV into SView

Post by matt-c »

Thanks Stevie, i will have a look at megalogviewer.

I'm getting my csv from RealDash, i managed to import one file, but it never worked since.
Post Reply