Hi George,

Here's a chunk of PHP I put together recently to generate the documents/files section of an Eprints XML upload.  This puts all the files into one document tag, which may or may not be waht you want to do - I'm not sure exactly how standard the mainfile configuration is on our system, but it seems to only allow the one file per document to be downloaded.  So either you need to enclose each file in a separate document tag, or as I eventually did, zip all the files and push that up as one file.  This version is the 'one document, many files' approach, but I can send you the Zip version as well if you like.

<?php
function eprints_xml_OAfiles($row){    # $row is the metadata values for this record

global $link;
global $dataset;
$docroot=$_SERVER['DOCUMENT_ROOT'];
$filebase="$docroot/publications/administration/....  <where the files live > /";

 
$pub_id = $row['pub_id'];
$oaPub_ID = $row['oaPub_ID']; 

   $PM= $row['pubmedid']  ;   
 

 $files_query = "SELECT
       oaPub_ID,
        `oaManuscript_ID`,
        `oaPub_ID`,
        `content_oaManuscript`,   # Manuscript
        `file_oaManuscript`,
        `file_oaManuscript_mimetype`,
        `URL_oaManuscript`,
        `upload_oaManuscript`,
        `notes_oaManuscript`,
        `modified_oaManuscript`
                                   
                                    FROM
                                   oaManuscript2
                                WHERE
                                
                                    oaPub_ID = $oaPub_ID
        and upload_oaManuscript = 1
         ";
                              #  ORDER BY surname";
        $files_result = mysql_query ($files_query,$link)
        or die ("Query failed:$files_query");
   
 $filesXML=""; 
        while ($f = mysql_fetch_array($files_result)) { #build file metadata and base64 data
          $record=print_r($f,TRUE); echo "<!-- $record -->";
    $filename = $f['file_oaManuscript'];
   $mimetype = $f['file_oaManuscript_mimetype'];
   if(FALSE === ($STUFF=file_get_contents($filebase.$filename))){die("\n\nfailed to get file: $filebase$filename");}
   $base64=chunk_split(base64_encode($STUFF));
   $hash=md5($base64); 
   $filesize = strlen($STUFF);
   $file_modified= $f['modified_oaManuscript'];
     
  
  
$filesXML .= "
     
    <file>
      
    <datasetid>document</datasetid>
    
    <filename>$filename</filename>
    <mime_type>$mimetype</mime_type>
    <hash>$hash</hash>
    <hash_type>MD5</hash_type>
    <filesize>$filesize </filesize>
    <mtime>$file_modified</mtime>
         
    <data encoding='base64'>";

$filesXML .= $base64;

#.=chunk_split(base64_encode(file_get_contents($fileURLbase.$filename)));
$filesXML .= "</data>
  </file>";

   }# ends while ($row2 = mysql_fetch_array($coded_result)) 
   

  

return $cit = <<<EOC
<documents>
<document>
  <mime_type>$maintype</mime_type>
    <format>text</format>
    <language>en</language>
    <security>public</security>
    <license>cc_by</license>
    <main>$mainfile</main>
    <content>accepted</content>
      
    <files>
     
      $filesXML
     </files>
       </document>
</documents>

EOC;

}
?>