JIM-to-uddeIM Import Fails

I am moving from JIM 1.0.1 to uddeIM 1.3 (downloaded 9/7). All has gone well until I tried to import approx. 22,000 messages. Using Vista, I receive a 500 server error. Using IE, the "wait for import" page appears, but no import occurs.

Well, it seems that the script dies (don't know how long it takes to import 22k messages but I am pretty sure that it will exceed the 30secs most provider allow a php script to run).

Another problem might be that php has not enough working memory. UddeIM reads all messages first (22k x 2kb per message = > 44mb memory). So it is also required to increase the working memory.

When you cannot change these values there is a way to import the messages but this requires some script modifications:

[code:1] $sql="SELECT id, whofrom, username AS whoto, date, message, subject, outbox, readstate FROM #__jim";
[/code:1]

change this to

[code:1] $sql="SELECT id, whofrom, username AS whoto, date, message, subject, outbox, readstate FROM #__jim WHERE id>=0 AND id<5000";
[/code:1]

then execute the import.

Change the WHERE clause to 5000 and 10000 and import again, change to 10000 and 15000 and...

Not very convenient but should work.

When the import tab is not longer shown you can reset the value in the config file (pmsinportdone=0).

Thanks for thinking this through. Although I do have full access to my server, I think that I will use your second suggestion.

In which file should I make the script change?

Its in admin.uddeim.php