Anyone else having problems submitting the 2017 data to the bureau?

We are getting edits that don't show on the scrub, but when we try to submit thru the portal
it saying there are problems.

We submitted to HMDA help or problem and after two days they want to see our screen shots
of what the system is telling us. This is what we said we are getting errors about:

For line 1, there is no table indicating the specific type of formatting error and the related fields impacted by the error.

For "applicant income" the field is filled in with "NA."

For "rate spread" the field is filled in with "NA."

I just tried to submit and the only error I got was one formatting error:

LAR Errors
Formatting errors in loan application records, arranged by row.
Row Errors
257 Census Tract is not numeric or NA

The census tract for row 257 is 0014.02. It is entered as '0014.02 (with the single parentheses). I've reentered the data twice and resubmitted twice and still got the formatting error. I sent an email to HMDA Help.

Thanks Dan. I'm sure there is still some de-bugging that has to be done.

We really need some time to come up to speed on these new procedures. Would have been really
nice if they simply delayed this overhaul of HMDA until next year. Thanks again.

Oh, Dan we have had snow here twice in the deep south! What fun, except for the flu bug and cold
bug hitting us hard.

When counting rows do not include the informational rows. Row 257 was actually row 260 in the spreadsheet. Once the proper row was identified I had an extra period in the census tract number.

My data has now been filed and accepted.

Thanks Dan. That appears to be the problem. We are correcting it now.

Your help has been an absolute blessing. Thank you again.

Here's a follow-up email they sent me.

For reference, the edits in the HMDA Platform count the rows based on the .txt file and consider the transmittal sheet row as row 1. If you're using the LAR Formatting Tool to create the .txt file, you would need to add 3 to the row number from the HMDA Platform to identify the row in the excel sheet, since rows 1, 2 and 4 are deleted when the .txt file is created.

We are four days into the process and still cannot get our data submitted. HMDA Help replied stating that there was an issue they fixed yesterday and asked us to resubmit. After attempting today we are still not able to submit, the signature box and submit button are grayed out. Anyone else having these issues?

I also had that issue, here is the response that I received from HMDA help:

Thank you for letting us know about this issue.

We recognize there was an issue causing that error message to be displayed in the HMDA Platform for certain file uploads. In many cases, there were edits present in the file, but they were not appearing on the screen as the user navigated through the submission steps.

We implemented a fix for the issue. Please re-upload your file and proceed through the submission steps. Please let us know if you encounter any further issues.

Best,
HMDA Help

I uploaded a public LAR and then found out from my vendor I need to upload a detailed LAR instead. It passed the format checking tool just fine...but for some odd reason the original file I upload and got bad format on every single line, won't go away...it's sticking in the system even though I'm telling it to accept a new file.

How freaking frustrating!!

Two hours later....it finally cleared and went through.

I was able to successfully upload our LAR on the HMDA Platform yesterday.

Took a handful of attempts.

I kept getting "syntactical and validity edits" which were legitimate formatting changes I needed to correct for certain columns of data. I apparently didn't pay attention to some of the formatting requirements for certain fields of data.

After correcting the formatting errors, the HMDA Platform moved me past the syntactical and validity edits and on to the quality and macro quality edits which were verified without issue.

Proceeded to the submission step and completed that without issue. I received a HMDA Filing Summary on the screen indicating the completion of the submission. I did not receive any kind of e-mail notification or acknowledgement indicating the successful submission or acknowledging receipt of the submission. Is that necessary with the HMDA Platform? Not sure, but I've grown to expect e-mail notifications from HMDAHELP on HMDA submissions.

All in all, it took about an hour to complete. I attribute that to my failure to fully prepare for and understand the specific formatting requirements for certain fields of data. I suspect if I had prepared the LAR with all the data in their proper format, I may have breezed through the syntactical and validity edits. In either case, that first step appears to do what it's intended to do... catch the syntactical and validity errors forcing you to correct.

Thanks everyone, we finally ...after 4 days... got everything submitted. This was a very frustrating process. Every step seemed to take a day each. I just printed out the receipt # for proving submission.

Maybe waiting to let others work the bugs out helps. Mine just went through very easily uploading from QuestSoft.

Same here. We uploaded last Friday using QuestSoft, and it was almost as easy as it was before when we filed with the FRB.

Mine was actually much easier than in the past!

I am having formatting issues, and mine also went through the initial File Format Verification Tool just fine. Every time I push the button too Create the LAR I have to contact our IT and they have too go through it because it's saying the file is corrupted, and IT says this is something we can't fix right now, so he has too copy and paste too a new excel sheet before I submit.

Now the next issue, which is giving me massive headaches!!! I am getting a Syntactical 040 error, which at Git Hub it states that it is a duplicating error. Well, none of my entries are duplicated, so I thought....the issue is our denial and w/d's.
Example:
l.o. MB has a denial on Jan.1, 2017 with applicant requesting $50,000 of credit, well we number this HMDA entry as MB010117-50. Then on April 3, l.o. MB has a denial requesting $125, and this denial is numbered as MB040317-125...so you can see where I am going with this.

My question is does anyone have a solution as too how I can re number our denials and w/d's? I thought about going through and numbering them beginning with 1, 2, 3, so on and so on, but the system will find my LAR as duplicating again because in the 20's those will all start with a 2, then when I get to the 30's, those will start with a 3, etc., etc.

I am going crazy! Does anyone have any suggestions? Please......

I don't see how the numbers you show above as being any where near duplications. They are very different!

Our numbers all start with a 1 or a branch number, depending on single pay vs amortized and I don't have that issue.

I know, I didn't think the system would pull them as being duplicated because the whole loan/application number aren't the same but I thought maybe it's because of the loan officers initials at the beginning of the number is being duplicated. Because each month the same loan officers are going to have deials and w/d's.

I'm literally stressing so badly and just don't know what to do to fix it

Curiously, can you use hyphens? I think the ULI has to be alphanumeric only. Maybe that's causing an issue?

(B) Follows the LEI with up to 23 additional characters to identify the covered loan or application, which:

(1) May be letters, numerals, or a combination of letters and numerals;

Therefore, the final rule does not permit the use of symbols,
as in proposed § 1003.4(a)(1)(i)(B)(1).

Hoping to submit by Friday. Any advice? TIA!

Ya, that's what I'm thinking, so I'm going in and numbering them, so they will start with a number instead of the letter of the l.o.'s initials. I'm hoping that fixes it.....

Catm, the letters aren't the problem. The hyphen is.

Anyone experiencing firewall issues internally once you log into the portal? I can access it fine from my home computer.