bengt

Hello
Is there any ways to export ex. wireconnections to excel in SI 5?
The only "export to csv" function I can find, only exports items. But i need to export the wireconnections as well.

Bengt

Memphix

I am looking for something similar... for my cable labels. Have we gone backwards with exporting options?

SenoS

In SI 5, you can export reports to: PDF, RTF, or HTML. The option to export to Excel was in the Crystal Viewer provided with SI 4 (SI 5 reports are created using Active Reports while SI 4 reports were created using Crystal Reports). If you wish to still use the SI 4 reports from within SI 5, you can use the Legacy Reporting System.
In order to be able to access the Legacy Reporting System, you must have SI 4 installed on your machine. Then open a project and select D-Tools->Reports. Once the Reports interface opens, select File->Legacy Reporting System. Page 525 of the SI 5 User Guide.

RandyB

Originally Posted by bengt

Hello Is there any ways to export ex. wireconnections to excel in SI 5? The only "export to csv" function I can find, only exports items. But i need to export the wireconnections as well. Bengt

Bengt,

You should be able to get the wire connections into excel by creating an excel report (refer to Excel Reports part of User Guide). Since the instructions there are very basic, I will take a look at this and see if there is something I can come up with to get you started.

Also, we are considering adding the capability to export reports from the Reporting Center to excel. Not sure if it will happen, but if it does, this will get you what you need.

Last note - as Senos mentions in his posting, if you have SI4 installed you can run a legacy wire connection report and export that to Excel.

Best regards,

Randy Bownds
Program Manager
D-Tools, Inc

RandyB

Originally Posted by bengt

Hello Is there any ways to export ex. wireconnections to excel in SI 5? The only "export to csv" function I can find, only exports items. But i need to export the wireconnections as well. Bengt

1. We will include the ability to export any report directly to Excel in the next service pack release, due out in March.

2. Until then, I have created the attached Excel report, which contains all of the data included in the Wire Connection report. You may be able to use or modify this to do what you need to do.

You can either import the .zip file and use the report as is (Tools > Import Report), or you can edit the .xls file and import using File > New > Excel Report from the Reporting Center. Note that the Macro which is included only sorts the data by Component ID, so you can enable this safely if you wish.

See the Excel Report Users Guide for more information on creating Excel reports.

P.S. Do not attempt to open the .zip file. Choose the Save option and store the .zip to your hard drive, then use Tools > Import Reports (from Rept Ctr) and browse to the .zip file to import.

Best regards,

Randy Bownds
Program Manager
D-Tools, Inc

bengt

Hello.. this looks great... But when i go in excel to edit xml source, and use "http://www.d-tools.com/schemas/si5/reports/dtoolsreport.xsd"
It doesn't find it.
And when i try to download the attached zip file, I cant use it, becaus the zip archive is damaged.

Regards Bengt

RandyB

Originally Posted by bengt

But when i go in excel to edit xml source, and use "http://www.d-tools.com/schemas/si5/reports/dtoolsreport.xsd" It doesn't find it.

This error was caused by our dtools.com server change last weekend. I believe it is fixed now. If not, it will be soon. Please let me know if you're still having problems.

Quote:

And when i try to download the attached zip file, I cant use it, becaus the zip archive is damaged. Regards Bengt

This may be the result of a known Internet Explorer issue which requires you to change a setting in IE. See this article for details:

http://support.microsoft.com/kb/308090

If you are still having difficulties after this, contact me at beta@d-tools.com and I'll email it to you directly.

Also, just to remind everyone, report.zip files are not meant to be opened or extracted - they are to be imported directly in .zip format into the reporting center. So be sure to use the Save option rather than Open when downloading.

These files always say they are corrupted if you try to Open them. Save them as .zip files, then use Import Report in the Reporting Center and browse to the .zip file.

- Randy

bengt

Hello Randy... Sent a mail to you, but i'll put it in here as well

When i make a excel report file, using the guide you provided. I get an error when loading it into dtools reportingcenter. The log file gives me this.
---
DefaultSource Error 2 Gammelt format eller ugyldig typebibliotek. (Unntak fra HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Translate: old format or invalid typelibrary. (exception from hresult...
Exception Detail
System.Runtime.InteropServices.COMException (0x80028018): Gammelt format eller ugyldig typebibliotek. (Unntak fra HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
ved Microsoft.VisualBasic.CompilerServices.LateBinding .LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
ved Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
ved DTools.SystemIntegrator.Reporting.Client.ExcelData Importer.ValidateExcelFile(String fullFilePath, String schemaURIToValidate)
ved DTools.SystemIntegrator.Reporting.Client.ReportCen ter.ValidExcelReportFile(String fullFilePath)
ved DTools.SystemIntegrator.Reporting.Client.UI.AddRep ortDialog.btnBrowse_Click(Object sender, EventArgs e)
ved System.Windows.Forms.Control.OnClick(EventArgs e)
ved System.Windows.Forms.Button.OnClick(EventArgs e)
ved System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
ved System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
ved System.Windows.Forms.Control.WndProc(Message& m)
ved System.Windows.Forms.ButtonBase.WndProc(Message& m)
ved System.Windows.Forms.Button.WndProc(Message& m)
ved System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
ved System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
--

And when i import the zip file this comes ut:
---
DefaultSource Error 2 Wrong Local header signature: 0x88B1F
Exception Detail
ICSharpCode.SharpZipLib.Zip.ZipException: Wrong Local header signature: 0x88B1F
ved ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNext Entry()
ved DTools.SystemIntegrator.ZipUtility.Archive.UnZip(S tring archiveFileFullPath, String destinationPath)
ved DTools.SystemIntegrator.Reporting.Client.ReportFac tory.ImportReports(String fullPathToArchiveFile)
ved DTools.SystemIntegrator.Reporting.Client.ReportCen ter.ImportReports(String fullPathToArchiveFile)
ved DToolsReportingCenter.ReportingCenter_MDI.importRe port_Click(Object sender, EventArgs e)
ved System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgs e)
ved System.Windows.Forms.ToolStripMenuItem.OnClick(Eve ntArgs e)
ved System.Windows.Forms.ToolStripItem.HandleClick(Eve ntArgs e)
ved System.Windows.Forms.ToolStripItem.HandleMouseUp(M ouseEventArgs e)
ved System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgs e, ToolStripItemEventType met)
ved System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
ved System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgs mea)
ved System.Windows.Forms.ToolStripDropDown.OnMouseUp(M ouseEventArgs mea)
ved System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
ved System.Windows.Forms.Control.WndProc(Message& m)
ved System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
ved System.Windows.Forms.ToolStrip.WndProc(Message& m)
ved System.Windows.Forms.ToolStripDropDown.WndProc(Mes sage& m)
ved System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
ved System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
---

Hope someone can help me...

Regards Bengt

bengt

I just have another question...
Is it possible to get the raw dtoolsreport xml file from any project?

Bengt