Expanding an Object before Exporting it

3 posts / 0 new
Last post
avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28
Expanding an Object before Exporting it
avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28

The + buttons can be used to expand a Gap Detection object before exporting the detailed object to Excel.
working in a Script mode The summarized object can be exported from within a script (by creating a GapDetection database first ), but I could not find a way to expand a Gap Detection object from within a script before exporting it.

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Avi,

This is a bit of a problem and unfortunately IDEA and IDEAScript doesn't really have a good solution for this.  In the past I have used two options, one is you create a new file in IDEAScript that lists all the JE Number entries, you summarize the file you are looking for gaps the gaps and then do a join with the summary file as primary, the new file as secondary and then extract all non-secondary matches to have your missing items file.

The other way is you will also have to create a new file but you can loop through all the JE NO looking for missing items and create the file directly that way.

Unfortunately I haven't figure out an easy way to get around this.

Brian