Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. Just how many formats can we use to represent the same data?

Just how many formats can we use to represent the same data?

Scheduled Pinned Locked Moved The Weird and The Wonderful
designsysadminxmlquestion
11 Posts 10 Posters 70 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M martin_hughes

    As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

    "It was the day before to

    P Offline
    P Offline
    Patrick Etc
    wrote on last edited by
    #2

    You know that scene in Family Guy where a store clerk sees Meg Griffin, screams, pours gasoline over herself, lights herself on fire and then jumps out the window? Yeah, I think I'd probably do that if I took one look at that app.

    1 Reply Last reply
    0
    • M martin_hughes

      As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

      "It was the day before to

      Q Offline
      Q Offline
      QuiJohn
      wrote on last edited by
      #3

      martin_hughes wrote:

      Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

      Awesome story, with the perfect punchline. :)


      Faith is a fine invention For gentlemen who see; But microscopes are prudent In an emergency! -Emily Dickinson

      1 Reply Last reply
      0
      • M martin_hughes

        As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

        "It was the day before to

        C Offline
        C Offline
        Chris Maunder
        wrote on last edited by
        #4

        You mean that's not the way you're meant to do it? Dammit. Back to the drawing board...

        cheers, Chris Maunder

        CodeProject.com : C++ MVP

        1 Reply Last reply
        0
        • M martin_hughes

          As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

          "It was the day before to

          C Offline
          C Offline
          codemunkeh
          wrote on last edited by
          #5

          Was there any sort of cleanup operation after this, or did it just sit there? And be grateful the EDI converters didn't create backups as well as the source, or maybe even some temp files for chunks too big to fit into conventional RAM because I'd imagine the system would be filled with useless file handles by now?


          Need Another Seven Acronyms...
          Confused? You will be...

          M 1 Reply Last reply
          0
          • C codemunkeh

            Was there any sort of cleanup operation after this, or did it just sit there? And be grateful the EDI converters didn't create backups as well as the source, or maybe even some temp files for chunks too big to fit into conventional RAM because I'd imagine the system would be filled with useless file handles by now?


            Need Another Seven Acronyms...
            Confused? You will be...

            M Offline
            M Offline
            martin_hughes
            wrote on last edited by
            #6

            Put it this way; every 60 days (or thereabouts) a "purge" happens...

            "It was the day before today.... I remember it like it was yesterday." -Moleman

            I 1 Reply Last reply
            0
            • M martin_hughes

              As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

              "It was the day before to

              N Offline
              N Offline
              ne0h
              wrote on last edited by
              #7

              What a story!:omg:

              -------------------------------- txtSignature

              P 1 Reply Last reply
              0
              • M martin_hughes

                Put it this way; every 60 days (or thereabouts) a "purge" happens...

                "It was the day before today.... I remember it like it was yesterday." -Moleman

                I Offline
                I Offline
                Ian Shlasko
                wrote on last edited by
                #8

                I actually covered my mouth in shock at that... This story is going to give me nightmares.

                1 Reply Last reply
                0
                • M martin_hughes

                  As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

                  "It was the day before to

                  P Offline
                  P Offline
                  pbraun
                  wrote on last edited by
                  #9

                  Isn't it fun to work with a bunch of ex-COBOL programmers ... at least I am assuming by your story that is what they used to do. Phil

                  1 Reply Last reply
                  0
                  • N ne0h

                    What a story!:omg:

                    -------------------------------- txtSignature

                    P Offline
                    P Offline
                    Paul Conrad
                    wrote on last edited by
                    #10

                    ne0h wrote:

                    What a story!:omg:

                    Uh huh, my thoughts exactly :)

                    "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                    1 Reply Last reply
                    0
                    • M martin_hughes

                      As those of you who have read my other horrors may have guessed, I work for a bunch of loons with a penchant for Heath Robinson design. You might think I'm being a little bit harsh, but let me justify myself by explaining the current data flow I'm looking at: 1.) Data is exported from a "legacy" Dos application, and written to a fixed width format file 2.) Legacy Win32 app picks up the data, looks at it briefly, and then writes it to another, but different!, fixed width format file 3.) Legacy Win32 app picks up the file it has just written, and wraps it in EDI - the resulting file is called blah~date.edi (where blah is a meaningful name and date is the date in yymmdd format). Note the ~. 4.) Legacy Win32 app picks up the EDI file it just created, inserts a "header" and "footer" to the file (I understand this breaks EDI conventions), and saves the file, changing alll the ~'s to +'s in the file name to show that the header and footer insertion has happened. 5.) Legacy Win32 app transfers the file to an FTP server ***For the sake of your sanity, I'm going to ommit details of the hellish "Interchange Mechanism"*** 6.) WinCE app contacts FTP server, finds work to download, and downloads and saves. 7.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 8.) Edi file is now extracted to fixed width format as seen in 2. 9.) User performs work on file. ***Again, for your sanity, I'll ommit the actual work process, and we'll go straight to the completed and sending back stage*** 10.) WinCE app picks up fixed width file and surrounds content with EDI tags and saves in the blah~date.edi format. 11.) WinCE app picks up newly created file, inserts a header and footer and saves the file replacing all the ~'s with +'s/ 12.) WinCE app transfers file to FTP server ***More nastiness ensues - look away!*** 13.) Legacy Win32 app contacts FTP server, finds file, downloads and svaes 14.) Newly downloaded file is opened, header and footer are removed and file is saved replacing all +'s with ~'s. 15.) EDI file is now extracted to a fixed width format (as seen in 2) and saved. 16.) Saved file is now opened, extraneous data removed and saved to another fixed width format as seen in 1. 17. File is presented to legacy Dos app. Do you know what they said when I suggested this was a perfect (and actually, for once, legitimate) use for XML? "XML will never take off - EDI is where it's at!"!

                      "It was the day before to

                      J Offline
                      J Offline
                      John R Shaw
                      wrote on last edited by
                      #11

                      You actually almost lost me at one point – lol. If I had not been in this business so long I might have been surprised, but the only thing that surprises me is that they gave you enough information to figure all that out. Sorry I very tired right now – but that was very entertaining. P.S. I am an old DOS guy so a time line for each step might have clarified why they did that to me (changing technology and all) – but I doubt it.

                      INTP "Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups