Re: [WebDNA] Limts? -and- Hot Merge

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102345
interpreted = N
texte = As far as i know, CSV is a comma delimited format. I never tried it, but if you check http://docs.webdna.us/ > "File Format" > "Databases", WebDNA should be able to read this format without any problem? Worst case, replacing "," by "tabs" should do it. - chris On Apr 4, 2009, at 13:28, Psi Prime, Matthew A Perosi wrote: > Yes, the ability to read CVS or TDF. > The docs say that WebDNA can read a CSV and it will convert it to a > TDF automatically. > But in all my testing I could not get it to work. > I dug through the archives and seem to remember finding someone else > with the problem years ago. > > I allow customers to upload their inventory lists, most of those > lists are in CSV. > I try to merge those lists into their existing product databases. > As it is right now I have to go through a very long process to > convert the CSV line by line, and I have a process that reads > through the entire line splitting out each field according to the > character combination "," The process is unbelievably long. > > I have to limit the size of the upload because sometimes the [span] > that does the merge routine will get too big and die. > > Bottom line is that I could not even get the example from the docs > to work for the CSV formats. >>> >>> Now, can someone tell me how to use the supposed built in feature >>> that converts CSV files into TAB tables? Because if I could get >>> that feature working my life would be easier too! >> >> Not sure what you mean.. are you talking about WebDNA's ability to >> read "WebDNA Databases" in either CSV or TDF formats? >> > > Matthew A Perosi JewelerWebsites.com > ------------------------------by Psi Prime------- > Senior Web Developer 323 Union Blvd. > Totowa, NJ 07512 > Pre-Sales: 888.872.0274 > Service: 973.413.8213 > Training: 973.413.8214 > Fax: 973.413.8217 > > http://www.jewelerwebsites.com > http://en.wikipedia.org/wiki/Psi_Prime%2C_Inc > http://www.psiprime.com > >> >> > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Limts? -and- Hot Merge ("Psi Prime, Matthew A Perosi " 2009)
  2. Re: [WebDNA] Limts? -and- Hot Merge (Donovan Brooke 2009)
  3. Re: [WebDNA] Limts? -and- Hot Merge (christophe.billiottet@webdna.us 2009)
  4. Re: [WebDNA] Limts? -and- Hot Merge ("Psi Prime, Matthew A Perosi " 2009)
  5. Re: [WebDNA] Limts? -and- Hot Merge (Donovan Brooke 2009)
  6. Re: [WebDNA] Limts? -and- Hot Merge ("Psi Prime, Matthew A Perosi " 2009)
  7. Re: [WebDNA] Limts? -and- Hot Merge (christophe.billiottet@webdna.us 2009)
  8. [WebDNA] Limts? -and- Hot Merge (Donovan Brooke 2009)
As far as i know, CSV is a comma delimited format. I never tried it, but if you check http://docs.webdna.us/ > "File Format" > "Databases", WebDNA should be able to read this format without any problem? Worst case, replacing "," by "tabs" should do it. - chris On Apr 4, 2009, at 13:28, Psi Prime, Matthew A Perosi wrote: > Yes, the ability to read CVS or TDF. > The docs say that WebDNA can read a CSV and it will convert it to a > TDF automatically. > But in all my testing I could not get it to work. > I dug through the archives and seem to remember finding someone else > with the problem years ago. > > I allow customers to upload their inventory lists, most of those > lists are in CSV. > I try to merge those lists into their existing product databases. > As it is right now I have to go through a very long process to > convert the CSV line by line, and I have a process that reads > through the entire line splitting out each field according to the > character combination "," The process is unbelievably long. > > I have to limit the size of the upload because sometimes the [span] > that does the merge routine will get too big and die. > > Bottom line is that I could not even get the example from the docs > to work for the CSV formats. >>> >>> Now, can someone tell me how to use the supposed built in feature >>> that converts CSV files into TAB tables? Because if I could get >>> that feature working my life would be easier too! >> >> Not sure what you mean.. are you talking about WebDNA's ability to >> read "WebDNA Databases" in either CSV or TDF formats? >> > > Matthew A Perosi JewelerWebsites.com > ------------------------------by Psi Prime------- > Senior Web Developer 323 Union Blvd. > Totowa, NJ 07512 > Pre-Sales: 888.872.0274 > Service: 973.413.8213 > Training: 973.413.8214 > Fax: 973.413.8217 > > http://www.jewelerwebsites.com > http://en.wikipedia.org/wiki/Psi_Prime%2C_Inc > http://www.psiprime.com > >> >> > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ christophe.billiottet@webdna.us

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:

Cart questions (1997) WebCat2: Master Counter snippet (1997) Emailer (WebCat2) (1997) [showif] not working (2003) How is it done? (1998) Friendly , quick 'security' check, please (2003) E-mail formating question (1999) Was cart limit-- Limits (2002) [append] and SSL (1997) Problems reading files created by WC (1997) Error handling for accountNum (1997) RePost: NAT and the CART (1999) Changing price for a SLU based on options (size, etc.) (1997) color and size options (1997) Nested tags count question (1997) upgrade? (1997) Attn: Bug in GeneralStore example b15 (1997) Banners (1997) [OT] will work for... (2003) wrong authentication (1998)