MickeyM Posted April 17, 2022 Share Posted April 17, 2022 When clicked on the CSV Import wizard, the click to assign function does not produce any drop downs to assign the csv headers to the EA data fields. It did once but did not import any data. Now it won't do anything at all with the csv file. Link to comment Share on other sites More sharing options...
YS LI Posted April 24, 2022 Share Posted April 24, 2022 1) Yes , I 'd the almost same problem. A little lucker than you is that some of my data can be transfered, it was transaction date, but the others, nothing. 2) I 'd read the online help again and realized that key role of " assign function" is to build up a so call - "matched " link - between your csv data and express account formatted data base. The reason you didn't get any data is because the " matached link " didn't build up successfully. 3) To to that, I decided to give my data a proper title at top of each coloum in my CSV file, delete any empty rows between the title row and data rows, and click the save button (not the save as)this csv file again, and close it. 4) After that I tried to do the assignment again. The good thing is datas can be inputed now , but bad thing is data are wrong or in wrong place. 5) I had tried assign my data titles to "Date, Memo,Amount,Deposit, Paymen " individually many times, finally I found one of them works well. Bank data was transfered into my EA, all the transaction date and amount are correct. There still exist some mistakes and missing data, it were not 100% as expected but good enough for me. 6 ) The reason why its not 100% perfect , I think because there are so many banks in the world, and each bank has its own format at the title area, and the express account won't recognized each of them. For example, my bank's csv file, at title area, there are only two cells has data, 1st cell's data is "Account details for:" The 2nd cell's data is my account info: "XXXbank -- number XXX" . If I didn't do any changes , when I do "bank reconcile "- only this two datas "Account details" and "XXXbank --numberXXX" will be assigned to Date, Memo,Amount,Deposit, Payment -- any one you wish to assign to. Obviously, those are wrong. Another reason is that when using excel to open csv file and save it again, some data format may be changed or lost and lead to the disorder in transfering data into EA. 7) Except your bank and EA has sit down and work together to work out a standard CSV format and work flow to let EA recognized it automatically , you won't get a 100% automate transfered result 😎 Hope my experience may help you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now