使用IMPEX Import从Hybris导出数据

Question

我正在尝试通过Export Impex脚本从多个表导出数据，但无法定义多个表的标题。层次结构类似于: OrderTable>>OrderEntry>>UNIT>PRODUCTID

有谁能建议我怎样才能做到这一点。

"#% impex.setTargetFile( ""Orders.csv"" );" 

insert_update Order;code[unique=true];purchaseOrderNumber;sapOrderNumber;site(uid);date;subtotal;currency(isocode);soldto(uid);user(uid);salesdistrict(uid);

"#% impex.exportItems(""select {pk} from {order} where {currency} IN ({{select {pk} from {currency} where {isocode} IN ('NOK','DKK','EUR','SEK')}})"", Collections.EMPTY_MAP, Collections.singletonList( Item.class ), true, true, -1, -1 );"

Answer 1

您的查询抛出错误，因此您的导出失败。

尝试使用以下查询，

select {pk} from {Order as o}, {Currency as c} where {o.currency} = {c.pk} and {c.isocode} IN ('NOK','DKK','EUR','SEK')

下面是从impex导出导出的另一个示例，供您参考。

"#% impex.setTargetFile( ""Category.csv"" );"

insert_update Category;&Item;ambassadorDesc;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];data_sheet(catalogVersion(catalog(id),version),code);defaultSku;description[lang=en];description[lang=en_GB];description[lang=en_US];detail(catalogVersion(catalog(id),version),code);logo(catalogVersion(catalog(id),version),code);name[lang=en];name[lang=en_GB];name[lang=en_US];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);picture(catalogVersion(catalog(id),version),code);stockLevelThreshold;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)

"#% impex.exportItems( ""Select {cat.pk} from {Category as cat join Catalog as c on {cat.catalog}={c.PK}} where {c.id}='masterProductCatalog'"" , Collections.EMPTY_MAP, Collections.singletonList (Item.class) , true, true, -1, -1 );"