function downloadfilesourcefile, destfile string boolean

Name: function downloadfilesourcefile, destfile string boolean
Category: Free
Published: nighmilkaastar1973
Language: English

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In this case – Sheet1 cell A1.
Select PMSDK and click Next:
These tables represent the data inside your P6 database. The ones with X_ in their names mean those tables are “extended” tables and simply means the table has been optimized for SQL joins. Since we are just going to look at simple data sets – like basic Project information – we do not need the X_PROJECT table. That said, let’s select the PROJECT table and click next.
Don’t worry about messing anything up – the data is read only. To get it to write back you need to do some further work behind the scenes in VBA. More on that in a later article. If someone makes any changes you can click “Refresh” in the Design tab and it will reload the table. You can connect every table to a sheet this way – but be sure to name your sheets to avoid confusion!
The first thing you will want to do is open up a blank Excel spreadsheet. Nothing fancy – just a plain spreadsheet:
Enter your Primavera P6 User credentials (The P6 Application credentials NOT the database ones!):
This will launch the Data Connection Wizard. Now we want to select “ODBC DSN” and click Next.
Now tell it where to insert the table data:
For this demo we will be using P6r15 and Excel 2013 – but it should work exactly the same with P6 7.x and 8.x. We are also going to assume your P6 SDK is correctly installed and configured and you used the default ODBC names and aliases – PMSDK – when P6 was installed. For more information about installing the P6 SDK check back soon – a related post is in the works.
From the Data tab we will select “From Other Sources” then “Import from Data Connection Wizard”:
Need a customized import/export routine? We do that- A LOT! Contact us today and we can get you up and running in no time.
A progress bar will pop up for a brief moment then it will give you a list of tables:
Pro Tip : Occasionally an error might pop up here that says “ OpenRDA ODBC RDA error: Connect error ”. This can be caused by the SDK not finding the correct files or not having access to them. A lot of times you will see this error and it will not matter – click ok and it will work anyway after making you select PMSDK and reclogging in again. If it doesn’t work – try running Excel as Administrator or reinstalling the SDK using the default location.
Now we will want to setup the ODBC/SDK connector. To do this we will click on the Data Tab:
In a previous article ( The Primavera SDK – It’s Not What You Think ) I briefly discussed what the Primavera P6 SDK is and what it is not. To the disappointment of the masses it isn’t by itself a good way to pull data from the database. In this article I am going to fix that by showing you how to use the P6 SDK to connect Excel to your P6 database and then pull various data elements from your P6 database.
Retrieving P6 Data using the Primavera P6 SDK and Excel.
It might ask you to log in again, simply put in your P6 username/password (again – the P6 application username/password, NOT the database connection username/password):

If all went well – you now have a sortable/filterable spreadsheet containing all of your P6 Projects:
Its near the middle of the top navigation bar.
Now it is asking us to save the data connection. You can leave the filename as it is, but it’s generally good practice to, at a minimum, tell what the table selected is and what database it’s connecting to:
Plain Ol’ Blank Spreadsheet.
http://semoleking1973.eklablog.com/8086-disassembler-download-3-1-a...