search

APSIMInitiative / ApsimX

ApsimX is the next generation of APSIM
http://www.apsim.info
Other
130 stars 160 forks source link

Export to excel crashing #848

Closed HamishBrownPFR closed 6 years ago

HamishBrownPFR commented 8 years ago

The file Overseertest.apsimx can be cloned from: https://github.com/PlantandFoodResearch/Overseer-testing

this file throws the following error when all simulations are run and attempted to export to Excel. We have tried this on two seperate computers and get the same error on both. image

zur003 commented 8 years ago

Github doesn't seem to know about that repository.

cla473 commented 8 years ago

Hi Eric,

Not sure how I sort that out, but here is a sample excel met data file. This is four sheets, that should all be in the correct format.

Let me know if you have any issues with these.

Regards,

Loretta Clancy Software Developer | CSIRO Agriculture Qld Biosciences Precinct, 306 Carmody Road, St Lucia Qld 4067 | Ph: (07) 3214 2609

From: Eric Zurcher [mailto:notifications@github.com] Sent: Monday, 23 May 2016 2:53 PM To: APSIMInitiative/ApsimX ApsimX@noreply.github.com Subject: Re: [APSIMInitiative/ApsimX] Export to excel crashing (#848)

Github doesn't seem to know about that repository.

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHubhttps://github.com/APSIMInitiative/ApsimX/issues/848#issuecomment-220887104

hol353 commented 8 years ago

Hamish, the repo you posted above is OK but I can't run your sims because of issue #851. Can you send me the .db file?

hol353 commented 8 years ago

OK, it is running out of memory (which we knew). Going to Release|AnyCPU (64bit) for all our projects will probably fix the issue but...

The build configurations are screwed so this isn't as easy as it should be. Also, we are using sqlite.dll which is a 32bit DLL so we'll have to look at another mechanism for handling SQLITE database. Using something from nuget would be good.

For now Hamish, I suggest you use an external tool like DbBrowser for SQLite and do an export to csv. It can be downloaded from: http://sqlitebrowser.org/

HamishBrownPFR commented 8 years ago

Thanks Dean.

I have a phyton script that I can set Edith up with to extract the data in the short term. We will progress with that solution.

Thanks,

Hamish

From: Dean Holzworth [mailto:notifications@github.com] Sent: Tuesday, 24 May 2016 2:02 p.m. To: APSIMInitiative/ApsimX Cc: Hamish Brown; Author Subject: Re: [APSIMInitiative/ApsimX] Export to excel crashing (#848)

OK, it is running out of memory (which we knew). Going to Release|AnyCPU (64bit) for all our projects will probably fix the issue but...

The build configurations are screwed so this isn't as easy as it should be. Also, we are using sqlite.dll which is a 32bit DLL so we'll have to look at another mechanism for handling SQLITE database. Using something from nuget would be good.

For now Hamish, I suggest you use an external tool like DbBrowser for SQLite and do an export to csv. It can be downloaded from: http://sqlitebrowser.org/

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/APSIMInitiative/ApsimX/issues/848#issuecomment-221147013

The contents of this e-mail are confidential and may be subject to legal privilege. If you are not the intended recipient you must not use, disseminate, distribute or reproduce all or any part of this e-mail or attachments. If you have received this e-mail in error, please notify the sender and delete all material pertaining to this e-mail. Any opinion or views expressed in this e-mail are those of the individual sender and may not represent those of The New Zealand Institute for Plant and Food Research Limited.