WebDNA - UNIX Shell program request

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59325
interpreted = N
texte = I am looking for some UNIX experience. BUSINESS CASE: We run VoteWashington.Org, Washington State's county election management service. OSX, WebCat 6, MySQL We receive an ascii file in fixed length format from a major county directly out of their ballot counting equipment with precinct level vote data; 28000 lines of data that needs to be parsed into a SQL table. The client cannot reprogram the file output to include any delimiters - limitations of the software in the elections equipment. It s not acceptable to ask the client to intervene in the process to do this manually on election night. They upload the file, and begin a process whereby the file is parsed into usable form and read into tables. It is lengthy - according to what I understand (a relative beginner with SQL), SQL cannot automatically parse in a LOAD INTO FILE command a fixed-length file. I have a routine that does the parsing, but am looking for a more efficient manner of processing the file. OPPORTUNITY: If anyone out there has experience with UNIX and OSX, I am wondering if a shell script can be written and run from the WedDNA SHELL context to parse the file at the OS level, inserting delimeters. The LOAD INTO FILE could then be used without the following parsing routine. I am willing to pay for a successful implementation of this, or something like it that resolves the issue of the long parsing routine. If anybody is interested in discussing this offline, please email me directly. I can share the sample file with you, and give you some more particulars about this issue. TIA LArry Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. UPDATE - WebDNA - UNIX Shell program request ( Larry Hewitt 2004)
  2. WebDNA - UNIX Shell program request ( Larry Hewitt 2004)
I am looking for some UNIX experience. BUSINESS CASE: We run VoteWashington.Org, Washington State's county election management service. OSX, WebCat 6, MySQL We receive an ascii file in fixed length format from a major county directly out of their ballot counting equipment with precinct level vote data; 28000 lines of data that needs to be parsed into a SQL table. The client cannot reprogram the file output to include any delimiters - limitations of the software in the elections equipment. It s not acceptable to ask the client to intervene in the process to do this manually on election night. They upload the file, and begin a process whereby the file is parsed into usable form and read into tables. It is lengthy - according to what I understand (a relative beginner with SQL), SQL cannot automatically parse in a LOAD INTO FILE command a fixed-length file. I have a routine that does the parsing, but am looking for a more efficient manner of processing the file. OPPORTUNITY: If anyone out there has experience with UNIX and OSX, I am wondering if a shell script can be written and run from the WedDNA SHELL context to parse the file at the OS level, inserting delimeters. The LOAD INTO FILE could then be used without the following parsing routine. I am willing to pay for a successful implementation of this, or something like it that resolves the issue of the long parsing routine. If anybody is interested in discussing this offline, please email me directly. I can share the sample file with you, and give you some more particulars about this issue. TIA LArry Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Larry Hewitt

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

searches with dash, period etc. (back form politeness) (2000) FW: About that math question ... (2003) beta 6 on OSX wierdness (2000) WAY Off-Topic (2004) Wanted: More Math Functions (or, Can You Solve This?) (1997) WCS Newbie question (1997) Preventing Merchant Settling ? (1997) WebCatalog 4.0 has been released! (2000) WebCatalog in the search engines (2001) proper username/password *w/out* the authenticate dialog. (2000) Multiple Search Fields (1998) 5.0 Preview Promotion Extension (2003) Template Encryption (1998) Kaaaaahhhhhhhnnnnnnn! (1997) RE: Emailer prefs in two places ... (1997) Q: for those who use Cookies for sessions? (2004) [sendmail] on NT? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Emailer 550 (solved!) (2000) Writefile doesn't work, which permissions to use? (2005)