Bug: Unable to Import Data

[vcao]

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug
On MacOS user can't import any files, specifically text files into tables, when you use the import tool. Files are greyed out regardless of type selected.

To Reproduce

Steps to reproduce the behavior:

1. Right click a table
2. Select Import/Export Data
3. Select filename under file selector ...
4. Attempt to select files, but greyed out

Expected behavior

All files should be available to select.

Error message

No error messages available.

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: MacOS Sonoma
• Version: 14.6.1
• Mode: Desktop
• Browser: n/a
• Package type: Intel/Apple Silicon

Additional context

[yogeshmahajan-1903]

@vcao
Can you please share screenshot? I am not able to reproduce the issue.

[vcao]

Here are the screenshots. It will import with a full pathname, but it will not with file browser.

[yogeshmahajan-1903]

@vcao
Can you please click on 'Show options' and check what file format is selected. I suspect, it is other than All files or .txt.

[vcao]

Both options also result in greyed out files in the file browser

[yogeshmahajan-1903]

@vcao
It should look as below -

You need to select either.txt or all file. If selection for it greyed out then its issue with native file explorer not the pgadmin. pgadmin use os level file explorer.

[adityatoshniwal]

@vcao Click on show options to show the file format drop-down. There you can select appropriate extension.

[vcao]

@vcao It should look as below -

You need to select either.txt or all file. If selection for it greyed out then its issue with native file explorer not the pgadmin. pgadmin use os level file explorer.

Thank you! The Show Options section threw me off. I usually have it on permanently. I'll close off the thread.