Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data can be transformed from any Jitterbit supported format to XML and vice versa. Before attempting to use an XML as a source or target you need to have a DTD or XSD definition file that represents the XML structure you wish to use uploaded to the Jitterbit server.

Create a New Transformation

  • Make sure you have opened the appropriate project in which you want to store the new transformation.

  • There are several ways you can start to create a new transformation:

    • If you are working in an operation, you can click the Control button to the right of the Transformation field and select Create New.

    • Select New in the File menu, then choose New Transformation from the sub-menu; OR

    • Click the Down Arrow next to the file icon in the toolbar, then choose New Transformation from the sub-menu; OR

    • Right-click on Transformations in the hierarchical tree in the Design tab in the left pane of the screen, then choose New Transformation from the pop-up menu.

  • The transformation wizard appears in its own New Transformation tab in the right pane of the window.

Specify Source and Target Types

  • Enter an appropriate name for your new transformation in the Transformation Name field.

  • Select XML from the Source drop-down menu and Text from the Target drop-down menu.

  • Click the Next button in the toolbar to continue.

Select Source Information (XML)

You have three options for loading your XML document. Click on the scenario that describes where your XML document's DTD/XSD file is located:

  1. You are using an XML document whose definition is already loaded into the software.

  2. You need to use an XML document whose definition has not yet been loaded into the software.

  3. You can upload an example XML document to have Jitterbit create the definition.

Select Target Information (Text)

  • Click Save to save your work and exit out of the Transformation Wizard.

What's Next?

Now that you have defined the nature of the source and your desired target, you are ready to map the relationship between your source and target at the field, or element, level.

...

Easy Heading Free
headingIndent0
expandOptiondisable-expand-collapse
navigationTitleOn This Page

...

wrapNavigationText

...

true

...

maxLevel3
minLevel2
indent20px
Panel
borderColor#FF7C4C
titleColor#FFFFFF
titleBGColor#FF7C4C
titleRelated Articles
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel in ("complex-text","xml-to-text","xml") and space = "DOC"
Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel in ("transformation-overview","file-format-overview") and space = "DOC"

navigationExpandOptionexpand-all-by-default

HideElements
metastrue

...