Support

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

Seating Chart CSV Issue

Posted: March 15, 2014 at 1:31 pm


nick hubley

March 15, 2014 at 1:31 pm

Hi
I have created a .csv seating chart and none of the seats are loading in when I attempt to upload it to EE3. Any help would be greatly appreciated. I have sent an email to support with the .csv attached. Thank you.


Dean

March 17, 2014 at 2:43 am

Hi,

I emailed you back.

The file didn’t work for me either until I re-saved it in Excel (this was the CSV file).

What did you edit the file with originally?

I also edited the chart a little as you had Lower D, Lower E, Lower D (again) and Lower F with rows 1 through 4. Because these are 3 different sections it cant work like that. They all need to be the same section with different rows, or different sections with a single row.

I hope that makes some sense, but looking at the file might make it clearer.


nick hubley

March 17, 2014 at 4:31 pm

The one you sent me worked! Thank you btw. However, I have tried to re-edit the file to no avail! Please find the file attached in my email. Could it be something wrong with my version of excel? (Mac os mavericks, with office 2011.)


Dean

March 18, 2014 at 2:21 am

It might well be something to do with the version (I’m a PC user). Can you try saving the file specifically as a CSV file? Try both comma and tab delimited if it gives you the option.


Dean

March 18, 2014 at 6:41 am

Hi,

I tried the two new files you sent. Both failed. I opened up the CSV and simply saved it in Excel and it worked.

Maybe try a different program such as http://www.openoffice.org/porting/mac/


nick hubley

March 18, 2014 at 6:19 pm

WOW! OpenOffice worked. For some weird reason saving in Office 2011 on a mac doesn’t ever work.. Thank you for all your help!


nick hubley

March 18, 2014 at 6:37 pm

Wait! Ohh no! None of my seats are now appearing. When I go to register. First Image has the error when registering for a seat. The second one show all the seats successfully loaded into the seating area. http://imgur.com/a/VSKXY

I have selected the right seating layout. The only plugins installed are EE plugins. Thank you for your continued help!


Dean

March 19, 2014 at 5:20 am

Well at least we are getting somewhere!

When saving the file, do you know what encoding it is being saved as? Is it UTF-8 ?

It’s odd that something is being output but stalling or being hidden. I see this is a local test server? Do you have this on a live test server at all?


nick hubley

March 19, 2014 at 11:07 am

I just sent you the link and login credentials. Thanks!


Josh

  • Support Staff

March 19, 2014 at 4:52 pm

Hi Nick,

The credentials you sent say that the username is invalid. There may be a conflict with the theme because this theme is fairly JavaScript heavy, and the seating chart also uses JavaScript. Can you try installing the theme test drive plugin and testing out the reg page seat selector with one of the WordPress twenty * themes installed?


nick hubley

March 19, 2014 at 5:55 pm

Sorry! I have created a new user with the previous credentials I sent you. Also, I have tried the plugin with different themes e.g. 2011 etc. and still the issue persists. Thank you for any help! Please bear with me and try the username and password again! Thank you again, you guys are extremely helpful!


nick hubley

March 20, 2014 at 3:28 pm

Hi, I was wondering if there is any update?


Dean

March 21, 2014 at 3:24 am

Hi,

There are no errors on your site. I also tested the seating charts with theme test drive and saw no issues.

I uploaded a test csv file and it worked fine.

I also edited your seating chart on site, simply opening a seat in each section and clicked save. This loaded *some* of the seating chart, but also duplicated it which was weird.

Right now the only thing I can think is that it has something to do with encoding on the Mac, but most of support uses Mac (I am an exception to this) so we would have picked up on any issues with it.

Which leads it to being localised to your system. What/how is something I don’t know.

Have you tried to create a file on a different mac or a pc and see if they work?


nick hubley

March 21, 2014 at 11:06 am

The only way for the seats to appear on a mac. You cannot define , and ” is to save the CSV as Windows comma separated (CSV) not MS-DOS comma separated or comma separated. It is working now. One last question… Thanks btw. How can I have all my rows within one column? http://imgur.com/iqP0iyd How can I get section low, low-e and Raised-D under Raised-A, Raised-B and Raise-C?


nick hubley

March 22, 2014 at 12:42 pm

I just figured it out. Thank you for all the help!

The support post ‘Seating Chart CSV 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.

Event Espresso