next »

[Lyanna]

I want to use the calendar script as a Change Calendar (ie, list all the changes we are undertaking on our infrastructure) and tried to import all information I had on changes in our helpdesk system.

To a certain extent, it worked. I loved how I could define event fields and everything. I went to the Import Event form, pasted in the header of the csv file I had created, pasted the rest of the document in the body field, changed the delimeter, linked fields to datatypes etc, hit submit, but then got a blank page.

I later found out that I could not import over 400 events in one go. It will only let me import 15 at a time or something. If I break up the csv file into small portions, I eventually can load everything I need, but it takes me ages to finish. Is this deliberate behavior, or do I need to tweak a parameter somewhere?

Help is muchly appreciated  

[DanO]

** I later found out that I could not import over 400 events in one go. It will only let me import 15 at a time or something. ... Is this deliberate behavior **

No. The script should allow you to import as many events is possible up to a maximum run time of the application the web server allows.

** or do I need to tweak a parameter somewhere? **

There is nothing in the script you can tweak. If the problem is the script is timing out on the server and you have access to the server's configuration, you may be able to increase that run time. On most of the servers I host on, maximum run time for CGI scripts is 30 seconds.

** I could not import over 400 events in one go. It will only let me import 15 at a time or something. **

If it won't allow you to import more then 400, how about 399 at a time??

Dan O.

------------------

[musicvid]

Lyanna,
I have successfully imported over 200 events from a backup flatfile without issues.
I do know that if you are creating the import files from scratch everything has to be just right. Even an extra whitespace in the wrong place can produce a blank file. You might try saving straight .txt rather than .csv
If you would like some examples of well-created flatfile data for import, do a search on these forums for "Holidays."

[This message has been edited by musicvid (edited November 10, 2004).]

[Lyanna]

Dan O, like I said, I can't import more than say 15 events at a time. So 399 is definately not going to work.

I unfortunately can't access any runtime parameters on the server, and our DBA is not here at the moment. Will check with him tomorrow, thanks for the tip. I hope that is it. I can't really check what is going wrong though since the only thing I get returned is a blank page, not an error message.

Musicvid, thanks for the tip. Looked up the said thread and my file looks just like that example, so I don't think I am doing much wrong there. It is a process of elimination though, so I am glad you could provide me with an example