We have data exports from two different systems. We use vbo_export, to export data from Drupal and for Moodle there is a similar module. We take these two XLS exports and put them in excel so we can do some data massaging before converting to csv. On a mac, we convert the finished excel into a csv. This works just fine on a mac and when we open it up, the values all display. However, when we share this output with other team members who use windows, they notified us that all the drupal data was absent.
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | content_2017_10_15_12_29-1aeefe42.zip | 2.07 KB | robpowell |
| #5 | content_view_with_vbo.yml | 17.61 KB | robpowell |
| #4 | mac_data_exists_bad_rows.png | 755.51 KB | robpowell |
| #4 | line_break_in_cell.gif | 763.54 KB | robpowell |
| #2 | mac_data_exists.png | 770.22 KB | robpowell |
Comments
Comment #2
robpowellIt seems like there is some cruft being added to the excel field
For example, here is the mac excel with the values working:
Here is the windows version that doesn't work:
again, same file different OS rendering different output.
In the mac screenshot, you can see the rows from vbo_export are formatted oddly (ie. left aligned or have a line break). I wonder if this cruft is making it so it can't render in windows.
Here are some stack overflows posts that may help:
Comment #3
graber commentedDid you check the actual values outputted from your fields to the view? Looks like some of them are numbers only and other contain some extra characters.
Comment #4
robpowell@graber thanks for following up with me. So I guess there's a couple of things to think about in terms how my webform submissions are getting into these csvs. Here are all the contact points:
I can confirm that the data in the database is pristine. When I look at the view the above outputs are based on, I see the data rendered correctly. One thing I do find a bit odd is when I export the data in xlsx, each field seems to have a line break or space after the value.
This is what is leading me to an encoding issue or random cruft. Regarding the mac screenshot above, I was trying to call out that odd formatting of the rows that were merged in from the vbo_export. Here is a new screenshot with those rows highlighted.
Comment #5
robpowellAlright, I put a little more thought into this and decided if I could test vbo_export with a non webform_view and get the same results then it is a vbo issue. I went ahead and updated the content view and removed the default bulk operator and added vbo_export. When I opened the csv in pc, I was able to see the data. So the best I can tell, this is not a vbo_export issue.
Comment #6
robpowellComment #7
graber commented