csv2sql
csv2sql copied to clipboard
Arp-G
A blazing fast fully-automated CSV to database importer
Add a option which when enabled will attempt to automatically fix csv headers if they are not valid sql column names or if their are duplicate column names.
When a CSV has text data which exceeds the length of TEXT that is 65535 characters then the characters are getting cut off while inserting into DB.
This would be a fantastic tool dockerized. If I knew more about creating dockers I would do it. But its just a suggestion.
When running the application sometimes MySQL gives an error like: ``` %MyXQL.Error{connection_id: 9, message: "(1067) (ER_INVALID_DEFAULT) Invalid default value for 'DateModified'", mysql: %{code: 1067, name: :ER_INVALID_DEFAULT}, statement: "CREATE TABLE csvsql_test.ActivityStream...
- created a start page with a start button to start parsing the CSVs - change the default page from config to start UI for succesfully parsing: [Screencast from 23-01-24...
`AN ERROR OCCURED AND FURTHER PROCESSING WAS STOPPED: %MyXQL.Error{connection_id: 175, message: "(1118) (ER_TOO_BIG_ROWSIZE) Row size too large. The maximum row size for the used table type, not counting BLOBs, is...
The following rows lead to an error like ## Error: ``` %FunctionClauseError{ args: nil, arity: 2, clauses: nil, function: :fixed_integer_impl, kind: nil, module: Combine.Parsers.Text } ``` ## Data: ``` "a080W00001U6ghZQAR","0","SCH-0317-116982","2017-03-22...
An option to switch between the csv file's encoding type before importing.
Bumps [minimist](https://github.com/minimistjs/minimist) from 1.2.5 to 1.2.8. Changelog Sourced from minimist's changelog. v1.2.8 - 2023-02-09 Merged [Fix] Fix long option followed by single dash [#17](https://github.com/minimistjs/minimist/issues/17) [Tests] Remove duplicate test [#12](https://github.com/minimistjs/minimist/issues/12) [Fix]...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}