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.
|