Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Done] Need Help Exporting Gallery Data for use in Excel  (Read 1435 times)

0 Members and 1 Guest are viewing this topic.

Djeep

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
[Done] Need Help Exporting Gallery Data for use in Excel
« on: September 14, 2015, 01:51:04 AM »

I'm a graphic designer (print) working on a calendar contest for a small non-profit organization in which users submit photos to the group's gallery. The highest rated photos at the end of the voting period win featured pages in the calendar.

I need to periodically export information from the gallery database as a .CSV file (or other appropriate file type) to be used in Excel. I need the following information exported:

1. IMAGE INFORMATION during submission period

Filename of Image
Date Added
User Name
User Email
Title
Description
Album
File Type
File Size
Width, Pixels
Height, Pixels
File Location

2. VOTES/RATINGS after voting closes
Date of Vote/Rating
Filename of Image
Rating (how many stars)
IP Address

I have no programming experience and am looking for the easiest and most cost-effective way to accomplish these exports. An export utility that I can run myself as needed, or a dynamic web page that auto populates with the required info that I can copy and paste into Excel would be ideal solutions. However, if these are not possible to do and I need to retain a freelancer to periodically generate the information and email the raw data to me, that would be an acceptable solution if reasonably priced.

As submissions are currently being accepted, we are looking to do this ASAP.

Thank you in advance for your consideration.
« Last Edit: September 22, 2015, 11:19:52 AM by Αndré »
Logged

MiWebDesign

  • Coppermine newbie
  • Country: 00
  • Offline Offline
  • Posts: 1
    • Realizzazione siti web
Re: Need Help Exporting Gallery Data for use in Excel
« Reply #1 on: September 14, 2015, 05:22:35 AM »

I can help you, contact me via email
Logged
Realizzazione Siti Web by http://www.marcoingraiti.it
Pages: [1]   Go Up
 

Page created in 0.061 seconds with 21 queries.