Jump to content


Photo

Records missing after export, help!

export missing record

  • Please log in to reply
7 replies to this topic

#1 floduk

floduk

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 06 December 2012 - 09:01 PM

Just starting out with Zurmo and undertaking trials.

Issue we are having is:

- 24 records showing after a specific search of contacts

- only 19 records appear in Excel csv

- add 3 new records to meet specifics, run search again, 27 records show

- only 19 records show after new export

Any ideas? We have checked each record for consistency and all conform.

Thanks for your help

#2 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 07 December 2012 - 03:17 AM

Can you try replicating the issue on our demo instance?
http://dev2.zurmo.co...o/default/login

When doing the export are you clicking "Selected" or "All Results"?
Thanks,
Ray

Ray Stoeckicht
Zurmo Team
Try Zurmo Pro


#3 floduk

floduk

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 07 December 2012 - 06:40 AM

Have tried it using 'selected' and 'all results' and get the same file.

I can try it on your demo site but we have added and changed quite a few fields so would take too long.

Any other suggestions how I can show you the details of the problem?

#4 daveturner101

daveturner101

    Newbie

  • New Members
  • Pip
  • 3 posts

Posted 07 December 2012 - 02:14 PM

the reason the export wasn't working was because we had commas and line breaks in the 'description' field of the contact entry. these were causing excel to interpret the commas as separate columns and messed up the file.

how can we store commas and line breaks in the description field but still export correctly to a csv? are we able to change the separator options of the export to something other than a comma?

many thanks

dave

#5 Ivica

Ivica

    Advanced Member

  • Moderators
  • 565 posts

Posted 07 December 2012 - 04:07 PM

Well, there are no such option in user interface, however you can modify ExportItemToCsvFileUtil::export function, or arrayToCsv default separator.

#6 Jason

Jason

    Administrator

  • Administrators
  • 864 posts
  • LocationChicago

Posted 08 December 2012 - 08:56 PM

I added a story for this:
https://www.pivotalt...y/show/40890263

Jason Green
Zurmo Team
Need support? Upgrade now


#7 daveturner101

daveturner101

    Newbie

  • New Members
  • Pip
  • 3 posts

Posted 10 December 2012 - 11:54 AM

Well, there are no such option in user interface, however you can modify ExportItemToCsvFileUtil::export function, or arrayToCsv default separator.


thanks, where would i find that file so i can have a look?

#8 Ivica

Ivica

    Advanced Member

  • Moderators
  • 565 posts

Posted 10 December 2012 - 03:30 PM

File is located under app/protected/modules/export/utils folder.





Also tagged with one or more of these keywords: export, missing record

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users