Error importing piecash on Windows 7 (Python 2.7.3)
35 views
Skip to first unread message
Brian Clarkson
Mar 12, 2015, 12:07:13 PM3/12/15
to pie...@googlegroups.com
Hello
I've installed the Microsoft Visual C++ Compiler for Python 2.7 and then executed:
pip install piecash
(The output of this at the bottom).
However when I try to 'import piecash' in Python, I get the following error:
Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import piecash
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\__init__.py", line 10, in <module>
from ._common import GncNoActiveSession, GnucashException, GncValidationError, GncImbalanceError
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\_common.py", line 7, in <module>
from .sa_extra import DeclarativeBase, _Date, long
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\sa_extra.py", line 9, in <module>
from sqlalchemy.ext.declarative import as_declarative
ImportError: cannot import name as_declarative
>>>
Does anyone have any idea why this is happening?
---- output from the piecash installation ----
>> pip install piecash
Downloading/unpacking piecash
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\piecash\setup.py) egg_info for package
piecash
no previously-included directories found matching 'docs\build'
warning: no previously-included files matching '*.pyc' found anywhere in distribution
Downloading/unpacking SQLAlchemy (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\SQLAlchemy\setup.py) egg_info for packa
ge SQLAlchemy
warning: no files found matching '*.jpg' under directory 'doc'
warning: no files found matching '*.mako' under directory 'doc'
warning: no files found matching 'distribute_setup.py'
warning: no files found matching 'sa2to3.py'
warning: no files found matching 'ez_setup.py'
no previously-included directories found matching 'doc\build\output'
Downloading/unpacking enum34 (from piecash)
Downloading enum34-1.0.4.tar.gz
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\enum34\setup.py) egg_info for package e
num34
Downloading/unpacking SQLAlchemy-Utils (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\SQLAlchemy-Utils\setup.py) egg_info for
package SQLAlchemy-Utils
warning: no previously-included files matching '*.pyc' found under directory 'tests'
warning: no previously-included files matching '*.pyc' found under directory 'docs'
no previously-included directories found matching 'docs\_build'
warning: no previously-included files found matching 'docs\_themes\.git'
Downloading/unpacking pytz (from piecash)
Downloading/unpacking tzlocal (from piecash)
Downloading tzlocal-1.1.2.zip
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\tzlocal\setup.py) egg_info for package
tzlocal
Downloading/unpacking future (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\future\setup.py) egg_info for package f
uture
warning: no files found matching '*.au' under directory 'tests'
warning: no files found matching '*.gif' under directory 'tests'
warning: no files found matching '*.txt' under directory 'tests'
Downloading/unpacking six (from SQLAlchemy-Utils->piecash)
Downloading six-1.9.0-py2.py3-none-any.whl
Installing collected packages: piecash, SQLAlchemy, enum34, SQLAlchemy-Utils, pytz, tzlocal, future, six
Running setup.py install for piecash
no previously-included directories found matching 'docs\build'
warning: no previously-included files matching '*.pyc' found anywhere in distribution
Running setup.py install for SQLAlchemy
building 'sqlalchemy.cprocessors' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/processors.c /Fobuild\temp.
win-amd64-2.7\Release\lib/sqlalchemy/cextension/processors.obj
processors.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcprocessors build\temp.win-a
md64-2.7\Release\lib/sqlalchemy/cextension/processors.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cprocessors.pyd /IMPLI
B:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.lib /MANIFESTFILE:build\temp.win-amd64-2.7\Rele
ase\lib/sqlalchemy/cextension\cprocessors.pyd.manifest
processors.obj : warning LNK4197: export 'initcprocessors' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.lib and object build\temp
.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.exp
building 'sqlalchemy.cresultproxy' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/resultproxy.c /Fobuild\temp
.win-amd64-2.7\Release\lib/sqlalchemy/cextension/resultproxy.obj
resultproxy.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcresultproxy build\temp.win-
amd64-2.7\Release\lib/sqlalchemy/cextension/resultproxy.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cresultproxy.pyd /IM
PLIB:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.lib /MANIFESTFILE:build\temp.win-amd64-2.7\
Release\lib/sqlalchemy/cextension\cresultproxy.pyd.manifest
resultproxy.obj : warning LNK4197: export 'initcresultproxy' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.lib and object build\tem
p.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.exp
building 'sqlalchemy.cutils' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/utils.c /Fobuild\temp.win-a
md64-2.7\Release\lib/sqlalchemy/cextension/utils.obj
utils.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcutils build\temp.win-amd64-
2.7\Release\lib/sqlalchemy/cextension/utils.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cutils.pyd /IMPLIB:build\temp.wi
n-amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.lib /MANIFESTFILE:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/c
extension\cutils.pyd.manifest
utils.obj : warning LNK4197: export 'initcutils' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.lib and object build\temp.win-
amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.exp
warning: no files found matching '*.jpg' under directory 'doc'
warning: no files found matching '*.mako' under directory 'doc'
warning: no files found matching 'distribute_setup.py'
warning: no files found matching 'sa2to3.py'
warning: no files found matching 'ez_setup.py'
no previously-included directories found matching 'doc\build\output'
Running setup.py install for enum34
Running setup.py install for SQLAlchemy-Utils
warning: no previously-included files matching '*.pyc' found under directory 'tests'
warning: no previously-included files matching '*.pyc' found under directory 'docs'
no previously-included directories found matching 'docs\_build'
warning: no previously-included files found matching 'docs\_themes\.git'
Running setup.py install for tzlocal
Running setup.py install for future
warning: no files found matching '*.au' under directory 'tests'
warning: no files found matching '*.gif' under directory 'tests'
warning: no files found matching '*.txt' under directory 'tests'
Installing pasteurize-script.py script to c:\python27\Scripts
Installing pasteurize.exe script to c:\python27\Scripts
Installing futurize-script.py script to c:\python27\Scripts
Installing futurize.exe script to c:\python27\Scripts
Successfully installed piecash SQLAlchemy enum34 SQLAlchemy-Utils pytz tzlocal future six
Cleaning up...
Kind regards,
Brian
I've installed the Microsoft Visual C++ Compiler for Python 2.7 and then executed:
pip install piecash
(The output of this at the bottom).
However when I try to 'import piecash' in Python, I get the following error:
Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import piecash
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\__init__.py", line 10, in <module>
from ._common import GncNoActiveSession, GnucashException, GncValidationError, GncImbalanceError
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\_common.py", line 7, in <module>
from .sa_extra import DeclarativeBase, _Date, long
File "c:\python27\lib\site-packages\piecash-0.7.4-py2.7.egg\piecash\sa_extra.py", line 9, in <module>
from sqlalchemy.ext.declarative import as_declarative
ImportError: cannot import name as_declarative
>>>
Does anyone have any idea why this is happening?
---- output from the piecash installation ----
>> pip install piecash
Downloading/unpacking piecash
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\piecash\setup.py) egg_info for package
piecash
no previously-included directories found matching 'docs\build'
warning: no previously-included files matching '*.pyc' found anywhere in distribution
Downloading/unpacking SQLAlchemy (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\SQLAlchemy\setup.py) egg_info for packa
ge SQLAlchemy
warning: no files found matching '*.jpg' under directory 'doc'
warning: no files found matching '*.mako' under directory 'doc'
warning: no files found matching 'distribute_setup.py'
warning: no files found matching 'sa2to3.py'
warning: no files found matching 'ez_setup.py'
no previously-included directories found matching 'doc\build\output'
Downloading/unpacking enum34 (from piecash)
Downloading enum34-1.0.4.tar.gz
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\enum34\setup.py) egg_info for package e
num34
Downloading/unpacking SQLAlchemy-Utils (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\SQLAlchemy-Utils\setup.py) egg_info for
package SQLAlchemy-Utils
warning: no previously-included files matching '*.pyc' found under directory 'tests'
warning: no previously-included files matching '*.pyc' found under directory 'docs'
no previously-included directories found matching 'docs\_build'
warning: no previously-included files found matching 'docs\_themes\.git'
Downloading/unpacking pytz (from piecash)
Downloading/unpacking tzlocal (from piecash)
Downloading tzlocal-1.1.2.zip
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\tzlocal\setup.py) egg_info for package
tzlocal
Downloading/unpacking future (from piecash)
Running setup.py (path:c:\users\clarkson\appdata\local\temp\pip_build_clarkson\future\setup.py) egg_info for package f
uture
warning: no files found matching '*.au' under directory 'tests'
warning: no files found matching '*.gif' under directory 'tests'
warning: no files found matching '*.txt' under directory 'tests'
Downloading/unpacking six (from SQLAlchemy-Utils->piecash)
Downloading six-1.9.0-py2.py3-none-any.whl
Installing collected packages: piecash, SQLAlchemy, enum34, SQLAlchemy-Utils, pytz, tzlocal, future, six
Running setup.py install for piecash
no previously-included directories found matching 'docs\build'
warning: no previously-included files matching '*.pyc' found anywhere in distribution
Running setup.py install for SQLAlchemy
building 'sqlalchemy.cprocessors' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/processors.c /Fobuild\temp.
win-amd64-2.7\Release\lib/sqlalchemy/cextension/processors.obj
processors.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcprocessors build\temp.win-a
md64-2.7\Release\lib/sqlalchemy/cextension/processors.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cprocessors.pyd /IMPLI
B:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.lib /MANIFESTFILE:build\temp.win-amd64-2.7\Rele
ase\lib/sqlalchemy/cextension\cprocessors.pyd.manifest
processors.obj : warning LNK4197: export 'initcprocessors' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.lib and object build\temp
.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cprocessors.exp
building 'sqlalchemy.cresultproxy' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/resultproxy.c /Fobuild\temp
.win-amd64-2.7\Release\lib/sqlalchemy/cextension/resultproxy.obj
resultproxy.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcresultproxy build\temp.win-
amd64-2.7\Release\lib/sqlalchemy/cextension/resultproxy.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cresultproxy.pyd /IM
PLIB:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.lib /MANIFESTFILE:build\temp.win-amd64-2.7\
Release\lib/sqlalchemy/cextension\cresultproxy.pyd.manifest
resultproxy.obj : warning LNK4197: export 'initcresultproxy' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.lib and object build\tem
p.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cresultproxy.exp
building 'sqlalchemy.cutils' extension
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /
Ox /MD /W3 /GS- /DNDEBUG -Ic:\python27\include -Ic:\python27\PC /Tclib/sqlalchemy/cextension/utils.c /Fobuild\temp.win-a
md64-2.7\Release\lib/sqlalchemy/cextension/utils.obj
utils.c
C:\Users\clarkson\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\link.exe /DLL /nolo
go /INCREMENTAL:NO /LIBPATH:c:\python27\libs /LIBPATH:c:\python27\PCbuild\amd64 /EXPORT:initcutils build\temp.win-amd64-
2.7\Release\lib/sqlalchemy/cextension/utils.obj /OUT:build\lib.win-amd64-2.7\sqlalchemy\cutils.pyd /IMPLIB:build\temp.wi
n-amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.lib /MANIFESTFILE:build\temp.win-amd64-2.7\Release\lib/sqlalchemy/c
extension\cutils.pyd.manifest
utils.obj : warning LNK4197: export 'initcutils' specified multiple times; using first specification
Creating library build\temp.win-amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.lib and object build\temp.win-
amd64-2.7\Release\lib/sqlalchemy/cextension\cutils.exp
warning: no files found matching '*.jpg' under directory 'doc'
warning: no files found matching '*.mako' under directory 'doc'
warning: no files found matching 'distribute_setup.py'
warning: no files found matching 'sa2to3.py'
warning: no files found matching 'ez_setup.py'
no previously-included directories found matching 'doc\build\output'
Running setup.py install for enum34
Running setup.py install for SQLAlchemy-Utils
warning: no previously-included files matching '*.pyc' found under directory 'tests'
warning: no previously-included files matching '*.pyc' found under directory 'docs'
no previously-included directories found matching 'docs\_build'
warning: no previously-included files found matching 'docs\_themes\.git'
Running setup.py install for tzlocal
Running setup.py install for future
warning: no files found matching '*.au' under directory 'tests'
warning: no files found matching '*.gif' under directory 'tests'
warning: no files found matching '*.txt' under directory 'tests'
Installing pasteurize-script.py script to c:\python27\Scripts
Installing pasteurize.exe script to c:\python27\Scripts
Installing futurize-script.py script to c:\python27\Scripts
Installing futurize.exe script to c:\python27\Scripts
Successfully installed piecash SQLAlchemy enum34 SQLAlchemy-Utils pytz tzlocal future six
Cleaning up...
Kind regards,
Brian
Sébastien de Menten
Mar 12, 2015, 2:21:35 PM3/12/15
to Brian Clarkson, pie...@googlegroups.com
Hello Brian,
I see that "as_declarative" is available as of sqlalchemy 8.3.
Could you check what version of sqlalchemy has been installed ? You can do this with "pip freeze" (I do not know your python proficiency, so sorry if this is obvious to you).
Otherwise, I do not know if you have the possibility to install miniconda (http://conda.pydata.org/miniconda.html) as this makes it way easier to install packages on windows already precompiled. And if so, you could install piecash as described on the page http://piecash.readthedocs.org/en/latest/doc/doc.html#installation.
Sebastien
--
You received this message because you are subscribed to the Google Groups "piecash" group.
To unsubscribe from this group and stop receiving emails from it, send an email to piecash+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/piecash/0546e0dd-525d-4623-947a-56aa6ce66cdc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sébastien de Menten
Mar 12, 2015, 3:59:38 PM3/12/15
to Brian Clarkson, pie...@googlegroups.com
After checking on my side, I see the same problem you have. The issue seems to be with sqlalchemy 0.9.9 (bug report https://bitbucket.org/zzzeek/sqlalchemy/issue/3324/from-sqlalchemyextdeclarative-import).
Installing sqlalchemy 0.9.8 should solve the issue (pip install sqlalchemy==0.9.8).
Brian Clarkson
Mar 12, 2015, 11:17:02 PM3/12/15
to pie...@googlegroups.com, clar...@orthogonaldevices.com
Hi Sebastien
Thanks for looking into the issue. Rolling sqlalchemy back to 0.9.8 fixed the problem for me too!
Kind regards,
Brian
Reply all
Reply to author
Forward
0 new messages