Zum Hauptinhalt gehen

Suche

Suche

How to write BTXML data into MS SQL database table

Kommentare

2 Kommentare

  • Avatar
    Peter Thane

    Not sure if the Update or Insert Database records Action option could be of use to you.

    0
  • Avatar
    Andreas Meichsner

    Hi Peter,

    no, the Insert database record action is useless, if you cannot "read" the named datasources from BTXML.

    I've found a workaround, but there should be an easierer and more dynamic solution.

    1) I convert BTXML into CSV data structure (with Convert XML using XSLT action)

    2) Convert text to data record using csv data strucure from Step 1... to get the named datasource / value pairs

    3) For each data record in the database action 

    4) Finally Insert database record action is used for maooing the database fields with named datasources from CSV

    The simplified action list looks as follows

     

     

    Maybe you have a better idea/solution

     

    Best regards,

    Andreas

    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.