Repository navigation
CSV import into a chosen schema, match columns by name, and locale number display - #4251
Open
deepsidhu1313 wants to merge 3 commits into
Open
deepsidhu1313 wants to merge 3 commits into
deepsidhu1313 wants to merge 3 commits into
Conversation
The Import CSV dialog always created the table in the main schema and looked for an existing table of that name there. Add a Schema selection next to the table name so a file can be imported into the temp schema or into an attached database. It defaults to main, so nothing changes unless the user picks another schema. The temp schema is always offered because SQLite does not report it until something has been created in it. The INSERT statement used the unqualified table name, so rows went to a temp table of the same name instead of the table which had just been created in main. Use the schema qualified name for it. Close: sqlitebrowser#2443
When importing a CSV file into an existing table, the columns of the file were inserted in the order they are in, whatever their names were. A file with the columns in a different order than the table, or with additional columns, could not be imported without editing it first. Add the advanced option "Match columns by name". When it is on and the first line contains the column names, each column of the file is imported into the table column with the same name (ignoring the case). Columns of the file which have no match are skipped and columns of the table which are not in the file get their default value. The option is off by default, so the import works as before unless it is turned on. It only has an effect on tables which exist already. Refs: sqlitebrowser#243
Numbers in the data browser were always shown the way SQLite writes them, e.g. 1234567.5, whatever the number format of the user is. Add the option "Show numbers in the system number format" to the data browser preferences. When it is on, the values of columns with an INTEGER, REAL or NUMERIC type affinity are shown with the digit grouping and the decimal separator of the system locale, e.g. 1.234.567,5. It is off by default, so nothing changes unless the user turns it on. Only the display changes. The digits are never rounded, and what is edited, copied or exported stays the plain number. Values which are not plain decimal numbers, such as text or numbers with an exponent, and columns with a display format are left as they are. Columns without a numeric type and the results of SQL queries are not changed either because there is nothing which tells a number from a text in them. Refs: sqlitebrowser#3718
This branch has not been deployed
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Three independent commits.
Refs #2443, #243, #3718