If yes, what about the Local Council or Provincial Council fonds CSVs is different from your test CSV, which you say works?
Glancing at the test CSV, it seems like you've gotten the general idea right. A couple high-level notes on importing translations:
- First, not all fields work - only the free-text fields found in the main table for descriptions, the information_object_i18n table. The supported fields are listed in the doc link above.
- Any untranslatable value such as an identifier (which is supposed to be a unique value, and therefore the same regardless of culture), a controlled term (such as an access point or a RAD GMD), a controlled date value (the start and end dates are the same regardless of culture - though I think you could add different display dates), or any part of a linked entry (such as the repository name, or your creator's name and history) should be left blank in the translation row. They will not translate via import this way, and in fact doing so may create duplicate entries on import.
- For the related entities (subject/place/genre access points, other controlled vocab terms, linked archival institution or authority records, etc), you will need to translate them from their view pages. For example, import your description so a new authority record is created. Then go to the authority record, flip the user interface to French, and translate the authority record via the user interface. Same for your access points, repository record, etc. At this time, other entities do not support translation rows via import, so this will be a more manual process.
If it seems like you're doing all that, and you are preparing the CSV in the same general way you've prepared your test CSV, then one last thing to try would be running some of the common maintenance commands (such as rebuilding the nested set, clearing the application cache, restarting PHP-FPM, and repopulating the search index). It's possible there's just a hiccup there that is affecting the display. Instructions and further links for all these tasks can be found on the Troubleshooting page:
Cheers,