I am trying to import just all the "Resource Names & Resource I.D." - I tried many times, but in vain.
I tried searching for YouTube Videos where only "Resource Names" are imported - But could not find a single such video.
I added 2 resources manually in Primavera i.e. NLD-21 & NLD-22 with all details & then exported to Excel with the following fields - Using the Resource Export -
Please note that the number values in the cells Are formatted as text or preceded by an apostrophe though it does not appear so in the below "Copy-Pasted" data - The Original Excel Data does have an Apostrophe.
rsrc_short_name | rsrc_name | rsrc_type | unit_id | role_id | def_qty_per_hr | max_qty_per_hr |
Resource ID | Resource Name | (*)Resource Type | Unit of Measure | (*)Role ID | Default Units / Time(h/d) | (*)Max Units/Time(h/d) |
NLD-21 | Parthiban | Labor | 8 | 12 | ||
NLD-22 | Vijay | Labor | 8 | 12 | ||
NLD-23 | VIKAS | Labor | 8 | 12 | ||
NLD-24 | ANIL | Labor | 8 | 12 | ||
NLD-25 | Sumit | Labor | 8 | 12 |
Then I opened the Excel file and deleted all other resources which are not part of the current project and added 3 more resources i.e. NLD-23, NLD-24 & NLD-25 with details as specified above.
Then I imported this resource added Excel file in Primavera - But these newly added 3 resources do not get imported even though Primavera displays that the "Import was successful" - I tried atleast 20 different Permutations & Combinations of adding and deleting fields, etc, etc but its not working out. The newely added 3 resources are Not Imported.
Can someone tell me why? And what to do?
With Thanks & Best Regards