Put the people.xml file in the input directory and check the output.XMLExchange Plus is a tool for reading and writing data exchange files formatted according to the NAACCR XML Data Exchange Standard. Test it by clicking on the Mode menu and select Testing Mode.ģ4. Save it by clicking File – Save Current Route.ģ3. Return to the console by clicking the File menu and clicking on Return to Console.ģ2. Save the transform by clicking on the Save icon, entering the name transform and clicking OK.ģ1. Go to the Testing tab, click on the Execute Transformation button, and verify that the results contains records and values as shown here.ģ0. Drag the Last element from the Source format onto the LastName element in the mapping view.Ģ9. Drag the First element from the Source format onto the FirstName element in the mapping viewĢ8. Drag the FirstName and LastName elements from the target format onto the Record element in the mapping view.Ģ7. Drag Record from the target format onto the for-each elementĢ6. Drag Person+ from the source format onto the for-each element’s “ select” attribute in the mapping view.Ģ5. In order to iterate through all of the Person elements in the source, go to the Flow Control functions and drag for-each onto the XCSData element in the mapping view.Ģ4. Drag XCSData from the target format onto the People in the mapping view.Ģ3. Drag People from the source format onto “ stylesheet” in the mapping view.Ģ2. Map the source format to the target format: Each of these steps involves dragging elements from one of the side panels into the Mapping view which is the center panel.Ģ1. Set the format reader to Flat File format builder.Ģ0. Add the file spec created in step 10 – XMLtoFixedFileSpec.xml – which will be in your interfaces/format/XMLtoFixedFormat directory. Setup the Target format by clicking on the Open target format button. and add the same people.xml file that this interface will be reading. Set the Source format by clicking on the Open source format button. Uncheck “ Use Direct Relay” and click on the “ New” button.ġ8. We will now want to use the Data Mapper to convert the incoming XML into the simple XML needed by our transformation module. Return to the eiConsole by clicking File, then clicking Return to Console.ġ7. Save the file spec by clicking on the Save icon and setting the name to “ XMLtoFixedFileSpec”.ġ6. You could repeat the previous step to create all other fields that you want to be added to the fixed-width file.ġ5. The length of this field is also 15 characters. Repeat step 12 to create another field called LastName.
Set the field name to FirstName and click OK. Start listing the fields in each record of the txt file: Right click on Record, select Add New Field. Start building out the structure of the Fixed-width file by right-clicking on “Base” in the Record Structure tab select Add New Record, and enter the name “ Record”.ġ3. In the Results preview, click the “ open file” icon and open a sample XML file that you will be reading.ġ1. For this example, open the attached people.xml file.ġ2. For Field Style, select “ Fixed Width” and click Save.ġ0. For the new File Type, select the User-defined and click Next.ĩ. Under Transformation Module Configuration, set the Transformation Module to Delimited and Fixed-Width File and click on the Edit button.Ĩ. Enter a name for the new format XMLtoFixedFormat and click OK.ħ. Create a new format: Click on the Target Transform stage. Set the Target file name to out and the Target file extension to txt.Ħ. Set the Target Directory to a directory where the output files should be written to – C:\out.
Set the Transport Type to Directory / File. Setup a Directory transport: Click on the Transport stage. Set Polling interval to 5 seconds and Polling Directory to the directory where it will pick up the XML files. Set the Listener Type to Directory / File. Setup a directory Listener: Click on the Listener stage. Double-click the new route to go to the Route Edit view.ģ. Create a new route by clicking on the Add Route button and entering in a name for the route XML-to-FixedWidthĢ.
0 kommentar(er)
