you must have the proper rights on the other machine for importing.
Also during the import process at the Update Project options select modify and under Data Type: Global for the Resource item under the action column make sure that you select INSERT NEW
Yes you can say that it does the Global Change on XER. But the key point it does it BEFORE XER files being imported into P6.
If you imported cost linked file into P6 it's already too late to do global change.
The problem is in resource unit prices - in the native database P6 keeps 8 digits after dot for all unit prices but when the schedule is exported into XER format the number of digits after dot is reduced to 2 only.
So when this schedule imported on other computer the cost is recalculated based on 2 digits unit prices and there is no way to get initial cost.
Regards,
Andrew
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Tue, 2017-06-27 13:24
When P6 imports xer it recalculates cost automatically if they are connected to units. Global change afterwards doesn't fix the problem - the Unit Prices are already skewed.
Global change will work only if host computer do it prior to exporting schedule into XER which is very rare (almost never) based on my experience.
Regards, Andrew
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Mon, 2017-06-26 17:59
There are few points to be considered when importing XER cost loaded schedule.
1. Make sure that all currencies used in schedule and on your PC have same conversion rates.
2. When importing global data in particular resources and roles make sure your import configuration is set to "Insert New"
3. Most probably the XER file has resource units and cost "connected" together. That means P6 after importing will recalculate all cost assignments based on unit prices and because of limitation of XER format the outcome might be different (sometimes quite different) from the original. In order to avoid this I've wrote simple utility that allows you to disconnect the Cost from Units (it also purges POBS junk - but this isn't primary purpose). You can grab it here:
No installation required. Just drop your XER file(s) onto form and select "Unlink Units from Cost" - the new XER will be created. Import this file instead of original and I'm pretty positive you will have same Cost information as original schedule.
Regards,
Andrew
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Tue, 2017-06-20 13:19
I am facing the same problem here . I have inserted a new calender and resources when importing . I have checked that the duration and project status remained the same . i created a new empty database and imported the file there but still the problem has not been solved . Please if anyone solved this problem help me . thaanxx
I am facing the same problem here . I have inserted a new calender and resources when importing . I have checked that the duration and project status remained the same . i created a new empty database and imported the file there but still the problem has not been solved . Please if anyone solved this problem help me . thaanxx
Member for
16 years 3 monthsyou must have the proper
you must have the proper rights on the other machine for importing.
Also during the import process at the Update Project options select modify and under Data Type: Global for the Resource item under the action column make sure that you select INSERT NEW
Member for
6 years 9 monthsCan any one, Give us a
Can any one, Give us a detailed solution for this Change in budgeted total cost when we are importing XER to other system.
Member for
20 years 11 monthsZoltan.Yes you can say that
Member for
16 years 3 monthsAndrew Your unlinking does
Andrew
Your unlinking does the same thing the global change does it that not true ?
I do like the utility
Member for
20 years 11 monthsZoltan.When P6 imports xer it
Zoltan.
When P6 imports xer it recalculates cost automatically if they are connected to units. Global change afterwards doesn't fix the problem - the Unit Prices are already skewed.
Global change will work only if host computer do it prior to exporting schedule into XER which is very rare (almost never) based on my experience.
Regards, Andrew
Member for
16 years 3 monthsAndrew why do you need simple
Andrew why do you need simple utility that allows you to disconnect the Cost from Units
run a global change
tools global change
Select subject area as
Actviity Resource Assignments
Where Calculate costs from units equals Yes
then Calculate costs form units = No
Change then committ changes
Member for
20 years 11 monthsHi salmin There are few
Hi salmin
There are few points to be considered when importing XER cost loaded schedule.
1. Make sure that all currencies used in schedule and on your PC have same conversion rates.
2. When importing global data in particular resources and roles make sure your import configuration is set to "Insert New"
3. Most probably the XER file has resource units and cost "connected" together. That means P6 after importing will recalculate all cost assignments based on unit prices and because of limitation of XER format the outcome might be different (sometimes quite different) from the original. In order to avoid this I've wrote simple utility that allows you to disconnect the Cost from Units (it also purges POBS junk - but this isn't primary purpose). You can grab it here:
https://www.dropbox.com/s/wqcqa1qxdlzm393/XER_POBS.exe?dl=0
No installation required. Just drop your XER file(s) onto form and select "Unlink Units from Cost" - the new XER will be created. Import this file instead of original and I'm pretty positive you will have same Cost information as original schedule.
Regards,
Andrew
Member for
16 years 3 monthsdo a global change and
do a global change and uncheck calculate costs from units
Member for
8 years 8 monthsI am facing the same problem
I am facing the same problem here . I have inserted a new calender and resources when importing . I have checked that the duration and project status remained the same . i created a new empty database and imported the file there but still the problem has not been solved . Please if anyone solved this problem help me . thaanxx
Member for
8 years 8 monthsI am facing the same problem
I am facing the same problem here . I have inserted a new calender and resources when importing . I have checked that the duration and project status remained the same . i created a new empty database and imported the file there but still the problem has not been solved . Please if anyone solved this problem help me . thaanxx
Member for
11 years 3 monthsHi,Could you please confirm
Hi,
Could you please confirm the following points;
1. Is there any change in activity duration where bugdeted unit values get losts.
2. Have you any common calender name in two different machine (original schedule and imported schedule)
3. Have you any common Resource IDs in two different machine (original schedule and imported schedule)
4. Activity status
- Ravi
Member for
24 years 4 monthsHi Guys,Just seen this post
Hi Guys,
Just seen this post we have had similar issues, please advise solution
Member for
24 years 4 monthsHi Guys,Just seen this post
Hi Guys,
Just seen this post we have had similar issues, please advise solution
Member for
17 years 4 monthsCan be resolve... I'll guide
Can be resolve...
I'll guide you personally...
Email me at izajuliana@yahoo.com.my