rename fileuploads in repeat group

[kouwearie]

How to rename fileuploads in a repeat group? The database is not the main joomla DB.
When using the example it gets an error, "mainDBname.ep_submission" doesnt exist.
How can i target elements from the repeated group to use for the rename?

Maybe good to mention its not repeated data but database join based.

// use Joomla file utils
jimport( 'joomla.filesystem.file' );
// get the original file and split it into parts
$old = ($formModel->formData['file']);
$oldParts = pathinfo($old);
// in this example we're using the id as the new filename
$sid = $formModel->formData['id'];
//create the new file (path and name)
$new = $oldParts['dirname'].'/'.$sid.'.'.$oldParts['extension'];
// update the file itself
JFile::move(JPATH_SITE.$old, JPATH_SITE.$new);
// update the data
$formModel->updateFormData('file', $new, true);
// update the db
$object = new stdClass();
// Must be a valid primary key value.
$object->id = $sid;
// new path + name
$object->file = $new;
// Update the data in the db
$result = JFactory::getDbo()->updateObject('ep_submission', $object, 'id');

 

[troester]

If you are outside the Joomla database you can't use Joomla's database connection JFactory::getDbo()...
If working with multiple databases/Fabrik connections you must know what you are doing and not everything is supported (e.g. you can't do cross-joining between the different connections).
To access alternate connections with custom code see http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#use-alternate-fabrik-connection