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
csv import - what am i missing?
Moderator: Renato
-
- New User
- Posts: 1
- Joined: Fri Aug 28, 2015 9:11 am
- Are you a spam bot?: No
-
- Developer
- Posts: 1535
- 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?
Hi Jeff,
I think the problem with amount field.
Should be digital value like 250.00 but not ($250.00)
Best regards,
Nikolay
I think the problem with amount field.
Should be digital value like 250.00 but not ($250.00)
Best regards,
Nikolay
-
- Senior User
- Posts: 23
- Joined: Mon Mar 06, 2017 12:53 am
- Are you a spam bot?: No
Re: csv import - what am i missing?
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
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
-
- New User
- Posts: 7
- Joined: Sat Oct 24, 2015 11:04 pm
- Are you a spam bot?: No
Re: csv import - what am i missing?
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. %