1 / 7

Questions/problems with Data Export Wizard

Questions/problems with Data Export Wizard. 27 Feb 2014. 2/27/2014 2:30:36 AM: PBM_Weekly.log: Connection node found -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: Connection to: xxx (KD034A), xxx_T -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: Begin Export

phyre
Download Presentation

Questions/problems with Data Export Wizard

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Questions/problems with Data Export Wizard 27 Feb 2014

  2. 2/27/2014 2:30:36 AM: PBM_Weekly.log: Connection node found -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: Connection to: xxx (KD034A), xxx_T -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: Begin Export -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: SQL to execute: SELECT ALL to_char(wip_order.date_complete_actual,'YYYY-MM') "Compl Month", … order by …. -- 2/27/2014 2:30:42 AM: PBM_Weekly.log: Beginning export -- 2/27/2014 2:30:53 AM: PBM_Weekly.log: Attempted to export 107 rows -- 2/27/2014 2:30:53 AM: PBM_Weekly.log: Successfully exported 107 rows -- 2/27/2014 2:30:54 AM: PBM_Weekly.log: Export Finished, click PBM_40304_Efficiency_byDept.xlsx to view file -- 2/27/2014 2:30:54 AM: PBM_Weekly.log: Row count variable File_40304_Efficiency_byDept_RCOUNT set to 107 rows -- 2/27/2014 2:30:54 AM: PBM_Weekly.log: Running export template C:\_reports\PBM_Export_template.txp -- 2/27/2014 2:30:55 AM: PBM_Weekly.log: Connection description = xxx (KD034A), xxx_T -- 2/27/2014 2:30:55 AM: PBM_Weekly.log: Connection node found -- 2/27/2014 2:30:58 AM: PBM_Weekly.log: Connection to: xxx (KD034A), xxx_T -- 2/27/2014 2:30:58 AM: PBM_Weekly.log: Excuting export using connection xxx (KD034A), xxx_Tspelling -- 2/27/2014 2:31:12 AM: PBM_Weekly.log: Attempted to export 28 rows. -- 2/27/2014 2:31:12 AM: PBM_Weekly.log: Successfully exported 28 rows. -- 2/27/2014 2:31:12 AM: PBM_Weekly.log: Export Finished, click PBM_40304_Efficiency_Detail.xlsm to view file. -- 2/27/2014 2:31:12 AM: PBM_Weekly.log: Export_PBM_40304_Efficiency_Detail - An item with the same key has already been added. -- 2/27/2014 2:31:13 AM: PBM_Weekly.log: Continuing after error -- 2/27/2014 2:31:13 AM: PBM_Weekly.log: Started generating report -- 2/27/2014 2:31:13 AM: PBM_Weekly.log: Connection description = xxx (KD034A), KD034A -- 2/27/2014 2:31:14 AM: PBM_Weekly.log: Connection node found -- 2/27/2014 2:31:14 AM: PBM_Weekly.log: Connection to: xxx (KD034A), xxx_T -- 2/27/2014 2:31:25 AM: PBM_Weekly.log: Connection description = xxx (KD034A), KD034A -- 2/27/2014 2:31:26 AM: PBM_Weekly.log: Connection node found -- 2/27/2014 2:31:26 AM: PBM_Weekly.log: Connection to: xxx (KD034A), xxx_T -- 2/27/2014 2:31:41 AM: PBM_Weekly.log: Report Finished, click PBM_6020404_Timeliness.pdf to view file. Is this due to the SQL being appended in a new tab that already has the same name? (See last page) Why are the SQL tabs named the way they are?

  3. Export Template can unintentionally be deleted Clicking here causes the Template reference to be deleted:

  4. Navigating the Export Wizard ‘forward’

  5. Navigating the Export Wizard ‘backward’- different screens appear Columns do not appear

  6. Navigating the Export Wizard ‘forward’ from ‘Select Objects’ Columns appear

  7. New Query tab added to exported sheet for each run – no evident option to turn this off Not selected Excel tabs show SQL repeated for each run: After running again:

More Related