HELP: Is Sugar just destined to not run on Windows???

[D_M_S]

Sugar CE 5.2i, formerly on WIMP, now on WAMP

I had an install of Sugar that was running on WIMP but just had too many PHP notices and errors. Also, I was able to IMPORT leads but not EXPORT them.

So I spent the greater part of last night moving from WIMP to WAMP. I get a lot fewer PHP errors and the program seems to run a little better but now I can EXPORT but not IMPORT. Frustrating! I have to say that it seems to run better on WAMP but these are two critical features that I need.

Does anyone have any ideas on fixing the Import feature? After I choose the CSV file to import (the same file I've imported in the past) it processes for a little bit and then just goes to a blank screen. The logs have one of those pesky "undefined index" errors . . . the same type of errors that had me move from WIMP - doh!

TIA!

[Angel]

Import errors are usually the result of data formatting issues within the source CSV or PHP configuration problems, such as low execution limit values.

What happens if you only try to import a small number of records?

All that aside, I have about 15 installs on my WAMP setup and none of them exhibit the behavior that you describe, nor can I state that I've seen it elsewhere. There is likely a subtle configuration issue that is causing you the headaches, as it is not the OS.

[D_M_S]

I appreciate the reply.

The strange part of all this is that I'm using a CSV file that I know I've imported just fine with WIMP and a truncated version also fails.

Your last comment is where my latest thinking is. I might have to adjust some items in Apache because I've noticed that the Import stops at EXACTLY 30 seconds, no matter the size of the file.

Can you recommend some parameters to look at ? I'm not an Apache tech at all . . .

[roblaus]

Yeah, pimp your WIMP is the only thing left to say...

Please get yourself the wamp stack installer, take a test machine and install it without any manual interventions. Try to im- and export. I am almost 100% sure (scrap the almost) that it will work and you won't be getting any errors.
I can't say anything about IIS (devil's work) but Sugar works very well on a WAMP stack.

[EDIT] look at the max execution time in php.ini, set it to 90 or 120...

[Angel]

I appreciate the reply.

The strange part of all this is that I'm using a CSV file that I know I've imported just fine with WIMP and a truncated version also fails.

Your last comment is where my latest thinking is. I might have to adjust some items in Apache because I've noticed that the Import stops at EXACTLY 30 seconds, no matter the size of the file.

Can you recommend some parameters to look at ? I'm not an Apache tech at all . . .

It is more likely an issue with PHP, which you should be able to correct by manipulating the PHP.INI file.

Check this out for some hints on what to look at: http://cheleguanaco.blogspot.com/200...-problems.html

Don't forget to restart Apache if you make any adjustments to PHP.INI.

[D_M_S]

RESOLVED

Here's something I haven't seen often - in a brand new, fresh install of PHP 5, the max_execution_time parameter was missing from the file - it wasn't in there at all! So, the program was defaulting to 30 seconds. I added it and set it to 300 and its now working fine.

[roblaus]

Life can be so easy sometimes...

[D_M_S]

Its even easier if you know what you're doing with Apache. Which I don't, this is my first time working with Apache and PHP.

[roblaus]

Very true and not easy to admit as you can see at so many places here. Glad it worked out for you...