How convert txt to sql

[BrOgBr]

Someone can help me?

How convert item_db.txt to item_db.sql, like the rAthena's github does with the "SQL synchronization"?

[Secrets]

Just download a perl runtime or w/e it is then execute the file. You don’t have to know Perl to use the tool. For Windows install StrawberryPerl or ActivePerl.

[Secrets]

1 hour ago, BrOgBr said:

Thank you Secrets and Nitrous.
I'll try here.

@Edit 

@Secrets I need change something at convert_sql.pl?

I tried click in it but nothing happened... (choosing execute Perl Program)

It opens the cmd but closes instantly.

I checked the item_db_re.sql but nothing changed.

Help please.
 

You need to run the file in command line because it needs some additional command line parameters.

[Frost Diver]

On 2/14/2018 at 12:37 PM, BrOgBr said:

I tried but I got this error:

ERROR: Filename_in and Filename_out are required to continue.

It worked!
I edited the convert_sql.pl, now I've learned.

Thank you very much @Secrets 

Hi, how u edit it? Please share your solutions here. Thanks!

[nitrous]

There are scripts in the tools directory, I think it's something like convert_sql.pl

[BrOgBr]

1 hour ago, Nitrous said:

There are scripts in the tools directory, I think it's something like convert_sql.pl

I found it.
But I need download Perl?
I don't know how to use perl 

[BrOgBr]

Thank you Secrets and Nitrous.
I'll try here.

@Edit 

@Secrets I need change something at convert_sql.pl?

I tried click in it but nothing happened... (choosing execute Perl Program)

It opens the cmd but closes instantly.

I checked the item_db_re.sql but nothing changed.

Help please.
 

Edited February 14, 2018 by BrOgBr

[BrOgBr]

55 minutes ago, Secrets said:

You need to run the file in command line because it needs some additional command line parameters.

I tried but I got this error:

ERROR: Filename_in and Filename_out are required to continue.

It worked!
I edited the convert_sql.pl, now I've learned.

Thank you very much @Secrets 

Edited February 14, 2018 by BrOgBr