- Also allow import of CSV from /import/ folder. All images uploaded into folder with CSV file. Then CSV file is scanned and processed.
Images imported, Titles assigned, Descriptions added, Location data inserted. etc.... Album added, Sub-Album added, etc.
Does that make sense? So rather than uploading just via a normal Ajax \ Flash uploader, instead it imports and processes the files uploaded into a folder on the server. Once importing (moving) is complete, it then sets up the data for each resource; where titles and descriptions and other information is added against the resource. Whether it be video files uploaded and imported or photographs. The aim is that these files do not need to be manually named, and given a description!
This would make life so much easier when it comes to managing the gallery with a large number of photographs \ videos \ files and galleries \ sub-galleries \ sub-sub-galleries and so on.
Please let me know your (positive) thoughts.
First row (Row 0) is column headers: ID ; STATUS ; PRI.ALBUM; SEC.ALBUMS ; TITLE ; DESCRIPTION ; SHARING_BTN ; SOCIAL_BTN; DOWNLOAD_BTN ; KEYWORDS ; TAGS ; FILENAME Second row (Row 1) is first item. 1001 ; Enabled ; \\Holidays\\2014\\Canada ; \\Family & Friends\\2014 | \\Weddings\\John & Mary Smith ; John and Mary at the alter! ; I cannot believe John forgot his vows! ; Disabled ; Disabled ; Enabled ; John Smith, Mary Smith, Wedding, 2014, Canada ; Weddings, Canada ; DSC482938.jpg Formula for A3 (Row 2) would be [b]=IF(B2<>"", A2+1, "")[/b] which means if above line for status is empty, then do not increment unique ID.
So that is simply an example (limited fields) of what could be done. Excel is magic. I am more than willing to help create a template to show you how easily something like this can be done and how much quicker it is at adding new content and updating existing content!
Now save as XLSX file. Then save as CSV file. (you don't want to lose all your formula when saving it as a CSV without saving your changes to the primary "DB" first! Done!
CSV contents would look like this:
ID,STATUS,PRI.ALBUM,SEC.ALBUMS,TITLE,DESCRIPTION,SHARING_BTN,SOCIAL_BTN,DOWNLOAD_BTN,KEYWORDS,TAGS,FILENAME 1001,ENABLED,\\Holidays\\2014\\Canada,\\Family & Friends\\2014 | \\Weddings\\John & Mary Smith,John and Mary at the alter!,I cannot believe John forgot his vows!,DISABLED,DISABLED,ENABLED,"John Smith, Mary Smith, Wedding, 2014, Canada","Weddings, Canada",DSC482938.jpg ,,,,,,,,,,, ,,,,,,,,,,, << these lines are ignored if you have blank lines in Excel (just from containing formula in Excel) but when saved as CSV they are removed and ignored. ,,,,,,,,,,,