Forum Sponsor:

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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.

Set activity type hammock for a set of tasks.

5 replies [Last post]
Gün Göksu
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Hello everyone,

Thank you to all who take the time to respond to all those questions. till now I have found all the answers to my questions as they have been asked and answered before.

This one I couldnt find.

I need to convert a certain number of tasks to hammocks.
(set Activity Type = hammock)

But I cant find a way to get the SYST column to show in the export files.

and a global change I could not make it to work.

a little detail.
Activity ID’s that need to change are all L????.?S


IF ACT EQ L????.?S
THEN SYST EQ "Hammock"


does not work. (I have tried hammock, "hammock", h, and whatever has come to my mind).

any other way to do this fast??

Thank you. :)
Gün.

Replies

Gün Göksu
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Thank you very much. :)

Both ways work. I really said "AHA!!!" when I saw that 5 for hammock. that was what was missing.

I am still looking for a way to get the STYP column to show and be used in a DBF file though.

If you come across that piece of information please send it this way. I will really appreciate it.

Gün. :)


Sukumaran Subaram...
User offline. Last seen 4 years 20 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi,

Why don’t you try to change the activity type using Activity Form.
You need to do a bit of hard work but you will get the result.

Go to View > Activity Form > Type. Change the activity to hammock.

OR:

Filter the selected activities > Open column for Activity Type > type Hammock to 1st activity > Highlight the remaining activities > Edit > Fill Cell. Now you have successfully change the activities to hammock.

Regards.
Jaco Stadler
User offline. Last seen 13 years 7 weeks ago. Offline
Joined: 8 Sep 2004
Posts: 300
Groups: None
Ok I have not been able to use export with this but what about a global change.

Fisr Copy Your Schedule (If any Thing goes Wrong you have it still)

It is Easy.

First you go to Selection
Select All
Act ID contains L
Act ID contains S

Then you go to Change
Then:STYP EQ 5

Pre Trail Run and see if this is what you needed.

Gün Göksu
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 31 Mar 2005
Posts: 123
Thank you for the very fast reply. :)

Any chance of doing this from export/import dbf file?

Because the activity.xls file is BIG and takes a very long time to update.

Plus I have had problems with the dates before that I have not been able to solve then. I try to steer away from the activity .xls file.

Gün. :)
Jaco Stadler
User offline. Last seen 13 years 7 weeks ago. Offline
Joined: 8 Sep 2004
Posts: 300
Groups: None
Try

C:\P3WIN\Samples\EXCEL\ACTIVITY.

This file is also on the p3 CD

Get the Activity’s

Sort the Activity’s

Change the Type to 5 (Hammock en reimport)

And Send back to p3 (Set Activity’s)

PS if you can not get the files PP me your email I will send you the "P3" File