Exporting data.fs to XLS Spreadsheet
I am trying to use the tool to export old Data.fs to XLS available as bazaar checkout. Every time I follow the steps outline I keep getting an error message indicating the following
"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"
I've used the tool with Ubuntu 9.10 and 10.04 and still get the same error. Any ideas on how I can resolve this?
Thanks much
Trevor
Question information
- Language:
- English Edit question
- Status:
- Solved
- For:
- SchoolTool Edit question
- Assignee:
- No assignee Edit question
- Solved by:
- Justas Sadzevičius
- Solved:
- Last query:
- Last reply:
Related FAQ:
None Link to a FAQ
Revision history for this message
|
#1 |
Did you run:
$ sudo make ubuntu-environment
as it's indicated at http://
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.
Revision history for this message
|
#2 |
Hi Douglas,
When I try running the make ubuntu-environment I get the following message
root@ubuntu:
make: *** No rule to make target `ubuntu-
Here is the full trace back when I just run the make command:
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
In file included from src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
In file included from src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
In file included from src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
In file included from src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
src/BTrees/
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
Revision history for this message
|
#3 |
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-
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/
Revision history for this message
|
#4 |
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:/
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:/
>
> 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-
>
> 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/
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https:/
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https:/
>
> You received this question notification because you are a direct
> subscriber of the question.
>
Revision history for this message
|
#5 |
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?
Revision history for this message
|
#6 |
Hi Justas,
Here is the last couple lines from the terminal when I attempt to export the
complete file (size 280 Mb)
/root/database_
DeprecationWarning: the sets module is deprecated
__import_
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.
File "/root/
191, in run
verbose=
File "/root/
138, in export
exporter.
File "/root/
in write
writer.write()
File "/root/
line 486, in write
writer.begin()
File "/root/
line 514, in begin
WithSchooly
File "/root/
121, in begin
self.sheet = self.workbook.
File "/root/
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:
Thanks much
Trevor
2010/11/9 Justas Sadzevičius <email address hidden>
> Your question #131776 on SchoolTool changed:
> https:/
>
> 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:/
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https:/
>
> You received this question notification because you are a direct
> subscriber of the question.
>
Revision history for this message
|
#7 |
That was a bug in the exporter - sheet names are apparently limited to 30 characters.
Fixed; please update your checkout:
$ bzr up
Revision history for this message
|
#8 |
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:/
>
> 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:/
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https:/
>
> You received this question notification because you are a direct
> subscriber of the question.
>
Revision history for this message
|
#9 |
Thanks Justas
That solved it!!
Trevor
Revision history for this message
|
#10 |
Well, perhaps we can add that functionality. I assume you need this ASAP?
Revision history for this message
|
#11 |
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:/
>
> 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.
>
Revision history for this message
|
#13 |
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:/
>
> Tom Hoffman posted a new comment:
> Yes.
>
> --
> You received this question notification because you are a direct
> subscriber of the question.
>
Revision history for this message
|
#14 |
We'll discuss it at our weekly developer meeting Monday morning.