{"id":5495,"date":"2017-11-13T18:11:21","date_gmt":"2017-11-13T18:11:21","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=5495"},"modified":"2020-07-01T12:13:58","modified_gmt":"2020-07-01T19:13:58","slug":"eformz-txt-to-xml-guide-getting-started","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/eformz-txt-to-xml-guide-getting-started\/","title":{"rendered":"eFORMz TXT To XML Guide: Getting Started"},"content":{"rendered":"

Part Two:\u00a0eFORMz TXT to XML Guide: Reset Line Number Count<\/a>
\nPart Three:\u00a0eFORMz TXT To XML Guide: States<\/a>
\nPart Four:\u00a0eFORMz TXT To XML Guide: State Loops<\/a><\/p>\n

What does TXT to XML mean? It simply means taking a text file and turning it into an XML file.<\/p>\n

In eFORMz the first thing you want to do is load in your text file that you want to have changed to XML. eFORMz also has a feature in \u201cOutput\u201d that output as a text file. For example, if you had a CVS file and you wanted to convert it to text. You could run the \u201cOutput\u201d setting in eFORMz and set it to be Text.<\/p>\n

You can load in the Text file many different ways into your project, but in mine, it was imported it through a \u201cPreprocessor\u201d that takes an output from a different eFORMz project that is creating my text file.<\/p>\n

Right click on your Project, mine is named \u201cTextToXMLBackup\u201d, \u201cAdd Preprocessor\u201d, \u201cProject\u201d.<\/p>\n

It will open up to the \u201cProject Preprocessor Properties\u201d page. In here is where you would insert the file path of where your project that Is creating the text file. Ex My file input\u2019s name is the following: \u201cMinisoft\\eFORMz_6\\projects\\Bradshaw\\PDFTXTPreprocessor2.efz\u201d Select that the output format from this project is \u201cText\u201d.<\/p>\n

\"\"<\/a><\/p>\n

If this was successful you should see a folder that is named \u201cPreprocessors\u201d with a bullet that says \u201cProject.<\/p>\n

\"\"<\/p>\n

Next add another preprocessor called \u201cText to XML Converter\u201d and you should see the following properties screen.<\/p>\n

\"\"<\/a><\/p>\n

The following options are explained here:<\/p>\n

Configuration File:<\/b> The file to configure the initial settings of the Text to XML Editor. This is an optional parameter and can be left blank. (This is where you could load in your text file if you did not want to have a preprocessor load it in and edit it)<\/p>\n

Stock Configuration File:<\/b> A pre-existing file that configures the initial settings of the Text to XML Editor. NOTE <\/b>There are three stock options: RedPrairie Ship Confirmation, RedPrairie Order Confirmation and blank.<\/p>\n

The RedPrairie Ship Confirmation structures the initial settings of the Text to XML Editor to handle a shipping confirmation generated by the RedPrairie Direct Commerce system. The RedPrairie Order Confirmation structures the initial settings of the Text to XML Editor to handle an order confirmation generated by the RedPrairie Direct Commerce system. These files can be modified with the Text to XML Editor, but by specifying the basic conditions, they can save the user significant time. Note: Default is blank.<\/p>\n

Record delimiter:<\/b> Separates groups of fields by specifying the boundaries of the data stream. Default is a linefeed (\\n = new line).<\/p>\n

Character Set:<\/b> All numbers, letters and symbols associated with a given coding system.<\/p>\n

Show Editor while in composer:<\/b> When checked, displays the Text to XML Editor in the eFORMz Composer (Window > Text to XML Editor) Default is unchecked.<\/p>\n

Once you have accepted it you will see the bullet \u201cText to XML Converter\u201d under the Preprocessors folder.<\/p>\n

\"\"<\/a><\/p>\n

Right click on the bullet \u201cText to XML Converter\u201d and select \u201cText XML Editor\u201d. It will pop-up with this screen.<\/p>\n

\"\"<\/a><\/p>\n

The left column contains \u201cLines\u201d and \u201cStates\u201d. The picture shows the viewer in \u201cLines\u201d Mode. Line mode is used to determine where text is on a certain line. The ordering of the lines go from top to bottom. Please ignore my variables I already have in my “Lines” column.<\/p>\n

\"\"<\/a><\/p>\n

This is your text that you imported into your project that we will turn into XML.<\/p>\n

\"\"<\/a><\/p>\n

Lets start by capturing the first line of text in XML. Right click on the \u201cyellow folder\u201d at the top of the \u201cLines column\u201d and select \u201cInsert Line\u201d. When the line Is created it will default to \u201cLine_(a number)\u201d. Click on that line and edit the properties value that is in a window below the column. It will look like the following photo below.<\/p>\n

\"\"<\/a><\/p>\n

I called my first line \u201cOrderDetail\u201d and gave it a code of \u201cCustomerNumber:\u201d at column 3. What this means is that in the text portion it will look for the literally text \u201cCustomerNumber:\u201d at column 3.<\/p>\n

You can see the row, and columns placement by moving your cursor to a desire location in the text and then checking where it is at the bottom of the page, which is shown in the picture below.<\/p>\n

\"\"<\/a><\/p>\n

Notice there is a \u201cSet\u201d button and a \u201cAuto Set\u201d radio button. Make sure to check the \u201cAuto Set\u201d as it will always save and update your changes without having to manually click \u201cSet\u201d eachtime. Once you have clicked \u201cSet\u201d or set-up \u201cAuto Set\u201d. Press the \u201cTest\u201d buttom in the bottom right hand corner of the page. You MUST<\/b> press test each time to see your changes update. Don\u2019t forget to always select Test to see new updates.<\/b><\/p>\n

\"\"<\/a><\/p>\n

If everything succeeds when you click on your variable it should highlight the line in the text. I have selected \u201cOrderDetails\u201d and it highlights the line it is on. That is because I have my settings set to\u00a0 column 3, search for the text \u201cCustomerNumber:\u201d. Currently the CustomerNumber is a line below the where it should be due to PDF to TXT encoding. How can we receive that number? There is no text that we can use to search for that will allow us to know here to get that information.<\/p>\n

\"\"<\/a><\/p>\n

You can get this information by creating a state. What is a state? A state is used to create folders in XLM, and the final variables in XML that you want. It also can organize the way you process the data from your text.<\/p>\n

Select the \u201cStates\u201d tab at the bottom of the column next to the \u201cLines\u201d tab. You should have a screen similar to the photo below. Please ignore all the states my project currently has. Yours will not look like mine.<\/p>\n

\"\"<\/a><\/p>\n

The first folder you see at the top is the XML folder that everything is going to be inside of. It defaults to be called null. Click on the \u201cnull\u201d folder at the top and rename it to whatever you want that folder name to be. I named mine \u201cPackSlipData\u201d. The \u201cTag\u201d row is how you define what your want your folder name\/variable name to be. Click on the \u201cActive\u201d tab in the \u201cState Editor\u201d as shown below. Once you have finished select \u201cSet\u201d.<\/p>\n

\"\"<\/a><\/p>\n

Right click on the state your renamed and select \u201cAdd State\u201d.<\/p>\n

\"\"<\/a><\/p>\n

It will default to this when you first add a state. Click on the your new \u201cnull (null)\u201d state and go into the \u201cState Editor\u201d. Then select a line. Selecting a \u201cLine\u201d will come from the \u201cLines\u201d columns that you have created before. For example my variable \u201cOrderDetail\u201d. Select \u201cSet\u201d. If you want this variable to be inside of a folder inside of the folder \u201cPackSlipData\u201d then you would put in a name into the tag row of \u201cOrderDetail\u201d state like the photo below. I will name my folder \u201cPackSlip\u201d. If you wanted the variable inside of the folder \u201cPackSlipData\u201d you simply would leave the tag row blank. This can be done multiple times to created nested folders.<\/p>\n

\"\"<\/a><\/p>\n

If successful it should look like this, without the plus sign because I have other states inside of that state that we will get to.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Part Two:\u00a0eFORMz TXT to XML Guide: Reset Line Number Count Part Three:\u00a0eFORMz TXT To XML Guide: States Part Four:\u00a0eFORMz TXT To XML Guide: State Loops What does TXT to XML mean? It simply means taking a text file and turning it into an XML file. In eFORMz the first thing you want to do is […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[6,266],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5495"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=5495"}],"version-history":[{"count":5,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5495\/revisions"}],"predecessor-version":[{"id":8161,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5495\/revisions\/8161"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=5495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=5495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=5495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}