topic Re: "Not as many fields as field headers" Import CSV file in ArcGIS Workforce Questions

"Not as many fields as field headers" Import CSV file

SharitaU — Tue, 07 Jun 2022 16:54:01 GMT

Hi all,

I'm trying to import a very simple CSV file of workers in Workforce. When I try to import my CSV which has the same headers as the template CSV file, or even when I try to add new rows to the template CSV file, I get an error that says "Not as many fields as field headers". Has anyone had this problem before/can anyone give me feedback.

Here's a screenshot of the csv I have tried to upload

Thank you all!

Re: "Not as many fields as field headers" Import CSV file

julian_svcs — Tue, 07 Jun 2022 17:21:46 GMT

I would say it is because of the comma in the Truck Driver, Night Shift cell. A CSV by default uses commas to separate the columns. The comma in this cell is causing is to split into another column, thereby creating another column for that row.

You would need to add double quotation marks to escape the comma so it would look like this:

"Truck Driver, Night Shift"

Re: "Not as many fields as field headers" Import CSV file

SharitaU — Tue, 07 Jun 2022 17:30:13 GMT

Greetings,

The first two rows actually came with the sample template. I did however try to delete the comma and still got the same error unfortunately. Although I am able to reupload their exact template with no errors but that ruins the point of using a csv to upload workers if I can't actually add workers.

Re: "Not as many fields as field headers" Import CSV file

julian_svcs — Tue, 07 Jun 2022 17:42:34 GMT

Would you be able to share your CSV file? I can have a quick look.

Re: "Not as many fields as field headers" Import CSV file

SharitaU — Tue, 07 Jun 2022 19:04:53 GMT

Re: "Not as many fields as field headers" Import CSV file

julian_svcs — Tue, 07 Jun 2022 20:21:06 GMT

Thanks for the file.

The error does not match what is the issue. The issue is the empty last line in the CSV file. Remove that empty row and you will be able to import the CSV file to add the users.

Re: "Not as many fields as field headers" Import CSV file

ISDEsriNeA — Tue, 09 Aug 2022 16:51:22 GMT

@julian_svcs i tried this solution, but it still not working, any other recommendation?

Re: "Not as many fields as field headers" Import CSV file

julian_svcs — Tue, 09 Aug 2022 17:53:47 GMT

@ISDEsriNeA Can you make you CSV file available so I can see what the issue could be. Thanks

Re: "Not as many fields as field headers" Import CSV file

CraigGillgrass — Wed, 10 Aug 2022 13:56:31 GMT

@ISDEsriNeA @SharitaU the issue is as @julian_svcs mentions, there is a trailing empty row in the csv file - this is bug in the template that we've addressed but older versions of the template file still exist.

Removing the trailing empty line will address the issue and allow the import verification to proceed. I've attached an edited version of the csv that @SharitaU first posted.

@ISDEsriNeA when you mention it is still not working, can you clarify? Does it fail with an error and if so, what is that? As @julian_svcs mentions, if you can, uploading the csv will help to quickly diagnose the issue.

Re: "Not as many fields as field headers" Import CSV file

OznurGeze — Thu, 11 Aug 2022 12:04:45 GMT

Hi,

@CraigGillgrass I tried the data updated version you shared. Still same error.

Re: "Not as many fields as field headers" Import CSV file

CraigGillgrass — Thu, 11 Aug 2022 13:17:06 GMT

Are you using Online or Enterprise? If Enterprise, which release? @OznurGeze

Re: "Not as many fields as field headers" Import CSV file

OznurGeze — Thu, 11 Aug 2022 13:39:42 GMT

Im using Online. @CraigGillgrass

Re: "Not as many fields as field headers" Import CSV file

CraigGillgrass — Thu, 11 Aug 2022 13:44:11 GMT

@OznurGeze thank you. I just tried to upload the csv into a Workforce project I have in Online and it succeeds, I do not see the error you mention. Wonder if this is browser/OS specific possibly. I'm using Chrome on Mac, what browser and OS are you using?

Re: "Not as many fields as field headers" Import CSV file

OznurGeze — Thu, 11 Aug 2022 13:51:23 GMT

Mine is Chrome on Windows10. But when you pointed if it is a browser issue, I tried Microsoft Edge, too. Same error again. Thank you for your concern by the way. 🙂 @CraigGillgrass

Re: "Not as many fields as field headers" Import CSV file

CraigGillgrass — Thu, 11 Aug 2022 13:58:32 GMT

I've also tried with Chrome on Windows10 and the upload succeeds for me. Let's move to a DM so I can ask more specific questions, I'll send a message.

Re: "Not as many fields as field headers" Import CSV file

CraigGillgrass — Thu, 11 Aug 2022 15:18:07 GMT

Closing the loop from the DM with @OznurGeze ; opening the csv in Excel can insert an empty row at the bottom of the file. By using Notepad (for Windows) this is avoided and the csv can be uploaded.

Re: "Not as many fields as field headers" Import CSV file

CharlescobBailey — Wed, 16 Nov 2022 19:54:12 GMT

I tried this and it didn't make any difference. I copied the cells to a new sheet and saved it as a csv also. Nothing works. THanks.

Re: "Not as many fields as field headers" Import CSV file

julian_svcs — Wed, 16 Nov 2022 19:58:47 GMT

@CharlescobBailey are you using Excel (or similar) to edit your CSV file? If so, for the final edit, option the CSV file in a text editor (I use Notepad++) and remove the last empty line. Save the CSV then try again.

If you are able to share your CSV file I can have a quick look at it.

Re: "Not as many fields as field headers" Import CSV file

CharlescobBailey — Wed, 16 Nov 2022 20:22:32 GMT

Well I thought that was going to work, thanks for clarifying about removing the line. It appeared to upload with a few exceptions that were understandable. But when I went to add, got this message

I can't share the csv, it contains private emails. Thanks for your quick response. cob

Re: "Not as many fields as field headers" Import CSV file

CharlescobBailey — Wed, 16 Nov 2022 20:30:00 GMT

Actually never mind, I somehow got logged into another account - success! Thanks again for your timely help = cob