View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001480 | Database Workbench v6 | Data Import & Export | public | 2017-03-14 22:25 | 2021-06-08 14:06 |
| Reporter | Doug Chamberlin | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | acknowledged | Resolution | open | ||
| Platform | All | OS | All | OS Version | All |
| Product Version | 5.2.6 | ||||
| Summary | 0001480: Make import from CSV text file easier | ||||
| Description | This request is to add the ability for DBWB to import a CSV file by only selecting the file. It assumes the file contains field names in first row. The resulting table will have a name based on the file name being imported and all fields will be varchar. (Or, if DBWB wants to analyze the data it can set more appropriate field types.) NULL values are always allowed in all fields to avoid errors if a row has missing data. No primary key is defined - that can come later. The idea is to get the data into the RDBMS as easily as possible without a lot of work by the user. Current export operation is almost as easy as needed. Employing a stored set of configuration choices, and only asking the user for the name of the stored set, would be a big plus in making this operation even easier than it already is. | ||||
| Additional Information | DBWB covers the traditional database circumstances very well. However, a new scenario has emerged as prevalent - ad hoc data processing. This is characterized by fast, efficient movement of data between systems for one-time analysis. Usually CSV text files are employed and extremely efficient operations are critical, sometimes at the expense of "proper" data handling. For example, importing a table into all varchar fields is preferred over accurately defined field types if the operation can be done automatically. This request enables DBWB to service this new type of DB usage. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-03-14 22:25 | Doug Chamberlin | New Issue | |
| 2017-03-29 13:42 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2017-03-29 13:42 | Martijn Tonies | Status | new => acknowledged |
| 2021-06-08 14:06 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
