[SOLVED] Need to add IPTC info to end of Description field on import

Can I use CONCAT for this? I need ['IPTC/City']','['IPTC/ProvinceState'] at the end of ['IPTC/Caption'].

Any guidance on this is really appreciated.

Oh wait, I think I see what you're doing. So you're having that info imported into Gallery's description? I don't know the best approach to do that in the code.

I don't think you can use "CONCAT" for that as I don't think it's a valid PHP function, but...
http://php.net/manual/en/language.operators.string.php

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

cron enhancement for adding images with IPTC data, custom fields and watermarking:

change part that import classes to add more needed classes

//import needed Gallery classes
        GalleryCoreApi::requireOnce('modules/core/classes/GalleryController.class');
        GalleryCoreApi::requireOnce('modules/core/classes/GalleryView.class');
        GalleryCoreApi::requireOnce('modules/core/ItemAdd.inc');
        GalleryCoreApi::requireOnce('modules/itemadd/ItemAddFromServer.inc');
	GalleryCoreApi::requireOnce('modules/exif/module.inc');
	GalleryCoreApi::requireOnce('modules/exif/classes/ExifExtractor.class');
	GalleryCoreApi::requireOnce('modules/customfield/classes/CustomFieldHelper.class');

change FOREACH loop that adds items to process IPTC to Description, IPTC to custom fields (in this example Author name and Country name from IPTC populates values for Custom Fields) and to automatically watermark images.

	    $i = 0;
            foreach ($files as $file)
            {    
                try {
                $ret = $this->itemAdd->addItem($this->album_id, $file, false, $this->text_fields, $this->status, $this->error);		
		$itemId = $this->status['addedFiles'][$i]['id'];
		$i++;
		$this->check($ret);		
		$exifExtractor = new ExifExtractor();
		$exifData = $exifExtractor->getMetaData(array($itemId));
		// load gallery item
                list ($ret, $item) = GalleryCoreApi::loadEntitiesById($itemId, 'GalleryItem');
            	if ($ret) {
            		return array($ret, null);
            	}
            	// lock gallery item
                list ($ret, $lockId) = GalleryCoreApi::acquireWriteLock(array($itemId));
            		if ($ret) {
            		    return array($ret, null, null);
            		}
            	// set properties
            	$item->setDescription($exifData[1][$itemId]['IPTC/Caption']['value']);
            	$item->setKeywords($exifData[1][$itemId]['IPTC/Keywords']['value']);
            	// save
            	$ret = $item->save();
            	// unlock gallery item
                if ($ret) {
        		GalleryCoreApi::releaseLocks(array($lockId));
        		return array($ret, null, null);
        	}
                $ret = GalleryCoreApi::releaseLocks(array($lockId));
            	if ($ret) {
            		return array($ret, null, null);
            	}
            	// set custom parameters: author, country
            	$extraParams = array(
            	    'Country' => $exifData[1][$itemId]['IPTC/CountryName']['value'], 
            	    'Author' => $exifData[1][$itemId]['IPTC/Byline']['value']
            	);
            	CustomFieldHelper::setCustomFieldValues($itemId, $extraParams);
            	// add watermark to resized image
            	// load watermark images
            	GalleryCoreApi::requireOnce('modules/watermark/classes/WatermarkHelper.class');
            	list ($ret, $watermarks) = WatermarkHelper::fetchWatermarks();
            	$watermark = array_shift($watermarks);
            	$which = array(
            	    DERIVATIVE_TYPE_IMAGE_PREFERRED => false,
            	    DERIVATIVE_TYPE_IMAGE_RESIZE => true,
            	    DERIVATIVE_TYPE_IMAGE_THUMBNAIL => false
            	);
            	$ret = WatermarkHelper::watermarkItem($watermark, $item, $watermark->xPercentage, $watermark->yPercentage, $which);
        		if ($ret) {
        			return array($ret, null, null, null);
        		}
                } catch (Exception $x) {
                    $this->log_error($x->getMessage() . ': ' . $x->getTraceAsString());
                }
            }