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 (XmlSimple, Table is [Project/ExtendedAttributes/ExtendedAttribute]);
WorkingTime:
LOAD FromTime,
ToTime,
%Key_WeekDay_02B90FFE85635485 // Key to parent table: Project/Calendars/Calendar/WeekDays/WeekDay
FROM (XmlSimple, Table is [Project/Calendars/Calendar/WeekDays/WeekDay/WorkingTimes/WorkingTime]);
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 (XmlSimple, Table is [Project/Calendars/Calendar/WeekDays/WeekDay]);
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 (XmlSimple, Table is [Project/Calendars/Calendar]);
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 (XmlSimple, Table is [Project/Tasks/Task]);
