Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In Edit Script, I am trying to create the QVD and TEXT file by using Store command.
After completion of execution and when i opened the Cus2 Text File , then it is showing like Xml Format.
IF we go through with MACRO Code for creating TEXT file then it is showing in different format.
//EDIT SCRIPT EXECUTION
Customers:
LOAD Address,
City,
CompanyName,
ContactName,
Country,
CustomerID,
DivisionID,
Fax,
Phone,
PostalCode,
StateProvince;
SQL SELECT *
FROM Customers;
Store Customers into Cus1.qvd;
Store Customers into Cus2.txt;
//MACRO SCRIPT EXECUTION
sub MyText
set vQvWorkPath = ActiveDocument.Variables("vQvWorkPath")
set obj = ActiveDocument.GetSheetObject("TB02")
set vBMname = ActiveDocument.Variables("vBook")
obj.Export vQvWorkPath.GetContent.String&replace(Date(),"-","")&"_"&replace(Time(),":","")&".txt",","
MsgBox("Data Has Been Transfered")
end sub
NOTE:
What is the main difference between Creating a QVD and TEXT in Edit Script, and what is the performance difference.
Thanks in advance
You need to specify file format as txt, just giving a filename.txt is not enough, use:
Store Customers into Cus2.txt (txt);