osuosl/streamwebs

Import Gallery data from old production site

Opened this issue · 3 comments

We need to work on importing data from the old production site for the gallery feature to be fully complete. To do that, we need to do the following:

  • Create Drupal views on the old site which export the data we need (partially complete: http://drupal.streamwebs.org/admin/build/views/edit/gallery_csv)
  • Add CSV new files to csvs directory
  • Add files to pull to data_scripts/pull-files.sh using wget
  • Create a data_scripts/get_gallery_images.py (and similar scripts for the other file types) which imports the files into the data model. You can look at data_scripts/get_site_images.py as an example of how this is done
  • Add the python scripts to the end of data_scripts/get_all.sh after ./get_site_images.py

CSV Exports

The CSV exports are split into two types of Drupal Views:

  1. metadata view
  2. URL to gallery file

There are also currently two types of exports, one for images and another for files. Specifically, you can use the following urls for the data:

Code for his is basically done, Brennan and I are going to do more testing on it locally and then on dev before I call this one done.

I can see the Gallery items, but the files don't appear to be there for download or viewing? @ramereth

http://drupal.streamwebs.org/node/2686/gallery
https://streamwebs-staging.osuosl.org/sites/wenaha-river/

@ramereth Can you help me export gallery journal entries/videos?
Model for Journal Entries: "Title", "Journal Entry Field", "Post Date", "Nid", "Uid", "Site Name"
Model for videos: "Title", "Description", "Post Date", "Nid", "Uid", "Site Name", "Filename", "Gallery Video" (Link to drupal site)