I’m a big fan of OpenRefine as an accessible tool for working with data in a wide variety of formats including JSON and XML

https://openrefine.org/

And a tutorial aimed at library workers

https://librarycarpentry.org/lc-open-refine/

Best wishes 

Owen

Sent from my iPhone

> On 1 Aug 2022, at 19:55, Cary Gordon <[log in to unmask]> wrote:
> 
> FWIW, while I prefer JSON, I believe that there is an existing EDIFACT to
> XML crosswalk.
> 
> Cary
> 
>> On Mon, Aug 1, 2022 at 10:12 AM Julie Swierczek <[log in to unmask]>
>> wrote:
>> 
>> I need to transform EDIFACT files into XML or JSON so I can extract the
>> Acquisitions data for use in another system. I can do some Python
>> scripting, so having XML or JSON would be a big help. Ideally, I'd love to
>> find something with a GUI so that other staff could manage the process,
>> too. But if all you've got is a hammer, then everything looks like ...
>> Python.
>> 
>> Any suggestions? I haven't quite read *all* of Stack Overflow - although I
>> feel I am getting close - so I might have missed something.
>> 
>> Thanks!
>> 
>> Julie
>> 
>> ----
>> Julie C. Swierczek (SWER-check)
>> Associate Librarian for Collection Description and Imaging
>> [log in to unmask]<mailto:[log in to unmask]> | She/her/hers
>> Folger Shakespeare Library | 201 East Capitol Street SE, Washington, D.C.
>> 20003
>> <https://www.google.com/maps/search/201+East+Capitol+Street+SE,+Washington,+D.C.+20003?entry=gmail&source=g>
>> www.folger.edu<http://www.folger.edu/> | Follow us on Facebook<
>> https://www.facebook.com/folgershakespearelibrary>, Twitter<
>> https://twitter.com/folgerlibrary>, and Instagram<
>> https://www.instagram.com/folgerlibrary/>
>> 
>> [Shape, arrow  Description automatically generated with medium confidence]
>> 
>> --
> Cary Gordon
> The Cherry Hill Company
> http://chillco.com