It is currently Wed Aug 05, 2020 6:26 am



Post new topic Reply to topic
Author Message
ekstra   ara
 Post subject: SKM report generation
PostPosted: Fri Jul 17, 2020 7:06 am 

Joined: Tue May 29, 2018 8:19 am
Posts: 29
I am trying to find a way in SKM to generate a report with all circuit breaker settings in one report, sorted by bus. I would prefer it in spreadsheet form with one device per row, so it could be easily sorted. I can produce an Excel report for "static trip" devices that is usable. I have not found way to do this for "thermal magnetic" devices that produces a sortable spreadsheet and it is in a different format than the static trip report.

When I talked to SKM support their only suggestion was for me to purchase a full Crystal Reports license and I could run the report I with that.

Reporting has been my biggest frustration with SKM. Has anyone tried Crystal Reports? Any other suggestions?

Thanks,
Alan

_________________
Alan Lehman


Top
 Profile Send private message  
Reply with quote  
 Post subject: Re: SKM report generation
PostPosted: Mon Jul 20, 2020 10:35 am 

Joined: Thu Apr 18, 2019 11:42 am
Posts: 18
I haven't used crystal reports formally for any studies. It's certainly better though than the txt reports. In another life, some smart guy developed a script that did all of the heavy lifting for us.

Sorry I can't be of more help.

Mike


Top
 Profile Send private message  
Reply with quote  
 Post subject: Re: SKM report generation
PostPosted: Mon Jul 20, 2020 11:23 am 

Joined: Tue Feb 17, 2009 8:38 am
Posts: 48
Location: Westminster, MD
Here's how I do it:

Document: component editor; Run, Query, All protective Devices.

Run datablock format (protective device settings)

Run datablock report

Save in Xcel format. Everything will be sorted alphabetically.

Then you can modify in Xcel to make it look good.


Top
 Profile Send private message  
Reply with quote  
 Post subject: Re: SKM report generation
PostPosted: Mon Jul 27, 2020 12:43 pm 

Joined: Tue May 29, 2018 8:19 am
Posts: 29
mpparent wrote:
In another life, some smart guy developed a script that did all of the heavy lifting for us.
Mike


Sounds like I need to find your smart guy...

_________________
Alan Lehman


Top
 Profile Send private message  
Reply with quote  
 Post subject: Re: SKM report generation
PostPosted: Mon Jul 27, 2020 12:58 pm 

Joined: Tue May 29, 2018 8:19 am
Posts: 29
mayanees wrote:
Then you can modify in Xcel to make it look good.


Thanks, but this is the part I struggle with. If it would give me a report in Excel with one device per row it could easily be sorted and parsed as needed, but I've played around with datablock formats and and can't seem to get an output that can be readily sorted. Most devices have data spread over multiple rows and varying numbers of rows depending on the type of device, so it seems like sorting is nearly impossible, except to do it completely manually.

I have a client who requires a concise report with one device per line, sorted by connected bus.

When I explained this to SKM support, their only advice was to buy Crystal Reports. I don't mind doing that if I thought it would give me what I need, but they can't seem to tell me. I was hoping to find someone who has used it.

_________________
Alan Lehman


Top
 Profile Send private message  
Reply with quote  
 Post subject: Re: SKM report generation
PostPosted: Mon Aug 03, 2020 2:59 pm 

Joined: Sun Jul 22, 2007 5:00 pm
Posts: 33
Location: Stratham, SW Australia
Have you tried creating a PTW 'user defined attribute' for sorting the datablocks ?


Top
 Profile Send private message  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
© 2019 Arcflash Forum / Brainfiller, Inc. | P.O. Box 12024 | Scottsdale, AZ 85267 USA | 800-874-8883