Am I right in saying that as of v13.5, the download template functionality in the Data Import tool on the WUI, uses the new, not the legacy, template format. This template can then be used to upload and import, using the same Data Import tool on the WUI.
However the bench data-import command cannot use this new template. In order to use this command you need to export the legacy template. I tried doing this via the Data Import Legacy tool (search for it in the awesome bar) but could not get it to accept my DocType. So I eventually exported the legacy template with
I just copy paste the name fields from the doctype into a csv file as headers. Add Information below it and upload. In the new version you don’t have to rely on a template. You create your own template.
Hi. Am referring to GUI upload using any CSV. Never tried Google sheets. On rare occasions have used script for backend. Have done on V12 and V13. Make sure that the field name is correct. Usually I copy field name to a text editor and then copy to csv. This removes any formatting that is inherited when copying from web page. Else paste it as plain text.