2024a vs 2024b detectImportOptions error

Question

Drew Jordison 2025-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2175389-2024a-vs-2024b-detectimportoptions-error

回答： Drew Jordison 2025-3-25

I just updated my matlab to start using a new toolbox added to my license. I'm now getting an error that I was previously not getting. I can run both versions of matlab beside each other and am still successfully running it on 2024a but getting an error on 2024b. Because it's not got an error in 2024a I know that the file DOES exist and the path IS valid. Help?

"Error using detectImportOptions (line 428)

Unable to find file. Ensure file exists and path is valid.

Error in Scriptname (line 79)

opts = detectImportOptions(url,'FileType','text');"

25 个评论
显示 23更早的评论隐藏 23更早的评论

dpb 2025-3-19

在 MATLAB Online 中打开

Show us the command output, don't tell us... :)

url='https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'
url = 'https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'
opt=detectImportOptions(url,'FileType','text')
opt = 
  DelimitedTextImportOptions with properties:

   Format Properties:
                    Delimiter: {','}
                   Whitespace: '\b\t '
                   LineEnding: {'\n'  '\r'  '\r\n'}
                 CommentStyle: {}
    ConsecutiveDelimitersRule: 'split'
        LeadingDelimitersRule: 'keep'
       TrailingDelimitersRule: 'ignore'
                EmptyLineRule: 'skip'
                     Encoding: 'UTF-8'

   Replacement Properties:
                  MissingRule: 'fill'
              ImportErrorRule: 'fill'
             ExtraColumnsRule: 'addvars'

   Variable Import Properties: Set types by name using setvartype
                VariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}
                VariableTypes: {'char', 'char', 'char' ... and 63 more}
        SelectedVariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}
              VariableOptions: [1-by-66 matlab.io.VariableImportOptions] 
	Access VariableOptions sub-properties using setvaropts/getvaropts
           VariableNamingRule: 'modify'

   Location Properties:
                    DataLines: [2 Inf]
            VariableNamesLine: 1
               RowNamesColumn: 0
            VariableUnitsLine: 0
     VariableDescriptionsLine: 0 
	To display a preview of the table, use preview
dir(url)
https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"  
version
ans = '24.2.0.2871072 (R2024b) Update 5'

Works here w/ R2024b, too...something about the local connection, for that one somehow if others succeed and it doesn't, maybe?

I don't have installed locally to test...

Drew Jordison 2025-3-20

>> url

url =

"https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z""

>> opts = detectImportOptions(url,'FileType','text')

Error using detectImportOptions (line 428)

Unable to find file. Ensure file exists and path is valid.

>> version

ans =

'24.2.0.2863752 (R2024b) Update 5'

>> dir(url)

https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"

vs 2024a below:

>> url='https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'

url =

'https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'

>> opt=detectImportOptions(url,'FileType','text')

opt =

DelimitedTextImportOptions with properties:

Format Properties:

Delimiter: {','}

Whitespace: '\b\t '

LineEnding: {'\n' '\r' '\r\n'}

CommentStyle: {}

ConsecutiveDelimitersRule: 'split'

LeadingDelimitersRule: 'keep'

TrailingDelimitersRule: 'ignore'

EmptyLineRule: 'skip'

Encoding: 'UTF-8'

Replacement Properties:

MissingRule: 'fill'

ImportErrorRule: 'fill'

ExtraColumnsRule: 'addvars'

Variable Import Properties: Set types by name using setvartype

VariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}

VariableTypes: {'char', 'char', 'char' ... and 63 more}

SelectedVariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}

VariableOptions: Show all 66 VariableOptions

Access VariableOptions sub-properties using setvaropts/getvaropts

VariableNamingRule: 'modify'

Location Properties:

DataLines: [2 Inf]

VariableNamesLine: 1

RowNamesColumn: 0

VariableUnitsLine: 0

VariableDescriptionsLine: 0

To display a preview of the table, use preview

>> version

ans =

'24.1.0.2653294 (R2024a) Update 5'

>> dir(url)

'https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"' contains an unsupported provider.

>>

I'd assume it was some obvious error on my part but the script hasn't changed between the two versions running side by side.

dpb 2025-3-21

编辑：dpb 2025-3-21

在 MATLAB Online 中打开

Anything is possible, yes, Walter, but as Steve points out, this failure to be able to open the file appears to point to something in the iofun category. I'm having difficulty wrapping my head around the fact that apparently it works for some, but not this particular file.

But, it's all conjecture until Drew comes back with results of further diagnostics...I think I'd set

dbstop if error

so can poke around inside the MATLAB function when it dies and see just what was the actual calling code that fails...although this is part of what Mathworks has so obfuscated by packaging internals in objects it's essentially impossible for the user to figure out any more...

Line 428 in R2021b of detectImportOptions appears to be no different than a current version -- it is

func = matlab.io.internal.functions.FunctionStore.getFunctionByName('detectImportOptions');

and from there it gets ever more convoluted to trace down to the final executed code to determine what might be the actual aliased function name, presuming that really is what is happening.

dpb 2025-3-21

编辑：dpb 2025-3-21

在 MATLAB Online 中打开

I missed your earlier comment about the try/catch block, Drew, sorry...

Instead of

try 
    section
catch
    warning('Error using detectImportOptions (line 428) Unable to find file. Ensure file exists and path is valid.')
    i=i+1;
end

What you would do is something like

.... existing code here
try    % the problematic line
  opts = detectImportOptions(url,'FileType','text');"
catch ME
  % try it again just in case -- this will almost certainly not work, but "ya' never know!"
  disp(ME.message) % show what happened; this will be the failed to open but then you know it was caught
  opts = detectImportOptions(url,'FileType','text');"
end
...

The second perhaps more interesting case would be something like

....
try    % the problematic line
  opts = detectImportOptions(url,'FileType','text');"
catch ME
  % try to copy to local temp location
  disp(ME.message) % show what happened; this will be the failed to open but then you know it was caught
  [f,n,e]=fileparts(url);                   % parse the url parts
  tempfile=fullfile(tempdir,strcat(n,e));   % create a temporary file name in system temp folder
  [status,msg]=copyfile(url,tempfile);      % see if can copy it local file
  assert(status==1,strcat('Copy failed: ',msg)) % if unsuccessful, abort but let us know
  opts = detectImportOptions(tempfile,'FileType','text'); % then try it
  urlold=url;                               % hang onto the original url in case need it later...
  url=tempfile;                             % if got here, it worked so redirect to the local copy...
end
...

This would be inelegant solution, but would be interesting as to see if the regular OS can get to the file and then whether detectImportOptions is barfing on the name or the fact it isn't local...

dpb 2025-3-21

编辑：dpb 2025-3-22

在 MATLAB Online 中打开

Yeah, you'll probably have to do something more like

...
[f,n,e]=fileparts(url);                             % parse the url parts
tempfile=char(fullfile(tempdir,strcat(n,'.txt')));  % create a temporary .txt file name
[status,msg]=copyfile(url,tempfile);                % see if can copy it local file
...

to create a normal filesystem filename. This one would be the base name

>> [f,n,e]=fileparts(url)
f =
    'https://catalogue.hakai.org/erddap/tabledap'
n =
    'HakaiWaterPropertiesInstrumentProfileProvisional'
e =
    '.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'
>> 

HakaiWaterPropertiesInstrumentProfileProvisional.txt in your temp dir

Or you could try and get more creative and try some variation such as

...
[f,n,e]=fileparts(url);                                 % parse the url parts
tstr=extractBetween(url,'"','"');                       % pull the time string out of the url
tempfile=char(fullfile(tempdir,strcat(n,tstr,'.txt'))); % create a temporary .txt file name
[status,msg]=copyfile(url,tempfile);                    % see if can copy it local file
...

The ? and " characters at least are invalid in Windows filenames, I guess the other alternative would be to replace them...

url=replace(url,{'&?"><'},{'_'});

first.

dpb 2025-3-22

在 MATLAB Online 中打开

url='https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'
url = 'https://catalogue.hakai.org/erddap/tabledap/HakaiWaterPropertiesInstrumentProfileProvisional.csvp?&hakai_id="1907674_2021-09-23T17:01:55Z"'
[f,n,e]=fileparts(url);
tstr=extractBetween(url,'"','"');
tempfile=char(fullfile(strcat(n,tstr,'.txt')))
tempfile = 'HakaiWaterPropertiesInstrumentProfileProvisional1907674_2021-09-23T17:01:55Z.txt'
[status,msg]=copyfile(url,tempfile)
status = logical
   1
msg =

  0x0 empty char array
dir *.txt
HakaiWaterPropertiesInstrumentProfileProvisional1907674_2021-09-23T17:01:55Z.txt  
opt=detectImportOptions(tempfile)  % will be 'Filetype','Text' based on file extension
opt = 
  DelimitedTextImportOptions with properties:

   Format Properties:
                    Delimiter: {','}
                   Whitespace: '\b\t '
                   LineEnding: {'\n'  '\r'  '\r\n'}
                 CommentStyle: {}
    ConsecutiveDelimitersRule: 'split'
        LeadingDelimitersRule: 'keep'
       TrailingDelimitersRule: 'ignore'
                EmptyLineRule: 'skip'
                     Encoding: 'UTF-8'

   Replacement Properties:
                  MissingRule: 'fill'
              ImportErrorRule: 'fill'
             ExtraColumnsRule: 'addvars'

   Variable Import Properties: Set types by name using setvartype
                VariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}
                VariableTypes: {'char', 'char', 'char' ... and 63 more}
        SelectedVariableNames: {'work_area', 'cruise', 'hakai_id' ... and 63 more}
              VariableOptions: [1-by-66 matlab.io.VariableImportOptions] 
	Access VariableOptions sub-properties using setvaropts/getvaropts
           VariableNamingRule: 'modify'

   Location Properties:
                    DataLines: [2 Inf]
            VariableNamesLine: 1
               RowNamesColumn: 0
            VariableUnitsLine: 0
     VariableDescriptionsLine: 0 
	To display a preview of the table, use preview

So, the copy does seem to work; the Q? then would be whether your system will then be able to open/process the local file that fails from the direct url request....

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kautuk Raj 2025-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2175389-2024a-vs-2024b-detectimportoptions-error#answer_1562398

I was facing a similar error during one of my workflows wherein the "detectImportOptions" threw a "Unable to find file" error when filename was a URL in MATLAB R2024b.

As a workaround, I switched to using MATLAB R2024a.

Alternatively, you use a local copy of the CSV file to mitigate the issue in MATLAB R2024b.