nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

SharitaU

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

workforce erro.PNG

Thank you all!

Najděte více příspěvků označených jako

Accepted answers

cgillgrass

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.

All comments

CharlescobBailey

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

CharlescobBailey

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

JulianInskip1

@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.

CharlescobBailey

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.

cgillgrass

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.

cgillgrass

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.

OznurGeze

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

cgillgrass

@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?

OznurGeze

Im using Online. @CraigGillgrass

cgillgrass

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

OznurGeze

Hi,

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

cgillgrass

@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.

sample-worker-data updated.csv

info_button_instant_app.JPG

JulianInskip1

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

ISDEsriNeA

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

JulianInskip1

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

SharitaU

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.

JulianInskip1

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"

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.