One of my clients receives a payroll file with no header records. They can import into Quickbooks by mapping the data field to the column in the excel file. Does Acumatica allow this type of mapping? For example, Column A = Date, Column B = Amount...In the Data Provider or Import Scenario can I specify Column A = Date?
Solved
Import scenario with no header records
Best answer by Naveen Boga
Hi
In the Import Scenarios, either we need to provide the mapping using header fields or we can provide the static values, but with out header fields we can not do the mapping in Acumatica.
+20Hi
In the Import Scenarios, either we need to provide the mapping using header fields or we can provide the static values, but with out header fields we can not do the mapping in Acumatica.
Hi
I know this is an old post, but I was looking for a similar solution yesterday and found a surprisingly simple solution.
If you create a simple sample file that only contains headers, you can use this to set up the data provider. Then on each import operation, check the ‘Skip Headers’ checkbox on the ‘Details’ tab. This will then not look for a header row.
The downside is that you have to do this for every import operation, but it works. You can actually set up another data provider type that permanently ignores headers, but this requires some C# coding.
Cheers,
Ben.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.