Can't import .xls file "required table is missing"

[aharown07]

Trying to import an .xls file into a fp7 file created for the purpose. Doing what I've always done successfully before (though with different files), I get an error this time

this action cannot be performed because the required table is missing

This happens as soon as I click Open.

It's been a while since I did this, but I seem to recall that, in the past, it went to a screen where I had the option to create a new table to contain the imported data.

Any idea what would keep that from happening now?

Just upgraded to fp9 advanced, btw.

[Lee Smith]

Did you change the File Type from FileMaker, or Any File to XLS?

[aharown07]

No. I'm guessing the file is corrupt in some way though. I created it using phpmyadmin and exporting a table from a database on my webserver.

Due to configuration obscurities I'm not yet up on, none of these files seem to download intact. Either truncated or in some other way strange.

Got weird results from exporting the table as CSV also. Fmp could not recognize the contents of the file.

So for now I'm working the issue w/my hosting co. to see if something can be configured differently in PHPmyadmin.

[Lee Smith]

I'm confused as to what you are trying to do.

HML isn't listed as a import file type option, read about File Formats in your User Guide, online help, or Here

[aharown07]

I'm confused as to what you are trying to do.

HML isn't listed as a import file type option, read about File Formats in your User Guide, online help, or Here

Doesn't involve html at all.

I've got a mysql database on a standard apache web server. I want to convert that database from one php application to another (happens to be wordpress to drupal, but it's not relevant). As part of the process of figuring out what I want to keep and what I want to discard and what the data actually looks like, I want to look at it in fmp.

I've used fmp in this way for migrations of other sorts as well... import, clean up, export. FM is great for that IMO.. "replace with calculation" is very handy and fast.

Anyway, the web server will not export the db in filemaker format, but it will in .xls or csv (via the phpmyadmin tool).

So I did an export to .xls and attempted to open the resulting file in Filemaker.

Got the missing table error.

Tried the same export to csv and it seemed to be confused as to where the rows/records end and begin... came in as one giant record.

My guess is that phpMyAdmin is not exporting the file cleanly... truncated maybe, not sure.

Either that, or I just need to play w/the options more.

Posted this here because I was hoping the "required table is missing" error might be well known as indicating a specific problem I could then fix, but it seems to occur in multiple situations.