B4J Question (Solved)[B4X] Localizator Tool - strings.db -> strings.xlsx

[aeric]

Refer to this tutorial

[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

Erel has provided a tool to convert the Excel file to SQLite file.

My mistake that I have manually created the strings.db file without the strings.xlsx file.

Now I am thinking to organize the file and check if I have missed any item.
Anyone have created a similar tool to convert the string.db back to strings.xlsx file?
Mind to share here?
If I have missed any thread with the solution, please point me to the post. Thanks.

 

[Magma]

Refer to this tutorial

[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

Erel has provided a tool to convert the Excel file to SQLite file.

My mistake that I have manually created the strings.db file without the strings.xlsx file.

Now I am thinking to organize the file and check if I have missed any item.
Anyone have created a similar tool to convert the string.db back to strings.xlsx file?
Mind to share here?
If I have missed any thread with the solution, please point me to the post. Thanks.

DB Browser for SQLite have export as csv, json

DB Browser for SQLite

sqlitebrowser.org

 

[aeric]

Yes, I can copy and paste to Excel too.
I also ask ChatGPT to help me convert the file.
I am wondering if anyone already created such tool so it is more convenient with 1 click of a button.

 

[Magma]

This is a gift from me ;-)

 

[aeric]

This is a gift from me ;-)

I just done my version too.

GitHub - pyhoon/localizator-file-converter-b4j

Contribute to pyhoon/localizator-file-converter-b4j development by creating an account on GitHub.

github.com

Expected output

 

[aeric]

This is a gift from me ;-)

Err...
Nice but the output is not I expected.

 

[Magma]

You mean the column width ? (This is something you must decide if you wanna do automatically)

here another version get all table names -> turn them all sheets:

Public Sub ExportTablesToXLSX(dbPath As String, dbfilename As String, exportfilename As String)

    
    ' Δημιουργία κενού workbook
    Dim Workbook As XLWorkbookWriter = xl.CreateWriterBlank



    Dim SQL2 As SQL
    SQL2.InitializeSQLite(dbPath,dbfilename,  False) ' True για read-only
            
    ' Λήψη των table names
    Dim rs2 As ResultSet = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'")

    Do While rs2.NextRow
    
    
    ' Δημιουργία sheet
    Dim sheet As XLSheetWriter = Workbook.CreateSheetWriterByName(rs2.GetString("name"))

    Dim rs As ResultSet = SQL1.ExecQuery("SELECT * FROM " & rs2.GetString("name"))
    ' Γράφουμε τα ονόματα των πεδίων ως τίτλους στη πρώτη σειρά
    Dim colCount As Int = rs.ColumnCount
    For col = 0 To colCount - 1
        sheet.PutString(xl.AddressZero(col, 0), rs.GetColumnName(col))
    Next

    ' Γράφουμε τις γραμμές δεδομένων
    Dim rowIndex As Int = 1
    Do While rs.NextRow
        For col = 0 To colCount - 1
            sheet.PutString(xl.AddressZero(col, rowIndex), rs.GetString2(col))
        Next
        rowIndex = rowIndex + 1
    Loop

    rs.Close
    
    Loop

    ' Αποθήκευση του αρχείου
    Workbook.SaveAs(dbPath, exportfilename, True)
    

End Sub

 

[aeric]

Time for dinner.
When I free, I will add the function for 2-way conversion.