Hey if someone could please help me with this code bit that is simply not working
MY goal is to loop through each list projects (ie in the variable ProjectName) and store them a specific file. So right now I only have one. So my goal in this case is to load from SP2 Project Sample.xml and then take the table Field_Table and store it in c:\LANDESK\TEST\CurrentDateField_Table.qvd . Below it is storing it in c:\ so any help is appreciated
thanks, Jason
The Code:
SET Directory[1] = c:\; SET ProjectName[1] = SP2 Project Sample.xml; SET ProjectPath[1]=LANDESK\TEST; LET ProjectCount=1; LET CurrentDate = date(today(),'YYMMDD');
for a = 1 to ProjectCount //LOAD all tables in to QVDs based on a filename convention of FileName and Current Date Field_Table: LOAD $(CurrentDate) as Field_Table.CurrentDate, FieldID, FieldName, Alias, Guid FROM [$(Directory$(1))$(ProjectPath(1))\$(ProjectName$(1))](XmlSimple, Table is [Project/ExtendedAttributes/ExtendedAttribute]); SET FileName = $(CurrentDate)Field_Table.qvd; STORE Field_Table INTO [$(Directory(1))$(ProjectPath(1))\$(FileName)]; DROP TABLE Field_Table; next a
