Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Batch Script to Remove Comma from XML saved Report for VIP XML import Module

    Issue
    User wants to use saved XML file from a report to use in the VIP however the format of the XML includes numbers with at least one comma that prevents the XML importer from reading the data.

    Product
    PME 7.2.x, 8.x

    Environment
    Designer

    Cause
    In PME 7.2, web report XML saved subscriptions started to include the comma to separate numbers for readability (eg 1,234.56). The XML import module views the result as a string rather than a number.

    Resolution

    Option 1
    Create a batch file that executes the following script to save the XML to a new file without the comma. Replace the test.txt (original XML file) and testnew.txt (new XML file) to match the names used in your system.

    ::-------begin code---------
    @echo off
    for /f "delims=" %%a in (test.txt) do call :process "%%a"
    goto :eof

    :process
    set strData=%1
    set strData=%strData:,=%
    for /f "delims=" %%x in (%strData%) do echo %%x >> testnew.txt
    ::-------end code-----------


    Option 2
    Use a Find and Replace tool such as FNR.exe (attached to this KB) to replace the commas.
    Command such as:
    FNR.exe --cl --dir "Full Path Of XML File" --fileMask "Name of XML file" --excludeFileMask "*.dll, *.exe" --useRegEx --find "," --replace ""
    Where "Full path of XML" is location where XML file is saved such as "C:\saved XML\My folder" and
    "Name of XML file" is the name of the XML file to process such as "My XMLfile.xml"

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance