Page 1 of 1

csv import - what am i missing?

Posted: Fri Aug 28, 2015 9:46 am
by jdbeck
Nikolay,

I can not seem to understand what is wrong with my csv import.
I keep getting the error message that date, amount or type is missing.

Line: 1 One of the following fields: Date, Amount, Type is missing, skipping
Line: 2 One of the following fields: Date, Amount, Type is missing, skipping


My bank only gives me the following fields:
Date
Payee (or number)
Amount as $250.00 or ($250.00)
Balance.

their data :

1/30/2015,Check Card: FOOD LION #1549 CRESAPTOWN MD  01/29/15%% Card 15 #4909,($141.79)
1/29/2015,CHECK #6754,($250.00)


How can I adapt their file to import?

Thank you!

Jeff

Re: csv import - what am i missing?

Posted: Fri Aug 28, 2015 11:05 am
by Nikolay
Hi Jeff,

I think the problem with amount field.
Should be digital value like 250.00 but not ($250.00)

Best regards,
Nikolay

Re: csv import - what am i missing?

Posted: Fri Aug 31, 2018 4:30 pm
by latedev
I have a similar problem and no matter how I change it around I really don't understand what it is asking for.

What is Type ? as this is not any field shown.

My own bank send a csv in the following format

"date","postedDate","amount","description","recurringPayment","originalCurrencyAmount","conversionRate","type","currency","merchant.name","merchant.town","merchant.postcode"

I thought by editing the file into in and out files, the way they show currency is in 2 columns, so inputting this into a spreadsheet, editing the file as 2 separate files then importing them should solve that issue.

In mmex I use date, amount payee but still get the usual Line: 1One of the following fields: Date, Amount, Type is missing, skipping etc for all lines.

MMEX Version 1.3.3 db 0.7

Re: csv import - what am i missing?

Posted: Sat Sep 01, 2018 9:53 pm
by hocko
I found the best way was to import into a spreadsheet, make changes to the file and then save as CSV and then import. Best to remove characters that are not ABC or 123. eg. %