adding files to database

Can you clarify what you mean here? The files table links files to nodes, so that the files on the system have a node that owns them. If the file appears in the report it means that the connection is broken. If you were to "re-attach" files then you would need to choose the node that you want to link to and you wouldn't really know where to put it!

The best option in this case might be to download the file using FTP, and then edit the relevant node and re-upload the file that way?

If I have missed something then if you can explain a little further how you might see this working then I can understand how this might work.

Hope that's ok!

I am in the exact same boat as you are in. I am using IMCE, and I want to be able to write uploaded FTP files to the database. Sorry for opening an old thread however if anyone has any suggestions that would be great! Thanks.

So I found a solution. In imce.inc in the filefield_sources module, instead of this:

  foreach ($directory['files'] as $filename => $file) { 
    if (!isset($db_files[$filename])) { 
			unset($directory['files'][$filename]);
			$directory['dirsize'] -= $file['size']; 

    } 
  }
  return $directory;
}

put this:

  foreach ($directory['files'] as $filename => $file) { 
    if (!isset($db_files[$filename])) { 
			//unset($directory['files'][$filename]);
			//$directory['dirsize'] -= $file['size']; 
			$mime_type = file_get_mimetype($filename);
			$sql = "INSERT INTO files(uid, filename, filepath, filemime, filesize, status, timestamp)
			VALUES('1', '" . $filename . "', '" . $sql_dir_name. "/" . $filename . "', '" . $mime_type . "', '" . $file["size"] . "', '1', '" . $file["date"] . "')";
			//echo $sql . "<br><br>";
			db_query($sql);
    } 
  }
  return $directory;
}

So this basically creates a database entry for new files that are not in the database. So now when I click insert it inserts the image, although, whenever I go to save my node I get this error: "Referencing to the file used in the field is not allowed."

Does anyone know what is wrong here?

Thanks.

Ok I found a solution for that as well so it does not throw the error. In the filefield module, I just commented out this block of code and it works like a charm.

if ($references['filefield'] == 0) {
          form_error($element, t('Referencing to the file used in the %field field is not allowed.', array('%field' => $element['#title'])));
}

Using Filefield 6.x-3.7

My version was slightly different. I found and commented out the code block under the filefield module in filefield_widget.inc and it looked like this:

if (field_file_references($file) == 0) {
form_error($element, t('Referencing to the file used in the %field field is not allowed.', array('%field' => $element['#title'])));
}

commenting that out worked for me! Thanks

Hi acondiff,
thanks for shareing your code.
I got the stuff working on Drupal 7 while changeing the module-file filefield_sources/sources/inc/imce.inc

Hope this helps someone:

/**
 * Scan directory and return file list, subdirectories, and total size.
 */
function filefield_source_imce_custom_scan($dirname, $imce) {
  // Get a list of files in the database for this directory.
  $scheme = variable_get('filefield_source_imce_scheme', 'public');
  $imce['scheme'] = $scheme;
  $sql_uri_name = $dirname == '.' ? $scheme . '://' : $scheme . '://' . $dirname;

  $result = db_select('file_managed', 'f')
    ->fields('f', array('filename'))
    ->condition('f.uri', $sql_uri_name . '/%', 'LIKE')
    ->condition('f.uri', $sql_uri_name . '/%/%', 'NOT LIKE')
    ->execute();

  $db_files = array();
  foreach ($result as $row) {
    $db_files[$row->filename] = $row->filename;
  }

  // Get the default IMCE directory scan, then filter down to database files.
  $directory = imce_scan_directory($dirname, $imce);
  foreach ($directory['files'] as $filename => $file) {
    if (!isset($db_files[$filename])) {
      #unset($directory['files'][$filename]);
      #$directory['dirsize'] -= $file['size'];
	  
      $mime_type = file_get_mimetype($filename);
	  
	  $id = db_insert('file_managed')
		->fields(array(
			'uid' => 1,
			'filename' => $filename,
			'uri' => $sql_uri_name . "/" . $filename,
			'filemime' => $mime_type,
			'filesize' => $file['size'],
			'status' => 1,
			'timestamp' => $file['date']
			))->execute();
	  if($id > 0) {
		$sql = "INSERT INTO file_usage (fid, module, type, id, count) VALUES(" . $id . ", 'file', 'node', 1, 1)";
		db_query($sql);
	  }
	  
    }
  }

  return $directory;
}

Cheers,
Rafael Kutscha