Register   Login
     
  Latest Posts  
Was create new album always in add photo?
by crocklobster on 12/02/2008 1:41 PM
JQuery Error in IE6
by rodneyjoyce on 12/02/2008 9:10 AM
RE: Language Packs?
by sschneider on 12/02/2008 8:38 AM
SUMMARY tag
by adski on 12/02/2008 7:55 AM
RE: Integration with UserProfile StoryFeed
by aviavia on 12/02/2008 7:43 AM
RE: Integration with UserProfile StoryFeed
by aviavia on 12/02/2008 7:41 AM
RE: Cache issue?
by jlatulippe on 12/02/2008 4:43 AM
RE: Cache issue?
by smcculloch on 12/02/2008 3:37 AM
RE: Cache issue?
by jlatulippe on 12/02/2008 3:35 AM
RE: Location Search
by rodneyjoyce on 12/02/2008 2:25 AM
  Forums  
Subject: Bulk Import/Export
Prev Next
You are not authorized to post a reply.

Author Messages
Chris WollesenUser is Offline
Registered Users
Nuke Newbie
Nuke Newbie
Posts:1

8/17/2005 7:51 PM  

What I'm really looking for is the ability to bulk import for a delimited file (tab probably).  Currently I'm having to clear the table and use DTS with a custom script to do this and just havign the functionality within the module would be much nicer and allow me to farm out this work to the guy actually creating the quote list.

Thanks,

Shaggy

Peter WarrenUser is Offline
Gold Membership
Nuke Addict
Nuke Addict
Posts:77

8/18/2005 3:55 AM  

I never like to clear a table while online as it will not be a nice experience for users at the time of update.  Are you on a hosted server? How many records are you talking about? How different is your data from one upload to another? Can you update/insert/delete from a subset of your data (ie preprocess some of the data to reduce the number of records uploaded.)? Can you convert the data to XML (SQL Server can load XML into a row set which can join with the database tables) before uploading.   
There may also be other options available if this is product information that you are uploading. Can you describe in more detail what you are doing so that we can get a better understanding of your requirements.  

Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12549


8/18/2005 6:46 AM  
Posted By Shaggy on 8/17/2005 7:51:50 PM

What I'm really looking for is the ability to bulk import for a delimited file (tab probably).  Currently I'm having to clear the table and use DTS with a custom script to do this and just havign the functionality within the module would be much nicer and allow me to farm out this work to the guy actually creating the quote list.

Thanks,

Shaggy


A few people have asked for bulk importing of quotes, can you put it in the feedback center?

Scott McCulloch
Site Administrator
Peter WarrenUser is Offline
Gold Membership
Nuke Addict
Nuke Addict
Posts:77

8/18/2005 7:04 AM  

Oops. Sorry, I wasn't thinking of Scott's quotes module, I thought the reference was to uploading quoting data (as in products).   Along with web development, I do a lot of product data conversion/manipulation and I misread the question,

You are not authorized to post a reply.
Forums > Modules > Quotes > Bulk Import/Export



ActiveForums 3.7