PLW to CSV Converter (Bulk)

Post your .Net discussions here
Sanjay
User
User
Posts: 3
Joined: Mon Jun 20, 2016 1:08 pm

PLW to CSV Converter (Bulk)

Post by Sanjay »

Locates all PLW files in a specific and converts whole folder
It can also be set to convert only 1 file.

Output is generated inside the same folder as the PLW file.

This application is provided as is and can be downloaded via our PicoApps page.

bilaltm
Newbie
Posts: 0
Joined: Fri May 12, 2017 4:11 am

Re: PLW to CSV Converter (Bulk)

Post by bilaltm »

Hi Sanjay,

Is it possible to post a sample code to convert the PLW file to CSV. I know you have a console app, but I need to integrate this code with another application. Appreciate if you can help me on this.

Thanks
Bilal

Hitesh

Re: PLW to CSV Converter (Bulk)

Post by Hitesh »

Hi Bilal,

What is it that you are looking to do with the data once it has been converted to csv file format?

Regards,

bilaltm
Newbie
Posts: 0
Joined: Fri May 12, 2017 4:11 am

Re: PLW to CSV Converter (Bulk)

Post by bilaltm »

Hi Hitesh,

My client wants to record all alarm into a database so that they can take a report of how many alarms raised and how long etc.,

Thanks
Regards
Bilal

Kroqy26
Newbie
Posts: 0
Joined: Mon May 22, 2017 8:44 pm

Re: PLW to CSV Converter (Bulk)

Post by Kroqy26 »

Hi,

I too would like to be able to convert the PLW file either through Excel or via an independent program. I would like to run a macro in Excel or similar to control the conversion program. At the moment as Bilal says it doesn't allow automated input.

Is there a way for example of converting all plw files to csv within the root folder upon running the converter program. This way we could control via vba or vb. Net to open the converter in the background, it runs the converter and then take the csv information and run additional code to format the data further or add to a database.

Our IT department won't allow me to install the sdk so I am unable to develop myself.

Any help for both of us would be great. Any ideas how I can achieve the above result without installing the sdk

Hitesh

Re: PLW to CSV Converter (Bulk)

Post by Hitesh »

Hi Kroqy26,

At the moment we do not have anything that could do what you are looking to undertake. Could you please e-mail support@picotech.com and we can discuss this further.

Thanks,

fmassetti
Newbie
Posts: 0
Joined: Fri May 04, 2018 10:26 am

Re: PLW to CSV Converter (Bulk)

Post by fmassetti »

Hi,

I would like to know if it is possible to customize the output of this app. At the moment the output I am getting in my csv files contains lot of information I don't need (PLW Converter Version, PLW File Header Version, Date of Test, Number of Channels, Last Sample Number and Sample Interval) but it doesn't have things I need like the name I gave to the channels which is usually present in the standard PicoLog text output.

Hitesh

Re: PLW to CSV Converter (Bulk)

Post by Hitesh »

Hi fmassetti,

This app was produced by a former colleague and hasn't had any major changes since.

Which device are you using? If you are using the PicoLog 6 software, the csv export feature will capture the channel names, although there isn't a bulk conversion utility. The PicoLog 6 software also uses a file format that is different to that used with PicoLog 5.

Regards,

fmassetti
Newbie
Posts: 0
Joined: Fri May 04, 2018 10:26 am

Re: PLW to CSV Converter (Bulk)

Post by fmassetti »

Hi Hitesh,
Thank you for you answer, I am using the PicoLog 6 software with a TC-08 Thermocouple Data Logger. I am aware of the possibility of using the software to obtain the CSV files with the channel names but I have hundreds of files to process and convert them singularly would require quite some time.
I am working on R so my only alternative would be to import the PLWs directly. Do you know any package that could do that for me?

Hitesh

Re: PLW to CSV Converter (Bulk)

Post by Hitesh »

Hi fmassetti,

I've checked the application and it will output the channel names.

I've updated it so that by default the settings are not printed (call the application with the -s flag to do this) - it should be available via the webpage later on today (version 1.0.1.0).

Hope this helps,

fmassetti
Newbie
Posts: 0
Joined: Fri May 04, 2018 10:26 am

Re: PLW to CSV Converter (Bulk)

Post by fmassetti »

Hi Hitesh,

Now the application works perfectly! Thank you very much!

Hitesh

Re: PLW to CSV Converter (Bulk)

Post by Hitesh »

Brilliant! Glad to hear its working. :D

fmassetti
Newbie
Posts: 0
Joined: Fri May 04, 2018 10:26 am

Re: PLW to CSV Converter (Bulk)

Post by fmassetti »

Good day,

I am having problems to convert part of my PLW files.
After reading part of the measurements for some files the program shows the error "Index was outside the bounds of the array". For each file for which the program gives this message I am not obtaining any output.
Is there any way to obtain the converted file?
I am attaching examples of a couple of the "problematic" PLWs
Attachments
238H.PLW
(22.27 KiB) Downloaded 740 times
237H.PLW
(22.27 KiB) Downloaded 748 times

AndrewA
PICO STAFF
PICO STAFF
Posts: 401
Joined: Tue Oct 21, 2014 3:07 pm

Re: PLW to CSV Converter (Bulk)

Post by AndrewA »

Regards Andrew
Technical Specialist

fmassetti
Newbie
Posts: 0
Joined: Fri May 04, 2018 10:26 am

Re: PLW to CSV Converter (Bulk)

Post by fmassetti »

Hi Andrew,

This is the app I am using already and that fails in converting my files.

Post Reply