sujaypillai / alfresco-business-reporting

Automatically exported from code.google.com/p/alfresco-business-reporting
0 stars 0 forks source link

Enhancement on harvesting: full refresh #45

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Hi Tjarda,

I notice that if use harvesting in incremental way after a certain period the 
data are not full aligned with lucene index

I suggest to introduce a new harvesting (refreshHarvesting) or a check on 
lessFrequent harvesting (Refresh checkbox) able to drop tables, recreate it and 
execute at least a moreFrequent harvesting

Do you think that could be add on your product roadmap?

Best regards
Vincenzo

Original issue reported on code.google.com by vincenzo...@gmail.com on 25 Nov 2014 at 5:09

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Hi Vincenzo,

Thanks for registering new idea's!

I hear what you're saying. On the other hand I am interested in where the delta 
occurs. 
I think I can make you happy, it is about already there. There is a Jjavascript 
root object called 'reporting'. It can do some administrative tricks 
[[https://code.google.com/p/alfresco-business-reporting/wiki/FAQ?ts=1416950473&u
pdated=FAQ#Can_I_control_reporting_from_Javascript]]. Just updated the Wiki for 
you :-) This code is in for quite a while, however it appeared to be an 
undocumented feature.

I can imagine if you create a light-weight JavaScript based cron job and paste 
in the proper methods clearing, resetting or dropping the appropriate 
tables/rows/dates, you are exactly where you want to be...

I think adding it to the less-frequent-harvesting can be tricy. If you have 
quite some documents (multiple 100.000, or millions) this is a costy exercise 
(see ticket #44). A new type of 'object' or control would me better... But then 
I am not sure what the right sorts of configuration options would be...

How about the Javascript root object, can this work for you??

Original comment by tjarda.p...@incentro.com on 25 Nov 2014 at 9:31

GoogleCodeExporter commented 9 years ago
Hi Tjarda,

Thanks for your rapid answer
I see your suggest, and is exactly what I was looking

The only doubt regard the scheduling time of Javascript based cron job.

I see that even if I set in Alfresco a job that start montly, it's execution 
happen also when restart Alfresco server and this is a condition that I would 
avoid

BR
Vincenzo

Original comment by vincenzo...@gmail.com on 26 Nov 2014 at 4:33

GoogleCodeExporter commented 9 years ago
See release 1.1.0.0. JavaSript methods are added to invoke a 
harvestMoreFrequent() or harvestLessFrequent(); Can be joined with the methods 
mentioned before to drop individual tables, and/or clear the lastreporingrun 
table...

Original comment by tjarda.p...@incentro.com on 15 Apr 2015 at 2:46