ccap : procedure to upload spreadsheet and images
1) add new records to CCAP database from spreadsheet
create subfolder in fromBrian folder on local computer e.g. EXAMPLE
in fromBrian/EXAMPLE
copy brian's csv file in, rename it EXAMPLE_noImages.csv
delete filename column from csv file
check other columns have legal column names
log in as admin to the CCAP AtoM instance (https://ccap.uvic.ca/index.php)
use import feature to upload csv file
2) prepare and upload images and spreadsheet
create subfolder in ccap_upload folder on local computer e.g. EXAMPLE
in ccap_upload/EXAMPLE folder
copy brian's csv file in, rename it EXAMPLE_imagesOnly.csv
delete all columns but identifier and filename from csv file
make sure filename column header appears
make sure "images/" precedes each filename (check direction of slash)
create images directory
put copy of image files into that directory
copy the EXAMPLE folder to a folder in an account on groesbeek
cd to ccap_upload folder
scp -r EXAMPLE sarneil@groesbeek.hcmc.uvic.ca:/home1l/sarneil/ccap_upload/EXAMPLE/
ssh into the account on groesbeek
make sure the directories are all globally readable and executable
make sure the files are all globally readable
3) get sysadmin to run job to import uploaded images and add pointers to database
send an email to hendrik (or sysadmin) like the following
===================
We have an automated process that needs to be run using symphony at the command line on groesbeek. It imports digital images into records in the database for the CCAP project. The process involves a folder full of images and a CSV file which maps each image to a record identifier in the database. It's described in the documentation here:
https://www.accesstomemory.org/en/docs/2.1/user-manual/import-export/csv-import/#digital-object-load-task
I've created the folder of images and the CSV file, and put them here:
/home1l/sarneil/ccap_upload/EXAMPLE/EXAMPLE_imagesOnly.csv
/home1l/sarneil/ccap_upload/EXAMPLE/images
They're globally readable.
We need you to run the Digital Object Load Task, passing the --path option pointing to the root folder (the image filenames in the CSV are relative to this) and the CSV file. So it would look like this:
php symfony digitalobject:load --path="/home1l/sarneil/ccap_upload/EXAMPLE/" /home1l/sarneil/ccap_upload/EXAMPLE/EXAMPLE_imagesOnly.csv
Once that's done, and assuming it goes OK, the search would need to be repopulated:
php symfony search:populate
Please run that for me when you get a chance (not urgent) and let me know how it goes. Thanks.
===================