#261 CSV import doesn't recognize dates

[J. B.]

First off, I tried to enter my question in the support forum (http://www.codelathe.com/forum/index.php) but it wouldn't let me register.

I am trying unsuccessfully to import a CSV file from my bank.

The MMEX and bank formats seem incompatible, so I wrote a Java program to reformat the CSV file before I import it.

I have almost completely succeeded, but the date recorded for each transaction is "12/31/1969".

I have read the docs and the date and csv related questions on the forum. I have changed my regionalization date formats, the MMEX formats (default and on the import page) and the bank date formats to all match, and I've tried several different formats.

The data imports correctly, it is only the dates that are messed up.

The input CSV looks like this:

"8607", 12/16/2013, "WITHDRAW", "Verizon Wireless", -76.20, 0, "0.00", 0, "VERIZON WIRELESSBILL PAYMT - 8607",

The MMEX import format is: DC, date, DC, payee, amount(+/-), DC, DC, trans#, notes (and the date format matches both the CSV file format and the MMEX format).

In the preview panel and in the successfully loaded account table, the imported date appears as "12/31/1969".

Since I have a conversion program, I can format the date any way that will work. In my regionalization setting is usually have the format as yyyy/mm/dd but I even changed that to match, just in case (I saw a note about regionalization settings in Linux).

Oh, and I'm running Windows 7 64-bit.

If you are interested in troubleshooting this, I'll be happy to provide any information you ask for, because so far I really like MMEX (and I've tried many different programs) and I'd really like to get this to work, but there's just TOO many transactions in my accounts to do this manually.

Thanks for you help!

Jim

[J. B.]

Gah! I went back and pored over the MMEX export format, and on a hunch, tried removing the spaces between the fields, and voila!

I've never seen CSV handling hampered by leading and trailing spaces, but that just shows you can't take anything for granted.

Sorry for the extraneous bug report.

Now if I can just get registered in the forum...

[Nikolay]

What is the problem with the forum registration?

[J. B.]

I just tried it again to make sure and it still won't let me register.

When I go to this page...

http://www.codelathe.com/forum/ucp.php?mode=register

I fill in all the fields, but it comes back with the message:

"You have provided an invalid answer to the question."

After about five tries, it locks up and won't let me try again.

I tried changing all the fields to obviously illegal things and was able to get it to complain specifically about each in turn, but when I go back to my desired values, I get that message, but no more detail.

For example, when I enter a password that is too short, I get this message:

"The password you entered is too short.
The password confirmation you entered is too short.
You have provided an invalid answer to the question."

But after it appears I answered everything correctly, it only gives me that vague failure message.

I wondered if it could be the username I selected, but I tried several unlikely values for that as well, and still got the same message.

I'm good for now. I was finally able to coax my bank's CSV into MMEX, so now the hard part starts - sticking with it!

So far, I'm quite satisfied.

Jim

[Nikolay]

Just fixed an answer (--=@(_)@=--) on the forum registration page. Please try again.