LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dstacey

Hi,

With the Output Excel node (and some of the other publishing nodes) is there a way to ensure that, if the file exists, it is not overwritten?

This exception behaviour is there with some nodes - for example the Output Tableau node - but doesn't appear to be an option for the Excel node.

thanks,
Dave

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Dave,

Most publishing nodes do not have that feature. I have included a few nodes below that will check if a file already exist and not overwrite if it does exist.

COPY THE LINES BELOW AND PASTE INTO BRE
---------------------------------------------------------------------------------
node:Directory_List_3
bretype:core::Directory List
editor:sortkey=557f190026e3535d_2
output:@40fd2c747c2b1c0a/=
prop:DirectoryName=C:\Users\ltolleson\Desktop
prop:Pattern=*.xlsx
editor:XY=880,320
end:Directory_List_3


node:Meta_Check_3
bretype:core::Meta Check
editor:sortkey=557f199c18e656bb_2
input:@43c285fc347d19f2/=Directory_List_3.40fd2c747c2b1c0a
output:557f1bf629a81962/out1=
prop:MaximumRecordCount=0
prop:MinimumRecordCount=0
prop:SuccessAction=Clock
prop:TerminusAction=Output
editor:XY=1030,320
end:Meta_Check_3


node:Static_Data_2
bretype:core::Static Data
editor:sortkey=557f198524ce466c_2
output:@40fe6c55598828e5/=
editor:XY=880,450
end:Static_Data_2


node:Output_Excel_3
bretype:core::Output Excel
editor:sortkey=557f19791d073a80_2
input:@49e34a5e55c82040/=Static_Data_2.40fe6c55598828e5
inclock:/=Meta_Check_3
prop:File=C:\Users\ltolleson\Desktop\TestData.xlsx
editor:XY=1190,450
end:Output_Excel_3

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dstacey

Hi Larry,

Thanks - that's helpful.

Dave