csv export failed with error

Forum for discussing PicoLog
Post Reply
molrich
Newbie
Posts: 0
Joined: Fri Aug 17, 2018 1:34 pm

csv export failed with error

Post by molrich »

When trying to export csv data I get an error message saying file in use or check to see if picolog has write permission to folder.

writing data to my documents folder or to default pico log folder generates the same error message
the file does not exist, and the folder is not write protected.
any ideas any one
I am running pico log6.1.5 and windows 10

Hitesh

Re: csv export failed with error

Post by Hitesh »

Hi molrich,

I've seen your post about the table view. When trying to export to csv file format, is the table view present or not?

Regards,

BePe
Newbie
Posts: 0
Joined: Wed Dec 05, 2018 1:24 pm

Re: csv export failed with error

Post by BePe »

Hello I am having similar problems exporting data to CSV. Could you tell me if the problem has been resolved?

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: csv export failed with error

Post by Martyn »

Which version of the software are you using ? Have you tried with the recently released PicoLog 6.1.7 ?
Martyn
Technical Support Manager

BePe
Newbie
Posts: 0
Joined: Wed Dec 05, 2018 1:24 pm

Re: csv export failed with error

Post by BePe »

I have automatic updates turned on, so should be the current version. How can I check?

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: csv export failed with error

Post by Martyn »

Click on the question mark on the left, you should find the version on the page.
Martyn
Technical Support Manager

BePe
Newbie
Posts: 0
Joined: Wed Dec 05, 2018 1:24 pm

Re: csv export failed with error

Post by BePe »

Uninstalled version 6.1.5 and reinstalled version 6.1.7; that seems to have sorted it. Thank you.

Lionelk
Newbie
Posts: 0
Joined: Fri Oct 18, 2019 1:03 am

Re: csv export failed with error

Post by Lionelk »

I'm having this issue - any significant export to csv result in "Error Writing File. The file could not be written..."
I have tried on different PCs, and as administrator - to local ssd folders / usb folders etc
The export process commences - the file is partially written - then the error message.
Current example = 1.12mb .picolog file; reported as 14mb csv export - gets to approx 4mb written, and then fails. If I [close] the error message - the partially written file is deleted.
I can successfully export "current table bounds" to identical output (name/location etc) - this is only 23kb output.
Currently using: PicoLog - 6.1.13
(Installed today after uninstalling 6.1.12 - which I experienced that same issues with)
Using Windows10 on a PC.

Help Please!

bbyeung1216
Newbie
Posts: 0
Joined: Thu Aug 26, 2021 1:33 am

Re: csv export failed with error

Post by bbyeung1216 »

for anyone in the future by searching google and this post come up.
I have the same problem. and I find out my problem come from the math channel.
you can't have conditions in a math channel then export it as CSV.
for example (A>5)?(A*10):(A*5) something like this you can see the value of it in the math channel when capturing.
but it won't show up in the graph, and is not able to export to CSV.
as long as you don't select that math channel. you will be good to export the CSV file.

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

Re: csv export failed with error

Post by AndrewA »

You should be able to something like this mathematically, but haven't tested in Picolog 6-

Greater than 4
sign(sign(A-5)+1)

NOT Greater than 4-
abs(sign(sign(A-5)+1)-1

And add it all together-
( sign(sign(A-5)+1) * (Condition1) ) + ( ( abs(sign(sign(A-5)+1)-1) ) * (Condition2) )
So
( sign(sign(A-5)+1) * (A*10) ) + ( ( abs(sign(sign(A-5)+1)-1) ) * (A*5) )

If are going to use this you should test the equation in excel with test values, as its a lot quicker to edit the equation than in PicoLog.
Regards Andrew
Technical Specialist

Post Reply