This module is laudably simple and I think I will probably be able to make it work for my limited use-case, but I have found the following limitations that I'm documenting here (to prevent others having to do the trial and error I've done):

  • Columns in the import source must be in the same order as the fields in the content type.
  • Columns must have content! Otherwise, the next column will be loaded instead. A null appears to be sufficient, but there must be at least a null. Not all software that produce XLS and XLSX files will include the null -- e.g., Google Sheets will, but apparently Softmaker PlanMaker won't. (This may be a weakness of PHPExcel; nevertheless, should be documented here.)
  • Does not appear to load taxonomy terms.

Comments

escoles’s picture

escoles commented

Additional note:

  • Full-HTML fields may render with the HTML code displayed as html entities, until the node has been manually edited and saved.
  • Haven't yet figured out how to import values into date fields using this module.
escoles’s picture

escoles commented

Date imports don't seem to be possible.

escoles’s picture

escoles commented

I've looked through smart_import.module and can confirm that it only supports the import of text fields. No other field types are supported.

Please change the module description to document this.

s.tabrij’s picture

s.tabrij commented

Hi escoles,

Thanks for the inputs. I am the original developer of this module but owned by CyberNetikz. I left job a couple of years ago, I guess there is no update till then. I will soon contact with them about these issues.