Android Question Localizator creates empty database

[tsteward]

I'm trying to convert this spreadsheet using localizator but it creates an empty database.
I'm guessing something is wrong with my spreadsheet but not sure what.

 

[DonManfred]

I don´t see such a HEADER-Line in your file.
Sure it is right to not having it?

See the Tutorial here:

[B4X] Localizator - Localize your B4X applications

Localizator is a cross platform solution for strings localization. The strings are defined in an Excel workbook. They are then converted to a SQLite database file with a B4J program: The database file should be added to the Files tab of your application. Localizator is a class. You need...

www.b4x.com

 

[tsteward]

I don´t see such a HEADER-Line in your file.
Sure it is right to not having it?
View attachment 158956


See the Tutorial here:

[B4X] Localizator - Localize your B4X applications

Localizator is a cross platform solution for strings localization. The strings are defined in an Excel workbook. They are then converted to a SQLite database file with a B4J program: The database file should be added to the Files tab of your application. Localizator is a class. You need...

www.b4x.com

Not sure I follow, mine looks the same and has worked in the past....

 

[aeric]

I see there is an error message in cell G37. Not sure is it related.
edit: It is not an error. Just a formula.

Do you need to copy the values to a new sheet? The cells contains formulas. Would it works?

 

[tsteward]

I see there is an error message in cell G37. Not sure is it related.
edit: It is not an error. Just a formula.

Do you need to copy the values to a new sheet? The cells contains formulas. Would it works?

 

[tsteward]

I see there is an error message in cell G37. Not sure is it related.
edit: It is not an error. Just a formula.

Do you need to copy the values to a new sheet? The cells contains formulas. Would it works?

Nope I saved results/values only to a new spreadsheet, but it still creates an empty database.

 

[aeric]

Nope I saved results/values only to a new spreadsheet, but it still creates an empty database.

I get a correct db. Make sure the sheet you want to use is on first tab.

 

[tsteward]

I get a correct db.

Thank you and yes that works for me.
What did you do please?

 

[aeric]

Thank you and yes that works for me.
What did you do please?

I just run the B4J convert tool. It also works with the excel file with formula.

 

[tsteward]

Hmmmm something is different as if I download the file I uploaded here it fails but your file works.

Thank You

 

[aeric]

Hmmmm something is different as if I download the file I uploaded here it fails but your file works.

Thank You

The different between my file (lang2.xlsx) and yours in first post (lang.xlsx) is that I copy and paste the values into a new sheet and deleted the old sheet.
Then I also tested with your original file.
Both files converted successfully.