csv import - what am i missing?

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
jdbeck
New MMEX User
Posts: 1
Joined: Fri Aug 28, 2015 9:11 am
Are you a spam bot?: No

csv import - what am i missing?

Post 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

Nikolay
MMEX Developer
Posts: 1386
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: csv import - what am i missing?

Post 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

latedev
Super MMEX User
Posts: 21
Joined: Mon Mar 06, 2017 12:53 am
Are you a spam bot?: No

Re: csv import - what am i missing?

Post 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

hocko
New MMEX User
Posts: 7
Joined: Sat Oct 24, 2015 11:04 pm
Are you a spam bot?: No

Re: csv import - what am i missing?

Post 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. %

Post Reply