There's the problem, Darryl. The product manager here wants to build it into our product. "... and you dont have to have all your employees register to use it.. you can just click one button and it'll import all their details from a spreadsheet!" ..
So it would be beginners with the product, setting up all their employees on the first day they're tinkering with the thing, and not necessarily anyone with any real IT knowledge. And - get this part - without our people present - it's supposed to be so easy to use, the user can do everything himself. !!!! HAH!!!! The rationale goes this way - we dont want to be messing about helping them get their employee records ready to enter into the system, so if we tell them to get them all into a spreadsheet, in a format we supply, then we can just import them all into our user table in one go. Somehow I dont see it happening quite that simply. Or am I being too negative here? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, 15 Mar 2005 09:05:04 +1000, Darryl Lyons <[EMAIL PROTECTED]> wrote: > Mike, > > Is this a one-off event or is this something that will ocurr over and over > again? I've found that the "Import Data" wizard in Enterprise Manager to > be quite good, but you are right, it is only as good as the data going in. > Can you import the Excel spreadsheet directly without saving to CSV format > (good for one-off event). > > CSV is pretty crap in my experience, especially if it is provided in > comma-delimited format. Can they provide you with a pipe-delimited (best) > or tab-delimited (better) format? > > Darryl Lyons > http://dangermoose.blogspot.com > > [EMAIL PROTECTED] wrote on 14/03/2005 01:48:48 PM: > > > Has anyone managed to import data into a SQLServer database through > > coldfusion from a CSV file, and do it reliably? > > > > My experience has been that anything to do with spreadsheets is > > unreliable when you come to load the records into SQLServer. But > > maybe I just havent set things up right. I find it'll assign column > > types and get it wrong, insert 20 rows then have an error, import > > dates as a numeric field, just plain omit fields. > > > > Or perhaps other people manage to import easily because they do > > something I'm not. > > > > > > What I have is an applicatoin where the client wasnt to be able to > > bulk-register lots of users from a spreadsheet instead of asking all > > fo them to fill out the registratoin form individually. > > > > At the moment I'm thinking of having him use ExcelXP and save the > > spreadsheet as XML instead of as CSV, becuase I have the feeling it'll > > be easier and/or more reliable to import the data through ColdFusion > > into SQLServer that way. > > > > Does anyone else have a view on this? > > -- > > Cheers > > Mike Kear > > Windsor, NSW, Australia > > Certified Advanced ColdFusion Developer > > AFP Webworks > > http://afpwebworks.com > > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > > --- > > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > To unsubscribe from this email please forward this email to [EMAIL PROTECTED] > > This email message is confidential and may be privileged. If you are not the > intended recipient > please forward the email to [EMAIL PROTECTED] and delete the original. > > ABN AMRO Morgans Limited and its associates hold or may hold securities in > the companies/trusts mentioned herein. > Any general advice included in this email has been prepared without taking > into account your objectives, financial situation or needs. > Before acting on the advice, you should consider its appropriateness or > discuss with one of our investment advisors. > > ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of > ASX Group. > A principal member of the Financial Planning Association. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
