Hi. I have an import scenario (attached XML) for opportunities that is tested and working perfectly for individual records. When I go to do the full import from Excel (1171 records), it only imports the first one, even if there is no error. In other words, it will import one correctly, finish running the full import (takes like 15 minutes), then says 1170 records did not import.
Can anyone tell me what I am doing wrong?
Best answer by vkumar
Hi
Please refer to our I100 certification guide and check following section on page 128. You should be able to alter the scenario and removal of unnecessary ‘Commit’ and enabling parallel processing are couple of options mentioned here.
https://training.acumatica.com/University/I100/I100_IntegrationScenarios_2024R2.pdf
Let us know if this helps improve the performance.
I do notice several ‘custom’ columns on your import. If you have a test environment, do test the import with default set of columns to compare the impact of customization on Import performance.
Hope this helps.
Regards,
Hi
Please refer to our I100 certification guide and check following section on page 128. You should be able to alter the scenario and removal of unnecessary ‘Commit’ and enabling parallel processing are couple of options mentioned here.
https://training.acumatica.com/University/I100/I100_IntegrationScenarios_2024R2.pdf
Let us know if this helps improve the performance.
I do notice several ‘custom’ columns on your import. If you have a test environment, do test the import with default set of columns to compare the impact of customization on Import performance.
Hope this helps.
Regards,
Hi
+11Hi
Please refer to the import file I attached. I have tested and imported successfully.
Best Regards,
NNT
@vkumar, I have done some testing of removing some of the custom fields, and I have had a successful run. I am still narrowing down which ones.
Thank you so much for your help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
