Unable to Export to CSV

Tinkerman61 commented 2 years ago

When trying to export the print history to CSV or Excel I get the below error;

"The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

guysoft commented 2 years ago

Hey. Can you provide the octoprint.log ? Should help determine what error you are getting

Tinkerman61 commented 2 years ago

Hello, attached is my octprint log. Thanks!

octoprint(1).log

guysoft commented 2 years ago

Ok there is indeed an error in the log:

Seems to be a syntax error, let me see if I can fix that.

2021-10-18 14:27:45,765 - octoprint - ERROR - Exception on /plugin/printhistory/export/csv [GET]
Traceback (most recent call last):
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/__init__.py", line 238, in exportHistoryData
    from . import export
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/export.py", line 88
    value = formatTimestamp(historyDetails.get(field, '-'))
                                                          ^
TabError: inconsistent use of tabs and spaces in indentation

guysoft commented 2 years ago

Ok fixed, You can upgrade by running on OctoPI:

~/oprint/bin/pip install git+https://github.com/imrahil/OctoPrint-PrintHistory@devel --upgrade

I want to make a release, but it seems the other export options are broken. I can't seem to get the csv extra option to work. Its was written in python2, and python3 does not handle lots of stuff in the same way, and its doing some strange stuff with class declarations which makes it hard to follow.

Tinkerman61 commented 2 years ago

Thank you for the update, Im not sure how to run the command line in OctoPi.

guysoft commented 2 years ago

ssh to octopi . Here is a guide from Vroron, you might find another guide that is simpler, if you use Windows us putty, if linux/mac use ssh: https://voron.dozuki.com/Guide/Connecting+to+your+Raspberry+Pi+via+SSH/2
in the commandline paste the line I wrote above.

Tinkerman61 commented 2 years ago

I ran the command thru PuTTY and get the below error when trying to export to CSV or Excel. I did reboot the server after the install.

{"error":"The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."}

This is the install log:

Tinkerman61 commented 2 years ago

Not sure why the lines above have a strikethrough after posting.

guysoft commented 2 years ago

They did that because markdown uses notations. When posting code you should add before it ```. and again after it ```. That way the code would look like this:

this is code unchanged

Looks like it worked, restart your OctoPrint service (or just reboot), and test the export.

The export to CSV was fixed, not the export to excel, I hadn't figured how to do that yet.

Tinkerman61 commented 2 years ago

When trying the CSV export, I am getting the below error

"The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application." "The server encountered a…ror in the application."

guysoft commented 2 years ago

That error means there is another error in your octoprint.log. I can't understand what the error is without seeing that. Can you please provide your octoprint.log?

Thanks.

Tinkerman61 commented 2 years ago

Attached is my octoprint log octoprint log.txt .

guysoft commented 2 years ago

Error from the log is:

Traceback (most recent call last):
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/__init__.py", line 238, in exportHistoryData
    from . import export
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/export.py", line 88
    value = formatTimestamp(historyDetails.get(field, '-'))
                                                          ^
TabError: inconsistent use of tabs and spaces in indentation

However that is line 100 in the code at the moment, as seen here: https://github.com/imrahil/OctoPrint-PrintHistory/blob/devel/octoprint_printhistory/export.py#L100

So you are not running an up to date version of the plugin, please make sure you installed it and tested again.

Nicoautoxp commented 2 years ago

Hi, i also wanted to use the export function but i get the following error: "The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

I performed the upgrade as you mentioned in one of the above post but it didn't seem to work.

Here you can find the log file: octoprint.log Any advice on how to proceed?

guysoft commented 2 years ago

@Nicoautoxp This is the error in the plugin:

Traceback (most recent call last):
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/pi/oprint/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/__init__.py", line 238, in exportHistoryData
    from . import export
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_printhistory/export.py", line 88
    value = formatTimestamp(historyDetails.get(field, '-'))
    TabError: inconsistent use of tabs and spaces in indentation                                                      ^

There is a syntax error in the file. That whole area needs to be reweworked, I am kinda busy to fix it atm

guysoft commented 2 years ago

@Nicoautoxp I jsut had a look, there arn't any tabs there. please make sure you are using the latest version of the plugin

Nicoautoxp commented 2 years ago

@guysoft no problem i wasn't sure if i maybe had missed something. I'm on version 1.3 at the moment i thought that this was the latest or is there a newer version?

chrineuh commented 1 year ago

Hello,

I have the same Problem with Octoprint History Plugin, dose someone have an solution. Thanks

guysoft commented 1 year ago

Fixed in #92 :) Will release soon

imrahil / OctoPrint-PrintHistory

Unable to Export to CSV #91