The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Data selection in large project

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
jdf726 Posted - 03/07/2018 : 08:51:32 AM
Origin Ver. and Service Release (Select Help-->About Origin): Origin2016 pro
Operating System: Win 7

I have a problem with selecting data in large project, similar to this one -
https://www.originlab.com/forum/topic.asp?TOPIC_ID=20146

I have a large project with something like 20 folders.
Each folder has:
* 20-30 books containing raw data with 12 columns x 30 rows
* half a dozen matrices 12 x 30
* A few 3-tabbed summary workbooks containing various averages and analysis of the raw data,
* A few plots

When I visit the plot setup dialog to add new data to my 'summary' plots (which include data from all folders) I find the data I want to plot by sorting in lots of different ways, but the dialog is very slow to load and I still have to do some scrolling.

If there was some way to filter each column by text search, then this would make data selection easier.
Alternatively, can I programmatically set the summary books to be in the favourites? (they are the ones I am likely to plot from)

One tip for those with a "mega project" like this is that you can loop over all objects in the project and hide them (selectively if you want). I added two custom labtalk functions to my custom menu called
"Hide books with names containing..." and "Hide all matrices." after hiding the raw data books, navigating the structure is much easier!!!

The way things are going, I might have to add "Delete workbook with name containing..."!
I don't want to do this, as this will prevent the project being a 'complete' record of the dataset.


J
6   L A T E S T    R E P L I E S    (Newest First)
cpyang Posted - 03/07/2018 : 12:05:09 PM
No, we are going to add to 2018b when it will be released end of month, and we will make an App that will take advantage of this new internal support. Origin already has built-in query mechanism that the App can use for searching.

CP
jdf726 Posted - 03/07/2018 : 11:55:37 AM
Yes, something like that would be good.

Does a manual "Exclude from plotting dialog" feature already exist?!...


J

cpyang Posted - 03/07/2018 : 11:45:32 AM
Looks like it is a bug with page -x command. It was never documented so nobody noticed this problem before. We will fix it in the upcoming 2018b, and you can contact us for a beta that we are planning to release this week or next and this bug should be fixed in the beta.

Also, we are thinking of making an App that will allow you to search for books and sheets and tag them as "Exclude from Plotting Dialog", will this work for your case?

CP
jdf726 Posted - 03/07/2018 : 10:43:23 AM
This seems to work... but why?

It takes ages, as it renders all of the visible windows in each folder, very disconcerting!

doc -e W {
if (search(page.longname$,"_WB")>0)
{
page.longname$=;
%H=;
win -a %H;
page -X;
}
}
jdf726 Posted - 03/07/2018 : 10:36:58 AM
I can't understand why this doesn't add all workbooks that match the string to the favourites folder!

doc -e W {
if (search(page.longname$,"_WB")>0)
{
page.longname$=;
page -X;
}
}


If I remove the page -X then the books are identified correctly, and if I visit one book and run page -X on the command line it adds it to favourites.

And the "page -x" syntax is not in this description
https://www.originlab.com/doc/LabTalk/ref/Page-cmd


My hunch(es) are that it is

1) Looping over the favourites folder itself my cause a recursive error?
2) If there is already a favourite set, then perhaps it fails upon duplication?
3) The page -X command requires some time? (NO - I used a sec -p 0.1 delay and this didn't help)
4) page -X requires the book to be active?

Any advice?...
jdf726 Posted - 03/07/2018 : 09:19:06 AM
Ok, so I think

page -X

adds a link to favourites, but it didn't work in a loop for some reason.

I found the above by holding down ctrl and shift and then using the right click context menu which links to the File.ogs sheet

(yes, that is a weird trick and I only learned this the other day)

The page setup menu still takes 30 seconds to load and it defaults to "Worksheets in project" I think.


The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000