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, MySQLWe 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.TIALArryLarry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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:
I am looking for some UNIX experience.BUSINESS CASE:We run VoteWashington.Org, Washington State's county election management service. OSX, WebCat 6, MySQLWe 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.TIALArryLarry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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)