News for hackers. Stuff that matters.
Re:How ACH works: A developer perspective (2014) by marktangotango on Thursday August 24, 2017 @10:24PM (#15095670)
Funnily, you're complaining about csv formatting, guess you never worked with ACH formatting. It's cobol fixed length files. I implemented parsing/creation for this file format at two different companies. Hired on at one company, first day, my manager said, "hey, you have experience with ACH right? we have this project...". That's when you learn to start leaving stuff off your resume.
Re:How ACH works: A developer perspective (2014) by bct on Thursday August 24, 2017 @11:24PM (#15095879)
You can do a lot worse than ACH. It's hard to read, but it's simple and pretty well-defined.

What _really_ sucks is one-off fixed-width formats that aren't well defined, or that change suddenly (oh, you thought that field would always be populated? lol no.)

Re:How ACH works: A developer perspective (2014) by HillRat on Friday August 25, 2017 @12:03AM (#15096022)
Yeah, ACH is surprisingly not-unpleasant, at least relative to nightmares like X12 EDI with its implicit looping constructs and billions of companion guides that supercede random parts of the base spec.
Re:How ACH works: A developer perspective (2014) by sixdimensional on Friday August 25, 2017 @12:29AM (#15096127)
X12 EDI, been there earned the badge, both on the generating and receiving sides. 837, 834, 835 and others in health care - fun! Positional format, with situational meaning... really it is a fascinating format.
Re:How ACH works: A developer perspective (2014) by 20after4 on Friday August 25, 2017 @01:36AM (#15096350)
Don't you mean nightmare format?
Re:How ACH works: A developer perspective (2014) by eric_h on Friday August 25, 2017 @12:37PM (#15099835)
Nightmares can be fascinating
Re:How ACH works: A developer perspective (2014) by pg_is_a_butt on Friday August 25, 2017 @01:07AM (#15096256)
i wrote the X12 EDI stuff for a major clearwater distributor... also wrote the ACH stuff that dumped someone a file and their job was to upload it via SFTP to the bank. so many badges.
Re:How ACH works: A developer perspective (2014) by oddsignals on Friday August 25, 2017 @04:01AM (#15096919)
What _really really_ sucks is well-defined, reasonable, meticulously documented formats where all in-the-wild implementations stray from the spec in different ways :-/
Re:How ACH works: A developer perspective (2014) by tonyedgecombe on Friday August 25, 2017 @03:39AM (#15096850)
Years ago I worked with a product that parsed line printer data, it was a nightmare trying to get every piece of optional data into the reports.
Re:How ACH works: A developer perspective (2014) by paulie_a on Friday August 25, 2017 @12:05AM (#15096037)
Previously I had no experience with ACH but my current project is essentially reverse engineering a very proprietary version of NACHA and another file that is 400 fields long. Honestly the current parser does work but I can only assume due to some black magic or other voodoo.
Re:How ACH works: A developer perspective (2014) by dmlittle on Friday August 25, 2017 @01:05AM (#15096247)
Every time someone complains about file formats I bring up a similar story. It's hard to believe fixed width files are still being used today. Parsing these kind of files with 45 million records, each 600+ bytes is a huge pain. I chuckle when I think about the first time I dealt with these files and thought I could open them in an editor...
Re:How ACH works: A developer perspective (2014) by DaiPlusPlus on Friday August 25, 2017 @02:28AM (#15096562)
> It's hard to believe fixed width files are still being used today. Parsing these kind of files with 45 million records, each 600+ bytes is a huge pain. I chuckle when I think about the first time I dealt with these files and thought I could open them in an editor...

Depending on the business-application, fixed-width formats are fantastic because they allow for genuine O(1) random-access to records without needing to precompute an index first. Writing parsers for fixed-width formats is also much simpler, for example, because it eliminates ambiguity around null-terminators vs length-prefix in text/string/array data - for resource-constrained environments it's great because you can guarantee you won't need to dynamically-allocate buffers. I feel the only real arguments against fixed-width records are concerned with wasted space - which are mitigated if your system lets you compress them somehow - because they'll typically compress very, very well.

Re:How ACH works: A developer perspective (2014) by krylon on Friday August 25, 2017 @04:11AM (#15096954)
> I feel the only real arguments against fixed-width records are concerned with wasted space

Sometimes, fields can turn out to be too short. I have received a few letters from business with my last name truncated, because somebody way back when decided eight or nine characters are definitely enough for a surname.

Re:How ACH works: A developer perspective (2014) by marktangotango on Friday August 25, 2017 @06:01AM (#15097300)
Ha! I wrote an editor for fixed length files, it lets you map to a cobol copybook, or create the layout manually. I never released it. Anyone interested?
Re:How ACH works: A developer perspective (2014) by wolfgang42 on Friday August 25, 2017 @12:02PM (#15099452)
If it works on Windows, I'd love to give it a try! Our ERP system is written in COBOL and I have to deal with fixed-width files all the time. Does it also handle REDEFINES and level 88?
Re:How ACH works: A developer perspective (2014) by marktangotango on Friday August 25, 2017 @02:06PM (#15100754)
Yes it handles redefines and 88s, my emails in my profile, I have a Windows build.
Re:How ACH works: A developer perspective (2014) by nvahalik on Thursday August 24, 2017 @10:51PM (#15095773)
NACHA cha cha cha!!
Re:How ACH works: A developer perspective (2014) by labster on Thursday August 24, 2017 @11:00PM (#15095803)
You can't spell Atlach-Nacha without ACH.