SimplyPats User Forum
http://www.simplypats.net/phpBB3/

megger 420 export csv too many spaces
http://www.simplypats.net/phpBB3/viewtopic.php?f=21&t=1081
Page 1 of 1

Author:  timbosss [ Tue Nov 22, 2016 5:59 pm ]
Post subject:  megger 420 export csv too many spaces

having exported from megger 420 in the csv format I note every entry has the model and serial number also masses of unused columns with nothing in them.
Is there a way to not export lots of empty asset address etc.
I see no need to print megger 420 and serial number 1600 times (my entries) once as a header should suffice?

Author:  richard [ Wed Nov 23, 2016 2:58 pm ]
Post subject:  Re: megger 420 export csv too many spaces

Hi timbosss

The CSV export from the Megger PAT420 is fixed and there is no way of suppressing individual columns which may be repeated. If you are opening the CSV with a spreadsheet you can obviously delete which columns you are not interested in.

When the CSV data is imported into Simplypats we obviously don't repeat the all the columns on the printed reports as like you say some things need only to be shown once in a header for example.

I assume you are not using either Megger Powersuite software or our SimplyPats software?

regards, Richard.

Author:  timbosss [ Sat Nov 26, 2016 11:05 am ]
Post subject:  Re: megger 420 export csv too many spaces

Hi Richard, thanks for your reply. Unfortunately I have just inherited the role on Severn Valley railway as a volunteer with no software purchase.
I import into excel and sit for hours removing columns.
Not wishing to spend the charities money I was scared off by Powersuite.
I will take a look at simplyPats.
Thank you

Author:  richard [ Mon Nov 28, 2016 1:45 pm ]
Post subject:  Re: megger 420 export csv too many spaces

Hi timboss

I believe Carl has emailed you some details regarding pricing of SimplyPats should you be interested. If you would like to discuss this further please send us an email or give us a ring.

Severn Valley is a wonderful preserved railway!

Regards, Richard.

Author:  timbosss [ Wed Nov 30, 2016 3:53 pm ]
Post subject:  Re: megger 420 export csv too many spaces

Yes thank you Richard and Carl.
Still a bit too much. Will have to continue manually deleting columns on excel.
Regards Tim

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/