Forums

Excel issue

share24 01 May, 2008
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?
Max_admin 03 May, 2008
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 ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
share24 03 May, 2008
Yes, backing up to CSV and opening it in Excel works.
share24 12 May, 2008
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?

Max_admin 13 May, 2008
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
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.