View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Access to all projects - ProjeQtOr
 

Access to all projects

More
11 Mar 2015 16:02 - 11 Mar 2015 16:45 #1 by oracleraj
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?
Attachments:
Last edit: 11 Mar 2015 16:45 by oracleraj. Reason: modified text

Please Log in or Create an account to join the conversation.

More
11 Mar 2015 21:24 #2 by babynus
Replied by babynus on topic Access to all projects
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
12 Mar 2015 06:36 #3 by oracleraj
Replied by oracleraj on topic Access to all projects
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

Please Log in or Create an account to join the conversation.

More
12 Mar 2015 10:33 #4 by babynus
Replied by babynus on topic Access to all projects
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
12 Mar 2015 12:39 #5 by oracleraj
Replied by oracleraj on topic Access to all projects
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.

Please Log in or Create an account to join the conversation.

More
12 Mar 2015 13:13 #6 by babynus
Replied by babynus on topic Access to all projects
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 ;)

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: oracleraj

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.043 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.