Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 10th, 2014, 03:25 AM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default XML, CSV or JSON for data source

Hello all

The objective is to get a reasonable volume of data once per day from a source and insert into a DB. This is presently being done using ASP from CSV files using the FSO. Some of these are triggered by users and some are vbs files which are run by windows scheduled tasks.

If there was a new requirement to get a higher volume of data and you could choose from CSV, XML or JSON what would be your preference and why? In my experience CSV files are much smoother and less complicated to work with than XML files. Is this true of have I worked with CSV files so often it just seems this why?

I have very little experience with JSON data but have been playing around a little lately. How smooth is the process a JSON data source and using ASP to get the data into a database? Is this process less complicated and more efficient than CSV and XML?

TYIA
__________________
Wind is your friend
Matt
Reply With Quote
  #2 (permalink)  
Old April 11th, 2014, 03:10 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

JSON (and XML) are great for hierarchical data, whereas CSV is easier to work with if all you have is flat records of data.

If CSV works for your scenario, I would stick to it. However, JSON is getting increasingly popular in client-server exchanges, where the browser calls the server for data using AJAX technology.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #3 (permalink)  
Old April 16th, 2014, 12:46 AM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Hi Imar - Thank you for your reply. As usual, your comments are very useful.
__________________
Wind is your friend
Matt
Reply With Quote
  #4 (permalink)  
Old July 29th, 2014, 05:47 AM
Registered User
Points: 6, Level: 1
Points: 6, Level: 1 Points: 6, Level: 1 Points: 6, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

JSON is a much richer structure - if your customers prefer CSV, they can always use an online converter such as convert json to csv.
Reply With Quote
  #5 (permalink)  
Old July 30th, 2014, 09:57 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Hi there - thank you for your input. Sorry if I didn't make it clear but most of these activities are unattended. Manually using a converter is not an option. The outcome of my research is to use CSV files if possible. If we have to deal with JSON files a JSON passer on the server side will allow us to get the hierarchical data into the DB
__________________
Wind is your friend
Matt

Last edited by mat41; August 6th, 2014 at 02:16 AM..
Reply With Quote
  #6 (permalink)  
Old August 6th, 2014, 02:01 AM
Registered User
Points: 6, Level: 1
Points: 6, Level: 1 Points: 6, Level: 1 Points: 6, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK sorry - I incorrectly assumed it to be a one-off data translation
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting html in xml data source? sg48 ASP.NET 2.0 Basics 1 February 22nd, 2010 11:16 AM
XML to CSV Converter for Mac (simple columnar data) ewolf XSLT 1 December 28th, 2009 06:26 AM
XML or JSON? ajaxbeginner BOOK: Professional Ajax 2nd Edition ISBN: 978-0-470-10949-6 1 December 6th, 2009 07:32 PM
Dynamic Data source with Native XML driver Nellie Crystal Reports 1 November 30th, 2006 11:42 AM
csv file data source q's kap260 Classic ASP Databases 0 August 4th, 2003 04:17 PM



All times are GMT -4. The time now is 09:41 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.