by MokasIT

Experts in Excel export. An export to Excel from any list, report or subpanel of SuiteCRM.

Cancel at any time!
Free Trial

#1156 - Export address lines separately?

Closed General Question created by agray 6 years ago

When exporting address data, the SuiteCRM "export to CSV" options always export street-address as a single field (which is obviously because that it how it is stored in the database).... but actually it would be much more flexible if the street-address was exported as line1,lin2,lin3 etc.... that's all supported by the import function but not the export function. I often need to be able to split street-address into individual lines (for printing or for list cleaning).

Can your module export street-address as separate fields? If so I would certainly use it. Thanks Andrew

  1. MokasIT member avatar

    MokasIT Provider Affiliate

    6 years ago

    Thanks for comment Andrew,

    We export address as multiline field, look at http://prntscr.com/jhvp5i Why excel show as one line in list we will check ASAP. I think it is common issue for all multiline fields.

    • MokasIT member avatar

      MokasIT Provider Affiliate

      6 years ago

      Andrew, we doubled check the code and we split lines multiply, just please wrap up the Street column in Excel.

  2. agray member avatar

    agray

    6 years ago

    Thanks for the response. Exporting fields that contain linebreaks is always a problem for Excel. If you double-click such files they usually import OK but if you open a new sheet and then IMPORT them Excel treats each linebreak as an end of row.

    My preference would be for your product to export the field as it currently does but then ALSO include columns for line1,2,3

    Any chance of that?

  3. MokasIT member avatar

    MokasIT Provider Affiliate

    6 years ago

    Andrew, our product idea is to keep it simple and export data in the same way you see columns and data in the list view or reports. Anyway, thanks for the input, we will include this idea to our product backlog for some possible future releases if the more people will require that.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "this plugin still has room for enhancement, but the developer is very helpful, that's why I gave it 5 stars." - fbeitt

    Read More Reviews