CUBRID Tools

Selecting column values from the multiple tables and export the result into the EXCEL file at once

Details

Description

문제:
개발/기획 부서에서 특정 데이터를 추출해달라는 요청이 많이 들어옴. 독립된 결과창에서 export하기가 매우 어려움

현재:
질의 편집기에서 테이블 1,2,3,4,5..N에 대해 SELECT N개를 실행 -> 질의 결과창이 독립적으로 표시됨 -> 질의 결과창 1에서 엑셀 파일로 export함 --> 질의 결과창 2에서 엑셀 파일 export --> ... --> 질의 결과창 N에서 엑셀 파일 export

개선:
질의 편집기에서 테이블 1,2,3,4,5..N에 대해 SELECT N개를 실행 -> 질의 결과창이 독립적으로 표시됨 -> Export하고자 하는 질의 결과탭을 복수개 선택 --> 한개의 엑셀 파일로 export(sheet 분리)

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
庞启仁 added a comment - 25/Aug/11 3:24 AM

Fix it in CUBRID Manager 8.4.0.2004 and CUBRID Query Browser 1.2.1

Solution:
(1)Add the action [Export all query results to a file] in the left corner in query result toolbar.
(2)Can export the all query results to a file. every query result own one or more sheet
(3)Now supported format are xls and xlsx

Show
庞启仁 added a comment - 25/Aug/11 3:24 AM Fix it in CUBRID Manager 8.4.0.2004 and CUBRID Query Browser 1.2.1 Solution: (1)Add the action [Export all query results to a file] in the left corner in query result toolbar. (2)Can export the all query results to a file. every query result own one or more sheet (3)Now supported format are xls and xlsx
Hide
Permalink
高艳铭 added a comment - 01/Sep/11 1:08 AM

1 Please add field name in export file.
2 when one record is empty, it display empty in xls. but it display (null) in xlsx
3 1)User demodb
Excute INSERT INTO agent(status,host_name) VALUES(1,'高!@#$%^&*()~<>?L:"{}_)(+|,./;''[]\=-09`')
2)Right click export to select.xls
3)open select.xls
Actual result:
it cann't open. but use the added button this version,it's ok
4 When the xls is open, export to the xls, it will display"Cannot rename ".....\select.xls" file to
"......\select.xls.bak"". Suggest to change the information, let them to close the file.

Show
高艳铭 added a comment - 01/Sep/11 1:08 AM 1 Please add field name in export file. 2 when one record is empty, it display empty in xls. but it display (null) in xlsx 3 1)User demodb Excute INSERT INTO agent(status,host_name) VALUES(1,'高!@#$%^&*()~<>?L:"{}_)(+|,./;''[]\=-09`') 2)Right click export to select.xls 3)open select.xls Actual result: it cann't open. but use the added button this version,it's ok 4 When the xls is open, export to the xls, it will display"Cannot rename ".....\select.xls" file to "......\select.xls.bak"". Suggest to change the information, let them to close the file.
Hide
Permalink
庞启仁 added a comment - 05/Sep/11 5:07 AM

Fix it in CUBRID Manager 8.4.0.2007 and CUBRID Query Browser 1.2.1.0007

Show
庞启仁 added a comment - 05/Sep/11 5:07 AM Fix it in CUBRID Manager 8.4.0.2007 and CUBRID Query Browser 1.2.1.0007
Hide
Permalink
高艳铭 added a comment - 08/Sep/11 4:10 AM

1 Please add field name in export file. ok
2 when one record is empty, it display empty in xls. but it display (null) in xlsx ok
3 1)User demodb
Excute INSERT INTO agent(status,host_name) VALUES(1,'高!@#$%^&*()~<>?L:"{}_)(+|,./;''[]\=-09`')
2)Right click export to select.xls
3)open select.xls
Actual result:
it cann't open. but use the added button this version,it's ok ok
4 When the xls is open, export to the xls, it will display"Cannot rename ".....\select.xls" file to
"......\select.xls.bak"". Suggest to change the information, let them to close the file. won't fix

Show
高艳铭 added a comment - 08/Sep/11 4:10 AM 1 Please add field name in export file. ok 2 when one record is empty, it display empty in xls. but it display (null) in xlsx ok 3 1)User demodb Excute INSERT INTO agent(status,host_name) VALUES(1,'高!@#$%^&*()~<>?L:"{}_)(+|,./;''[]\=-09`') 2)Right click export to select.xls 3)open select.xls Actual result: it cann't open. but use the added button this version,it's ok ok 4 When the xls is open, export to the xls, it will display"Cannot rename ".....\select.xls" file to "......\select.xls.bak"". Suggest to change the information, let them to close the file. won't fix
Hide
Permalink
高艳铭 added a comment - 08/Sep/11 4:11 AM

Fixed in version 8.4.0.2008

Show
高艳铭 added a comment - 08/Sep/11 4:11 AM Fixed in version 8.4.0.2008

People

Vote (0)
Watch (0)

Dates

  • Created:
    03/Aug/11 5:32 AM
    Updated:
    08/Sep/11 4:11 AM
    Resolved:
    25/Aug/11 3:24 AM
Atlassian JIRA (v4.3.3#617-r149616) | Report a problem
Powered by a free Atlassian JIRA open source license for CUBRID. Try JIRA - bug tracking software for your team.