Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi Babynus,
You are doing great job on ProjeQtor tool. It is sooooo good and almost satisfying my needs. I have been validating your tool for more than a week for our organization (50+ users).
We are using an in house PM tool (fat client) and i tried to migrate some projects by using ProjeQtor's import option. Following issues identified during this import and i am clueless what to do next.
1. Client, Projects, Sub Projects, Resource, Affectation were imported successfully. But 'activity' Import stops @ 357th record inserts. No error in log. I have to import 7000+ records. Are there any limitation?
2. To bypass the above issue, I did DB Table insert directly into 'activity' and 'planningelement' tables by referring some of existing records and it was successful. I am able to view activities and planning data. However when I login with different users i am able to view all projects, though the affectation is for limited projects. Verified profile of those users, all of them are 'Project Member'.
Can you please advise?
Hi,
First, it may be dangerous to manually import into database.
About your import issue, most likely is a Timeout. Try and increase max_execution_time in php.ini.
Also have a look at apache log files.maybe you hve to play with Apache Timeout.
About project visibility, it is difficult to investogate with to little information.
What is project type ? "Template" gives special visibility.
Hi Babynus,
Thanks for quick response. I agree I should have not have tried direct table import 🙁 . As you suggest, I will increase max_execution_time and try again.
Need a clarification: Before using Import I usually export the module (resource, customer, activity etc.,) with some of existing data and use the same template for import. This does great job without any hassles. Unfortunately i couldn't find export for 'assignement' but it has Import option. I see the fields of assignment in 'Activity' import template but it is not importing for 'assginments'. Any tips to achieve this?
Thanks
Raj
Hi,
As you guessed it is not possible to export assignments.
Data exported in Activities are not assignments, but sum of assignements consolidated on the activity.
Only way to get expected format is to use the help botton on import form.
Hi Babynus,
I have increased 'max_execution_time' and imported agian. This time I am getting PHP Fatal error: Allowed memory size of 536870912 bytes exhausted . It should be server error and i need to google to fix it.
Thanks.
This time, you have to plau with memory_limit.
You must have memory_limit = 512M
You can try memory_limit = 1024M or more, depending on your server capacity.
But also you should concider splitting your import file... after all, ProjeQtOr is not an ETL 😉
Hi Babynus,
I resolved my problem (of course I introduced it 😛 ). As I mentioned earlier I was evaluating more than a week, I have initially imported Projects from live system. Some days later I've inserted Activities and Assignments in `Activity`, `Assignment` and `planningelement` table. By that time some more projects and their activities have piled up in live system. Being no reference constraints in DB, I was able to insert them without the new Projects. The resource assignments without `projects` were able to view ALLProjects regardless to their assignment in them. I have deleted those orphaned projects to solve this problem.
YOU ARE RIGHT!!!! DO NOT INSERT INTO TABLE MANUALLY. :sick: .
Thanks
Raj