Skip to main content
Solved

Renaming a file turns it into a folder

joe.fme
Contributor
Forum|alt.badge.img+4

Hello all,

I've got a spreadsheet with filenames, and have been asked to rename the files in a folder/subfolders - with the filenames in the spreadsheet.

 

After joining them, which works fine, I then put it through an Attribute Manager to have the attached image as an output destination (Folders and a Document at the end).

 

I was wondering if anyone could shed any light on why the output files, from the FileCopy writer (both Copy and Move mode) come out as folders, and not the PDF files as they went in?

Best answer by alexlynch3450

joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

this would be an example of how you would copy file from local drive to an external device and rename it.

View original
Did this help you find an answer to your question?

10 replies

alexlynch3450
Contributor
Forum|alt.badge.img+14

Did you add the file extension after?

Are you using the 'fan out' parameter?

joe.fme
Contributor
Forum|alt.badge.img+4
  • joe.fmeContributor
  • Author
  • Contributor
  • January 25, 2021
alexlynch3450 wrote:

Did you add the file extension after?

Are you using the 'fan out' parameter?

Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?
alexlynch3450
Contributor
Forum|alt.badge.img+14
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

do you use "filecopy_source_dataset", "filecopy_dest_dataset", and "filecopy_dest_ filename" attributes when writing?

joe.fme
Contributor
Forum|alt.badge.img+4
  • joe.fmeContributor
  • Author
  • Contributor
  • January 26, 2021
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

Morning,

That I do - they are as follows. Mind the lame attempt at censorship, it's just due to my job.

 

filecopy_source_dataset = Path_Filename

filecopy_dest_dataset = Output

filecopy_dest_filename = Renamed

 

Thank you for your help. Ive managed to tweak it whereby it creates the folders I need, but it doesn't put the files into it, with the errors as follows -

 

2021-01-26 08:48:43| 13.3| 0.0|WARN |File Copy Writer: Ignoring the destination filename '50079212042 Site MPP.pdf' because the source dataset '20190226134825_124852.pdf' was not a file. Destination file names are only used when the source dataset is a file

2021-01-26 08:48:43| 13.3| 0.0|WARN |File Copy Writer: Feature contains an invalid source dataset '20190226134825_124852.pdf'. No file operations will be performed for this feature

1 Attachments
alexlynch3450
Contributor
Forum|alt.badge.img+14
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

so you rename the attribute 'Path_Filename' to filecopy_source_dataset?

also, is the fullllllllll filepath used for filecopy_source_dataset--drive/server and all?

alexlynch3450
Contributor
Forum|alt.badge.img+14
  • alexlynch3450Contributor
  • Contributor
  • Best Answer
  • January 26, 2021
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

this would be an example of how you would copy file from local drive to an external device and rename it.

joe.fme
Contributor
Forum|alt.badge.img+4
  • joe.fmeContributor
  • Author
  • Contributor
  • January 26, 2021
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

Hi Alex,

 

Cheers for that! I got it working in the end for the most part - however there are still a few that show up as folders with PDF at the end. Any idea what might cause this?

joe.fme
Contributor
Forum|alt.badge.img+4
  • joe.fmeContributor
  • Author
  • Contributor
  • January 26, 2021
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

Edit - Just realised as some have different folder structures, I'm now using the FilenamePartExtractor to move these to the output folder

 

You're still a star for getting me on the right track :)

1 Attachments
alexlynch3450
Contributor
Forum|alt.badge.img+14
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

I assume this is FME Desktop?

Test by changing "Copy Subfolders:" to 'No' and "error on Non-Existent Source:" & "error on Invalid Destination" to 'Yes'.

 

In addition, check your log file...I get you're trying to conceal sensitive information, but this would be so much easier if I could see what you're seeing. No Biggie tho

joe.fme
Contributor
Forum|alt.badge.img+4
  • joe.fmeContributor
  • Author
  • Contributor
  • January 26, 2021
joe.fme wrote:
Hi Alex, I had the file extension as part of the filename attribute, so it comes out as "file.pdf" but is seen as a folder. As for the fanout, that's not enabled, no. Would they be the way to go?

Yeah it's a bit of a pain. Needless to say though, I got there in the end - once I could put the attribute manager there and say "if the subdirectory contains this, then put that folder first, then the subfolder and the file"

 

Instead it was originally saying to "put the folder, then the other folder - as the PDF"

 

Paid off :)

Reply


Helpful Members This Week

Community Stats

30,960
Posts
117,344
Replies
38,748
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.