[REQUEST] CSV files Mob and mobitems

[driesy1]

hey yyes its been explained again and again i jus for some reason cant get my head around doing it. could someone with the ep6 mob set up able to post here the 2 files mob.csv and mobitem.csv for me please ive been trying and trying to get them from the db ive done eveything i can think off and ive read and it jus dont work.


sory to b a hassel

[ShaiyaHaven]

If you already have the mobs and mobitems in the database correctly (full ep "6") like it seems you do from the post, then all you have to do it create a Monster.ex in ShStudio, which I assume you're trying to do. If this is the case, I wrote a step-by-step guide just a few days ago on how to do it:

That should help. ^^ Good luck!

[driesy1]

Originally Posted by ShaiyaHaven

If you happen to check this anymore after all this time, just use the SELECT function to grab the info you want:

SELECT * FROM PS_[COLOR="Red"]DatabaseName[/COLOR].dbo.[COLOR="red"]TableName[/COLOR]

Fill in the DatabaseName and TableName parts with the real DB and Table names, obviously; like PS_GameData.dbo.Chars, or PS_GameDefs.dbo.Mobs, etc.

Before the next step, make sure you have SQL set to save the headers of the table, if you need them (if not, skip this). If this is for ShStudio, you will indeed have to do this. You'll find the option here:

SQL Management Studio Tools menu > Options > Query Results > SQL Server > Results to Grid > check box for "Include column headers when copying or saving the results" > Ok

You may want to restart Management Studio to make sure those changes take effect, in which case you will need to run the SELECT query again before moving on. Then, click on the top left square of the results window, the one that highlights the entire results grid. Right click, Save Results As... The save window pops up. Just make sure the file type is CSV, and you're good to go.

If this is specifically for making a Monster.EX for ShStudio, it goes a little further. Type the name of the file (Mobs or MobItems). Instead of just hitting the "Save" button, click the tiny black arrow next to it and select "Save with encoding". Change the dropdown option to ANSI, then hit OK and it should save. Then open the Monster.Sdata and File > Import, import BOTH files before saving, then save. A Monster.EX should have been generated.

Good luck to you on your journey!

shaiyahaven when i run this step by step the only way i can save it is sql files text files or all files there aint no CSV and im using microsoft SQL management studio

[ShaiyaHaven]

You have to manually enter .csv as the format. On the Save menu, when you type in the name, there is a drop-down menu beneath it that says "File type". You have to change it to "All file types", then actually type in "Mobs.CSV" and "MobItems.CSV".

I didn't know I had to teach you how to use a computer too. o.O Honestly, if you don't even know how to save as a file type other than the one listed, maybe you don't want to be trying to run a server... that's not an insult, just a suggestion. If you don't even have basic knowledge of using a computer, running a server is going to kick your a**. x)

[Dread123]

well i ran this step by step and yes headers are selected saved as ansi and all i get is

invalid information must start with rowID

and doesnt import been trying to export every possible way any ideas?

[Elessar2]

It's a little late I wanted to share because nobody did anything

[bharwey]

Use BMS scripts.