Hi Zohan,
I am not clear about your question, Are you asking about the possibility to export the table data to CSV file.
If this is your query: Yes. it is possible
Sample is given below
static void AE_AttributeExport_CSV(Args _args)
{
#file
#define.FileFormat('.csv')
str dateFormat;
TextIo textIO;
FileIoPermission filepermission;
Filename fileName;
DictTable dt ;
DictField df ;
FieldId fieldId;
int row = 1 ,FieldCnt, fieldName;
int header = 0, i,j;
System.IO.StreamWriter streamWriter;
RetailTmpCatBulkAttrib retailTmpCatBulkAttrib;
Notes text;
fileName = @"f:\anitha\AttributesExport_CSV_Other consoles accessories.csv";
filepermission = new FileIoPermission(filename, #io_write);
filepermission.assert();
if (WINAPI::fileExists(fileName))
{
WINAPI::deleteFile(fileName);
}
streamWriter = new System.IO.StreamWriter(fileName);
dt = new DictTable(tableNum(RetailTmpCatBulkAttrib));
FieldCnt = dt.fieldCnt();
fieldId = dt.fieldNext(0);
header = 0;
while select retailTmpCatBulkAttrib
where retailTmpCatBulkAttrib.CatalogName == 'MSPT Catalog' &&
retailTmpCatBulkAttrib.AttributeSourceName == "Other consoles accessories"
{
text = '';
if(header == 0)
{
for(i=1;i<=FieldCnt;i++)
{
fieldId = dt.fieldCnt2Id(i);
df = dt.fieldObject(fieldId);
if (df.isSql() && !df.isSystem() && df.visible())
{
text += df.name();
text += ";";
}
}
streamWriter.WriteLine(text);
header++;
}
text = '';
for(i=0;i<=FieldCnt;i++)
{
fieldId = dt.fieldCnt2Id(i);
df = new DictField(tableNum(RetailTmpCatBulkAttrib), fieldId);
if (!df.isSystem() &&df.visible())
{
text += retailTmpCatBulkAttrib.(fieldId);
text += ";";
}
}
streamWriter.WriteLine(text);
}
info("Exported");
}
