ArcOnline; .CVS wont import: Duplicate Field Names Not Allowed () error

[GeovannaArguelles]

Hello,

I'm trying to import a .CSV datasheet unto my dashboard and it just keeps giving me the above error. None of the field names are duplicate, they don't have any spaces or special characters. Any advice?

I've tried the below and have had no luck.

1. I made sure my headings don't have spaces (instead, they would be filled with "_").

2. I have ensured that there are no duplicate field names

3. I have tried importing directly on the dashboard and through a map and get the error in both methods.

Is there alternate way to upload my CSV or a way to get over this error ?

Thank you in advance.

[JenniferAcunto]

The error message was a red herring. ArcGIS uses the first row of data to determine the field types for each column so all of the empty values in your first row is causing issues. If i put dummy values into each of the empty cells in the first row, I'm able to upload it.

I would either rearrange your dataset so a full row is at the top, or include a dummy data row at the top and then delete it after publishing. If you do include dummy data make sure that it matches the data type for that field. For example, if it's a date field, ensure your dummy data is a date. 

[GeovannaArguelles]

Jen,

Thanks for your help. I have rearranged my dataset to include two full rows at the top. I made sure all fields were filled in according to their data type. However, I am still getting the same error.

I have attached the updated copy of my dataset. Is there something I am missing?

[JenniferAcunto · Accepted solution]

Does this one work for you, as it works for me? Note that you will want to delete the first record once it publishes. 

[GeovannaArguelles]

Yes, that one works for me as well!

I wish ArcGis was a little more specific on these errors. It makes it quite difficult to determine what it will take.

[MackKing]

I'm following this because I've got the same issue.  I don't see a difference in the two attachments structurally.  My csv also has the same error.  Can someone tell me why?

[temprobertcottreau131313]

You may need to change the name of your columns in your table.  AGOL looks at the first few characters and if these show up more than once, it's considered duplicate.  Rename them in your table and then change the names back in AGOL as you're bringing the data in