Back to myContactForm.com - Easy email form creation and processing for your web site
myContactForm.com - Help Forum Forum Index myContactForm.com - Help Forum
Have a question that you need answered about myContactForm.com? Post it on this message board but first search this forum and read out FAQ to ensure it has not already been answered. This is not a board to post links to your site! SPAM will be deleted!
 
   Search MessagesSearch Messages
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

EXporting to excel file

 
Post new topic   Reply to topic    myContactForm.com - Help Forum Forum Index -> Message Center
View previous topic :: View next topic  
Author Message
pnowlan



Joined: 15 Aug 2012
Posts: 1

PostPosted: Thu Jan 29, 2015 6:09 am    Post subject: EXporting to excel file Reply with quote

Hi
first thanks for a great site
two issues
1. when exporting the random 'student code ' to an excel sheet it only exports the first 4 characters . This is a recent issue it used to be OK
2. In my current form tcd15A the columns do not line up correctly when exported to an excel sheet
I have a column marked 'I will be attending day1 ' the export includes other data '
I did amend the form after data had been entered
Thank you
Peter
Back to top
View user's profile
mycontac
Site Admin


Joined: 31 Dec 2003
Posts: 2860

PostPosted: Fri Jan 30, 2015 2:36 am    Post subject: Reply Reply with quote

This is an issue that occurs when forms have been altered after data is collected. Your best bet when altering a form that requires exports is to copy the form in the admin panel, modify it, and then start collecting data on the new form. This keeps the changes and data separate in the Message Center and prevents these types of errors.

Nick Ladd
mycontactForm.com
Back to top
View user's profile
kseidl



Joined: 10 Feb 2009
Posts: 2

PostPosted: Thu Jun 18, 2015 9:50 am    Post subject: Same issue Reply with quote

I was reading this question about exporting data after altering the questions, specifically adding questions in and changing the order of the questions, after data has been collected. I am having the same issue, where the columns of data will skew to the right based on a new question added. I'm not sure I understand your answer about copying the form into the admin panel. Would I be creating a new form all together and from that point forward would have 2 databases of information? Thanks!
Back to top
View user's profile
mycontac
Site Admin


Joined: 31 Dec 2003
Posts: 2860

PostPosted: Fri Jun 19, 2015 3:15 am    Post subject: Re: Same issue Reply with quote

kseidl wrote:
Would I be creating a new form all together and from that point forward would have 2 databases of information? Thanks!


Essentially, yes. You would copy the form in the admin panel and then begin using that form and its code. You would then retire the old form.

Nick Ladd
myContactForm.com
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    myContactForm.com - Help Forum Forum Index -> Message Center All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.11 © 2001, 2002 phpBB Group