Solved

Importing Information from Excel


Userlevel 4
Badge

We are needing to import data from multiple sheets in the same excel workbook. However, we have been told that all data must be on the first sheet in order pull. Has anyone else experienced this? What was your solution?  

Also, once you have hit the upload button a common settings box pops up. Does anyone know what the null value field represents? We haven’t been able to get a clear answer. 

 

Thanks in advance for any help/clarification you can provide. 

icon

Best answer by Laura02 7 July 2023, 23:07

View original

3 replies

Badge +18

Hello @mnecaise ,

Acumatica offers multiple ways to import data from Excel. The simplest method, using ‘Import from file’ button located just above the grid area of many screens, is the simplest import method and the only method that is limited to reading from the first tab of the Excel workbook. Import from File loads only one batch or document at a time.

Excel The way around using the first tab only is to import via Import Scenarios instead.

I have been importing to Acumatica for about 10 years and have never needed to use the Null Value field. Perhaps someone else can answer that part of your question.

 

Laura

Userlevel 6
Badge +3

Hi @mnecaise you can access multiple tabs the spreadsheet using your data provider:

 

 

Userlevel 7
Badge +9

The NULL value is used to replace the NULL value of the imported fields with the provided replacement value. To be honest there is no use for it or at lyi have never seen or heard someone use it.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved