Help importing Mobs.csv and MobItems.csv

[xSunSet]

Hey everyone

I need some help to import Mobs.csv and MobItems.csv,

I have followed this steps:

You need to run 2 queries in SQL:

Code:
USE PS_GameDefs;
SELECT * FROM Mobs
Code:
USE PS_GameDefs;
SELECT * FROM MobItemsAfter each you need to save them as .csv WITH ANSI ENCODING and make sure you have the column headers included. You can make SQL include the column headers in your .csv files at Tools -> Options -> Query Results -> SQL Server ->
Results to Grid -> Check the "Include column headers when copying or saving the results".
Results to Text -> Check the "Include column headers in the result set."

Open the Monster.SData. Go to File -> Import, and import the 2 .csv tables.

Now in your Data\Monster folder you will have a new file named MonsterEx.SData.

That's quite it. Now whenever you save your Monster.sdata it will generate an .sql file.

But when I import the files there is an error:

Error,the file contains invalid data
the first line must be the column names and starts with "RowID"


Ty for help.

[nubness]

Re-open SQL Server Management Studio and try saving them again.

Make sure your dbo.Mobs and dbo.MobItems tables start with a RowID INT IDENTITY(1,1) column.

[xSunSet]

Thanks for reply,

I try to save them again but the same error appened.

How do I know if they start with INT IDENTITY(1,1) ?

[nubness]

That was the RowID column definition. Do you have that column at all ?

[xSunSet]

Yes I have RowID with int in

[nubness]

And last but not least, are you saving it with ANSI encoding ?

[xSunSet]

Yes

Fixed, I have define RowID as primary key Now I have my MonsterEx.SData

[huyfefe]

Originally Posted by xSunSet

Yes

Fixed, I have define RowID as primary key Now I have my MonsterEx.SData

I can't import, sh studio only have export can you help me

Originally Posted by xSunSet

Yes

Fixed, I have define RowID as primary key Now I have my MonsterEx.SData

Can you help me ?