tsteward Well-Known Member Licensed User Longtime User Nov 27, 2024 #1 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. Attachments lang.xlsx lang.xlsx 73.3 KB · Views: 259
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 Expert Licensed User Longtime User Nov 27, 2024 #2 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 Upvote 0
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 Well-Known Member Licensed User Longtime User Nov 27, 2024 #3 DonManfred said: 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 Click to expand... Not sure I follow, mine looks the same and has worked in the past.... Upvote 0
DonManfred said: 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 Click to expand... Not sure I follow, mine looks the same and has worked in the past....
aeric Expert Licensed User Longtime User Nov 27, 2024 #4 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? Upvote 0
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 Well-Known Member Licensed User Longtime User Nov 27, 2024 #5 aeric said: 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? Click to expand... Upvote 0
aeric said: 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? Click to expand...
tsteward Well-Known Member Licensed User Longtime User Nov 27, 2024 #6 aeric said: 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? Click to expand... Nope I saved results/values only to a new spreadsheet, but it still creates an empty database. Upvote 0
aeric said: 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? Click to expand... Nope I saved results/values only to a new spreadsheet, but it still creates an empty database.
aeric Expert Licensed User Longtime User Nov 27, 2024 #7 tsteward said: Nope I saved results/values only to a new spreadsheet, but it still creates an empty database. Click to expand... I get a correct db. Make sure the sheet you want to use is on first tab. Attachments lang2.xlsx lang2.xlsx 47.2 KB · Views: 261 Upvote 0
tsteward said: Nope I saved results/values only to a new spreadsheet, but it still creates an empty database. Click to expand... I get a correct db. Make sure the sheet you want to use is on first tab.
tsteward Well-Known Member Licensed User Longtime User Nov 27, 2024 #8 aeric said: I get a correct db. Click to expand... Thank you and yes that works for me. What did you do please? Upvote 0
aeric said: I get a correct db. Click to expand... Thank you and yes that works for me. What did you do please?
aeric Expert Licensed User Longtime User Nov 27, 2024 #9 tsteward said: Thank you and yes that works for me. What did you do please? Click to expand... I just run the B4J convert tool. It also works with the excel file with formula. Upvote 0
tsteward said: Thank you and yes that works for me. What did you do please? Click to expand... I just run the B4J convert tool. It also works with the excel file with formula.
tsteward Well-Known Member Licensed User Longtime User Nov 27, 2024 #10 Hmmmm something is different as if I download the file I uploaded here it fails but your file works. Thank You Upvote 0
Hmmmm something is different as if I download the file I uploaded here it fails but your file works. Thank You
aeric Expert Licensed User Longtime User Nov 27, 2024 #11 tsteward said: Hmmmm something is different as if I download the file I uploaded here it fails but your file works. Thank You Click to expand... 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. Upvote 0
tsteward said: Hmmmm something is different as if I download the file I uploaded here it fails but your file works. Thank You Click to expand... 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.
