Theater conversion from 4.33 to 4.34
-
@Bad:
Why do you want to use excel with the XML database ? Simply use Notepad++
What do you want to do exactly ?
Notepad++ u can’t multi compare (more than 2 and maybe winmerge is better for this) and u get lost to the thousands of lines.
With Excel u have them there in the corner and you can add flags to help you out.
well Falcas better to have and manipulate them all in one tool instead of 2 3 4 tools.
-
You dont need excel for the xml files. If you want to compare use the examdiff tool. I’ve used it extensivelly, along with notepad++.
-
@Nuno:
The problem is that (at least at this stage) I cannot access my old DB files with the new BMS Editor. Everytime I open it, it shows “Iberia” as the selected theater but all the visualized DB structure is the stock KTO one.
Maybe I have to update first all the other folders, and then get back to it.
Thank you
I do not know if it could help, but if I remember corectly, when changing theatre in EDITOR, it is good (or even necessary?) to close it then reopen it.
BB could confirm as he is more accustomed to change the target DB for TvT.
I don’t know if it has been said or written somewhere, but you don’t need ALL the DB files, now you can just apply “deltas” on parts of DB … take a look to TvT database.
-
About XML use or editing. Never do this directly in the files itself. Always use the BMSeditor!!!
You have been warnedGr Falcas
I fully concur.
However, on some VERY specific cases, using Notepad++ may be usefull to make research or batch replace.
To be used EXTREMELY CAREFULLY , errors are very easy to be introduced and likely to happens … Anytime it is possible, pefer a dedicated tool as Cars said.I do REALLY not recommend Excel for DB files for the resons Arty mentioned. Excel may be good for UI files.
Another very nice and usefull feature is the export/import to work on Objectives.
-
Another very nice and usefull feature is the export/import to work on Objectives.
Dee-Jay
When you mention export/import to work on objectives, do you mean using that function in Notepad ++?
-
@Nuno:
Dee-Jay
When you mention export/import to work on objectives, do you mean using that function in Notepad ++?
Nope. In BMS Editor.
Go in “Objective”, either “Export” the entire Objective , or you can select the features you want in the feature list and “Export Selected”. The. You can import them elswhere. Useful in many cases when working on Objectives (at least for me it is usefull).
-
I like excel and manage well working with excel.
Used it to check stations+ils for poh, exporting original (official version) to make my changes, including detection of duplicates of tcn channels, comms freqs, association of IDs, etc… even created my new file from excel… using vba scripting.
Anyways, bms DB is still a big mistery me…Cheers and keep it up.
-
Anyways, bms DB is still a big mistery me…
Sometimes to us also Even with coder’s help it can be tricky. Something I’ve learned working on it with my team mates: Do not trust your “feelings/believes” nor what you are witnessing in game. Sometimes “pragmatism” is a good bet … Sometimes not.
-
Sorry guys… i use notepad ++ for years (not advanced user) and for what we r talking here is like going from Athens to Paris via Moscow. Yeap hard and cold.
Toooo much up and down and looking for a word or value in a mess and just vertical scrolling.
By principal a db is a tabular format. With notepad++ u just kill that and u make your life harder.
Notepad as u say or i know can compare only 2 files simultaneously? I didn’t knew it could compare side by side but i dont believe this is enough.
Besides tabular format u dont even have filters in notepad.
Either im not seeing what u do or mean but for now sounds very simplistic and inefficient. Seems to me U spend more time.What worried me very much is Falcas warning.
Sent from my SAMSUNG-SM-T818A using Tapatalk
-
-
What worried me very much is Falcas warning.
Let me explain a little.
The DB is in Falcon is complecated and there are a lot of cross references to different places. Even outside of the database.
Not many people have a good oversight or good knowledge about everything.
The chance of mistakes and messing up your database is very very high when you do this in notepad or excel.The XML has been introduced to keep track of the changes and being able to revert errors (inside the dev team)
And yes it also gives options to fix things.But you are much much saver to use the BMSeditor which gives you plenty of features and protection.
It even has a good DB testing featureGr Falcas
PS. You have been warned
-
Yeah … as Cars said, it is also a matter of CT/Index links among the different DB parts/files that could be easily scrubbed by using unsuitable “editing” methods. And once those are messed up … good luck to restore the correct links. This is truly critical.
-
Well the point is to edit the database. Since there are links outside then doing it with excel or doing it with Feditor then it will result to the same if you don’t update needed external values. It will not work either way.
So this argument doesn’t say much as you kinda talking about one record edits here, I’m talking about massive ones… and this is the point of this thread.New Vanila came to town ok how do I get my theater updated and compatible in no time for what’s known and just fiddle with the newcomers in the new vanila db version.
Today it struck me like why not use Vanila BMS and EMF or Balkans DB and try to recreate it from Vanila Falcon to end up to EMF or Balkans and see how it goes.
For starters (cause of the outsiders mentioned earlier) just do an import in current EMF and see just if the restructure from vanila will work.
This way you can make sure that the process is ok regarding just core DB update.For the outsiders you mention… an excel is way easier maintained than code and UI. So you can add those external links or references that must be updated also. Maybe excel will not be able to do the job but sure can be set to warn you about it. it’s just conditions.
-
The best is a dedicated tool with many edit/check/comparison/copy/past features.
-
Well the point is to edit the database. Since there are links outside then doing it with excel or doing it with Feditor then it will result to the same if you don’t update needed external values. It will not work either way.
So this argument doesn’t say much as you kinda talking about one record edits here, I’m talking about massive ones… and this is the point of this thread.The argument is about much much more.
But let me say it like this… The advice is to use the BMSeditor and NOT to edit the XML directly. Why… well that is the experiance after many years.
And advice is an advice, use it as you see fitGr Falcas
-
Here is a vid of me using lodediter on 4.34 might be helpful to some.
-
That’s really great, Ned!!
Thank you, I’m studying it and it will prove very helpful, mate!
Cheers
-
Any chance of making this thread a “Sticky”, at least for the time being? It’s going to be quite a hot topic during the coming months.
Thanks
-
This post is deleted! -
Here is a vid of me using lodediter on 4.34 might be helpful to some.
Is there anyway that you can upload this video to Youtube so it can be download to one’s PC system?