This is all I can do with what info I have.
I hope this helps. excuse my twisted humor, the pain pills are working well.
<cfcomponent extends="
com.magic.Do.Everything.For.Me.So.I.Dont.Have.To.Google.It">
<cffunction name="init">
<cfargument name="magic" />
<cfargument name="objective" />
<cfset setMagic(arguments.magic) />
<cfset variables["_objective"] =
do_basic_authentication_of_the_uplaoder(arguments.objective) />
<cfset variables["step2_&_3"] = validate_XML_file_format_its_data() &
save_ALL_successful_jobs_having_proper_data_into_SQL_server_bulk_upload()>
<cfreturn this>
</cffunction>
<cffunction name="do_basic_authentication_of_the_uplaoder">
<cfset myMagicCode = getMagic().doMagic()>
<cfreturn myMagicCode>
</cffunction>
<cffunction name="validate_XML_file_format_its_data">
<cfxml variable="jobs">
<jobs>
<job>
<jobReference>...</jobReference>
....
....
...
</job>
<job>
<jobReference>...</jobReference>
....
....
...
</job>
</jobs>
</cfxml>
<cfset myMagicXmlValidator = getMagic().doMoreMagic(jobs)>
<cfreturn myMagicXmlValidator>
</cffunction>
<cffunction
name="save_ALL_successful_jobs_having_proper_data_into_SQL_server_bulk_upload">
<cfset myMagicSQLServerBulk = getMagic().doEvenMoreMagic()>
<cfreturn myMagicXmlValidator>
</cffunction>
<cffunction name="setMagic">
<cfset variables.magic = arguments[1]>
</cffunction>
<cffunction name="getMagic">
<cfreturn variables.magic>
</cffunction>
</cfcomponent>
On Thu, Aug 13, 2009 at 3:12 AM, Hitesh <[email protected]> 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
