Hi Kevin, I am going to do another post with more clarify in the question. Thanks for your comments.
Hitesh. On Aug 18, 7:02 pm, Kevin Pepperman <chorno...@gmail.com> wrote: > Hello Hitesh. > My suggestion is to start small here. > > You are asking a for heck of a lot of information in 1 email. > > Without seeing the entire scope of the data and the current situation, > you aren't going to get too much help . > > This email looks more like a job description than a question for a > usergroup. (am I wrong?..anyone?) > > Maybe if you start with "How can I read this XML with ColdFusion", then work > from there? > > > > On Tue, Aug 18, 2009 at 4:51 AM, Hitesh <hiteshpatel1...@gmail.com> wrote: > > > Can somebody please help me on this? > > > On Aug 13, 5:12 pm, Hitesh <hiteshpatel1...@gmail.com> wrote: > > > I am writing you regarding XML File/Data validation and bulk upload to > > > SQL Server. > > > > Objective: > > > Receive XML file (having multiple jobs in just single file), validate > > > it & save ALL jobs with proper data form save into DB. > > > > More to explain: For example XML file format would me something like. > > > <jobs> > > > <job> > > > <jobReference>...</jobReference> > > > .... > > > .... > > > ... > > > </job> > > > > <job> > > > <jobReference>...</jobReference> > > > .... > > > .... > > > ... > > > </job> > > > </jobs> > > > > In order to receive 3rd party XML file I will have to expose API (a > > > CFC method with remote attribute - webservice) and then > > > STEP 1: do basic authentication of the uplaoder > > > STEP2: validate XML file format & its data > > > STEP3: save ALL successful jobs having proper data into SQL server - > > > bulk upload > > > > Can anybody help me on this solution especially step2 & 3? > > > > Thanks - Hitesh > > -- > -- if you've written a homegrown[*CFML] controller layer that rivals the > sophistication and ease of use of the three major players (MG/MII/FB) - then > share it or shut up. You code in a silo - that's great. Just stay in there > and don't try to tell everyone how good it smells. > --Dave Ross --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---