Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9282 > unrolled thread

Utility to load JSON data to Access

Back to article view | Back to comp.databases.ms-access

Contents

  Utility to load JSON data to Access BobAlston <bobalston9@yahoo.com> - 2014-04-23 20:53 -0500
    Re: Utility to load JSON data to Access kduc <kduc@numerifil.invalid> - 2014-04-24 08:23 +0200
      Re: [SPAM]Utility to load JSON data to Access BobAlston <bobalston9@yahoo.com> - 2014-04-24 12:40 -0500
        Re: [SPAM]Utility to load JSON data to Access The Frog <Mr.frog.to.you@googlemail.com> - 2014-04-28 14:25 +1000
          Re: [SPAM]Utility to load JSON data to Access BobAlston <bobalston9@yahoo.com> - 2014-05-05 09:15 -0500

#9282 — Utility to load JSON data to Access

Anyone have a good utility or method to load JSON data to Access?

any free and reliable method of converting JSON data to XML?

Thanks

bob

[toc] | [next] | [standalone]

#9283

Le 24/04/2014 03:53, BobAlston a écrit :

> JSON data to XML

Download the library here : <http://json.codeplex.com/releases/view/43775>

Use DeserializeXmlNode to convert fron JSON to XLM
Use SerializeXmlNode  to convert from XLM to JSON

JAVA:
private XmlDocument ConvertJsonToXml(string JsonString)
        {
            XmlDocument XmlDoc;
            XmlDoc =
(XmlDocument)JsonConvert.DeserializeXmlNode(JsonString);
            return XmlDoc;
        }

-- 
kd

[toc] | [prev] | [next] | [standalone]

#9291 — Re: [SPAM]Utility to load JSON data to Access

On 4/24/2014 1:23 AM, kduc wrote:
> Le 24/04/2014 03:53, BobAlston a écrit :
>
>> JSON data to XML
>
> Download the library here : <http://json.codeplex.com/releases/view/43775>
>
> Use DeserializeXmlNode to convert fron JSON to XLM
> Use SerializeXmlNode  to convert from XLM to JSON
>
> JAVA:
> private XmlDocument ConvertJsonToXml(string JsonString)
>          {
>              XmlDocument XmlDoc;
>              XmlDoc =
> (XmlDocument)JsonConvert.DeserializeXmlNode(JsonString);
>              return XmlDoc;
>          }
>
Great.  Thank you.

I have no experience in running Java so could you/anyone tell me what I 
need to do/know to take the JSON from a file and output the XML to a 
file?  Need to know how to run the thing on Windows.

Thanks again.

Bob

[toc] | [prev] | [next] | [standalone]

#9303 — Re: [SPAM]Utility to load JSON data to Access

Hi Bob,

A codeless approach would be to use Pentaho Data Integration (also 
called KETTLE). It's an ETL tool that you can use to massage data 
from most anything to most anything. JSON direct to Access? No 
problem. JSON to CSV? Also no problem. Drag and drop. Like buildup a 
flowchart. Grab the free community edition.

-- 
Cheers

The Frog

[toc] | [prev] | [next] | [standalone]

#9330 — Re: [SPAM]Utility to load JSON data to Access

On 4/27/2014 11:25 PM, The Frog wrote:
> Hi Bob,
>
> A codeless approach would be to use Pentaho Data Integration (also
> called KETTLE). It's an ETL tool that you can use to massage data from
> most anything to most anything. JSON direct to Access? No problem. JSON
> to CSV? Also no problem. Drag and drop. Like buildup a flowchart. Grab
> the free community edition.
>
Thank you    thank you     thank you.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web