PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Easiest way to create an XML file  (Read 54 times)

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 81
    • View Profile
Easiest way to create an XML file
« on: Today at 01:22:48 AM »
Hi All,

Is there a program or utility that can read file with a dictionary definition and Output it an XML file 
Thanks
Mike H

Jane Raymond

  • Staff
  • Diamond Member
  • *****
  • Posts: 287
    • View Profile
    • PVX Plus Technologies
Re: Easiest way to create an XML file
« Reply #1 on: Today at 01:30:27 PM »
Yes, there is way to do this if you're using PxPlus 2024, released last week.


Create a query to define the file(s) and fields. Then you can use the query definition in conjunction with the new *tools/qryexport utility to generate a Microsoft XML file that can be used to populate a spreadsheet. (It can also generate comma-separated (.csv), tab-delimited (.txt) and symbolic link (.slk) files.


Call "*tools/qryexport",queryName$,queryLib$,exportfile$[,queryopts$,show_flg$]


Here's more info on all the options:
https://manual.pvxplus.com/page/utilities/qryexport.htm
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.