Re: Upload Text File/ Append to DB
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 55041
interpreted = N
texte = We use several file upload procedures in various sites - most significantly our VoteWashington.Org election management system. A county uploads a text file from their back end election system, the WebDNA then processes the file, (we have to do a significant amount of conversion because the client cannot control the out. We have a series of custom procedures to generate a proper text file. Much easier with a delimited file). Basically, a multi-step process: 1.- Conduct the upload using server specific code (we use Webstar 5, OSX) 2.- The file arrives in a directory, and WebDNA highlights the file using a FileInfo context - either looking for a predetermined file name , or showing any file in the upload directory. 3.- The file name is a link that calls a process that reads the file, and appends the database. By using this approach, you can direct where the file goes, what kind of file it is, rename it, run multiple processes, or just about anything your can conceive of with the WebDNA code. Larry On Wednesday, December 17, 2003, at 02:33 PM, Clint Davis wrote: > Has anyone written code to allow customers to upload a tab-delimited > text > file whose records are appended/replaced in a specified database? > > Is this easy to accomplish with WebDNA? > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- > > > ------------------------------------------------------------- > 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 360.807.1100 OFFICE HCO, LLC 360.807.1103 FAX 1133 Kresky NE #106 360.508.6231 CELL Centralia, WA 98531 larryh@hewittco.com www.hewittco.com www.votewashington.org ------------------------------------------------------------- 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:
We use several file upload procedures in various sites - most significantly our VoteWashington.Org election management system. A county uploads a text file from their back end election system, the WebDNA then processes the file, (we have to do a significant amount of conversion because the client cannot control the out. We have a series of custom procedures to generate a proper text file. Much easier with a delimited file). Basically, a multi-step process: 1.- Conduct the upload using server specific code (we use Webstar 5, OSX) 2.- The file arrives in a directory, and WebDNA highlights the file using a FileInfo context - either looking for a predetermined file name , or showing any file in the upload directory. 3.- The file name is a link that calls a process that reads the file, and appends the database. By using this approach, you can direct where the file goes, what kind of file it is, rename it, run multiple processes, or just about anything your can conceive of with the WebDNA code. Larry On Wednesday, December 17, 2003, at 02:33 PM, Clint Davis wrote: > Has anyone written code to allow customers to upload a tab-delimited > text > file whose records are appended/replaced in a specified database? > > Is this easy to accomplish with WebDNA? > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- > > > ------------------------------------------------------------- > 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 360.807.1100 OFFICE HCO, LLC 360.807.1103 FAX 1133 Kresky NE #106 360.508.6231 CELL Centralia, WA 98531 larryh@hewittco.com www.hewittco.com www.votewashington.org ------------------------------------------------------------- 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:
Paymethod question (1999)
[OT] Mom's gift (2006)
[OT] Ecommerce Insurance (2000)
Weird Problem (1997)
[SearchString] (1998)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
Running 2 two WebCatalog.acgi's (1996)
[WriteFile] problems (1997)
WebCat2b13 Command Reference Doc error (1997)
RAM variables (1997)
emailer (1997)
I've been framed by webcatalog! Does anyone know the way out? (2000)
shipcost and Formulas.db (2000)
Transfer of data from Invoice to thank you templates (1998)
your mail (2000)
Emailer help....! (1997)
Help! WebCat2 bug (1997)
Resume Catalog ? (1997)
Problems with sql: "not supported" (2005)
Email Mac (2002)