Collect usage stats on office content

[Paul Everitt]

Nat would like a listing of every content item under /offices, downloadable to a spreadsheet.

Let's provide a link in ADMIN for this called "Office Dump". You click on it and get a CSV dump with the following columns:

- File Title
- Office
- Last Updated By (User)
- Last Updated On (Date)
- File Type
- URL

I think we could use the new jsonindex for this to avoid blowing up the universe on cache. Presumably this isn't more than a few thousand objects, so not too big of a CSV response.

[Paul Everitt (paul-agendaless)]

Adding Nat as nosy on this. Carlos, I slotted this for Feb (as Jan is already full.)

[Jim Fulton (jim-zope)]

Do you want the URL? Or just the path?

[Jim Fulton (jim-zope)]

Should the output have a headings row?

[Jim Fulton (jim-zope)]

You say "file" and "content". Do you mean just files (karl.content.models.files.CommunityFile)? Or all IContent.

What is the file type?

[Jim Fulton (jim-zope)]

I started this because it looked like low-hanging fruit. :)

[Nat Katin-Borland (nborland)]

If it's possible to have the full URL that is preferable. And yes to the title. Thanks!

Sent with Good (www.good.com)

-----Original Message-----
From: Jim Fulton [<email address hidden><mailto:<email address hidden>>]
Sent: Sunday, April 30, 2017 12:20 PM Eastern Standard Time
To: Nathaniel Katin-Borland
Subject: [Bug 1655655] Re: Collect usage stats on office content

Should the output have a headings row?

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1655655

Title:
  Collect usage stats on office content

Status in KARL4:
  New

Bug description:
  Nat would like a listing of every content item under /offices,
  downloadable to a spreadsheet.

  Let's provide a link in ADMIN for this called "Office Dump". You click
  on it and get a CSV dump with the following columns:

  - File Title
  - Office
  - Last Updated By (User)
  - Last Updated On (Date)
  - File Type
  - URL

  I think we could use the new jsonindex for this to avoid blowing up
  the universe on cache. Presumably this isn't more than a few thousand
  objects, so not too big of a CSV response.

To manage notifications about this bug go to:
https://bugs.launchpad.net/karl4/+bug/1655655/+subscriptions

[Jim Fulton (jim-zope)]

Thanks re the title line and full url.

I still need to know if this is just community files, or all content? And if all content, what is the meaning of file type?

[Nat Katin-Borland (nborland)]

It's just content uploaded to the office homepages. File type is doc, PDF, exls. JPEG etc.

Sent with Good (www.good.com)

-----Original Message-----
From: Jim Fulton [<email address hidden><mailto:<email address hidden>>]
Sent: Sunday, April 30, 2017 01:25 PM Eastern Standard Time
To: Nathaniel Katin-Borland
Subject: [Bug 1655655] Re: Collect usage stats on office content

Thanks re the title line and full url.

I still need to know if this is just community files, or all content?
And if all content, what is the meaning of file type?

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1655655

Title:
  Collect usage stats on office content

Status in KARL4:
  New

Bug description:
  Nat would like a listing of every content item under /offices,
  downloadable to a spreadsheet.

  Let's provide a link in ADMIN for this called "Office Dump". You click
  on it and get a CSV dump with the following columns:

  - File Title
  - Office
  - Last Updated By (User)
  - Last Updated On (Date)
  - File Type
  - URL

  I think we could use the new jsonindex for this to avoid blowing up
  the universe on cache. Presumably this isn't more than a few thousand
  objects, so not too big of a CSV response.

To manage notifications about this bug go to:
https://bugs.launchpad.net/karl4/+bug/1655655/+subscriptions

[Jim Fulton (jim-zope)]

OK, thanks.

[Jim Fulton (jim-zope)]

This is staged. To try it out, click on the "Office Dump" link here:

https://karlstaging.gocept.com/admin.html

[Paul Everitt (paul-agendaless)]

Geez that’s fast.

—Paul

> On May 1, 2017, at 9:27 AM, Jim Fulton <email address hidden> wrote:
>
> This is staged. To try it out, click on the "Office Dump" link here:
>
> https://karlstaging.gocept.com/admin.html
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1655655
>
> Title:
> Collect usage stats on office content
>
> Status in KARL4:
> New
>
> Bug description:
> Nat would like a listing of every content item under /offices,
> downloadable to a spreadsheet.
>
> Let's provide a link in ADMIN for this called "Office Dump". You click
> on it and get a CSV dump with the following columns:
>
> - File Title
> - Office
> - Last Updated By (User)
> - Last Updated On (Date)
> - File Type
> - URL
>
> I think we could use the new jsonindex for this to avoid blowing up
> the universe on cache. Presumably this isn't more than a few thousand
> objects, so not too big of a CSV response.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/karl4/+bug/1655655/+subscriptions

[Nat Katin-Borland (nborland)]

Jim, this looks great. Definitely what I had in mind. I agree with Paul on the speed - wow!

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Paul Everitt
Sent: Monday, May 1, 2017 9:43 AM
To: Nathaniel Katin-Borland <email address hidden>
Subject: Re: [Bug 1655655] Collect usage stats on office content

Geez that’s fast.

—Paul

> On May 1, 2017, at 9:27 AM, Jim Fulton <email address hidden> wrote:
>
> This is staged. To try it out, click on the "Office Dump" link here:
>
> https://karlstaging.gocept.com/admin.html
>
> --
> You received this bug notification because you are subscribed to the
> bug report.
> https://bugs.launchpad.net/bugs/1655655
>
> Title:
> Collect usage stats on office content
>
> Status in KARL4:
> New
>
> Bug description:
> Nat would like a listing of every content item under /offices,
> downloadable to a spreadsheet.
>
> Let's provide a link in ADMIN for this called "Office Dump". You
> click on it and get a CSV dump with the following columns:
>
> - File Title
> - Office
> - Last Updated By (User)
> - Last Updated On (Date)
> - File Type
> - URL
>
> I think we could use the new jsonindex for this to avoid blowing up
> the universe on cache. Presumably this isn't more than a few thousand
> objects, so not too big of a CSV response.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/karl4/+bug/1655655/+subscriptions

--
You received this bug notification because you are subscribed to the bug report.
https://bugs.launchpad.net/bugs/1655655

Title:
  Collect usage stats on office content

Status in KARL4:
  New

Bug description:
  Nat would like a listing of every content item under /offices,
  downloadable to a spreadsheet.

  Let's provide a link in ADMIN for this called "Office Dump". You click
  on it and get a CSV dump with the following columns:

  - File Title
  - Office
  - Last Updated By (User)
  - Last Updated On (Date)
  - File Type
  - URL

  I think we could use the new jsonindex for this to avoid blowing up
  the universe on cache. Presumably this isn't more than a few thousand
  objects, so not too big of a CSV response.

To manage notifications about this bug go to:
https://bugs.launchpad.net/karl4/+bug/1655655/+subscriptions