Error: No binding found in the table.

[Tristan-bash]

I recentyl added the spreadsheetimporter to my project.
When i try now to upload an excelfile I get the following error msg:

No binding found in the table.
If you are in a list report, press the 'Go' button.
Error: No binding found in the table.
If you are in a list report, press the 'Go' button.
at t.e [as setContext] (https://port4004-workspaces-ws-fq4k6.eu10.applicationstudio.cloud.sap/com.jh.sls.managefieldcampaigns/thirdparty/customcontrol/spreadsheetimporter/v1_7_3/Component-preload.js:35:2784)
at async t.e [as initialSetup] (https://port4004-workspaces-ws-fq4k6.eu10.applicationstudio.cloud.sap/com.jh.sls.managefieldcampaigns/thirdparty/customcontrol/spreadsheetimporter/v1_7_3/Component-preload.js:35:1584)
at async t.e [as initializeComponent] (https://port4004-workspaces-ws-fq4k6.eu10.applicationstudio.cloud.sap/com.jh.sls.managefieldcampaigns/thirdparty/customcontrol/spreadsheetimporter/v1_7_3/Component-preload.js:35:5163)
at async t.e [as openSpreadsheetUploadDialog] (https://port4004-workspaces-ws-fq4k6.eu10.applicationstudio.cloud.sap/com.jh.sls.managefieldcampaigns/thirdparty/customcontrol/spreadsheetimporter/v1_7_3/Component-preload.js:35:5483)

The function which is invoked by the action looks like that: (its pretty much the example provided by the typescript section of the docu)

import Component, {
	Component$ChangeBeforeCreateEvent,
	Component$CheckBeforeReadEvent,
	Component$UploadButtonPressEvent,
} from "cc/spreadsheetimporter/v1_7_3/Component";
import BaseController from "sap/fe/core/BaseController";
import ExtensionAPI from "sap/fe/core/ExtensionAPI";
import MessageToast from "sap/m/MessageToast";

export async function openSpreadsheetUploadDialog(this: ExtensionAPI) {
	const assetTableId =
		"com.jh.sls.managefieldcampaigns::GlobalFieldCampaignsObjectPage--fe::CustomSubSection::MaintainAssets--maintainAssetsTable";
// the assetTabledId is found and its correct. 
//but then the following will be undefined

	const table = sap.ui.getCore().byId(assetTableId);
	console.log("Table:", table);
	console.log("Binding Info:", table?.getBindingInfo("items"));
	console.log("Controller:", view.getController());

	const view = this.getAppComponent().getRootControl().getController().getView(); // some unsuccessfull modifications were made here. 
	const controller = view.getController() as BaseController;

	console.log("View:", view); // undefined
	console.log("Table:", table);  // undefined
	console.log("Binding Info:", table?.getBindingInfo("items"));  // undefined
	console.log("Controller:", view.getController());  // undefined

	view.setBusyIndicatorDelay(0);
	view.setBusy(true);
	debugger;

	const spreadsheetUpload = (await controller.getAppComponent().createComponent({
		usage: "spreadsheetImporter",
		async: true,
		componentData: {
			context: this,
			tableId: assetTableId,
			skipColumnsCheck: true,
		},
	})) as Component;

	spreadsheetUpload.openSpreadsheetUploadDialog();
	view.setBusy(false);
}

I think basiclly this is because i have an associations.
The ObjectPage is in kind of fc. fc has an assocaiation to asset. I want an excelupload into asset.

   ```
 $Type : 'UI.CollectionFacet',
        Label : '{i18n>maintainAssets}',
        ID    : 'i18nMaintainAssets',
        Facets: [{
            $Type : 'UI.ReferenceFacet',
            Target: 'assets/@UI.LineItem#MaintainAssets',
        }],
        ```

Can you use the importer with something like that?

I found in the documentation the bindingCustom option but until now i didnt manage to tell the "right binding".

in the docu it gives an example like:
bindingCustom: this.getView().byId("ui.v4.ordersv4fe::OrdersList--fe::table::Orders::LineItem-innerTable").getBinding("items")

If i do this similar (with my tableId), then

this.getView().byId(assetTableId).getBinding("rows")
VM377:1 Uncaught TypeError: this.getView is not a function
    at eval (eval at openSpreadsheetUploadDialog (ExcelUpload.ts:12:2), <anonymous>:1:6)
    at n.openSpreadsheetUploadDialog (ExcelUpload.ts:12:2)
    at FPMHelper.ts:33:14
    at ui5loader-dbg.js:2163:18

and with

this.byId(assetTableId).getBinding("rows"); => undefined

im Using a "grid table" so i changed from "items" (example) into "rows". But stil i got undefined

Any help will be much appreciated!

[marianfoo]

Can you please post the complete metadata.xml?
If it contains sensitive information you can send it to me via [email protected]
With the metadata i can hopefully recreate the problem.

[Tristan-bash]

Hi Marian,
thanks for your response. Im using SAP CAP with Fiori Elements. I didn't found an metadata.xml? Have you an hint where i can find it or similar file?

[Tristan-bash]

I was able to debug it and get it working :) .
The problem was that the tableId I provided was of a mdc-table (sap.ui.mdc.Table).
And for that case the binding was undefined since your checking only on

      if (tableObject.getMetadata().getName() === "sap.m.Table" || tableObject.getMetadata().getName() === "sap.m.List") {
        return tableObject.getBinding("items");
      }
      if (tableObject.getMetadata().getName() === "sap.ui.table.Table") {
        return tableObject.getBinding("rows");

I provided now the ui.table and it works :)

[marianfoo]

thank you for debugging! I may need to improve the error message then, I'll create a issue for this