map folders during staticsync

159 views
Skip to first unread message

Christopher May

unread,
Mar 19, 2015, 5:12:13 PM3/19/15
to resour...@googlegroups.com
Hello, trying to figure out the mapfolders functionality in staticsync.

here is the map folder code I have in config.php

$staticsync_mapfolders[]=array
 
(
 
"match"=>"/archive/",
 
"field"=>1,
 
"level"=>2
 
);
 
$staticsync_mapfolders
[]=array
 
(
 
"match"=>"/archive/",
 
"field"=>1,
 
"level"=>3
 
);
$staticsync_mapfolders
[]=array
 
(
 
"match"=>"/archive/",
 
"field"=>25,
 
"level"=>2
 
);
$staticsync_mapfolders
[]=array
 
(
 
"match"=>"/archive/",
 
"field"=>75,
 
"level"=>3
 
);

just as a fyi: field 1= keywords, field 25= Notes and field 75= is ProjectName - one I have added.

my folder structure:

/archive/2014/PSS/project1/


after running staticsync the resources show up in RS, but the metadata is missing. 

Looking at the debug report, I do not see any SQL statements that are attempting to insert the appropriate data.

here is the debug report:
2015-03-19 16:06:02 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority
2015-03-19 16:06:02 SQL: select language,name,text from site_text where (page='staticsync' or page='all') and (specific_to_group is null or specific_to_group=0)
2015-03-19 16:06:02 SQL: select file_path value from resource where length(file_path)>0 and file_path like '%/%'
2015-03-19 16:06:02 SQL: select ref,file_modified,file_path from resource where archive=0 and length(file_path)>0
2015-03-19 16:06:02 SQL: select value from sysvars where name='lastsync'
2015-03-19 16:06:02 SQL: insert into resource(resource_type,creation_date,archive,created_by) values ('1',now(),'2','')
2015-03-19 16:06:02 SQL: select resource_type value from resource where ref='10089'
2015-03-19 16:06:02 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0
2015-03-19 16:06:02 SQL: delete from resource_keyword where resource='10089' and keyword= ANY (select ref from keyword where keyword='10089') and resource_type_field='-1' limit 1
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count-1 where keyword='10089' limit 1
2015-03-19 16:06:02 adding 10089
2015-03-19 16:06:02 resolving keyword 10089. Create=true
2015-03-19 16:06:02 resolving normalized keyword 10089.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='10089'
2015-03-19 16:06:02 Creating new keyword for 10089
2015-03-19 16:06:02 SQL: insert into keyword (keyword,soundex,hit_count) values ('10089',left('0000',10),0)
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','23406','0','-1')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='23406'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23406'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Keyword added to resource','23406','1')
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Create resource' and object_ref='10089'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Create resource','10089','1')
2015-03-19 16:06:02 SQL: insert into resource_log(date,user,resource,type,resource_type_field,notes,diff,usageoption,purchase_size,purchase_price,access_key,previous_value) values (now(),null,'10089','c',null,'','','-1','','0',null,'')
2015-03-19 16:06:02 SQL: update resource set resource_type='1' where ref='10089'
2015-03-19 16:06:02 SQL: delete from resource_data where resource='10089' and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0)
2015-03-19 16:06:02 SQL: delete from resource_keyword where resource='10089' and resource_type_field!=-1 and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0)
2015-03-19 16:06:02 SQL: update resource set archive=0,file_path='2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg',file_extension='jpg',preview_extension='jpg',file_modified=now() where ref='10089'
2015-03-19 16:06:02 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='51'
2015-03-19 16:06:02 SQL: select value from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 SQL: select value from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 adding roadmap
2015-03-19 16:06:02 resolving keyword roadmap. Create=true
2015-03-19 16:06:02 resolving normalized keyword roadmap.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='roadmap'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3165','0','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='3165'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:02 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:02 adding slide2
2015-03-19 16:06:02 resolving keyword slide2. Create=true
2015-03-19 16:06:02 resolving normalized keyword slide2.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='slide2'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3167','1','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='3167'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Keyword added to resource','3167','1')
2015-03-19 16:06:02 adding jpg
2015-03-19 16:06:02 resolving keyword jpg. Create=true
2015-03-19 16:06:02 resolving normalized keyword jpg.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='jpg'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','45','2','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='45'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='45'
2015-03-19 16:06:02 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='45'
2015-03-19 16:06:02 SQL: delete from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 SQL: insert into resource_data(resource,resource_type_field,value) values ('10089','51','RoadMap_Slide2.jpg')
2015-03-19 16:06:02 SQL: update resource set field51='RoadMap_Slide2.jpg' where ref='10089'
2015-03-19 16:06:02 SQL: select file_path value from resource where ref='10089'
2015-03-19 16:06:02 SQL: select *,mapzoom from resource where ref='10089'
2015-03-19 16:06:02 SQL: select ref,type,exiftool_field,exiftool_filter,options,name from resource_type_field where length(exiftool_field)>0 and (resource_type='1' or resource_type='0')  order by exiftool_field
2015-03-19 16:06:02 CLI command: '/usr/bin/exiftool' -s -s -f -m -d "%Y-%m-%d %H:%M:%S" -G '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'
2015-03-19 16:06:03 CLI output: [ExifTool] ExifToolVersion: 8.99
[File] FileName: RoadMap_Slide2.jpg
[File] Directory: /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills
[File] FileSize: 612 kB
[File] FileModifyDate: 2012-05-08 14:45:04
[File] FilePermissions: rw-r--r--
[File] FileType: JPEG
[File] MIMEType: image/jpeg
[File] ExifByteOrder: Big-endian (Motorola, MM)
[File] ImageWidth: 1920
[File] ImageHeight: 1440
[File] EncodingProcess: Baseline DCT, Huffman coding
[File] BitsPerSample: 8
[File] ColorComponents: 3
[File] YCbCrSubSampling: YCbCr4:2:0 (2 2)
[JFIF] JFIFVersion: 1.01
[EXIF] XResolution: 72
[EXIF] YResolution: 72
[EXIF] ResolutionUnit: inches
[EXIF] ModifyDate: 2012-05-08 14:44:54
[EXIF] ExifImageWidth: 1920
[EXIF] ExifImageHeight: 1440
[XMP] XMPToolkit: Adobe XMP Core 5.2-c003 61.141987, 2011/02/22-12:03:51
[XMP] InstanceID: xmp.iid:B0157BE51620681192B094CB94162DA0
[XMP] DocumentID: xmp.did:AE157BE51620681192B094CB94162DA0
[XMP] OriginalDocumentID: xmp.did:AE157BE51620681192B094CB94162DA0
[XMP] MetadataDate: 2012-05-08 14:45:04
[XMP] VideoAlphaMode: None
[XMP] VideoFrameRate: 0.000000
[XMP] HistoryAction: saved, saved
[XMP] HistoryInstanceID: xmp.iid:AF157BE51620681192B094CB94162DA0, xmp.iid:B0157BE51620681192B094CB94162DA0
[XMP] HistoryWhen: 2012-05-08 14:44:54, 2012-05-08 14:45:04
[XMP] HistorySoftwareAgent: Adobe Premiere Pro 5.5, Adobe Premiere Pro 5.5
[XMP] HistoryChanged: /metadata;/content, /metadata
[XMP] VideoFrameSizeW: 1920
[XMP] VideoFrameSizeH: 1440
[XMP] VideoFrameSizeUnit: pixel
[Photoshop] CopyrightFlag: False
[Photoshop] IPTCDigest: d41d8cd98f00b204e9800998ecf8427e
[ICC_Profile] ProfileCMMType: appl
[ICC_Profile] ProfileVersion: 2.2.0
[ICC_Profile] ProfileClass: Display Device Profile
[ICC_Profile] ColorSpaceData: RGB
[ICC_Profile] ProfileConnectionSpace: XYZ
[ICC_Profile] ProfileDateTime: 2009-02-25 11:26:11
[ICC_Profile] ProfileFileSignature: acsp
[ICC_Profile] PrimaryPlatform: Apple Computer Inc.
[ICC_Profile] CMMFlags: Not Embedded, Independent
[ICC_Profile] DeviceManufacturer: appl
[ICC_Profile] DeviceModel:
[ICC_Profile] DeviceAttributes: Reflective, Glossy, Positive, Color
[ICC_Profile] RenderingIntent: Perceptual
[ICC_Profile] ConnectionSpaceIlluminant: 0.9642 1 0.82491
[ICC_Profile] ProfileCreator: appl
[ICC_Profile] ProfileID: 0
[ICC_Profile] ProfileDescription: Generic RGB Profile
[ICC_Profile] ProfileDescriptionML-sk-SK: Všeobecný RGB profil
[ICC_Profile] ProfileDescriptionML-hr-HR: Generički RGB profil
[ICC_Profile] ProfileDescriptionML-ca-ES: Perfil RGB genèric
[ICC_Profile] ProfileDescriptionML-pt-BR: Perfil RGB Genérico
[ICC_Profile] ProfileDescriptionML-uk-UA: –ó–∞–≥–∞–ª—å–Ω–∏–π –ø—Ä–æ—Ñ–∞–π–ª RGB
[ICC_Profile] ProfileDescriptionML-fr-FU: Profil générique RVB
[ICC_Profile] ProfileDescriptionML-zh-TW: 通用 RGB 色彩描述
[ICC_Profile] ProfileDescriptionML-it-IT: Profilo RGB generico
[ICC_Profile] ProfileDescriptionML-nb-NO: Generisk RGB-profil
[ICC_Profile] ProfileDescriptionML-ko-KR: 일반 RGB 프로파일
[ICC_Profile] ProfileDescriptionML-cs-CZ: Obecn√Ω RGB profil
[ICC_Profile] ProfileDescriptionML-he-IL: פרופיל RGB כללי
[ICC_Profile] ProfileDescriptionML-de-DE: Allgemeines RGB-Profil
[ICC_Profile] ProfileDescriptionML-hu-HU: Általános RGB profil
[ICC_Profile] ProfileDescriptionML-sv-SE: Generisk RGB-profil
[ICC_Profile] ProfileDescriptionML-zh-CN: 普通 RGB 描述文件
[ICC_Profile] ProfileDescriptionML-ja-JP: 一般 RGB プロファイル
[ICC_Profile] ProfileDescriptionML-ro-RO: Profil RGB generic
[ICC_Profile] ProfileDescriptionML-el-GR: Γενικό προφίλ RGB
[ICC_Profile] ProfileDescriptionML-pt-PO: Perfil RGB genérico
[ICC_Profile] ProfileDescriptionML-nl-NL: Algemeen RGB-profiel
[ICC_Profile] ProfileDescriptionML-es-ES: Perfil RGB genérico
[ICC_Profile] ProfileDescriptionML-th-TH: โปรไฟล์ RGB ทั่วไป
[ICC_Profile] ProfileDescriptionML-tr-TR: Genel RGB Profili
[ICC_Profile] ProfileDescriptionML-fi-FI: Yleinen RGB-profiili
[ICC_Profile] ProfileDescriptionML-pl-PL: Uniwersalny profil RGB
[ICC_Profile] ProfileDescriptionML-ru-RU: –û–±—â–∏–π –ø—Ä–æ—Ñ–∏–ª—å RGB
[ICC_Profile] ProfileDescriptionML-ar-EG: ملف تعريف RGB العام
[ICC_Profile] ProfileDescriptionML: Generic RGB Profile
[ICC_Profile] ProfileDescriptionML-da-DK: Generel RGB-beskrivelse
[ICC_Profile] ProfileCopyright: Copyright 2007 Apple Inc., all rights reserved.
[ICC_Profile] MediaWhitePoint: 0.95047 1 1.0891
[ICC_Profile] RedMatrixColumn: 0.4543 0.24191 0.01489
[ICC_Profile] GreenMatrixColumn: 0.35335 0.67363 0.09064
[ICC_Profile] BlueMatrixColumn: 0.15665 0.08446 0.71957
[ICC_Profile] RedTRC: (Binary data 14 bytes, use -b option to extract)
[ICC_Profile] ChromaticAdaptation: 1.04788 0.02292 -0.0502 0.02957 0.99049 -0.01706 -0.00923 0.01508 0.75165
[ICC_Profile] BlueTRC: (Binary data 14 bytes, use -b option to extract)
[ICC_Profile] GreenTRC: (Binary data 14 bytes, use -b option to extract)
[Composite] ImageSize: 1920x1440
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 Exiftool: extracted field 'EXIFTOOL:EXIFTOOLVERSION', value is '8.99'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILENAME', value is 'RoadMap_Slide2.jpg'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:DIRECTORY', value is '/
Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:FILESIZE', value is '612 kB'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:FILEMODIFYDATE', value is '2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:FILEPERMISSIONS', value is 'rw-r--r--'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:FILETYPE', value is 'JPEG'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:MIMETYPE', value is 'image/jpeg'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:EXIFBYTEORDER', value is 'Big-endian (Motorola, MM)'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:IMAGEWIDTH', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:IMAGEHEIGHT', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:ENCODINGPROCESS', value is 'Baseline DCT, Huffman coding'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:BITSPERSAMPLE', value is '8'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:COLORCOMPONENTS', value is '3'
2015-03-19 16:06:03 Exiftool: extracted field '
FILE:YCBCRSUBSAMPLING', value is 'YCbCr4:2:0 (2 2)'
2015-03-19 16:06:03 Exiftool: extracted field '
JFIF:JFIFVERSION', value is '1.01'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:XRESOLUTION', value is '72'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:YRESOLUTION', value is '72'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:RESOLUTIONUNIT', value is 'inches'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:MODIFYDATE', value is '2012-05-08 14:44:54'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:EXIFIMAGEWIDTH', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field '
EXIF:EXIFIMAGEHEIGHT', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:XMPTOOLKIT', value is 'Adobe XMP Core 5.2-c003 61.141987, 2011/02/22-12:03:51'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:INSTANCEID', value is 'xmp.iid:B0157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:DOCUMENTID', value is 'xmp.did:AE157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:ORIGINALDOCUMENTID', value is 'xmp.did:AE157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:METADATADATE', value is '2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:VIDEOALPHAMODE', value is 'None'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:VIDEOFRAMERATE', value is '0.000000'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:HISTORYACTION', value is 'saved, saved'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:HISTORYINSTANCEID', value is 'xmp.iid:AF157BE51620681192B094CB94162DA0, xmp.iid:B0157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:HISTORYWHEN', value is '2012-05-08 14:44:54, 2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:HISTORYSOFTWAREAGENT', value is 'Adobe Premiere Pro 5.5, Adobe Premiere Pro 5.5'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:HISTORYCHANGED', value is '/metadata;/content, /metadata'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:VIDEOFRAMESIZEW', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:VIDEOFRAMESIZEH', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field '
XMP:VIDEOFRAMESIZEUNIT', value is 'pixel'
2015-03-19 16:06:03 Exiftool: extracted field '
PHOTOSHOP:COPYRIGHTFLAG', value is 'False'
2015-03-19 16:06:03 Exiftool: extracted field '
PHOTOSHOP:IPTCDIGEST', value is 'd41d8cd98f00b204e9800998ecf8427e'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILECMMTYPE', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEVERSION', value is '2.2.0'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILECLASS', value is 'Display Device Profile'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:COLORSPACEDATA', value is 'RGB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILECONNECTIONSPACE', value is 'XYZ'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDATETIME', value is '2009-02-25 11:26:11'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEFILESIGNATURE', value is 'acsp'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PRIMARYPLATFORM', value is 'Apple Computer Inc.'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:CMMFLAGS', value is 'Not Embedded, Independent'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:DEVICEMANUFACTURER', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:DEVICEMODEL', value is ''
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:DEVICEATTRIBUTES', value is 'Reflective, Glossy, Positive, Color'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:RENDERINGINTENT', value is 'Perceptual'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:CONNECTIONSPACEILLUMINANT', value is '0.9642 1 0.82491'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILECREATOR', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEID', value is '0'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTION', value is 'Generic RGB Profile'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-SK-SK', value is 'Všeobecný RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-HR-HR', value is 'Generički RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-CA-ES', value is 'Perfil RGB genèric'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-PT-BR', value is 'Perfil RGB Genérico'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-UK-UA', value is '–ó–∞–≥–∞–ª—å–Ω–∏–π –ø—Ä–æ—Ñ–∞–π–ª RGB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-FR-FU', value is 'Profil générique RVB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-ZH-TW', value is '通用 RGB 色彩描述'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-IT-IT', value is 'Profilo RGB generico'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-NB-NO', value is 'Generisk RGB-profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-KO-KR', value is '일반 RGB 프로파일'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-CS-CZ', value is 'Obecn√Ω RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-HE-IL', value is 'פרופיל RGB כללי'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-DE-DE', value is 'Allgemeines RGB-Profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-HU-HU', value is 'Általános RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-SV-SE', value is 'Generisk RGB-profil'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-ZH-CN', value is '普通 RGB 描述文件'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-JA-JP', value is '一般 RGB プロファイル'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-RO-RO', value is 'Profil RGB generic'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-EL-GR', value is 'Γενικό προφίλ RGB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-PT-PO', value is 'Perfil RGB genérico'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-NL-NL', value is 'Algemeen RGB-profiel'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-ES-ES', value is 'Perfil RGB genérico'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-TH-TH', value is 'โปรไฟล์ RGB ทั่วไป'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-TR-TR', value is 'Genel RGB Profili'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-FI-FI', value is 'Yleinen RGB-profiili'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-PL-PL', value is 'Uniwersalny profil RGB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-RU-RU', value is '–û–±—â–∏–π –ø—Ä–æ—Ñ–∏–ª—å RGB'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-AR-EG', value is 'ملف تعريف RGB العام'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML', value is 'Generic RGB Profile'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILEDESCRIPTIONML-DA-DK', value is 'Generel RGB-beskrivelse'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:PROFILECOPYRIGHT', value is 'Copyright 2007 Apple Inc., all rights reserved.'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:MEDIAWHITEPOINT', value is '0.95047 1 1.0891'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:REDMATRIXCOLUMN', value is '0.4543 0.24191 0.01489'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:GREENMATRIXCOLUMN', value is '0.35335 0.67363 0.09064'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:BLUEMATRIXCOLUMN', value is '0.15665 0.08446 0.71957'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:REDTRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:CHROMATICADAPTATION', value is '1.04788 0.02292 -0.0502 0.02957 0.99049 -0.01706 -0.00923 0.01508 0.75165'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:BLUETRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field '
ICC_PROFILE:GREENTRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field '
COMPOSITE:IMAGESIZE', value is '1920x1440'
2015-03-19 16:06:03 SQL: SELECT resource.file_path FROM resource WHERE resource.ref = 10089
2015-03-19 16:06:03 EXIF - option for field 73 : yes
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='
73'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='
10089' and resource_type_field='73'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='
10089' and resource_type_field='73'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('
10089','73','0000626688')
2015-03-19 16:06:03 EXIF - option for field 71 : yes
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='
71'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='
10089' and resource_type_field='71'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='
10089' and resource_type_field='71'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('
10089','71','1920x1440')
2015-03-19 16:06:03 EXIF - custom option for filename field 51 : yes
2015-03-19 16:06:03 SQL: select file_extension value from resource where ref = '
10089'
2015-03-19 16:06:03 SQL: select resource_type, name from resource left join resource_type on resource.resource_type = resource_type.ref where resource.ref = '
10089'
2015-03-19 16:06:03 SQL: select resource_type value from resource where ref='
10089'
2015-03-19 16:06:03 use perms: 1
2015-03-19 16:06:03 SQL: select d.value,d.resource_type_field,f.*,f.required frequired,f.ref fref from resource_type_field f left join (select * from resource_data where resource='
10089') d on d.resource_type_field=f.ref and d.resource='10089' where ( f.resource_type=0 or f.resource_type=999 or f.resource_type='1') group by f.ref order by f.resource_type,f.order_by,f.ref
2015-03-19 16:06:03 SQL: select ref value from resource_type
2015-03-19 16:06:03 fieldProject Name=
2015-03-19 16:06:03 fieldSigned model release on file=
2015-03-19 16:06:03 fieldCCR Client=
2015-03-19 16:06:03 fieldTitle=
2015-03-19 16:06:03 fieldOriginal Filename=RoadMap_Slide2.jpg
2015-03-19 16:06:03 fieldKeywords=
2015-03-19 16:06:03 fieldCaption=
2015-03-19 16:06:03 fieldExtracted Text=
2015-03-19 16:06:03 fieldCountry=
2015-03-19 16:06:03 fieldNamed Person(s)=
2015-03-19 16:06:03 fieldDate=
2015-03-19 16:06:03 fieldCredit=
2015-03-19 16:06:03 fieldExpiry Date=
2015-03-19 16:06:03 fieldNotes=
2015-03-19 16:06:03 fieldWebsite=
2015-03-19 16:06:03 fieldFile Size=0000626688
2015-03-19 16:06:03 fieldCamera Make / Model=
2015-03-19 16:06:03 fieldSource=
2015-03-19 16:06:03 fieldImage Size=1920x1440
2015-03-19 16:06:03 SQL: select resource_type value from resource where ref='
10089'
2015-03-19 16:06:03 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='
1') and length(autocomplete_macro)>0
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='
8'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='
10089' and resource_type_field='8'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='
10089' and resource_type_field='8'
2015-03-19 16:06:03 adding 2014
2015-03-19 16:06:03 resolving keyword 2014. Create=true
2015-03-19 16:06:03 resolving normalized keyword 2014.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
2014'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','1464','0','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
1464'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='1464'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='1464'
2015-03-19 16:06:03 adding pss
2015-03-19 16:06:03 resolving keyword pss. Create=true
2015-03-19 16:06:03 resolving normalized keyword pss.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
pss'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','2216','1','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
2216'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='2216'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='2216'
2015-03-19 16:06:03 adding pssproject1
2015-03-19 16:06:03 resolving keyword pssproject1. Create=true
2015-03-19 16:06:03 resolving normalized keyword pssproject1.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
pssproject1'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','23401','2','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
23401'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23401'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23401'
2015-03-19 16:06:03 adding stills
2015-03-19 16:06:03 resolving keyword stills. Create=true
2015-03-19 16:06:03 resolving normalized keyword stills.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
stills'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','23350','3','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
23350'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23350'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23350'
2015-03-19 16:06:03 adding roadmap
2015-03-19 16:06:03 resolving keyword roadmap. Create=true
2015-03-19 16:06:03 resolving normalized keyword roadmap.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
roadmap'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','3165','4','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
3165'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:03 adding slide2
2015-03-19 16:06:03 resolving keyword slide2. Create=true
2015-03-19 16:06:03 resolving normalized keyword slide2.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='
slide2'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('
10089','3167','5','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='
3167'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='
2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='
10089' and resource_type_field='8'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('
10089','8','2014 - PSS - pssproject1 - stills - RoadMap Slide2')
2015-03-19 16:06:03 SQL: update resource set field8='
2014 - PSS - pssproject1 - stills - RoadMap Slide2' where ref='10089'
2015-03-19 16:06:03 create_previews(ref=10089,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=)
2015-03-19 16:06:03 SQL: update resource set file_checksum='' where ref='
10089'
2015-03-19 16:06:03 SQL: update resource set preview_tweaks = '
0|1' where ref = '10089'
2015-03-19 16:06:03 File source is /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg
2015-03-19 16:06:03 create_previews_using_im(ref=10089,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=)
2015-03-19 16:06:03 CLI command: '
/usr/local/bin/identify' -format %wx%h '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'[0]
2015-03-19 16:06:03 CLI output: 1920x1440
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 SQL: select * from preview_size  order by width desc, height desc
2015-03-19 16:06:03 Contemplating hpr (sw=1920, tw=999999, sh=1440, th=999999, extension=jpg)
2015-03-19 16:06:03 Contemplating lpr (sw=1920, tw=2000, sh=1440, th=2000, extension=jpg)
2015-03-19 16:06:03 Contemplating scr (sw=1920, tw=850, sh=1440, th=850, extension=jpg)
2015-03-19 16:06:03 Generating preview size scr to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg
2015-03-19 16:06:03 CLI command: '
/usr/local/bin/convert' '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'[0] +matte -flatten -quality 90  +matte -strip -colorspace RGB  -resize 850x850">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'
2015-03-19 16:06:03 CLI output:
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 Contemplating pre (sw=1920, tw=350, sh=1440, th=350, extension=jpg)
2015-03-19 16:06:03 Generating preview size pre to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089pre_29fea14a79341a9.jpg
2015-03-19 16:06:03 CLI command: '
/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90  +matte -strip -colorspace RGB  -resize 350x350">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089pre_29fea14a79341a9.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 Contemplating thm (sw=1920, tw=150, sh=1440, th=150, extension=jpg)
2015-03-19 16:06:04 Generating preview size thm to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089thm_d7e4ab2d1deed46.jpg
2015-03-19 16:06:04 CLI command: '
/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90  +matte -strip -colorspace RGB  -resize 150x150">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089thm_d7e4ab2d1deed46.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 Contemplating col (sw=1920, tw=75, sh=1440, th=75, extension=jpg)
2015-03-19 16:06:04 Generating preview size col to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089col_a4db3c1096eaf66.jpg
2015-03-19 16:06:04 CLI command: '
/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90  +matte -strip -colorspace RGB  -resize 75x75">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089col_a4db3c1096eaf66.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 SQL: update resource set image_red='
945', image_green='105', image_blue='96',colour_key='NEKWR',thumb_width='150', thumb_height='113' where ref='10089'
2015-03-19 16:06:04 SQL: update resource set has_image=1,preview_extension='
jpg',preview_attempts=0,file_modified=now() where ref='10089'
2015-03-19 16:06:04 SQL: update resource set access = '
0' where ref = '10089'
2015-03-19 16:06:04 SQL: select ref,file_path from resource where archive=0 and length(file_path)>0 and file_path like '
%/%'
2015-03-19 16:06:04 SQL: delete from collection where theme is not null and length(theme)>0 and (select count(*) from collection_resource cr where cr.collection=collection.ref)=0;
2015-03-19 16:06:04 SQL: update sysvars set value=now() where name='
lastsync'


Thanks in advance for any suggestions.

Chris

are...@gmail.com

unread,
Mar 20, 2015, 1:32:02 PM3/20/15
to resour...@googlegroups.com
Did staticsync.php show that it had found any metadata or not? Check the actual output of the script.

Also you have a conflict in that you're trying to map both level 2 and level 3 to field 1. I'm not sure if that would usually cause an error or if one would take priority... again, check the script output.

Christopher May

unread,
Mar 23, 2015, 9:59:32 AM3/23/15
to resour...@googlegroups.com
There is no mention of metadata or errors in the staticsynch.php output:

ccr-ld-imac:/ root# cd Library/Webserver/Documents/resourceSpace/pages/tools
ccr
-ld-imac:tools root# php staticsync.php
Preloading data......done. Looking for changes...Processing Folder: /Volumes/ccfs_footage/archive
Processing Folder: /Volumes/ccfs_footage/archive/2014
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pss project 2
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pss project 2/courseFiles
Processing file: /Volumes/ccfs_footage/archive/2014/PSS/pss project 2/courseFiles/3dArrow.png
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pss project 2/supportMaterial
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pssproject1
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/courseFiles
Processing Folder: /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills
...done.
Looking for deleted files......Complete
ccr
-ld-imac:tools root#



Allison Stec

unread,
Mar 23, 2015, 10:27:27 AM3/23/15
to ResourceSpace
I was never able to get mapping to work recursively - meaning files would have to be in the mapped level to get the metadata pulled.

To follow the mapping you posted.../archive/2014/file.jpg would get "2014" in keywords, but /archive/2014/PSS/file.jpg would not.

My experience is outdated, though. Perhaps this has changed.

Allison Stec
Senior Developer & Asset Management Specialist
Colorhythm
http://www.colorhythm.com

Main Office: +1 415-399-9921
Fax: +1 415-399-9928

as...@colorhythm.com

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.org
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Christopher May

unread,
Mar 23, 2015, 12:22:54 PM3/23/15
to resour...@googlegroups.com
Thanks for the replies so far, but I have happened upon a larger issue with the mapping. So to set up what I have:

  • Working on a Mac
  • using external drive to house the syncdir
  • $syncdir in config.php is /Volumes/ccfs_footage/archive
Just to translate "ccfs_footage" is the drive name and "archive" is a folder on that drive.

I want to start the mapping at the "archive" folder, and map from there, so in config.php, on the var $static_mapfolders, I set the match to "archive" just like the example in config.default.php and set the folders in different levels below "archive" to map to different fields.

And metadata based on folder structure was never pulled in.

Looking in the staticsync.php i found some interesting code at approx. line 125. 

$shortpath=str_replace($syncdir . "/","",$fullpath);

What this line of code is doing is stripping the syncdir portion of the path from the full path of the files and folders in the directory.

so   "/Volumes/ccfs_footage/archive/2014/PSS/pssproject2/courseFiles/publishSettings.jpg" becomes "2014/PSS/pssproject2/courseFiles/publishSettings.jpg" in the var $shortpath

then when staticsync.php is trying to match my "/archive/" root folder in lines approx. line 240 where $match = /archive/

if (strpos("/" . $shortpath,$match)!==false)

No matches are never found because the "archive" directory has been removed from $shortpath.

With that said, how is everyone else setting up their static sync? Should I simply add another folder under "/archive/" where I begin my organized file structure? This seems like it should be unnecessary but maybe there is a reason why the logic was set up like this.

Thanks, 
Chris 

are...@gmail.com

unread,
Mar 26, 2015, 9:10:50 AM3/26/15
to resour...@googlegroups.com
You should be matching "/" not "/archive/"

I have:

$syncdir = "/mnt/photos";


$staticsync_mapfolders
[]=array (
       
"match" => "/",
       
"field" => 73,
       
"level" => 1,
);

"level" => 1 // matches any folder inside /mnt/photos

So for /mnt/photos/landscape, "landscape" will be mapped to field 73.

are...@gmail.com

unread,
Mar 26, 2015, 9:13:00 AM3/26/15
to resour...@googlegroups.com
Probably changed, I'm doing mapping right now with a directory depth of 3, and all directories in the path are being mapped properly.
Reply all
Reply to author
Forward
0 new messages