First things first...thanks for such an easy component to use! From install to setting up my first form; everything was a breeze.
But, I've run into a small issue.
I have set up a form that uses mainly text boxes and a couple of drop down menus. Pretty simple.
Everything works as it's supposed to except there's one hitch. When I export the saved data into Excel, there's one column (a multi-line text box) that is getting cut off.
If I open the saved data in CSV, it's fine--everything typed in the box appears.
In the confirmation e-mail, all the text typed appears.
But, in Excel, that particular column--which is supposed to hold about a 250-word paragraph--is being cut off.
Here's an example:
From the e-mail confirmation:
A strong 7-3 finish has XXX head coach XXX excited about the 2008 season. The XXX return six starters on offense but just two on defense, so they\'ll have their work cut out for them defensively. That shouldn\'t be a problem because of the off-season work the players put in and the team speed on offense should allow them to outscore many of their opponents.
From the Excel import:
A strong 7-3 finish has XXX head coach XXX excited about the 2008 season. The XXX return six starters on offense but just two on defense, so they'll have their work cut out for them defensively. That shouldn't be a problem bec
Any ideas?
But, I've run into a small issue.
I have set up a form that uses mainly text boxes and a couple of drop down menus. Pretty simple.
Everything works as it's supposed to except there's one hitch. When I export the saved data into Excel, there's one column (a multi-line text box) that is getting cut off.
If I open the saved data in CSV, it's fine--everything typed in the box appears.
In the confirmation e-mail, all the text typed appears.
But, in Excel, that particular column--which is supposed to hold about a 250-word paragraph--is being cut off.
Here's an example:
From the e-mail confirmation:
A strong 7-3 finish has XXX head coach XXX excited about the 2008 season. The XXX return six starters on offense but just two on defense, so they\'ll have their work cut out for them defensively. That shouldn\'t be a problem because of the off-season work the players put in and the team speed on offense should allow them to outscore many of their opponents.
From the Excel import:
A strong 7-3 finish has XXX head coach XXX excited about the 2008 season. The XXX return six starters on offense but just two on defense, so they'll have their work cut out for them defensively. That shouldn't be a problem bec
Any ideas?
Hi,
The Excel export function exports all data to text fields, may be the text field in excel has a maximum limit but I'm not sure, I think that exporting to CSV and opening with excel is just fine ?
The Excel export function exports all data to text fields, may be the text field in excel has a maximum limit but I'm not sure, I think that exporting to CSV and opening with excel is just fine ?
OK...this is weird.
Previously when I clicked back up to CSV it would give me a screen that allowed me to open or save the file. I'd save it as a CSV, open it in Excel and all my text would be there.
Now, I click back up to CSV and it automatically opens it in my browser with all the fields all over the place.
If I save it as CSV and open in Excel, it still looks all messed up with fields all over (see screen shot enclosed).
Any ideas?
Previously when I clicked back up to CSV it would give me a screen that allowed me to open or save the file. I'd save it as a CSV, open it in Excel and all my text would be there.
Now, I click back up to CSV and it automatically opens it in my browser with all the fields all over the place.
If I save it as CSV and open in Excel, it still looks all messed up with fields all over (see screen shot enclosed).
Any ideas?
Really no idea, try to do this from another machine or another browser, if its different then you had something with your browser
Cheers
Max
Cheers
Max
This topic is locked and no more replies can be posted.
