Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Moderate |
| Component | MongoSQL |
| Version | 14.0 |
When a CSV dump of a collection (generated via Export Data feature of ADS) is reimported/restored to a new collection using 'Import Data' feature of ADS, not all field data is imported.
Steps to reproduce this issue:
1) Generate a CSV file of a collection using 'Export Data' feature of ADS. Pls use default parameters.
2) Create a new empty collection and use 'Import Data' feature (with default parameters) to import the CSV file generated from step 1. The 'Sample File Columns' displayed seems to correctly delimit the field data (Pls refer to screenshot importstep.png)
3) After the import is completed, query the destination collection using select * from collection_name or db.collection_name.find()
Expected result:
a) All the fields present in the import file must be restored in the collection.
Actual result:
b) Only the first field data are present in the collection. (Pls refer import_final.png)
I have attached a sample CSV file used (trash.csv)
|
|
65 KB
|
|
66 KB
|
434 B
The fix for issue #8585 doesn't address the problem reported in this issue. Removing the duplicate link.
For this issue, we'll wait for customer feedback and usage. Changing to a future version.
Import of CSV files also does not work into exsited collections. No rows inserted. For tests I used file created manualy and file created by tools/export. Seems that import to newly created colection described above imported 1 column because only _id column shown in the import list and not possible to dd other columns ( as described in ticket 8585). All test I made on Aqua Data Studio 14.0-alpha-27 Build #: 32643 on Ubuntu 12.04( Mongo DB 2.4.3).
Import of CSV files also does not work into exsited collections. No rows inserted. For tests I used file created manualy and file created by tools/export. Seems that import to newly created colection described above imported 1 column because only _id column shown in the import list and not possible to dd other columns ( as described in ticket 8585). All test I made on Aqua Data Studio 14.0-alpha-27 Build #: 32643 on Ubuntu 12.04( Mongo DB 2.4.3).
Made some enhancements to the Format tab of the Import Dialog for MongoDB:
- If a file column name doesn't match any existing field name, add the file column to Collection Field Info with a default data type of "string".
- You can update Field Name and Data Type in Collection Field Info (issue #8585).
- Data Type is a drop-down list.
Made some enhancements to the Format tab of the Import Dialog for MongoDB:
- If a file column name doesn't match any existing field name, add the file column to Collection Field Info with a default data type of "string".
- You can update Field Name and Data Type in Collection Field Info (issue #8585).
- Data Type is a drop-down list.
Verified on ADS 14-beta-55 that the import happens fine for the issue mentioned in the description.
Verified on ADS 14-beta-55 that the import happens fine for the issue mentioned in the description.
Issue #8820 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 14.0.0-beta-22 |
| No time estimate |
3 issue links |
relates to #9367
Issue #9367"Import data" on ADS seems to inadvertantly modify data type |
is a duplicate of #9307
Issue #9307'Collection field info' does not display all the fields |
relates to #8585
Issue #8585Import Dialog enhancements for MongoDB |
The fix for issue #8585 doesn't address the problem reported in this issue. Removing the duplicate link.
For this issue, we'll wait for customer feedback and usage. Changing to a future version.