Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've created a really basic MS project 2007 file and saved it as XML and imported the XML in to QlikView.
The script looks like it's imported as expected, but there's no tables or fields. I was expecting to be able to add an object and select fields from the various tables that would have been created.
Could anyone point me in the right direction please?
Here's an excerpt of the script:
// Start of [Project1.xml] LOAD statements
'ExtendedAttributes/ExtendedAttribute':
LOAD FieldID,
FieldName,
SecondaryPID,
%Key_Project_59FE1CDD36903AAC // Key to parent table: Project
FROM
WorkingTime:
LOAD FromTime,
ToTime,
%Key_WeekDay_02B90FFE85635485 // Key to parent table: Project/Calendars/Calendar/WeekDays/WeekDay
FROM
WeekDay:
LOAD DayType,
DayWorking,
%Key_Calendar_FD9CE055B3853312, // Key to parent table: Project/Calendars/Calendar
%Key_WeekDay_02B90FFE85635485 // Key for this table: Project/Calendars/Calendar/WeekDays/WeekDay
FROM
Calendar:
LOAD UID,
Name,
IsBaseCalendar,
BaseCalendarUID,
%Key_Project_59FE1CDD36903AAC, // Key to parent table: Project
%Key_Calendar_FD9CE055B3853312 // Key for this table: Project/Calendars/Calendar
FROM
Task:
LOAD UID,
ID,
Type,
IsNull,
CreateDate,
WBS,
OutlineNumber,
OutlineLevel,
Priority,
Start,
Finish,
Duration,
DurationFormat,
Work,
ResumeValid,
EffortDriven,
Recurring,
OverAllocated,
Estimated,
Milestone,
Summary,
Critical,
IsSubproject,
IsSubprojectReadOnly,
ExternalTask,
EarlyStart,
EarlyFinish,
LateStart,
LateFinish,
StartVariance,
FinishVariance,
WorkVariance,
FreeSlack,
TotalSlack,
FixedCost,
FixedCostAccrual,
PercentComplete,
PercentWorkComplete,
Cost,
OvertimeCost,
OvertimeWork,
ActualDuration,
ActualCost,
ActualOvertimeCost,
ActualWork,
ActualOvertimeWork,
RegularWork,
RemainingDuration,
RemainingCost,
RemainingWork,
RemainingOvertimeCost,
RemainingOvertimeWork,
ACWP,
CV,
ConstraintType,
CalendarUID,
LevelAssignments,
LevelingCanSplit,
LevelingDelay,
LevelingDelayFormat,
IgnoreResourceCalendar,
HideBar,
Rollup,
BCWS,
BCWP,
PhysicalPercentComplete,
EarnedValueMethod,
IsPublished,
CommitmentType,
Name,
ConstraintDate,
%Key_Project_59FE1CDD36903AAC // Key to parent table: Project
FROM
Ugh, forget it, hadn't run the script, idiot!