AnsweredAssumed Answered

Search for Duplicate file names

Question asked by Russell Abraham on Jul 16, 2012
Latest reply on Mar 13, 2013 by Ravi Teja

Like • Show 0 Likes0
Comment • 13

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

Ravi Teja Jul 20, 2012 9:00 AM

Correct Answer

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

See the reply in context

No one else had this question

Outcomes

Raghavendra Bhagwan Jul 16, 2012 11:22 AM

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.

Actions

Russell Abraham @ Raghavendra Bhagwan on Jul 16, 2012 11:25 AM

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

Actions

Tim Read @ Russell Abraham on Jul 16, 2012 11:34 AM

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.

Actions

Raghavendra Bhagwan @ Russell Abraham on Jul 16, 2012 11:34 AM

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 !

Actions

Ravi Teja Jul 18, 2012 5:00 AM

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

Actions

Russell Abraham @ Ravi Teja on Jul 19, 2012 6:59 AM

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

Actions

Joy Garon

@ Russell Abraham on Jul 19, 2012 7:12 AM

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

Actions

Russell Abraham @ Joy Garon on Jul 19, 2012 8:54 AM

Joy,

That works brilliantly but how do I get it to return the filename with different extensions as well?

Cheers

Russ

Actions

Joy Garon

@ Russell Abraham on Jul 19, 2012 9:09 AM

Hi Russ,

I'm not sure what you mean?

Joy

Actions

Russell Abraham @ Joy Garon on Jul 19, 2012 9:19 AM

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

Actions

Ravi Teja @ Russell Abraham on Jul 20, 2012 9:00 AM

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

Actions

Robert Rurka Mar 13, 2013 6:13 AM

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.

Actions

Ravi Teja @ Robert Rurka on Mar 13, 2013 10:22 AM

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

Actions

13 Replies

Raghavendra Bhagwan Jul 16, 2012 11:22 AM
Mark Correct
Correct Answer
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 Likes0
Actions
- Russell Abraham @ Raghavendra Bhagwan on Jul 16, 2012 11:25 AM
  Mark Correct
  Correct Answer
  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 Likes0
  Actions
  - Tim Read @ Russell Abraham on Jul 16, 2012 11:34 AM
    Mark Correct
    Correct Answer
    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 Likes0
    Actions
  - Raghavendra Bhagwan @ Russell Abraham on Jul 16, 2012 11:34 AM
    Mark Correct
    Correct Answer
    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 Likes0
    Actions
Ravi Teja Jul 18, 2012 5:00 AM
Mark Correct
Correct Answer
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 Likes0
Actions
- Russell Abraham @ Ravi Teja on Jul 19, 2012 6:59 AM
  Mark Correct
  Correct Answer
  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 Likes0
  Actions
  - Joy Garon @ Russell Abraham on Jul 19, 2012 7:12 AM
    Mark Correct
    Correct Answer
    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 Likes0
    Actions
    - Russell Abraham @ Joy Garon on Jul 19, 2012 8:54 AM
      Mark Correct
      Correct Answer
      Joy,
      
      That works brilliantly but how do I get it to return the filename with different extensions as well?
      
      Cheers
      
      Russ
      Like • Show 0 Likes0
      Actions
      - Joy Garon @ Russell Abraham on Jul 19, 2012 9:09 AM
        Mark Correct
        Correct Answer
        Hi Russ,
        
        I'm not sure what you mean?
        
        Joy
        Like • Show 0 Likes0
        Actions
        Russell Abraham @ Joy Garon on Jul 19, 2012 9:19 AM
        Mark Correct
        Correct Answer
        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 Likes0
        Actions
        Ravi Teja @ Russell Abraham on Jul 20, 2012 9:00 AM
        Unmark Correct
        Correct Answer
        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 Likes0
        Actions
Robert Rurka Mar 13, 2013 6:13 AM
Mark Correct
Correct Answer
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 Likes0
Actions
- Ravi Teja @ Robert Rurka on Mar 13, 2013 10:22 AM
  Mark Correct
  Correct Answer
  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 Likes0
  Actions

Search for Duplicate file names

Outcomes

Related Content

Recommended Content