Page 1 of 1

Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 4:34 am
by bluebuttongames
Hi guys,

So I've exported my items and quest data into a CSV, edited in a google sheet and everything seems fine until when I re-merge it I get this issue:

https://ibb.co/S7V4Z0M

The ZH entry 1 now appears weird and not integrated. I haven't had this issue with any other area I've exported and merged.

Any ideas?

Re: Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 9:10 am
by Tony Li
Hi,

Are you using the Dialogue Editor's Database > Localization Export/Import section?

Or exporting the entire database to CSV using Database > Export Database and then importing it using the CSV Import window?

Can you send your CSV file(s) to tony (at) pixelcrushers.com? I'll be happy to take a look and try to provide an answer.

Re: Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 2:17 pm
by bluebuttongames
I'm using the database panel exporter with these settings:

https://ibb.co/Hgjhw00

I have mailed you the file.

Thanks!

Re: Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 5:51 pm
by Tony Li
Hi,

In your CSV, find the cell "Description zh". Below it is the field's type. Change it from "Text" to "Localization".

The Dialogue Editor is getting a little confused by the field's type and showing everything "zh" as text fields instead of as part of the localization fields.

BTW, to identify the issue, I opened the quest in the Dialogue Editor. Then I expanded All Fields and looked for what was different between the "zh" fields and the other languages. If you notice any issues in the future, All Fields is a helpful place to look.

Re: Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 5:59 pm
by bluebuttongames
That worked, however I'm not sure how that happened. In the template and in the individual entries it was type Localisation.

Perhaps I'll have to fix that on every import/export.

Re: Issues when converting to CSV then back into DB

Posted: Wed Aug 07, 2019 6:41 pm
by Tony Li
It's possible that one of your quests, or your Template, had "Description zh" listed as Text, even if it was listed as Localization elsewhere, and the CSV export just happened to use the Text type instead of Localization.