Please Help With DB Master

[drigOrange]

Hello friends will try to explain "maybe someone from soccergaming understand how to do."

When you open the DB Master teamkit table presents so I do not know how to copy the columns to add new kits.

For example: Alternative Home Stoke City.
So I just need to copy the Home and change the number color. OK

When exporting teamkits and open as Notepad, looks like this:

It becomes unreadable.
It would be easier and faster if it were possible to copy and paste the desired column.

Someone could tell me what is the secret? I am weeks trying to figure out, as the editors who make patches, adcionam columns.

That's what I wonder, waiting for answers and thanks for listening. Sorry for bad English.

 

[bangus]

It would be easier and faster if it were possible to copy and paste the desired column.

Export the tables into a new folder. Open and edit the tables with Excel. Save and import back. If you do it this way, you can easily and quickly copy and paste any desired columns.

 

[drigOrange]

But when opening Excel with the column order are wrong. They are not like the Master DB.

For example:
teamkitid / teamtechid / teamkittypetechid / hasadvertisingkit etc.

If it stayed so would to download directly to apply in a new column of teamkit. Understood?

bangus What is your recommendation? And thanks for the reply.

 

[mrliioadin]

But when opening Excel with the column order are wrong. They are not like the Master DB.

For example:
teamkitid / teamtechid / teamkittypetechid / hasadvertisingkit etc.

If it stayed so would to download directly to apply in a new column of teamkit. Understood?

bangus What is your recommendation? And thanks for the reply.

The column ordering issue is one of the most annoying. There really is nothing else you can do but put them back in order. I recommend writing a script to help with that using either Excel VBA or SQL/MySQL. I know that's not easy to know how to do off the top of your head, but it is not too difficult and I could probably help with some syntax if you can put most of the legwork in. PM if you're still looking for help.

 

[js121]

You don't need to reorder them. When you open it in excel, that is how it's supposed to be. That's how EA has them set up. When DB Master opens the tables, it uses it's own ordering system to make it more user friendly I believe. However, internally, the column order is the same as when you see it open in excel.

For example, export a table, reorder the columns the way you actually see it in DB master, try to import it back like that and you will get an error. So bottom line, export the table, leave column order alone (if you do reorder for whatever editing reason, be sure you put it back), edit, save, and import back to db master.

 

[mrliioadin]

Fuck, you're right. My bad.