Importing DB fails

[zion2k]

What did you expect to happen?

• I exported my database (got a zip file with the csv files inside)
• switched to a new Raspberry Pi and a new installed OctoPi v0.14
• I tried to import the database, but only get an import error

What happened instead?

data import error

Link to octoprint.log

2018-01-19 16:52:59,488 - octoprint.plugins.filamentmanager - ERROR - Data import failed: Column('id', INTEGER(), table=, primary_key=True, nullable=False)

2018-01-19 16:52:59,497 - tornado.access - ERROR - 500 POST /plugin/filamentmanager/import (127.0.0.1) 38.84ms

Link to gcode file

none

Link to contents of Javascript console in the browser

none

Further information

profiles.csv

1,DAS FILAMENT,PLA,1.24,1.75
2,3D-Filament.net,PLA INGEO 3D850,1.24,1.75
3,OWL-SAT,PLA,1.24,1.75
4,DAS FILAMENT,TPU,1.21,1.75
5,DAS FILAMENT,PETG,1.24,1.75
6,Filamentworld,PLA,1.24,1.75

spools.csv

1,1,Tiefschwarz (RAL 9005),15.95,800.0,338.346978052,0
2,1,Reinorange (RAL 2004),15.95,800.0,0.0,0
3,1,Himmelblau (RAL 5015),15.95,800.0,19.9917105156,0
4,2,Pure White,12.09,1000.0,0.0,0
5,2,Pure White,12.09,1000.0,0.0,0
6,3,Transparent,9.84,1000.0,0.0,0
7,3,Silber (RAL 9006),9.84,1000.0,0.0,0
8,3,Violett,9.84,1000.0,0.0,0
9,3,Gold,9.84,1000.0,0.0,0
10,3,Kanariengelb (RAL 1003),9.84,1000.0,0.0,0
11,3,Signalrot (RAL 3001),9.84,1000.0,0.0,0
12,4,Transparent,3.95,50.0,0.0,0
13,4,Tiefschwarz (RAL 9005),3.95,50.0,0.0,0
14,5,Transparent,2.95,50.0,0.0,0
15,5,Tiefschwarz (RAL 9005),2.95,50.0,0.0,0
16,2,Titan Silver,0.0,31.0,0.0,0
17,6,Schwarz,0.0,36.0,0.0,0
18,6,Schwarz,0.0,42.0,0.0,0

filament_export_2018-01-19_14-48-01.zip

[ghost]

Hi @zion2k,

It looks like there is some information missing in your ticket that will be needed in order to reproduce and fix the problem at hand. Please take a look at the Issue Template, which will tell you exactly what your ticket has to contain in order to be processable.

If you did not intend to report a bug but have a question or want to request a feature add a "[Question]" respectively "[Request]" prefix to the title.

I'm marking this one now as an incomplete ticket. Please understand that if you do not provide that information within the next two weeks (until 2018-02-02 18:15) I'll close this ticket so it doesn't clutter the bug tracker.

Best regards,
~ Your FriendlyGithubBot

PS: I'm just an automated script, not a human being.