MS project xml import

Wed, 10 Sep 2014 10:18:09 GMT

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]);

Re: MS project xml import

Wed, 10 Sep 2014 11:29:21 GMT

Ugh, forget it, hadn't run the script, idiot!

topic Re: MS project xml import in QlikView

MS project xml import

Re: MS project xml import