The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Fri Mar 30, 2012 2:54 pm 
Joomla! Intern
Joomla! Intern

Joined: Mon Feb 08, 2010 9:27 pm
Posts: 57
I just had 200 people fill a form out. They have fields with names, addresses, emails, choices,comments, etc.
When i exported it, all the data seems to have moved around.Nothing is in the write place.
Not sure how i can use the data or fix it in excel.
I tried the import text using the delimeters but I see multiple semi colons on some and 2 on others..such a mess.
In the text field where you enter line by line addresses and it seems when exported it shows up on multiple cells.!
advice?


Last edited by crosswire on Fri Mar 30, 2012 5:11 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Fri Mar 30, 2012 3:52 pm 
Joomla! Intern
Joomla! Intern

Joined: Mon Feb 08, 2010 9:27 pm
Posts: 57
Is it because there are 28 fields mmmm..


Top
 Profile  
 
PostPosted: Fri Mar 30, 2012 5:10 pm 
Joomla! Intern
Joomla! Intern

Joined: Mon Feb 08, 2010 9:27 pm
Posts: 57
This has been solved.

When exported, the address shows up on different lines in the text file. This messes things up. I used wrangler for Mac to edit the file and move the address text back to the the rows without having it on its own line. Not sure why this happens.
thanks


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 



Who is online

Users browsing this forum: No registered users and 13 guests


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 post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group