10 réponses à ce sujet

[Anny78]

Tried "drag and drop" and it didn't work, tried "using bat file" and it doesn't work either - no error messages, but the GDA is nowhere to be found, please help. 

Modifié par Anny78, 17 août 2012 - 07:11 .

[DarthParametric]

If you didn't get a GDA then that means there was an error. When dragging and dropping (and presumably when using a batch file as well), the commandline window should remain open reporting the error. The most common error is an incorrect filename. GDA filenames are determined by the XLS sheet name/s (each sheet in an XLS will be exported as a GDA, except those with an underscore ( _ ) prefix). Sheet names can only be a maximum of 27 characters long.

There are various pages on the wiki that you may wish to peeruse. This should be a good starting point - http://social.biowar...g_GDAs_tutorial

[Anny78]

Thank you, but nothing helped so far. The name of my sheet was too long, I thought that soves my problem, but no change after renaming. Checked the toolset wiki, just to be sure and from my point of view is everything ok. Still getting no error messages (the batch file window is always reporting "Success!" damn thing) and still getting no gda. :-(

Might the problem be in Windows 2000? Or in Open Office - I'm creating the sheet in it and then saving it as an MS Excel 97/2000/XP (*.xls) file.

[DarthParametric]

Ah, OpenOffice. Yes, it doesn't save XLS in the proper format. Upload your file to Google Docs, then save it as a new XLS. Should work then. I recall that was mentioned on one of the wiki pages, but can't remember where. I should add it to the page I linked to earlier.

[BlackSheep42]

As an addendum (sp?) to this topic, I found that when using MS Office 2010 the file did not compile automatically - I had to first save the spreadsheet as an Excel 97 workbook, and then it compiled fine. Just something that future readers of this thread might find answeres their query.

[Anny78]

DarthParametric wrote...

Ah, OpenOffice. Yes, it doesn't save XLS in the proper format. Upload your file to Google Docs, then save it as a new XLS. Should work then. I recall that was mentioned on one of the wiki pages, but can't remember where. I should add it to the page I linked to earlier.

Tried this, but it got even worse, I got a Windows message, that the Excel Processor stopped working.
Makers breath, I'll try the last thing I can now (i think), I'll wait for my dear half to come home with his notebook and I'll write a new sheet in his MS Excel.

[DarthParametric]

BlackSheep42 wrote...

I found that when using MS Office 2010 the file did not compile automatically - I had to first save the spreadsheet as an Excel 97 workbook, and then it compiled fine.

By default, Excel 2007/2010 will save in the newer XLSX format, which is not compatible. You have to choose Save As and save it in the legacy XLS format.

Anny78 wrote...

Tried this, but it got even worse, I got a Windows message, that the Excel Processor stopped working.

Yeah I just tried it myself making an entirely new document via Google Docs (rather than converting an existing file) and got the same issue. I guess they changed how it works. That pretty much means Excel is the only option, unless there is some other converter out there that exports compliant files.

Edit: Here's something interesting. Just found a free app that will convert from CSV to XLS. Did a quick test and it converted fine into a GDA except for the filename, as the sheet name defaults to "untitled", but that is easily remedied. So just export a CSV out of Open Office or Google Docs, then convert that to an XLS. You can grab it here - http://bytescout.com...sheettools.html

A scan on Virus Total comes up clean, but it does try to phone home, so you'll probably want to block it in your firewall.

Modifié par DarthParametric, 17 août 2012 - 05:14 .

[Anny78]

...
 I'll wait for my dear half to come home with his notebook and I'll write a new sheet in his MS Excel.

Did this and it worked like a charm!


@Darth Parametric

Thank you very much for all the help!

[sea-]

http://social.bioware.com/project/755/

Or get this and never touch Excel ever again.

Modifié par sea-, 18 août 2012 - 02:17 .

[DarthParametric]

GDApp is a very helpful tool, but it's not super great when dealing with large sheets. Take APR_base as an example. For something of that scale you really need a proper spreadsheet app (unless you want to be there forever). However, GDApp is extremely useful for making minor alterations to existing compiled GDAs to save you having to recompile new ones. Things like changing an ID number for a particular row for example.

[sea-]

Well okay, sure, if you are making alterations to huge tables, and don't want to use an M2DA, use Excel, you're right in that the UI is better.  Still, I can't think of a single time I've ever used it outside of exporting the original tables I want to modify.

Modifié par sea-, 18 août 2012 - 03:09 .