Sage 100

 View Only

  • 1.  what's the best way to get XML files into Sage 100

    Posted 04-16-2014 07:42
    what's the best way to get XML files into Sage 100 (GL entry, vendor info, cash receipts)? Convert file to csv and use VI, sData, other options?


  • 2.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 08:28
    I don't know if I'd call it the best way, but you could get pretty far with BOI and VBScript (http://stackoverflow.com/questions/8254600/reading-xml-file-with-vbscript)


  • 3.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 08:32
    Since I don't do sData, I would recommend CSV.


  • 4.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 11:23
    Agree with @JeffSchwenk - csv is very reliable. I like using the tilde ~ as the separator and no quotes.


  • 5.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 13:22
    @Moria and @Jeff - any XML to csv tools that you know of? We're trying to decide whether that's a better option or using BOI/VBScripting as Steve recommends. Received info back that the file coming out of the other system is definitely going to be XML.


  • 6.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 14:28
    @EricAnderson is this a one time only import or will it be happening every day,week,month? Are you doing the import or will the customer be doing it? If answer is yes to either then I look at B TO B Vision Link.. Otherwise I'm with @JeffSchwenk and @MoiraGoggin .


  • 7.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 14:41
    Just found this XML to CSV conversion tool (http://xmltocsv.codeplex.com/). Looks like it has command-line switches for batching.


  • 8.  RE: what's the best way to get XML files into Sage 100

    Posted 04-16-2014 15:10
    I just tested that Steve and it totally works - thanks!


Related Content