Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Too many columns error
Options
Go to last post Go to first unread
Previous Topic Next Topic
WRodger  
#1 Posted : Friday, November 29, 2013 3:05:31 AM(UTC)
WRodger
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1
Location: Melbourne

Hi,

I am having problems exporting data to chem tables and was hoping someone might be able to help. When I try to export data I get the following error:

Error: Too many columns are being exported (max 255 excel columns), try exporting less data or use a different data orientation.

However, I am only trying to export results for a handful of locations with vertical chemical names so it shouldn’t exceed 255 columns. Instead, it seems that the error occurs when I try to add more than two location/sample data fields to the table. I.e. it exports without any problems when I include only the Well Code and Sample ID fields but when I try to add further fields such as the sampling date and lab report number the error appears. 

I’m using the Access version of ESdat and Excel 2010.

Any advice would be welcome.

Thanks,

Will
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Saturday, November 30, 2013 2:17:37 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Will,

Are you using the Access version (listed in the drop-down on starting ESdat)?

If you are able to send screen shots and a zipped copy of a database that shows the issue to support@ESdat.com.au we will take a look at it.

Regards,

Warwick

 
Back to top
WWW
JAzzam  
#3 Posted : Thursday, December 19, 2013 7:29:57 PM(UTC)
JAzzam
Rank: Newbie

Reputation:

Groups: Registered
Posts: 5
Location: Vancouver

I am having the same issue and cannot export my data to vue in excel. Any word on how to resolve this?

Thanks,

J

Back to top
Warwick Wood  
#4 Posted : Thursday, December 19, 2013 10:33:41 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Wills issue was found to be a known bug.  Inclusion of the "Sample Type" column in the Chem Table caused the issue.  This is fixed for the next release.

Warwick

Back to top
WWW
JAzzam  
#5 Posted : Tuesday, December 31, 2013 7:27:38 PM(UTC)
JAzzam
Rank: Newbie

Reputation:

Groups: Registered
Posts: 5
Location: Vancouver

Thanks Warwick!

I will remove Sample Type from my export. 

Back to top
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET