csv import - what am i missing?

Page 1 of 1
4 posts
csv import - what am i missing?

jdbeck
New MMEX User

Posts: 1
Joined: Fri Aug 28, 2015 3:11 am
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?

Nikolay
MMEX Developer

Posts: 2262
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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?

latedev
New MMEX User

Posts: 19
Joined: Sun Mar 05, 2017 6:53 pm
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?

hocko
New MMEX User

Posts: 8
Joined: Sat Oct 24, 2015 5:04 pm
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. %
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests