Supporting NULL data option for both Data Import and Export and moving the option setting menu inside Data import, Export UI

Details

Description

The issue should be applied to CM and CQB.
There is an option to set "NULL" data for Data import. Users should click <file>/<default setting>/<Data import Option>

1) It is hard to find the NULL data related option when Data importing. The option setting UI should be merged in Data importing UI menu.

2) CM and CQB only supports "NULL" data option only for Data import. It is necessary when users exporting data from the DB. The same option should be in Data export UI.

Data import/export is a feature so useful to users. The feature/UI should consider user experience.

  1. File
    CODE_REVIEW.creview
    08/Mar/12 1:28 AM
    50 kB
    付雷
  1. 2012-03-07 13-27-38.PNG
    17 kB
    07/Mar/12 12:29 AM
  2. T3.PNG
    6 kB
    18/Mar/12 11:19 AM

Issue Links

blocks

Bug - A problem which impairs or prevents the functions of the product. TOOLS-876 [CM8.4.1.2] When export char data type to csv by change appointed word to null, it doesn't work

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.
relates to

Improvement - An improvement or enhancement to an existing feature or task. TOOLS-799 Data export after SELECT WHERE in CQB and CM

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Laura Oh added a comment - - edited

In addition, if a user export data from DB to csv file, " " embraces are not displayed in the string type data. However if a user opens that file in the MS Word or other text tool, it shows " ".
DBAs periodically exports/imports Data using CQB or CM to deliver to other department otherwise to move data into other DBMS such as Mysql, MSsql and so on. If the format is broken or different, users will encounter inconvenience.

Show
Laura Oh added a comment - - edited In addition, if a user export data from DB to csv file, " " embraces are not displayed in the string type data. However if a user opens that file in the MS Word or other text tool, it shows " ". DBAs periodically exports/imports Data using CQB or CM to deliver to other department otherwise to move data into other DBMS such as Mysql, MSsql and so on. If the format is broken or different, users will encounter inconvenience.
Hide
Permalink
Isaiah Choe added a comment -

I think, it is good to include some options the import dialog as attached image.

Show
Isaiah Choe added a comment - I think, it is good to include some options the import dialog as attached image.
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed

Show
付雷 (Inactive) added a comment - Fixed
Hide
Permalink
Isaiah Choe added a comment -

It is included to handle NULL string on export dialog (T3.PNG).

Show
Isaiah Choe added a comment - It is included to handle NULL string on export dialog (T3.PNG).
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2

Show
高艳铭 added a comment - Fixed in CM8.4.1.2
Hide
Permalink
高艳铭 added a comment -

Use the table of a in demodb

server: 10.34.64.146,8007, dba 2222

the function isn't work.

Show
高艳铭 added a comment - Use the table of a in demodb server: 10.34.64.146,8007, dba 2222 the function isn't work.
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed at TOOLS0876

Show
付雷 (Inactive) added a comment - Fixed at TOOLS0876
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed at TOOLS-876

Show
付雷 (Inactive) added a comment - Fixed at TOOLS-876
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2003

Show
高艳铭 added a comment - Fixed in CM8.4.1.2003

People

  • Assignee:
    高艳铭
    Reporter:
    Laura Oh
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: