Skip to main content
March 16, 2016
Question

How to load JSON file or CSV file into oracle database using ColdFusion ? Please tell me ASAP

  • March 16, 2016
  • 1 reply
  • 2056 views

Hi ColdFusion Team,

How to load JSON file or CSV file into oracle database using ColdFusion ? Please tell me ASAP

Thanks in Advance

    This topic has been closed for replies.

    1 reply

    WolfShade
    Legend
    March 16, 2016

    That depends.  You can very easily insert the JSON or CSV data as a string into a varchar or text datatype on the database, no problem.

    However, if you need the JSON or CSV to be in an array (like a query object) so that it can be inserted into the database, then how the data was "flattened" would matter.

    I avoid CSV, if at all possible.  Never liked it.

    However, if you are using CF to create the JSON (or if you manually piece it together in JavaScript and it follows the CF format), then you should be able to use DeserializeJSON() to put it back into a query object and append the data into a database relatively easily.

    HTH,

    ^_^

    PS:  I just noticed that you addressed your post to "ColdFusion Team".  Just to make sure, the people at Adobe don't officially monitor these forums - these forums are primarily a user-to-user interaction.  Although sometimes Adobe staff do check in here to see what's going on.

    March 16, 2016

    Hi WolfShade,

    *Could you please send me the total script code to load data from json/csv

    file to oracle database using cold fusion scripts*

    *Hope you do well reply me please ASAP *

    Thanks in advanceOn Wednesday, March 16, 2016, WolfShade <

    Carl Von Stetten
    Legend
    March 16, 2016

    As much as I'd like to assist you, this is not a "write my code for me" kind of forum.  If you have specific questions, or have tried something and it isn't working, people will generally try to offer assistance.  But asking someone to write code for you is an unreasonable expectation.

    Even if you provided the structure of your json/csv data and the exact schema of the database table(s) in Oracle that you wish to write to, you should not expect forum members to provide you "the total script code to load data from json/csv file to oracle database".

    And, as WolfShade‌ stated, very few Adobe ColdFusion developer team actively follow these forums - they are intended to provide peer-to-peer support.  Furthermore, most of the ColdFusion development team do not routinely write ColdFusion code and would be unlikely to be able to write this code for you.

    -Carl V. - Moderator