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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
