| Time |
Nick |
Message |
| 02:15 |
|
beanjammin joined #evergreen |
| 07:10 |
|
rjackson_isl joined #evergreen |
| 08:43 |
|
stephengwills joined #evergreen |
| 08:47 |
stephengwills |
Good morning. During my recent upgrade, I lost some report templates. Anyone know where the shared folders data, displayed in the shared folders window of the staff client comes from? I tried reporter.template_folder but the display data doesn’t appear to be stored there. either on my target or my old system. |
| 08:58 |
|
mmorgan joined #evergreen |
| 09:01 |
|
aabbee joined #evergreen |
| 09:15 |
bshum |
stephengwills: The data itself? or the structure? The data itself would be on your filesystem on your application server. In opensrf.xml it specifies where reports are saved to, usually something like /openils/var/web/reporter/* |
| 09:18 |
bshum |
So while the database stores which reports have been run, and where to find them, the output files themselves are generated and stored in places like that. |
| 09:18 |
mmorgan |
stephengwills: Have you looked at reporter.template for the report template data? |
| 09:19 |
mmorgan |
Definitely the output is in the file system rather than the db. |
| 09:30 |
|
jvwoolf joined #evergreen |
| 09:39 |
stephengwills |
i’m still too novice on how the /staff interface works to ask the right question I think. On the interface screen… Shared Folders -> Templates. this opens into a tree of shared template choices. I’m trying to find where that tree gets populated. I’m tearing apart js/ui/default/staff/reporter/services/template.js (and friends) to gain this understanding. I have lots of choices on old system and non on new system eve |
| 09:39 |
stephengwills |
though the contents of the table reporter.template_folder is identical on both new and old systems. |
| 09:40 |
stephengwills |
no choices on new system* |
| 09:44 |
mmorgan |
stephengwills: I believe reporter.template_folder defines the structure of those folders you are seeing in the staff interface. |
| 09:44 |
mmorgan |
reporter.template looks to contain the actual templates, and points back to those folders via the reporter.template.folder field. |
| 09:46 |
csharp |
stephengwills: whether it ends up in the Shared Folders section is determined by the "shared" column on each of the reporter.*_folder tables - the UI must be filtering on those for shared (also, you only see other people's shared folders - your own will show up under My Folders even if they are shared to others) |
| 09:47 |
csharp |
also "share_with" determines the org depth you're sharing with (0 = consortium, 1 = system, 2 = branch, etc.) |
| 09:47 |
* csharp |
goes back to his day off after not being able to resist answering :-) |
| 09:48 |
stephengwills |
ok but reporter.*_folder IS the correct table these template folder names are coming from. thanks Chris… Happy new year. :) |
| 09:48 |
stephengwills |
I’ll leave you alone now, I *gulp* promise |
| 09:48 |
csharp |
actually, I'm wrong - share_with is a specific org_unit ID, not org depth - sorry |
| 09:49 |
stephengwills |
ok |
| 09:50 |
csharp |
stephengwills: if it looks like incomplete loading of shared folders, check to see that someone hasn't set a child folder that's not shared to shared = true |
| 09:50 |
csharp |
I've seen that sort of thing screw up display for everyone else |
| 09:51 |
csharp |
meaning, parent folder shared = false, child folder shared = true |
| 09:51 |
csharp |
should probably be reported as a bug, actually :-/ |
| 09:51 |
stephengwills |
that feels totally like something my peeps would do and often. |
| 09:53 |
csharp |
something like this should work: select * from reporter.template_folder where shared and parent in (select id from reporter.template_folder where not shared); |
| 09:53 |
csharp |
now I'm really going away :-) |
| 09:55 |
mmorgan |
@decide Can csharp stay away? |
| 09:55 |
pinesol |
mmorgan: go with Can csharp stay away? |
| 09:55 |
mmorgan |
Well, that didn't work. |
| 09:56 |
mmorgan |
@eightball Can csharp stay away? |
| 09:56 |
pinesol |
mmorgan: Of course. |
| 09:56 |
mmorgan |
:) |
| 09:57 |
bshum |
csharp++ |
| 09:58 |
bshum |
mmorgan++ # heh :) |
| 10:02 |
stephengwills |
yeah, csharp will never know he’s my hero… and my staff will never know how their templates magically reappear on the last day of 2018. <3 |
| 10:02 |
mmorgan |
csharp++ |
| 10:03 |
mmorgan |
bshum++ |
| 10:37 |
|
mmorgan1 joined #evergreen |
| 11:19 |
|
Christineb joined #evergreen |
| 11:42 |
|
jvwoolf joined #evergreen |
| 12:11 |
|
mmorgan1 left #evergreen |
| 12:12 |
|
beanjammin joined #evergreen |
| 12:37 |
|
jihpringle joined #evergreen |
| 12:57 |
|
jvwoolf joined #evergreen |
| 12:58 |
|
jvwoolf1 joined #evergreen |
| 13:02 |
|
beanjammin joined #evergreen |
| 13:03 |
|
sandbergja joined #evergreen |
| 14:45 |
|
sandbergja joined #evergreen |
