Thanks for your reply Dear Mr. Izam Zakaria.

I am trying to import just all the "Resource Names" - 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 - 

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)

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 newely added 3 resources do not get imported even though Primavera displays that the "Import was successful" - I tried atleast 15 different Permutations & Combinations of adding and deleting fields, etc, etc but its not working out. The newely added 3 resources are Not Imported.

Can you tell me why? And what to do?

With Thanks & Best Regards

 

Can you please explain how to import the "Resource Names" because the exported excel file has an Asterix (*) in the Resource Name field and is therefore "Un-editable" and ignored by P6 during import.   

Hello for all I have problem when i expert exel sheet with activity name and id it comming sheet empty in task no id .no actovity name .idonot know why ?

Hello Everyone,

I am receiving the message "Exort failed. Unexpected error from external datadase driver (1). Please contact your administrator to correct the problem.

Any input/ help is more than appreciated.

 

Keith

Hello Ali,

 

I am experiencing the same problem and was wondering if you ever received a solution?

 

Thanks

 

 

Dear Zolfan, 

Thank you for your reply.

This problem was from first and it is not new.

We were not able export to excel. I dont know it is microsoft problem or P6 admin access problem. 

Hi everybody, 

Please help me to solve my problem. 

I cannot export schedule from P6 to excel. The below error message is coming:

"Export failed. Unexpected error from external database driver (1) please contact your administrator to correct the problem."

Please advice me how to solve this problem. 

Hi Ankit Singh,

There is an option in excel through which you could import csv file, to import csv file first of all open Microsoft Excel and go to Data option, here you will see an option where you can import data from external resource such as txt, xml, form web resources etc.  But in case If you want to use any third party software to perform such kinds of action, you should be download MindStick DataConverter. This is very efficient tool through which you can perform many such type of actions and saved file in many extensions, basically it's free charge tool so you have not any difficulty to download it.

MindStick DataConverter Download Link: http://mindstick.com/Product/ProductDC.aspx

I hope it might be useful for you.

Hello Everyone,

I'm posting this question here because I haven't found found option for creating New Thread, Actually I have been suffering with one problem since two days I want to import CSV data into excel file and export it in SQL file format, so I want to whether any option or efficient tool to solve this problem. Please resolve my problem as soon as possible or give me any valuable suggestion.

Thanks in advance!

Well, this might be a bit late, but for others who might be struggling with importing updates from excel, I've put together a step by step video tutorial with a real-world project example.  If you're interested, have a look https://www.planacademy.com/excellerate-your-updates-how-to-import-your-subcontractors-primavera-updates-from-excel/

Also, on re-importing data, all excell data must be of "TEXT" type for the reimport to work.  It's all outlined in the post.

 

Regards,

Michael

Arnold,

Sorry for getting back to you late. The problem is that when I choose to export both the activities & relationships. I added to export both ’predecessor name’ & the ’successor activity names’. When I open the excel file, I found that I got the first 4 letters of the activity name under these two columns. I did get the complete activity names at the ’activity name’ column.

When I export activity ID, Name, and relationships to excel in P6, I got only the frist few letters in the Activity Name column. Anyone can tell me how to modify the length of the exported text in P6?

I knew how to do this in P3.

Hi Izam,

First of all, thanks for appreciating my assistance. I am happy to help.

Regarding to your query, to assign resources using excel sheet:

1. Create first the resources in Primavera 6 Windows.
2. After creating, export to excel all the activities don’t have resources assign.
3. make sure that your export type is "Resource Assignment" and include the "Resource ID", Activity ID and Activity Name & Budgeted Units (If necessary).
4. In Resource ID (rsrc_id) column, assign only the unique Resource ID (This is the Resources you newly created in Primavera 6 Windows) to that particular Activity ID & Name and put the units under the “Budgeted Units” column.

Try this and let me know, otherwise I will send you the steps.

Regards,

Arnold