Non-english cards

[Edmondo]

This is the 1st time I'm creating a database with OpenOffice. Just tell me if it would be ok like this:
http://dl.dropbox.com/u/5447898/MTG%204th%20Test.odb
Ed.

[Goblin Hero]

I imagine to copy/paste the info into the access file. Will that do?

Yes. But remember I need all 5 columns filled: English name, localized name, localized type, localized text, localized flavor.

P.S.: I just discovered that I can only save the database as .odb (OpenOffice). Hope that's not a problem.

I can install OpenOffice if needed.
Try to gather the data for any one set and send it to me,

[AsBest]

Do you mean something like this? Ä Ö Ü ß ?

Yes.

4th Edition example:
http://www.magiccards.info/query?q=e%3A ... rd&s=cname
I think this should be sufficient. I imagine to copy/paste the info into the access file. Will that do?

Look a bit carefully: some text represent new oracle data. Text on original cards is different.

P.S.: I just discovered that I can only save the database as .odb (OpenOffice). Hope that's not a problem.

If you have OpenOffice, better use Calc format.

[Edmondo]

Seems to me that the german text there is the original (awkward) text from the german cards. Should the database contain only the renewed text? I finished the first 60 cards of 4th Edition. If someone (preferably GH) could tell me if it's ok like this, I'd be more than happy to go on. I don't want to enter about 360 cards for nothing. With some time I could do all missing editions in german, so please have a look at what I've done yet and tell me if I can go on like this. Here's my ODB file:
http://dl.dropbox.com/u/5447898/MTG%204th%20Test.odb
In the meantime I'll check out the calc format.
Ed.

[AsBest]

Should the database contain only the renewed text?

No, db should contain only original texts.

[Goblin Hero]

Here's my ODB file

I've opened it with OpenOffice but there're zeroes instead of real data in the table.

[AsBest]

zeroes instead of real data

Have the same and this is strange, because file contain data...
Ed, please, move all data to Calc and repost new file.

[Edmondo]

This turns out to be tougher than I thought.
It should look like this

and then like this:

Ed.

[AsBest]

Yes, first screen looks like yours, but second contains just zeros instead the data...

[Edmondo]

Okay, I found out that I could Drag&Drop every field from Base to Calc, but at some point (after about 140 Drag&Drops) some "Textimport" window came up and both programs (not the whole computer) kinda froze. Is there perhaps a way to import the whole Base thingy into the Calc thingy? I never, ever used Calc (or Excel for that matter) before, so I got no clue what's going on there.
Damn, I'm such a noob!
I really want to help with this, but I do not want to type in everything manually.

Ed.

[Edmondo]

YES!!! I did it!
Figured it out! So, finally, here's your Calc-file.
http://dl.dropbox.com/u/5447898/MTG%204th%20Ed.ods
Man, am I glad this worked!

[Goblin Hero]

Figured it out! So, finally, here's your Calc-file.

It's ok now. I have only one wish: I'd prefer proper line breaks inside text and flavor.

[Edmondo]

Do you mean like it's originally on the card? Can do!

[Goblin Hero]

Do you mean like it's originally on the card?

Yes.

[SoldT]

Hi there!

Well, I only want to ask if it's possible to help you adding some sets in other languages, like Edmondo did with German 4th edition...

I have almost all my cards in Spanish, and have several complete sets... and I love Magic Album, so, if I could help you it would be great.

I read this topic http://www.slightlymagic.net/forum/viewtopic.php?f=32&t=2333 and used the sample database without problem, adding 15 cards from the Onslaught set in Spanish. So if you want, I can continue adding the entire Onslaught cycle and then pass the Db file to you...

Pedro.