[QUESTION] Merge DBC locales?

[xzetaxx]

Hello guys!
Is there any way to merge for example esES(Spanish) and enGB(English) DBC´s?
Im doing a huge DBC modification but only people with the esES WoW can use the patch without errors and it would be cool to merge all the locales into one that supports all languages.

Info: Doing it in a manual way can take me ages, thats why im asking for an automatic way to merge the files.

[schlumpf]

Convert to csv, use excel or alike to copy whole columns.

[xzetaxx]

Well that works with most of .dbc files but when I open the Spell.dbc with Excel the spell description is not appearing as a text, its a number. How can I make the spell description to appear like a text in Excel?

Example:
18817,0,0,0,0x10000,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,,0x0,,0x0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0x0,101,0,0,6

0,60,0,0,0,0,0,,5,0.0,0,0,0,0x0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x0,0x0,-1,0,0x0,9,0,0,1,0,0,0.0,0.0,0.0,34,0,0,0,0,0,6,0

,0,0,0,0,0,0,0,0,0,0,0,0,0,1.0,0.0,0.0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.0,0.0,0.0,0,0,0x0,0,0x0,0,0,0,0,0,0x0,546,0,0x

0,"DrainLife",,,,,,,,,,,,,,,,0xFF01FE,0,,,,,,,,,,,,,,,,0xFF01FC,262273,,,,,,,,,,,,,,,,0xFF01FE,0,,,,,,,,,,,,,,,,0xFF01FC,0,0x0,0

,0,0,0x0,0x0,0x0,0,1,0x0,0,1.0,1.0,1.0,0x0,0,0,0,0,0,0x20,0,0,0,1.0,0.0,0.0,0,0,

[schlumpf]

Depends on your converter.

[xzetaxx]

Can you explain me that better? Wich converter I should use to get the description as text?

[schlumpf]

I'd suggest the reverse: tell us which converter you use. After reading the help / readme of that application.

[xzetaxx]

I use the Dbcutil so it has no Readme but in properties it says:

Nneonneo's DBC<->CSV Converter
Version 1.3.2.0
2MB Size
2006 Year
English

[schlumpf]

http://www.wowresource.eu/index.php?showtopic=918

[xzetaxx]

The download links are down in that page. :S

[schlumpf]

You already have that application?! I was linking there as there is a readme.

[xzetaxx]

I just finished talking with some "known" users from the spanish comunity and we have the same problem trying to merge the locales of the Spell.dbc. The Dbcuil works fine until we convert it again from CSV to DBC, it seems that it brokes the Spell.dbc so you cant use it.
I have tryed all the versions of Dbcuitl that I found but it doesnt work(It does work with other .dbc but not with the spell one). The only one that works is a very old version that doesnt read spell descriptions so its useless. Do you know what could be the problem or if there is any other way to get from CSV to DBC.

[schlumpf]

As described in that linked thread: You can overwrite the auto-column-type-detection of dbcutil, which will fix the problem with the earlier version,