I'm trying to import data from excel .
I'm searching for a simple method but i can't found it .
*This post is locked for comments
My best guess is that you are using not a template that should have been exported first and then filled and imported, but you just use some similar template.
The first thing that i'm doing is :configuration worksheet->i choose customer then i export to template -> i fill the excel file -> i selected customer and i click on import from template.
Do you have all required fields filled?
yes i fill all required fields . the first thing that i tried is adding a single line in excel file and the second method i tried to extract all the data that exists in customer and i added a line in the final of the excel file but these 2 methodes don't worked and the same error appears.
Hi,
To me its not clear, do you want to import using configuration worksheet or you want to use Excel Buffer to import data?
i tested on payment terms which the id table is 3 and the import of data is done .
so maybe the problem in customer is that the data that i added should be also exist in the relation table first .
Yes that is true.
IN Configuration package, when you select a table say 18.
In Tables action, From Function Menu you can select the option to load get related tables.
All related tables to customer will be added automatically to the list.
Also all the related tables to the customer should import their related tables this is the solution because when you click to get the related tables dynamics get just the tables that the customer is related to them directly and these tables also have an other table which they conneted to it .
Now the import works correctly.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
