Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

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.

Import from WKS or DBF

12 replies [Last post]
Forum Guest
User offline. Last seen 14 weeks 4 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
I have problem in importing to P3 from WKS and DBF.
Total no of activities in P3= 12K. Exported 1000 activites to dbf and imported it after updating the progress. Around 10% of my actuals were missing. In the past weeks I didn’t have an problem. It just happened this week.Import function didn’t account those activities. Did any one come accross such import problem?. Any advise?.
Thanks.

Replies

Luca Basile
User offline. Last seen 9 years 38 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
To avoid the problem I am using an RA utility I found in internet, long time ago, that is making a matrix Activities/resouces.
Just push a bottom to import in excel and another to import in.
Very nice and usefull.
if You want I can send to You.

Luca

PS I understood that in P3e this functionality is integrated in the package.
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Dear All,
I came across this problem before. The answer is simple. Both DBF and WKS or WK1 have range. When you combine data or deleting data, the range changes. Although you might cut and pasted back but the range remain un-change as a result when you import you only imported the top end range of activities where your bottom half will not be imported.
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
By import/export to create the DBF, I can do some ’data combination’, like dates, WBS and codes value per activity. If by RA Excel, you’ll have 3 separate worksheets.
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Don’t worry, this Activity.xls is available on CD also. The data connection is by RA.
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
That ’SDK’ Excel file is available on the installation CD!
Luca Basile
User offline. Last seen 9 years 38 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
I am agree, but look like the originator of this discussion had problems because was using excel.
Is true teh same file open after with access had all the records.

MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
I remember there is limitation in Excel for number of row and column. It is not related to the export file since it is in DBF or WK1. (WK1 even more worst. DBF is better.)
Open DBF by Excel will be affected by Excel’s limitation, that’s why Access or other database software is better. Excel is spreadsheet type software, not database.
Luca Basile
User offline. Last seen 9 years 38 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Exporting in excel a 5000 activities schedule in DB format I found out that the excel database was able to recognise only around 3000. I do not remember the exact number.
For this reason I switched directly to access and I have not again the same problem, and now the construction schedule is bigger.
I think is not excel limitation as it can work with around 65.000 rows, but when You start to work with the database capabilities of excel.
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
There is no limitation to XLS file format file. The limitation is depend of the file type, like WK1, WKS, etc.
Luca Basile
User offline. Last seen 9 years 38 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Have You try to manipulate the exported file with access?
Excel database is limited in capacity, so it will be not able to read all the records.

In any case if You work with excel remind to save as DB3 format. Excel put as default DB4
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
My practice is export at least 2 activities from P3 into dbf. Open dbf by Excel, modify the record. If any addition row, insert the new between the first and last export records (the range will be increased auto). Then save the dbf and ready for import.
MK TSE
User offline. Last seen 4 years 22 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
For WKS or WK1, there is some limitations, the export result cannot more than certain row number.

For dbf, this limitation seems not exceed. However, the import row is bounded by a named range. If you have rows not in the ranged, these record will not be imported.