I already have model and controller that basically doing all the work I need. model is basically our domain class.
and controller is just all of combined classes that do all the thing we want like add, modify the data in xml or database.

our next is to create restful API that allow external users to use it. Do you have very simple example for us to get start it?

Hi,
We are working on the requirement.
We are getting transaction data to one staging db ( The table having clob column and store this data as xml). we need to parse this xml and insert/update data in three different tables.

xml  like this::

Batch
   document
       Field information...

Based on the xml.. we need to update
Batch Table
Document Table
Field Table


Regards,
Praven

So I have an XML that is like this:

<document>
<component>
 <structuredBody>
  <component>   
   <section ID="something"/>      //dont render
   <id root="123"/>
   <code code="8585"/>
      Title
  <component>
   <section ID="something"/>     //dont render
   <id root="123"/>
   <code code="2222"/>
      Title 
  </component>
  <component>               //render everything starting from this component until the end of the XML
    <section ID="something"/>
    <id root="123"/>
    <code code="20"/>
      Part1
  </component>
  <component>                                       
    <section ID="something"/>      //render
    <id root="456"/>
    <code code="1"/>
      Text..
  </component>
 </structuredBody>
</component>
</document>

Select all Open in new window

What im having trouble is that I how to start rendering starting where the code/@code='20'.
I cant use position()>1 since there could be any number of <component> varies.

Hello,
I am using c# and MySQL. In c# I build an XML string is like below format. I am facing problem in MYSQL stored procedure.

set @xml ='<Details>
    <Levels>
        <Level>
            <SectionId>681</SectionId>
            <RiskId>0</RiskId>
            <WAC>Test </WAC>
            <DOCReview>Test</DOCReview>
            <MAT>1</MAT>
            <SDV>1</SDV>
            <Questions>
                <QuestionId>1186</QuestionId>
                <QuestionId>1187</QuestionId>
            </Questions>
        </Level>
        <Level>
            <SectionId>681</SectionId>
            <RiskId>1</RiskId>
            <WAC>Test </WAC>
            <DOCReview>Test</DOCReview>
            <MAT>2</MAT>
            <SDV>2</SDV>
            <Questions>
                <QuestionId>1186</QuestionId>
                <QuestionId>1187</QuestionId>
                        <QuestionId>1188</QuestionId>
                <QuestionId>1189</QuestionId>
            </Questions>
        </Level>
        <Level>
            <SectionId>681</SectionId>
            <RiskId>2</RiskId>
            <WAC>Test </WAC>
            <DOCReview>Test</DOCReview>
            <MAT>1</MAT>
            <SDV>3</SDV>
            <Questions>
                <QuestionId>1209</QuestionId>
                <QuestionId>1210</QuestionId>
                 <QuestionId>1199</QuestionId>
            </Questions>
        </Level>
      </Levels>
</Details>';


DECLARE tSectionId varchar(20),tWAC …

I have codes below and everything works fine except I get alert message below

The process cannot access the file 'c:\abc.xml because it is being used by another process

Just FYI, the xml is used for a website with around 20 users.

   public static DataTable GetUniquePhoneNo(string accountPhoneNo)
        {
            string clientPhoneNo = string.Empty;
            string inputFilePath = filePathUserMessagesAll;
            DataTable dt = new DataTable();
            dt.Clear();
            dt.Columns.AddRange(new DataColumn[]
           {
                new DataColumn("PhoneNo",typeof(string)),
                new DataColumn("Client",typeof(string)),
                new DataColumn("DateCreated",typeof(string))
           });
            XDocument xdoc = null;
            using (XmlReader xr = XmlReader.Create(inputFilePath))
            {
                xdoc = XDocument.Load(xr);
                var query1 = from t in xdoc.Descendants("User")
                             where t.Element("From").Value.ToLower() == "+1" + accountPhoneNo.ToLower()
                             select new
                             {
                                 To = t.Element("To").Value,
                                 FullName = t.Element("FullName").Value,
                                 DateTimeSent = t.Element("DateTimeSent").Value
                                 //DateTime.Parse(txtDatepicker_end.Text).ToString("YYYY-MM-dd");
                             };
     

Select all Open in new window

…

Hi all, could me please tell me how to create dll file using vba.net. I need to create dll file and use in word vba. I have create dll file and gave reference via word vba but Activex can't create objects error coming..

ex:
Dim tem as testing.test
Set tem = New testing.test

error coming in second line

I have an XML file extract with names of people and other details. How do I make this data available on a form of some sorts so end users can perform all kinds of searches on the data. i. e. First Name/Last name text search or even filter the data further using drop down that users can choose from?

I am thinking of loading the XML file into an Oracle database and then display the data as a form on Oracle Apex. However I have no prior experience in Oracle Apex, so I'm assuming it has text search, drilling down features etc.

Ps - this XML data load could end up being a weekly /monthly data load.

Really appreciate your help/suggestions.

Thanks, Ben

Hi, All - I need to convert XML to JSON 1-5 times a month, I want to do this on premise on a Windows or Linux server. Online conversions are not an option, doing the task manually is not an option.

I would prefer to find a free option, happy to pay a little money for software however free is best. I was thinking java, ASP - anything really.

The files will be downloaded from an FTP server and placed in a directory, which I then hope to have something pick them up to convert them. Once converted the files will be placed in a  folder.

I am looking for suggestions and ideas on how to make this happen, in the event someone out there is feeling helpful I have attached the two files that I will convert regularly that can be used to create a script.

Thanks
promotionsxml.xml
201707pb.xml

Hi All,

Given SQL Server 2008R2, a table table_name and column column_name that contains the below XML (heavily mocked up), I need to write a query that returns a set navigates down Envelope > Body > MyFabulousVacation > Reservation > AirSegment, and returns a set with four rows (one for each <AirSegment>) and these columns
 
Group, Carrier, FlightNumber, Origin, Destination, DepartureTime
ArrivalTime, SupplierCode, ClassOfService, OperatingCarrier

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/wahoo/">
  <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <MyFabulousVacation xmlns="http://yabba.dabba.doo/schema/">
      <reservation Key="bkgoU0BAAA/BM8PzEHAAAA==" TotalPrice="USD569.56" BasePrice="USD56.00" Taxes="USD513.56" xmlns="http://yabba.dabba.doo/schema/">
        <AirSegment Key="bkgoU0BAAA/BI8PzEHAAAA==" Group="0" Carrier="ZZ" FlightNumber="32" Origin="HOME" Destination="HERE" DepartureTime="2017-11-14T10:45:00" ArrivalTime="2017-11-15T15:40:00" ProviderCode="1P" SupplierCode="ZZ" ClassOfService="K">
          <CodeshareInfo OperatingCarrier="ZZ" />
          <Connection />
        </AirSegment>
        <AirSegment Key="bkgoU0BAAA/BJ8PzEHAAAA==" Group="0" Carrier="ZZ" FlightNumber="7971" Origin="HERE" Destination="THERE" DepartureTime="2017-11-15T18:15:00" ArrivalTime="2017-11-15T23:35:00" ProviderCode="1P" SupplierCode="ZZ" ClassOfService="K">
          <CodeshareInfo 

Select all Open in new window

…

Hi, hoping somebody could give me a quick hand with this. Normally I would try figure it out on my own but I am on a very tight time scale and its not something I would usually deal with.

We have been given an XML file that has 2 namespaces, which I have read SSIS will not support.

I want to use an XML task to strip the first namespace. How would I go about doing this?

I have created an XML Task in SSIS, in the input I have put the link to my XML file, then in the output I just left it to "Save operation Result"

In the Second Operand I have put direct input and typed in exclude-result-prefixes="ms ns xsi"   However I am getting an error when I run the code saying it cant find any XML.

Any help / point in the right direction would be really appreciated.

I am calling the stored procedure using these parameters.
All but the last column (Mulitplier are varchar or nvarchar fields, so xml is fine.  How must I change things to update the multiplier field which is decimal (18,9)?

exec concord_updateDSEmatchedIndexDatatypeNotFutures @RIC='.HKCES120',
@indextype='DF',
@dtvalues='<root><dts><rtrcol>Unadjusted High (col 43)</rtrcol><dt>PH</dt><multiplier>2</multiplier></dts><dts><rtrcol>Unadjusted Last Trade (col 71)</rtrcol><dt>PI</dt><multiplier>
2</multiplier></dts><dts><rtrcol>Unadjusted Low (col 57)</rtrcol><dt>PL</dt><multiplier>
2</multiplier></dts><dts><rtrcol>Unadjusted Open (col 155)</rtrcol><dt>PO</dt><multiplier>
2</multiplier></dts></root>'

Select all Open in new window

ALTER proc [dbo].[concord_updateDSEmatchedIndexDatatypeNotFutures] @RIC varchar(24),
@indextype char(2),@dtvalues xml
as

set nocount on 

if not exists (select 1 from DSEMatchedIndex with (nolock) where Ric = @Ric)
begin
	raiserror('RIC %s not in DSEMatchedIndex',15,127,@RIC)
	return 
end

DECLARE @ErrorMessage NVARCHAR(4000) 
DECLARE @ErrorSeverity INT 
DECLARE @ErrorState INT   

declare @rectype char(2)
if @indextype in ('CC','CS','CO')
	set @rectype = 'PT'
else
	set @rectype = 'P0'           

create table #idt (
	RIC   varchar(24) COLLATE SQL_Latin1_General_CP1_CS_AS,
	RtrColumnDesc varchar(90),	
	datatypemnem    varchar(6),
	multiplier int
)

insert #idt(                
    RIC,          
    RTRcolumnDesc,	
	datatypemnem,
	Multiplier)                
	

Select all Open in new window

…