DATA IMPORT - AQ
In the Open Standard
Jonathan WardMember for 19 years 8 months
- Created
- 3
- 1
0
Hello all,
Any help with this would be very much appreciated.
I am having difficulties importing a value into the AQ Actual Quantity field,, currently all other fields are importing and updating perfectly i.e. % comp, Actual Start, Actual Finish, BQ.
When I run the import (picking up a .DBF) all other fields are updating however the AQ is reading the same value as the Earned,, I assume this is automatic IF the AQ value is not being picked up?
Any ideas?????
Any help with this would be very much appreciated.
I am having difficulties importing a value into the AQ Actual Quantity field,, currently all other fields are importing and updating perfectly i.e. % comp, Actual Start, Actual Finish, BQ.
When I run the import (picking up a .DBF) all other fields are updating however the AQ is reading the same value as the Earned,, I assume this is automatic IF the AQ value is not being picked up?
Any ideas?????
3 replies
Oldest first- 0Jonathan Ward ·Thank you Rodel,
these figures that I need to import are Actuals - real numbers booked to activities so I need the AQ field populated from the import.
It is very strange as I can update the Es and EF and Activity Titles - just not the AQ??
any other ideas?
once again many thanks
- 0Rodel Marasigan ·Jonathan,
I think you did not understand what I mean. This is what you need to do.
First export P3 data including Act Id, resource, BQ, AQ, QAT & QTC. Then populate all fields using your own data then import back. This will update all fields that you required. If importing only AQ it may not update because QAT - QTC = AQ where QAT & QTC is exist on your P3 database which you need to replace also using your own populated data.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?