Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

DATA IMPORT - AQ

3 replies [Last post]
Fri, 2010-06-11 04:54
Jonathan Ward
User offline. Last seen 12 years 17 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 114
Groups: Petro-Chem / Oil & Gas
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?????
Top

Replies

Fri, 2010-06-11 06:37
#1
Rodel Marasigan
User offline. Last seen 10 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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.
Top
Fri, 2010-06-11 05:45
#2
Jonathan Ward
User offline. Last seen 12 years 17 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 114
Groups: Petro-Chem / Oil & Gas
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
Top
Fri, 2010-06-11 05:19
#3
Rodel Marasigan
User offline. Last seen 10 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Jonathan,
Try to include QAC "Quantity At Completion" and QTC "Quantity to Complete". It dictates the update of AQ "Actual Quantity". If QAC = BQ then QAC-QTC = AQ.
Top