tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/74594-text-csv-import-error-from-fileimportInfinite Kind: Discussion 2022-02-03T08:50:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494703832021-11-03T16:56:30Z2021-11-03T16:56:30ZText (csv) import error from File/Import<div><p>Please post the whole Help>Console output<br>
Also, if you are willing, post the csv file with the error; or enough of it to give the error...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494703832021-11-03T17:00:36Z2021-11-03T18:48:45ZText (csv) import error from File/Import<div><p>The issue was resolved by changing the date format in the csv file. I found this by experimentation - the MD error was not informative AT ALL.</p>
<p>Edit: Issue was NOT resolved. My analysis was incorrect. I'm am still experiencing the import problem.</p></div>gpolktag:infinitekind.tenderapp.com,2009-01-14:Comment/494703832021-11-03T19:07:36Z2021-11-03T19:07:38ZText (csv) import error from File/Import<div><p>Requested files attached</p></div>gpolktag:infinitekind.tenderapp.com,2009-01-14:Comment/494703832021-11-03T20:09:43Z2021-11-03T20:09:44ZText (csv) import error from File/Import<div><p>Seems as though the problem is related to having NEW categories with sub categories in the csv file. (with colon separation)<br>
e.g. "New Category:Subcategory"<br>
It seems to me that MD has previously been able to handle this format on import and automatically add the category(s) and subcategory(s)</p></div>gpolktag:infinitekind.tenderapp.com,2009-01-14:Comment/494703832021-11-04T08:44:29Z2021-11-04T08:44:29ZText (csv) import error from File/Import<div><p>OK, it's a bug(ette)..... When you specify an account such as 'aaa:bbb' and when aaa does not exist, then it fails.... So when aaa exists, then it can create 'bbb'.... So perhaps create the top level accounts first.... Remove all second-levels, run the import, then delete all the txns, put the second-levels back, re-run the import.,,,</p></div>Stuart Beesley (Mr Toolbox)