Exporting data.fs to XLS Spreadsheet

Did you run:

$ sudo make ubuntu-environment

as it's indicated at http://book.schooltool.org/htmlhelp/dev_sandbox.html

Usually the cause of gcc errors is a missing dev package in the system (again, running 'sudo make ubuntu-environment' should install all the necessary packages).

Could you paste the full traceback?. In this case the lines above "error: Setup script exited with error: command 'gcc' failed with exit status 1" would help.

Hi Douglas,
When I try running the make ubuntu-environment I get the following message
root@ubuntu:~/database_exporter# sudo make ubuntu-environment
make: *** No rule to make target `ubuntu-environment'. Stop.

Here is the full trace back when I just run the make command:

src/BTrees/BTreeTemplate.c:1056: error: ‘v’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1058: error: ‘BTreeItem’ has no member named ‘key’
src/BTrees/BTreeTemplate.c:1062: error: ‘BTreeItem’ has no member named ‘key’
src/BTrees/BTreeTemplate.c:1068: error: ‘BTreeItem’ has no member named ‘child’
src/BTrees/BTreeTemplate.c:1069: error: ‘BTreeItem’ has no member named ‘child’
src/BTrees/BTreeTemplate.c:1072: error: ‘BTreeItem’ has no member named ‘child’
src/BTrees/BTreeTemplate.c:1072: error: too many arguments to function ‘_set_setstate’
src/BTrees/BTreeTemplate.c:1076: error: ‘BTreeItem’ has no member named ‘child’
src/BTrees/BTreeTemplate.c:1076: error: too many arguments to function ‘_bucket_setstate’
src/BTrees/BTreeTemplate.c:1081: error: ‘BTreeItem’ has no member named ‘child’
src/BTrees/BTreeTemplate.c:1088: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1090: warning: implicit declaration of function ‘PyObject_IsInstance’
src/BTrees/BTreeTemplate.c:1090: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1091: error: ‘SetType’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1091: error: ‘BucketType’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1096: error: ‘BTree’ has no member named ‘firstbucket’
src/BTrees/BTreeTemplate.c:1104: error: ‘BTree’ has no member named ‘len’
src/BTrees/BTreeTemplate.c: At top level:
src/BTrees/BTreeTemplate.c:1109: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1142: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1189: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1276: error: expected declaration specifiers or ‘...’ before ‘PyObject’
src/BTrees/BTreeTemplate.c: In function ‘BTree_findRangeEnd’:
src/BTrees/BTreeTemplate.c:1284: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1284: error: ‘key’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1287: error: ‘keyarg’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1292: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:1292: error: ‘BTree’ has no member named ‘len’
src/BTrees/BTreeTemplate.c:1299: error: ‘BTree’ has no member named ‘len’
src/BTrees/BTreeTemplate.c:1299: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:1300: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:1301: error: ‘BTree’ has no member named ‘ob_type’
src/BTrees/BTreeTemplate.c:1301: error: ‘Sized’ has no member named ‘ob_type’
src/BTrees/BTreeTemplate.c:1303: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:1309: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1309: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1309: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c:1313: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1313: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:1313: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1313: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1313: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1322: warning: passing argument 4 of ‘Bucket_findRangeEnd’ makes pointer from integer without a cast
src/BTrees/BucketTemplate.c:647: note: expected ‘int *’ but argument is of type ‘int’
src/BTrees/BTreeTemplate.c:1322: error: too many arguments to function ‘Bucket_findRangeEnd’
src/BTrees/BTreeTemplate.c:1335: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1335: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:1335: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1335: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1335: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1336: error: ‘Bucket’ has no member named ‘next’
src/BTrees/BTreeTemplate.c:1345: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1345: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1345: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c:1350: error: ‘Sized’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1350: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:1350: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1350: error: ‘Sized’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1350: error: ‘Sized’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1353: error: ‘Sized’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1353: error: ‘Sized’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1353: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c:1360: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1360: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:1360: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:1360: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1360: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1363: error: ‘Bucket’ has no member named ‘len’
src/BTrees/BTreeTemplate.c:1364: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1364: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1364: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c:1371: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1371: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:1371: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c: At top level:
src/BTrees/BTreeTemplate.c:1376: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1448: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1454: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1467: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1628: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1637: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1646: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1652: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1722: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1735: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1741: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1774: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1824: error: expected declaration specifiers or ‘...’ before ‘PyObject’
src/BTrees/BTreeTemplate.c: In function ‘BTree_contains’:
src/BTrees/BTreeTemplate.c:1826: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1826: error: ‘asobj’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:1826: warning: implicit declaration of function ‘_BTree_get’
src/BTrees/BTreeTemplate.c:1826: error: ‘key’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c: At top level:
src/BTrees/BTreeTemplate.c:1836: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1857: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1871: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1878: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1885: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1892: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/BTreeTemplate.c:1909: error: array type has incomplete element type
src/BTrees/BTreeTemplate.c:1910: error: expected expression before ‘BTree’
src/BTrees/BTreeTemplate.c:1910: error: ‘RO’ undeclared here (not in a function)
src/BTrees/BTreeTemplate.c:1914: error: array type has incomplete element type
src/BTrees/BTreeTemplate.c:1915: error: expected ‘}’ before ‘BTree_getstate’
src/BTrees/BTreeTemplate.c:1919: error: expected ‘}’ before ‘BTree_setstate’
src/BTrees/BTreeTemplate.c:1923: error: expected ‘}’ before ‘BTree_has_key’
src/BTrees/BTreeTemplate.c:1927: error: expected ‘}’ before ‘BTree_keys’
src/BTrees/BTreeTemplate.c:1932: error: expected ‘}’ before ‘BTree_values’
src/BTrees/BTreeTemplate.c:1938: error: expected ‘}’ before ‘BTree_items’
src/BTrees/BTreeTemplate.c:1943: error: expected ‘}’ before ‘BTree_byValue’
src/BTrees/BTreeTemplate.c:1949: error: expected ‘}’ before ‘BTree_getm’
src/BTrees/BTreeTemplate.c:1953: error: expected ‘}’ before ‘BTree_setdefault’
src/BTrees/BTreeTemplate.c:1958: error: expected ‘}’ before ‘BTree_pop’
src/BTrees/BTreeTemplate.c:1963: error: expected ‘}’ before ‘BTree_maxKey’
src/BTrees/BTreeTemplate.c:1968: error: expected ‘}’ before ‘BTree_minKey’
src/BTrees/BTreeTemplate.c:1973: error: expected ‘}’ before ‘BTree_clear’
src/BTrees/BTreeTemplate.c:1976: error: expected ‘}’ before ‘BTree_addUnique’
src/BTrees/BTreeTemplate.c:1981: error: expected ‘}’ before ‘Mapping_update’
src/BTrees/BTreeTemplate.c:1984: error: expected ‘}’ before ‘BTree_iterkeys’
src/BTrees/BTreeTemplate.c:1987: error: expected ‘}’ before ‘BTree_itervalues’
src/BTrees/BTreeTemplate.c:1990: error: expected ‘}’ before ‘BTree_iteritems’
src/BTrees/BTreeTemplate.c:1993: error: expected ‘}’ before ‘BTree_check’
src/BTrees/BTreeTemplate.c:1997: error: expected ‘}’ before ‘BTree__p_resolveConflict’
src/BTrees/BTreeTemplate.c:2001: error: expected ‘}’ before ‘BTree__p_deactivate’
src/BTrees/BTreeTemplate.c:2008: error: expected ‘)’ before ‘*’ token
src/BTrees/BTreeTemplate.c: In function ‘BTree_dealloc’:
src/BTrees/BTreeTemplate.c:2024: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2026: error: ‘cPersistenceCAPIstruct’ has no member named ‘pertype’
src/BTrees/BTreeTemplate.c:2026: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:2026: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c: At top level:
src/BTrees/BTreeTemplate.c:2030: error: expected declaration specifiers or ‘...’ before ‘visitproc’
src/BTrees/BTreeTemplate.c: In function ‘BTree_traverse’:
src/BTrees/BTreeTemplate.c:2042: error: ‘BTree’ has no member named ‘ob_type’
src/BTrees/BTreeTemplate.c:2042: error: ‘BTreeType’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:2043: error: ‘BTree’ has no member named ‘ob_type’
src/BTrees/BTreeTemplate.c:2048: error: ‘cPersistenceCAPIstruct’ has no member named ‘pertype’
src/BTrees/BTreeTemplate.c:2048: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:2048: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2056: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2059: error: ‘BTree’ has no member named ‘len’
src/BTrees/BTreeTemplate.c:2065: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:2065: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2065: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:2070: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:2070: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2070: error: ‘BTree’ has no member named ‘data’
src/BTrees/BTreeTemplate.c:2072: error: ‘BTree’ has no member named ‘firstbucket’
src/BTrees/BTreeTemplate.c:2072: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2072: error: ‘BTree’ has no member named ‘firstbucket’
src/BTrees/BTreeTemplate.c: In function ‘BTree_tp_clear’:
src/BTrees/BTreeTemplate.c:2083: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c: In function ‘BTree_length_or_nonzero’:
src/BTrees/BTreeTemplate.c:2110: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2110: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:2110: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeTemplate.c:2110: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2110: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2110: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2111: error: ‘BTree’ has no member named ‘firstbucket’
src/BTrees/BTreeTemplate.c:2112: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2112: error: ‘BTree’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2112: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c:2118: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2118: error: ‘cPersistenceCAPIstruct’ has no member named ‘setstate’
src/BTrees/BTreeTemplate.c:2118: error: expected expression before ‘)’ token
src/BTrees/BTreeTemplate.c:2118: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2118: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2119: error: ‘Bucket’ has no member named ‘len’
src/BTrees/BTreeTemplate.c:2120: error: ‘Bucket’ has no member named ‘next’
src/BTrees/BTreeTemplate.c:2121: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2121: error: ‘Bucket’ has no member named ‘state’
src/BTrees/BTreeTemplate.c:2121: error: ‘cPersistenceCAPIstruct’ has no member named ‘accessed’
src/BTrees/BTreeTemplate.c: At top level:
src/BTrees/BTreeTemplate.c:2133: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘BTree_as_mapping’
src/BTrees/BTreeTemplate.c:2139: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘BTree_as_sequence’
src/BTrees/BTreeTemplate.c:2158: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘BTree_as_number_for_nonzero’
src/BTrees/BTreeTemplate.c:2162: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘BTreeType’
In file included from src/BTrees/BTreeModuleTemplate.c:397,
                 from src/BTrees/_OOBTree.c:32:
src/BTrees/TreeSetTemplate.c:17: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/TreeSetTemplate.c:36: error: expected declaration specifiers or ‘...’ before ‘PyObject’
src/BTrees/TreeSetTemplate.c: In function ‘_TreeSet_update’:
src/BTrees/TreeSetTemplate.c:39: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/TreeSetTemplate.c:39: error: ‘iter’ undeclared (first use in this function)
src/BTrees/TreeSetTemplate.c:39: error: ‘v’ undeclared (first use in this function)
src/BTrees/TreeSetTemplate.c:39: warning: left-hand operand of comma expression has no effect
src/BTrees/TreeSetTemplate.c:42: error: ‘seq’ undeclared (first use in this function)
src/BTrees/TreeSetTemplate.c:54: error: ‘Py_None’ undeclared (first use in this function)
src/BTrees/TreeSetTemplate.c:54: error: too many arguments to function ‘_BTree_set’
src/BTrees/TreeSetTemplate.c: At top level:
src/BTrees/TreeSetTemplate.c:73: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/TreeSetTemplate.c:92: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/TreeSetTemplate.c:103: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/TreeSetTemplate.c:119: error: array type has incomplete element type
src/BTrees/TreeSetTemplate.c:120: error: expected ‘}’ before ‘BTree_getstate’
src/BTrees/TreeSetTemplate.c:124: error: expected ‘}’ before ‘TreeSet_setstate’
src/BTrees/TreeSetTemplate.c:128: error: expected ‘}’ before ‘BTree_has_key’
src/BTrees/TreeSetTemplate.c:132: error: expected ‘}’ before ‘BTree_keys’
src/BTrees/TreeSetTemplate.c:137: error: expected ‘}’ before ‘BTree_maxKey’
src/BTrees/TreeSetTemplate.c:142: error: expected ‘}’ before ‘BTree_minKey’
src/BTrees/TreeSetTemplate.c:147: error: expected ‘}’ before ‘BTree_clear’
src/BTrees/TreeSetTemplate.c:150: error: expected ‘}’ before ‘TreeSet_insert’
src/BTrees/TreeSetTemplate.c:153: error: expected ‘}’ before ‘TreeSet_insert’
src/BTrees/TreeSetTemplate.c:156: error: expected ‘}’ before ‘TreeSet_update’
src/BTrees/TreeSetTemplate.c:159: error: expected ‘}’ before ‘TreeSet_remove’
src/BTrees/TreeSetTemplate.c:162: error: expected ‘}’ before ‘BTree_check’
src/BTrees/TreeSetTemplate.c:166: error: expected ‘}’ before ‘BTree__p_resolveConflict’
src/BTrees/TreeSetTemplate.c:169: error: expected ‘}’ before ‘BTree__p_deactivate’
src/BTrees/TreeSetTemplate.c:175: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘TreeSet_as_mapping’
src/BTrees/TreeSetTemplate.c:179: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘TreeSet_as_sequence’
src/BTrees/TreeSetTemplate.c:193: error: expected ‘)’ before ‘*’ token
src/BTrees/TreeSetTemplate.c:206: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘TreeSetType’
In file included from src/BTrees/BTreeModuleTemplate.c:398,
                 from src/BTrees/_OOBTree.c:32:
src/BTrees/SetOpTemplate.c:73: error: expected declaration specifiers or ‘...’ before ‘PyObject’
src/BTrees/SetOpTemplate.c: In function ‘initSetIteration’:
src/BTrees/SetOpTemplate.c:75: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:76: error: ‘SetIteration’ has no member named ‘position’
src/BTrees/SetOpTemplate.c:77: error: ‘SetIteration’ has no member named ‘usesValue’
src/BTrees/SetOpTemplate.c:79: error: ‘s’ undeclared (first use in this function)
src/BTrees/SetOpTemplate.c:79: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/SetOpTemplate.c:79: error: expected expression before ‘)’ token
src/BTrees/SetOpTemplate.c:81: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:86: error: ‘SetIteration’ has no member named ‘usesValue’
src/BTrees/SetOpTemplate.c:87: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:90: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:92: error: expected expression before ‘)’ token
src/BTrees/SetOpTemplate.c:94: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:96: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:98: error: expected expression before ‘)’ token
src/BTrees/SetOpTemplate.c:100: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:100: warning: implicit declaration of function ‘BTree_rangeSearch’
src/BTrees/SetOpTemplate.c:101: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:105: error: ‘SetIteration’ has no member named ‘usesValue’
src/BTrees/SetOpTemplate.c:106: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:109: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:111: error: expected expression before ‘)’ token
src/BTrees/SetOpTemplate.c:113: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:114: error: ‘SetIteration’ has no member named ‘set’
src/BTrees/SetOpTemplate.c:115: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c:132: error: ‘PyExc_TypeError’ undeclared (first use in this function)
src/BTrees/SetOpTemplate.c:136: error: ‘SetIteration’ has no member named ‘position’
src/BTrees/SetOpTemplate.c: In function ‘copyRemaining’:
src/BTrees/SetOpTemplate.c:155: error: ‘SetIteration’ has no member named ‘position’
src/BTrees/SetOpTemplate.c:157: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:157: error: ‘Bucket’ has no member named ‘size’
src/BTrees/SetOpTemplate.c:158: error: ‘Bucket’ has no member named ‘keys’
src/BTrees/SetOpTemplate.c:158: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:158: error: ‘SetIteration’ has no member named ‘key’
src/BTrees/SetOpTemplate.c:159: error: ‘Bucket’ has no member named ‘keys’
src/BTrees/SetOpTemplate.c:159: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:163: error: ‘Bucket’ has no member named ‘values’
src/BTrees/SetOpTemplate.c:163: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:163: error: ‘SetIteration’ has no member named ‘value’
src/BTrees/SetOpTemplate.c:164: error: ‘Bucket’ has no member named ‘values’
src/BTrees/SetOpTemplate.c:164: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:166: error: ‘Bucket’ has no member named ‘len’
src/BTrees/SetOpTemplate.c:167: error: ‘SetIteration’ has no member named ‘next’
src/BTrees/SetOpTemplate.c: At top level:
src/BTrees/SetOpTemplate.c:200: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/SetOpTemplate.c:356: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/SetOpTemplate.c:376: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/SetOpTemplate.c:399: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
In file included from src/BTrees/BTreeModuleTemplate.c:399,
                 from src/BTrees/_OOBTree.c:32:
src/BTrees/MergeTemplate.c: In function ‘merge_output’:
src/BTrees/MergeTemplate.c:24: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c:24: error: ‘Bucket’ has no member named ‘size’
src/BTrees/MergeTemplate.c:26: error: ‘Bucket’ has no member named ‘keys’
src/BTrees/MergeTemplate.c:26: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c:26: error: ‘SetIteration’ has no member named ‘key’
src/BTrees/MergeTemplate.c:27: error: ‘Bucket’ has no member named ‘keys’
src/BTrees/MergeTemplate.c:27: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c:29: error: ‘Bucket’ has no member named ‘values’
src/BTrees/MergeTemplate.c:29: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c:29: error: ‘SetIteration’ has no member named ‘value’
src/BTrees/MergeTemplate.c:30: error: ‘Bucket’ has no member named ‘values’
src/BTrees/MergeTemplate.c:30: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c:32: error: ‘Bucket’ has no member named ‘len’
src/BTrees/MergeTemplate.c: At top level:
src/BTrees/MergeTemplate.c:40: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
src/BTrees/MergeTemplate.c:88: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
In file included from src/BTrees/_OOBTree.c:32:
src/BTrees/BTreeModuleTemplate.c:401: error: array type has incomplete element type
src/BTrees/BTreeModuleTemplate.c:402: error: expected ‘}’ before ‘difference_m’
src/BTrees/BTreeModuleTemplate.c:406: error: expected ‘}’ before ‘union_m’
src/BTrees/BTreeModuleTemplate.c:409: error: expected ‘}’ before ‘intersection_m’
src/BTrees/BTreeModuleTemplate.c:452: error: expected ‘)’ before ‘*’ token
src/BTrees/BTreeModuleTemplate.c: In function ‘init_OOBTree’:
src/BTrees/BTreeModuleTemplate.c:466: error: ‘PyObject’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:466: error: ‘m’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:466: error: ‘d’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:466: warning: left-hand operand of comma expression has no effect
src/BTrees/BTreeModuleTemplate.c:466: error: ‘c’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:466: warning: left-hand operand of comma expression has no effect
src/BTrees/BTreeModuleTemplate.c:468: error: ‘sort_str’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:468: warning: implicit declaration of function ‘PyString_InternFromString’
src/BTrees/BTreeModuleTemplate.c:471: error: ‘reverse_str’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:474: error: ‘__setstate___str’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:477: error: ‘_bucket_type_str’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:482: warning: implicit declaration of function ‘PyImport_ImportModule’
src/BTrees/BTreeModuleTemplate.c:484: warning: implicit declaration of function ‘PyObject_GetAttrString’
src/BTrees/BTreeModuleTemplate.c:486: error: ‘ConflictError’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:491: error: ‘PyExc_ValueError’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:496: warning: implicit declaration of function ‘PyCObject_Import’
src/BTrees/BTreeModuleTemplate.c:496: warning: assignment makes pointer from integer without a cast
src/BTrees/BTreeModuleTemplate.c:500: error: ‘BTreeItemsType’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:500: error: ‘PyType_Type’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:501: error: ‘BTreeIter_Type’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:502: error: ‘PyObject_GenericGetAttr’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:503: error: ‘BucketType’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:503: error: ‘PyType_GenericNew’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:504: error: ‘SetType’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:505: error: ‘BTreeType’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:506: error: ‘TreeSetType’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:507: warning: implicit declaration of function ‘init_persist_type’
src/BTrees/BTreeModuleTemplate.c:516: warning: implicit declaration of function ‘PyDict_SetItem’
src/BTrees/BTreeModuleTemplate.c:517: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:518: warning: implicit declaration of function ‘fprintf’
src/BTrees/BTreeModuleTemplate.c:518: warning: incompatible implicit declaration of built-in function ‘fprintf’
src/BTrees/BTreeModuleTemplate.c:518: error: ‘stderr’ undeclared (first use in this function)
src/BTrees/BTreeModuleTemplate.c:522: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:523: warning: incompatible implicit declaration of built-in function ‘fprintf’
src/BTrees/BTreeModuleTemplate.c:528: warning: implicit declaration of function ‘Py_InitModule4’
src/BTrees/BTreeModuleTemplate.c:530: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:533: warning: implicit declaration of function ‘PyModule_GetDict’
src/BTrees/BTreeModuleTemplate.c:534: warning: implicit declaration of function ‘PyDict_SetItemString’
src/BTrees/BTreeModuleTemplate.c:535: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:538: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:541: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:544: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:547: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:555: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:558: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:561: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:564: error: expected expression before ‘)’ token
src/BTrees/BTreeModuleTemplate.c:570: error: ‘Py_False’ undeclared (first use in this function)
error: Setup script exited with error: command 'gcc' failed with exit status 1
An error occured when trying to install ZODB3 3.9.4. Look above this message for any errors that were output by easy_install.
While:
  Installing package.
  Getting distribution for 'ZODB3==3.9.4'.
Error: Couldn't install: ZODB3 3.9.4

Much thanks

Trevor

The compilation error indicates that you do not have python-dev installed.

Where do you checkout from? It is strange that Makefile does not contain the ubuntu-environment target that gives this error:

  make: *** No rule to make target `ubuntu-environment'. Stop.

The command to install build dependencies is:

  sudo apt-get install bzr build-essential gettext enscript python-all-dev libc6-dev libicu-dev libxslt1-dev libfreetype6-dev libjpeg62-dev

You may need to delete an incomplete installation of ZODB:

  rm -r ~/.buildout/eggs/ZODB3-3.9.4-py2.*.egg

Hi Paulauskas,

Thank you very much. That solved it!!! After installing the python-dev I ran
the make command and for the first time it completed the install
successfully.

I'm trying to run the a tool to export the data in the older version of
schooltool to the an XLS file. The tool is located here:
Upgrading from SchoolTool 0.11.x databases to SchoolTool 1.4
   https://answers.edge.launchpad.net/schooltool/+faq/1222

Following the successful install of ZODB I was able to test the
example.data.fs and successfully export. However when I tried exporting my
file which is approx 280 Mb in size, the export does not complete. My
conclusion is that the file I'm trying to export is tool large. When I split
my file It successfully exports the first part once it is about five Mb.
Larger files also fail.

Any hints on a work around to this?

Trevor

On 2 November 2010 10:17, Gediminas Paulauskas <
<email address hidden>> wrote:

> Your question #131776 on SchoolTool changed:
> https://answers.edge.launchpad.net/schooltool/+question/131776
>
> Status: Open => Answered
>
> Gediminas Paulauskas proposed the following answer:
> The compilation error indicates that you do not have python-dev
> installed.
>
> Where do you checkout from? It is strange that Makefile does not contain
> the ubuntu-environment target that gives this error:
>
> make: *** No rule to make target `ubuntu-environment'. Stop.
>
> The command to install build dependencies is:
>
> sudo apt-get install bzr build-essential gettext enscript python-all-
> dev libc6-dev libicu-dev libxslt1-dev libfreetype6-dev libjpeg62-dev
>
> You may need to delete an incomplete installation of ZODB:
>
> rm -r ~/.buildout/eggs/ZODB3-3.9.4-py2.*.egg
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.edge.launchpad.net/schooltool/+question/131776/+confirm?answer_id=2
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.edge.launchpad.net/schooltool/+question/131776
>
> You received this question notification because you are a direct
> subscriber of the question.
>

The file is indeed large, and the tool is not optimized at all (as exporting the old database is a one-shot operation), but there should be no problems to export it anyway. Just that it may take a considerable amount of time.

Can you please paste the last output you see in the terminal?

Hi Justas,

Here is the last couple lines from the terminal when I attempt to export the
complete file (size 280 Mb)

/root/database_exporter/eggs/ZODB3-3.9.4-py2.6-linux-i686.egg/ZODB/broken.py:181:
DeprecationWarning: the sets module is deprecated
  __import__(modulename)
Warning: There are sections with no terms assigned, putting them to sheet
'Sections with no term' (they will fail to import)
Traceback (most recent call last):
  File "./export", line 21, in <module>
    schooltool.db_exporter.export.run()
  File "/root/database_exporter/src/schooltool/db_exporter/export.py", line
191, in run
    verbose=options.verbose, force=options.force)
  File "/root/database_exporter/src/schooltool/db_exporter/export.py", line
138, in export
    exporter.write(output_filename)
  File "/root/database_exporter/src/schooltool/db_exporter/xls.py", line 97,
in write
    writer.write()
  File "/root/database_exporter/src/schooltool/db_exporter/mock_0_11_4.py",
line 486, in write
    writer.begin()
  File "/root/database_exporter/src/schooltool/db_exporter/mock_0_11_4.py",
line 514, in begin
    WithSchoolyearSheetWriter.begin(self)
  File "/root/database_exporter/src/schooltool/db_exporter/xls.py", line
121, in begin
    self.sheet = self.workbook.add_sheet(self.sheet_name)
  File "/root/database_exporter/eggs/xlwt-0.7.2-py2.6.egg/xlwt/Workbook.py",
line 319, in add_sheet
    raise Exception("invalid worksheet name %r" % sheetname)
Exception: invalid worksheet name u'Sections 2006 region institute 2006
term'
root@ubuntu:~/database_exporter#

Thanks much

Trevor

2010/11/9 Justas Sadzevičius <email address hidden>

> Your question #131776 on SchoolTool changed:
> https://answers.launchpad.net/schooltool/+question/131776
>
> Status: Open => Answered
>
> Justas Sadzevičius proposed the following answer:
> The file is indeed large, and the tool is not optimized at all (as
> exporting the old database is a one-shot operation), but there should be
> no problems to export it anyway. Just that it may take a considerable
> amount of time.
>
> Can you please paste the last output you see in the terminal?
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.launchpad.net/schooltool/+question/131776/+confirm?answer_id=4
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/schooltool/+question/131776
>
> You received this question notification because you are a direct
> subscriber of the question.
>

Thanks Justas,

That solved it! I was able to export the entire file. Thanks again for your
help and that from * Gediminas Paulauskas*.

I was able to recover much information from the file. I was hoping for a
little more details under the *person* tab. I only got the user name, first
name and Last name. All the other fields like gender, ethnicity, etc were
left blank. So our taks is now ahead of us to piece together the missing
data. However this help certainly makes the task much easier.

Any way guys thanks for a job well done!!

Trevor

2010/11/11 Justas Sadzevičius <email address hidden>

> Your question #131776 on SchoolTool changed:
> https://answers.launchpad.net/schooltool/+question/131776
>
> Status: Open => Answered
>
> Justas Sadzevičius proposed the following answer:
> That was a bug in the exporter - sheet names are apparently limited to 30
> characters.
> Fixed; please update your checkout:
> $ bzr up
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.launchpad.net/schooltool/+question/131776/+confirm?answer_id=6
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/schooltool/+question/131776
>
> You received this question notification because you are a direct
> subscriber of the question.
>

Thanks Justas

That solved it!!

Trevor

Well, perhaps we can add that functionality. I assume you need this ASAP?

Hi Tom,

Are your referring to the functionality that will allow for the recovery of
additional details?

Trevor

On 11 November 2010 21:26, Tom Hoffman <<email address hidden>
> wrote:

> Your question #131776 on SchoolTool changed:
> https://answers.launchpad.net/schooltool/+question/131776
>
> Tom Hoffman posted a new comment:
> Well, perhaps we can add that functionality. I assume you need this
> ASAP?
>
> --
> You received this question notification because you are a direct
> subscriber of the question.
>

Yes.

Hi Tom,

If that functionality can be added it would save us a lot of man hours to
physically re-enter much of the missing data. Any steps taken to improve the
amount of data recovered is most welcome.

Thanks again

Trevor

On 12 November 2010 09:41, Tom Hoffman <<email address hidden>
> wrote:

> Your question #131776 on SchoolTool changed:
> https://answers.launchpad.net/schooltool/+question/131776
>
> Tom Hoffman posted a new comment:
> Yes.
>
> --
> You received this question notification because you are a direct
> subscriber of the question.
>

We'll discuss it at our weekly developer meeting Monday morning.