Support

Home Forums Seating Chart Add-on (EE3) Seating Chart CSV order Issue

Seating Chart CSV order Issue

Posted: October 15, 2014 at 11:59 am


Matthew Simmons

October 15, 2014 at 11:59 am

So I saw the other post about using Open Office on the Mac to save the seating chart as a csv file and followed the instructions. When imported though, the row order gets messed up. It shows row 1, then row 10-19, then row 2, then row 20, then row 3,4,5,6,7,8 and 9. I tried adding leading zeroes to the row number, but it didn’t seem to work. Is there a bug or something that I’m missing. I’m happy to send you the csv file to take a look.


Josh

  • Support Staff

October 15, 2014 at 12:50 pm

Hi Matthew,

The rows are ordered alphanumerically, but adding a leading zero should work. Did you add more than one leading zero?


Matthew Simmons

October 15, 2014 at 2:10 pm

I only added one zero. Should I have added two?


Josh

  • Support Staff

October 15, 2014 at 2:13 pm

One should work. Can you post the contents of the CSV file onto a pastebin or a github gist and give us a link to it so we can take a look?


Matthew Simmons

October 15, 2014 at 2:20 pm

It’s working now. it looks like open office was dropping the leading zero when it saved the document as a csv. Thanks for your help.


Josh

  • Support Staff

October 15, 2014 at 7:52 pm

Hi Matthew,

I’ve seen the same thing happen with Numbers on the Mac, but changing the data format for the Row cells made it happen.

The support post ‘Seating Chart CSV order Issue’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for the Seating Chart add-on for EE3.
This product has been discontinued and is no longer under development.

Status: closed

Updated by  Josh 4 years, 10 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!