Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-16571

Enclose exported Number in double quotes to ease Excel import

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 13
    • Component/s: Phonebook
    • Labels:
    • ToDo:
    • Distro Version:
      14
    • Distro:
      FreePBX Distro

      Description

      exported csv from phonebook will get the leading zero truncated with excel and calc.

      So the number should also be enclosed in double Quotes like the "name".

      Phonebook.class.php:

      case "export":
      header('Content-Type: text/csv');
      header('Content-disposition: attachment; filename=phonebook.csv');
      $numbers = \phonebook_list();
      foreach ($numbers as $number => $values){
      printf("\"%s\";\"%s\";\"%s\"\n", $values['name'], trim($number), $values['speeddial']);
      }

      before change the line read:

      printf("\"%s\";%s;%s\n", $values['name'], trim($number), $values['speeddial']);

      This modification makes Excel recognise the number as text and leaves it "as-is"

       

       

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  xrobau Rob Thomas
                  Reporter:
                  mwelters Markus Welters
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    NextupJiraPlusStatus

                    Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.