13 Replies Latest reply on Mar 13, 2013 10:22 AM by Ravi Teja

Search for Duplicate file names

Russell Abraham Jul 16, 2012 11:17 AM

We have just started using EPDM after converting from DBWorks.

Historically we have PDF's of hand or 2D generated drawings and also 3D models and drawings.

If a part/assembly is required in a higher level assembly but a pdf of the 2D exists we would model it but not approve it.

Viewers can't see non approved models or drawings.

It is the engineer's responsibility when they redraw something on SolidWorks to obsolete the old version pdf. Typically they have the part number as the file name.

This, in some cases, is not happening.

I need to be able to quickly identify if this has not happened

Is there an easy way to search for file names that have duplicates but have different extensions?

Thanks

Re: Search for Duplicate file names

Raghavendra Bhagwan Jul 16, 2012 11:22 AM (in response to Russell Abraham)

Hello Russell,

The best way and easiest way is to search the files in the vault by "Filename" or "Number" with out entering the file extension.

Search result will display all the files with the same name.

Just my 2 cents !

Regard,
Raghav.
Like Show 0 Likes(0)

Actions
- Re: Search for Duplicate file names
  
  Russell Abraham Jul 16, 2012 11:25 AM (in response to Raghavendra Bhagwan)
  
  I don't think I made exactly clear what I wanted.
  
  I need to do this globally and not just on single files.
  
  ie run a search, or similar, everyday to highlight any new files that have duplicates and are both at the same state but with different issues.
  
  Cheers
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Search for Duplicate file names
    
    Tim Read Jul 16, 2012 11:34 AM (in response to Russell Abraham)
    
    Somewhere.... there is an excel spreadsheet with a marco that does this.
    
    I cannot track it down at the moment so maybe you can 'google' it. I think it was called "EPDM Hyperlink Query" or something like that.
    
    Like Show 0 Likes(0)
    
    Actions
  - Re: Search for Duplicate file names
    
    Raghavendra Bhagwan Jul 16, 2012 11:34 AM (in response to Russell Abraham)
    
    Well Russell,
    
    I think we may have to write a programme and output.
    
    In the mean time why don't you try enabling Don't Allow Duplicate file names for the files, This ensures that users are not allowed to save the new files with the same name.
    
    Hope this helps !
    
    Like Show 0 Likes(0)
    
    Actions
Re: Search for Duplicate file names

Ravi Teja Jul 18, 2012 5:00 AM (in response to Russell Abraham)

Hi Russel,

Following query will give list of all the duplicate filenames

--

Select D.DocumentID, D.FileName AS [File Name], P.Path AS [Project Path]
From Documents AS D
INNER JOIN DocumentsInProjects AS DIP ON D.DocumentID = DIP.DocumentID
FULL OUTER JOIN Projects P ON DIP.ProjectID = P.ProjectID
WHERE D.Filename IN (Select Filename FROM Documents Where Deleted = 0
GROUP BY Filename
HAVING (COUNT (Filename) > 1))
ORDER BY D.Filename

--

If you want filename with differenct extensions then comment out " HAVING (COUNT (Filename) > 1))"

Regards
Ravi T
Like Show 0 Likes(0)

Actions
- Re: Search for Duplicate file names
  
  Russell Abraham Jul 19, 2012 6:59 AM (in response to Ravi Teja)
  
  Ravi,
  
  Thanks for that.
  Is it possible for it to return the state name as well?
  
  I have tried to comment out the " HAVING (COUNT (Filename) > 1))" and get the following error
  
  Cheers
  
  Russell
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Search for Duplicate file names
    
    Joy Garon Jul 19, 2012 7:12 AM (in response to Russell Abraham)
    
    Hi Russell,
    
    Try this:
    
    Select D.DocumentID, D.FileName AS [File Name], P.Path AS [Project Path], S.Name AS [Current State]
    From Documents AS D
    INNER JOIN DocumentsInProjects AS DIP ON D.DocumentID = DIP.DocumentID
    INNER JOIN Status AS S ON S.StatusID = D.CurrentStatusID
    FULL OUTER JOIN Projects P ON DIP.ProjectID = P.ProjectID
    WHERE D.Filename IN (Select Filename FROM Documents Where Deleted = 0
    GROUP BY Filename
    HAVING (COUNT (Filename) > 1))
    ORDER BY D.Filename
    
    Regards,
    Joy
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Search for Duplicate file names
      
      Russell Abraham Jul 19, 2012 8:54 AM (in response to Joy Garon)
      
      Joy,
      
      That works brilliantly but how do I get it to return the filename with different extensions as well?
      
      Cheers
      
      Russ
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Search for Duplicate file names
        
        Joy Garon Jul 19, 2012 9:09 AM (in response to Russell Abraham)
        
        Hi Russ,
        
        I'm not sure what you mean?
        
        Joy
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Search for Duplicate file names
        
        Russell Abraham Jul 19, 2012 9:19 AM (in response to Joy Garon)
        
        Joy,
        
        I want to return a list of documents where there are multiple files of the same name but with different file extensions.
        
        We currently have a PDF (scan of 2d drawing) and if the document then get replaced by a SW file I need to make sure that the pdf get made obsolete.
        
        Cheers
        
        Russ
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Search for Duplicate file names
        
        Ravi Teja Jul 20, 2012 9:00 AM (in response to Russell Abraham)
        
        Hi Russel,
        As i mentioned remove the "HAVING (COUNT (Filename) > 1))" coz this line is sorting filename matcing fully.
        
        If the query isint running try removing "GROUP BY Filename"as well.and alos add a")" at the end of 5th line.
        
        --------------------------------------------------------
        Select D.DocumentID, D.FileName AS [File Name], P.Path AS [Project Path]
        From Documents AS D
        INNER JOIN DocumentsInProjects AS DIP ON D.DocumentID = DIP.DocumentID
        FULL OUTER JOIN Projects P ON DIP.ProjectID = P.ProjectID
        WHERE D.Filename IN (Select Filename FROM Documents Where Deleted = 0)
        --GROUP BY Filename
        --HAVING (COUNT (Filename) > 1))
        ORDER BY D.Filename
        
        __________________________________________________
        
        Sorry no SQL here ...
        
        You may require even advance query if you want to sort all the files with same name but different extension.
        
        The above query will match names starting from first char.
        
        Regards
        Ravi T
        
        Like Show 0 Likes(0)
        
        Actions
Re: Search for Duplicate file names

Robert Rurka Mar 13, 2013 6:13 AM (in response to Russell Abraham)

Recently i have found a nice software "Duplicate Files Deleter". Just go to http://DuplicateFilesDeleter.com and you can find and delete duplicate files safely. I use it and I warmly recommend.
Like Show 0 Likes(0)

Actions
- Re: Search for Duplicate file names
  
  Ravi Teja Mar 13, 2013 10:22 AM (in response to Robert Rurka)
  
  Hi Robert,
  Have you used it on files and folders inside EPDM ? I'd be surprised if it finds all the files in Local View.AFAI can guess i would return only locally cached files.
  
  Regards
  Ravi T
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post