[Bug]: 'Error browsing to location' in Microsoft Excel Input when location is using variables

[maxbobse]

Apache Hop version?

2.17

Java version?

OpenJDK 64-Bit Server VM Temurin-21.0.3+9 (build 21.0.3+9-LTS, mixed mode, sharing)

Operating system

Windows

What happened?

In the Microsoft Excel Input step, I am accessing a file using a path like

${PROJECT_HOME}/ETL/import forecast qty/data all channels.xlsx

If I now want to change the file I get this error in the Open File dialog:

Error browsing to location: 'C:\Users\john.doe\Applications\apache-hop-client-2.17.0\hop\C:\Users\john.doe\OneDrive - ACME\Documents\GitHub\hdi_a\ETL\import forecast qty\data all channels.xlsx'
FileNotFolderException: Could not list the contents of "file:///C:/Users/john.doe/Applications/apache-hop-client-2.17.0/hop/C:/Users/john.doe/OneDrive - ACME/Documents/GitHub/hdi_a/ETL/import forecast qty" because it is not a folder.
Root cause: FileNotFolderException: Could not list the contents of "file:///C:/Users/john.doe/Applications/apache-hop-client-2.17.0/hop/C:/Users/john.doe/OneDrive - ACME/Documents/GitHub/hdi_a/ETL/import forecast qty" because it is not a folder.

org.apache.commons.vfs2.FileNotFolderException: Could not list the contents of "file:///C:/Users/john.doe/Applications/apache-hop-client-2.17.0/hop/C:/Users/john.doe/OneDrive - ACME/Documents/GitHub/hdi_a/ETL/import forecast qty" because it is not a folder.
	at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1110)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.populateFolder(HopVfsFileDialog.java:932)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.refreshBrowser(HopVfsFileDialog.java:889)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.browserColumnSelected(HopVfsFileDialog.java:597)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.getData(HopVfsFileDialog.java:846)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.open(HopVfsFileDialog.java:558)
	at org.apache.hop.ui.core.dialog.BaseDialog.presentFileDialog(BaseDialog.java:461)
	at org.apache.hop.ui.core.dialog.BaseDialog.presentFileDialog(BaseDialog.java:290)
	at org.apache.hop.pipeline.transforms.excelinput.ExcelInputDialog$2.widgetSelected(ExcelInputDialog.java:1073)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:290)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4364)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1217)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4162)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3750)
	at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:740)
	at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:704)
	at org.apache.hop.pipeline.transforms.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:928)
	at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:195)
	at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3560)
	at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:2352)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.hop.core.gui.plugin.action.GuiActionLambdaBuilder.lambda$createLambda$0(GuiActionLambdaBuilder.java:97)
	at org.apache.hop.ui.hopgui.context.GuiContextUtil.lambda$handleActionSelection$0(GuiContextUtil.java:177)
	at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
	at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4137)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3753)
	at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:514)
	at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:387)

Issue Priority

Priority: 3

Issue Component

Component: Hop Gui

[leehaut]

.take-issue