The following import options are supported: Delimited Files: delimited files such as comma separated (csv), tab separated (tsv) space separated, and any other type of delimited file. In a Windows environment, this most likely means into a Notepad file. MongoDB is supported on the following operating systems:. Before you begin. You can import data from CSV file(s) directly into your database table(s). This software can calculate, draw and exports 2-D mathematical functions and their combinations to the BMP, EMF, and CSV formats and also imports external CSV files to draw graphics to export them to BMP or EMF format. convert csv to pst free download - OI Convert CSV, CSV To XLSX Convert Software, vCard VCF To CSV Converter Software, and many more programs All Windows Mac iOS Android. Go through these. vcf format converted over to. NoSQLBooster for MongoDB 4. WindowsFormUtilities. Get PDFBox pom. For a comma-separated file with a. So here’s a simple Java Utility class that can be used to load CSV file into Database. Step 3: Save or keep your CSV or TXT file here to which you want to import. Mongoimport is distributed with MongoDB. From our blog Sqlify's New Pay As You Go Pricing Convert between CSV, JSON and SQL files in PHP using the Sqlify API Convert and flatten JSON to CSV or SQL using JSON path expressions One-liner to migrate data from MongoDB to MySQL from your shell Uploading a big file to the Sqlify API in chunks. Quicken could open source the QFX file format and I'd be able to write my own conversion routine. 1 Today, we’re happy to announce the release of MongoBooster 2. To get started, you want to select Export to a file. And the Employee. com It will read your mysql database, build a translation file and allow you to map the information. com or Exchange account, your contacts are automatically added to the People app. I want to Import a. Export and Import CSV Data Logging Export CSV Data Logging. MS SQL Server Import Tool. com contacts list into the Mail app. Rename the CSV file to match the desired collection name, for example Cars. i would like to import a csv file data into datagrid,how to do this by using c#. CSV file name does it have to be same as it is in Schema. Outputting a Query to a file. Comma-separated values are exported. Type mongo import dash dash help to see the options available. Before you create an import job to transfer data into Azure Files, carefully review and complete the following list of prerequisites. Tips on how to import great amount of csv knowledge to mongodb mongoimport -d -c -type csv -file -headerline - Exchange along with your respective values-d - Tells on your mongo server into which database you need to import-c - Tells on your mongo server in into which assortment you need to import -type csv - Says this is a csv. The following example exports the name and address fields in the contacts collection in the users database and uses --noHeaderLine to suppress the output of the field names as the first line:. Good, Better, Best. csv is the file which i want to import in MongoDB database through mongo shell. If you have a panic moment and think the CSV file isn't correct, or some of the information from the tabs isn't what you expected, you can undo the import up to 48 hours after you imported it. 2, mongoimport expects import data to be in Extended JSON v2. Since you have already downloaded and installed MongoDB, you have access to it from the command line interface of your choice. After you have created a CSV file you will be able to upload your contacts to Gmail which is used to sync with your device. Running MongoDB deployments to which to connect. Syntax The following syntax rules govern how to correctly define applications, stored procedure definitions, or files in the extension mapping document in CSV format. I have the file on a SD card in the. There is no “CSV standard”, so the format is operationally defined by the many applications which read and write it. csv file, that you previously downloaded >> click "Open. mongoimport is located in the bin directory (eg, /mongodb/bin or wherever you installed it). Note that most of the advice is for pre-Excel 2007 spreadsheets and not the later. js file with the following function into your home directory. Each record consists of one or more fields, separated by commas. Few examples to show you how to use the mongoexport to back up the database. The implementation of all these examples and code snippets can be found over on GitHub – this is a Maven based project, so it should be easy to import and run as it is. I also need to remove any single quotes from a specific field. Review some of the common use options. csv) file, which can be imported into popular apps such as Microsoft Excel, Apple Numbers, and Google Sheets. There are three major steps. The purpose of this post will be to provide files you can use to create your own imports. Consultez le profil complet sur LinkedIn et découvrez les relations de Radu, ainsi que des emplois dans des entreprises similaires. csv" or import-csv "D:\Load\sample. Export data from collections, views, or query results to formats such as Excel, Access, CSV and more. Important : do not forget to delete the exported csv file from your hard drive when you are done. csv | Sort-Object DN, department-----. Click  Get External Data, then select  From Text : This will bring up a file explorer. Export Wizard Export MongoDB to CSV, JSON, BSON/mongodump, SQL, and another collection in a few clicks with Studio 3T's Export Wizard. Before the tool can import CSV data into CollectionSpace, it first "stages" the data from the CSV files into a MongoDB database. The following loop will take all of the tables in the database with which you connect. Now obviously you can't copy each data and insert it manually. More about FileToMongo - the tool to import data from Csv file to MongoDB collection 30-day free trial US$59. Import CSV using MongoDB Compass. The MongoDB Driver. Need to search about 50+ evtx files from our archieve. This is a list of formats commonly found in CSV files. Import CSV file into Mongo DB MongoDb Tutorial 6 - How to Import and Export data in Mongo DB Pankaj Kumar 2,270 views. Previous Post Exporting Data from SQL Server to CSV Files for Import to MongoDB Using PowerShell Next Post Installing Windows PowerShell Modules on Multiple User's Computers-Updated One thought on "Importing MongoDB Data Using SSIS 2012". mongoimport --db test --collection stuff --type csv C:\data\Employee. 4 Pitfalls when importing MongoDB into Redshift. csv writes compliant files on Windows: use eol = "\r " on other platforms. Log into your MySQL shell and create a database. Exporting Azure Files is not supported. Therefore, to get your data from Excel into MongoDB, the best option is to save it as a CSV file, and then use [code ]mongoimport[/code] to import it. CSV file is nothing but a Text file where data (records) are stored separated (delimited) by comma character. For those MongoDB gurus, you'll notice in the 'complex' data illustration, this is really a string and not a MongoDB complex object - that discussion is for another day. Data is stored in MongoDB as BSON, which looks like JSON files. You can import a *. 2, mongoimport expects import data to be in Extended JSON v2. Select "Comma Separated Values (Windows)" then click Next. Learn how to install MongoDB and configure it with XAMPP on Windows. To do this, use the LOAD CSV clause. Download Free VCF file to CSV or Excel converter for free. Each record consists of one or more fields, separated by commas. To enable the CSV to be importable, you must first create the. Lucas at some point suggested a CSV parser better than what Compass uses now (COMPASS-3129) Note that selecting fields and their types is not part of this story Attachments. To do that, the first step is to convert the xml data into a csv file, and then load that data into a MongoDB database using mongoimport. Application use data with comma or semicolon separator. In this tutorial, we show you how to backup and restore MongoDB with the commands : mongoexport and mongoimport. Please be aware that Quicken cannot import Excel (. Learn how to import CSV data from a local directory into MongoDB using the MongoDB connector. Search for the vCard file, and choose Import vCard file. writerows (someiterable) Since open() is used to open a CSV file for reading, the file will by default be decoded into unicode using the system default encoding (see locale. ) Next open Outlook and press ALT + F11 to open the VBA editor. mongoimport: Being used to import data to a Collection from a file ( json, csv,. Note: If you have opened the file in Excel to look at it, close it without saving. Import contacts in CSV format to Windows Hotmail April 10, 2012 Steve 0 Comments Now-a-days everyone is linking accounts and data, rather than keeping them in sync. import" command takes two arguments which are the name of the disk file from which CSV data is to be read and the name of the SQLite table into which the CSV data is to be inserted. This format saves your Excel workbook as a comma-separated file for use on Mac operating system. For this tutorial we will use the file above and call it tutorial. Attributes may or may not be in quotes. Point Data to CSV Software Informer. You can now import that csv-file into Outlook just as you would have done with an Excel file but now of course choose to import a “Comma Separated Values” file. Then use the Browse button to select the CSV file. A tool for import from a wide variety of text, CSV or xml sources (and even some types of binary) to Line 50 sales orders, product or service sales invoices, purchase orders, customers, suppliers, stock, audit trail posting transactions (with 'grouping'), stock transactions, price lists, etc. To connect to MongoDB from Python Application, follow the below step by step guide : Install Python Driver - PyMongo. The purpose of couchimport is to write data to CouchDB in chunks using data from a text file: It also allows a transform function to be added to the workflow: this function gets called with each new document and can modify it to cast data types, remove unwanted fields or to reorganise the structure. Software to export Lotus Notes contacts to CSV file, then users can easily import CSV file to WAB file using Import option in Outlook Express. It’s a clean approach to cleaning the schema for a testing environment. Select Import/Export. Choose File - Open. The CSV file does not provide Aircraft Model information, so the import wizard will default all aircraft as Model X. In terms of pricing, it offers three different versions. BSON format, or restore them to a live database. csv or sample. I am using windowsXP 32-bit machine. CSV stands for “comma-separated values,” and CSV files are simplified spreadsheets stored as plaintext files. Excel VBA Script to convert VCF file with multiple entries to CSV file. How to Migrate from MySQL to MongoDB In the last week I was working on a key project to migrate a BI platform from MySQL to MongoDB. Connect to MongoDB from Python - In this MongoDB Tutorial, we shall learn to connect to MongoDB from Python Application. The tool has a lot of problems. (You can use a different folder but will need to update the macro with the correct folder path. With this import functionality, you can import almost all excel spreadsheets (Just export to CSV format and import that file to your NodeChef database). There are three major steps. MongoBooster - MongoDB GUI Tool. vcf format converted over to. You can use the mongoexport utility to export data from your MongoDB database, to a JSON or CSV file. Select the Save as type as CSV (Comma delimited) (*. A couple of important things to note about importing contacts to Gmail with a CSV file:. After specifying a Blob container URL and Account Key, simply provide a regular expression to select the file(s) to import. Though, Outlook contacts are saved as PST but one can export contacts to vCard and other files formats such as MS Excel, CSV, etc as per requirements. Withdata Software is a technology company, specializing in software for database developers. It is a best software to convert a CSV to vCard to import into iCloud. Used mongoimport to import. In this section, we will discuss about how to connect the Upload Tool to pull data from your local/hosted MongoDB database and import into Zoho Analytics. 1,"Exporting CSV from MongoDB" mongodb csv mongoexport Free 30 Day Trial A look at MongoDB CSV exporting makes up the first part of our Comma Values series, all about the rarely loved CSV files and the databases that import/export them. Download Free VCF file to CSV or Excel converter for free. import pandas as pd olympicsData = pd. There is no “CSV standard”, so the format is operationally defined by the many applications which read and write it. The neo4j-admin import tool allows you to import CSV data to an empty database by specifying node files and relationship files. Importing data from a CSV file into MongoDB is one of the fastest methods of import available. This example creates an export of the collection contacts from the MongoDB instance running on the localhost port number 27017, with journaling explicitly enabled. We'll explore some of the settings and features mongoimport offers There comes a time in almost everyone's experience with databases when it would be great to bring in data from an outside source. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. This is what I would suggest if you are a Windows user, the ease of use is simply superb. txt is similar to. The first part you need following the PROC IMPORT statement is the datafile argument. The Fastest Way to Import Text, XML, and CSV Files into MySQL Tables Morpheus Data One of the best ways to improve the performance of MySQL databases is to determine the optimal approach for importing data from other sources, such as text files, XML, and CSV files. Under the File menu, select Import. csv file in Excel file without using: Workbooks. csv : val "titi""toto" Why a double quote. We should make clear that by import and export in this article we mean dealing with data. Choose JSON as the import format. Try importing your. The utility is located in the MongoDB bin directory (eg, /mongodb/bin ). We're the creators of MongoDB, the most popular database for modern apps, and MongoDB Atlas, the global cloud database on AWS, Azure, and GCP. Changing Regional Setting in Windows (CSV imports) This solution will assist where clients are trying to import reports from a CSV file and they appear on the first column. Import csv to windows on MainKeys. Import CSV using MongoDB Compass. The Import-Csv cmdlet reads the CSV file and creates an array of reservations objects where an object is created from each row in the CSV file. In the tutorial, Grokonez shows how to import data from CSV File to MongoDB with Node. 2, mongoimport expects import data to be in Extended JSON v2. This is true, and that are the required files to MongoDB, it's really. 0, you can install and configure MongoDB as a Windows Service during the install, and the MongoDB service is started upon successful installation. If you need to import or export data in a flat file (non-binary) format such as JSON, CSV, or TSV, the mongoimport and mongoexport commands are the appropriate MongoDB command-line tools to use. Until these features are available, here is workaround solution how to export to CSV using Robomongo shell: Workaround Solution: How to export to CSV. JSON (pronounced “JAY-sawn” or “Jason”—it doesn’t matter how because either way people will say you’re pronouncing it wrong) is a format that stores information. Since having an Outlook or Live Mail is mandatory for Windows 10 users, you may like to import contacts from Outlook to People. Open your Excel file and click Save As. The most basic purpose of ImportQIF is to add the account name and type to a QIF file to bypass the restriction in Quicken Windows US that only allows importing into asset and liability accounts. I want to Import a. Step 1 : Select CSV file and go to Open & Export > Import / Export. CSV or comma separated files are often used to export or import data in web applications. read_csv('data. This allows for easier MongoDB consumption. Syntax The following syntax rules govern how to correctly define applications, stored procedure definitions, or files in the extension mapping document in CSV format. What i am trying to do is to open a txt file that has rows and columns of numbers so that it opens in the product in cells - when i try it just seems to display the page without any cell placement. The neo4j-admin import tool allows you to import CSV data to an empty database by specifying node files and relationship files. It covers MongoDB administration tools, syntax, and management principles addressing everything from installation to configuration, backups, monitoring, scaling out, security, and performance tuning. how to import file of csv extension using importmongo in mongodb. Importing data from a CSV file into MongoDB is one of the fastest methods of import available. Connect to. Download it here. Importing CSV into Adressbook may need to check that each field (row) of the CSV exactly match the number and kind of fields in your contacs or Adressbook, which can be. We should make clear that by import and export in this article we mean dealing with data. In this tutorial, you learn, how to import CSV file using NodeJS into MongoDB. 1,"Exporting CSV from MongoDB" mongodb csv mongoexport Free 30 Day Trial A look at MongoDB CSV exporting makes up the first part of our Comma Values series, all about the rarely loved CSV files and the databases that import/export them. Step 2 : Now Select Import from another program or file. Import Contacts to Mail app in Win 10 After upgrading to Win 10 I can't figure out how to get my Outlook. From the command line options, I see that mongoimport accepts data as json or csv or tsv (tab separated). Import and Export CSV in ASP. Related posts: - Nodejs Express RestAPI - Upload. tail -n +2 users. CSV Contacts file into that Gmail Account using the Web Interface. Importing an existing MySQL table into MongoDB collection is a very trivial task. We have built abc import to address the problem of indexing and syncing data from source X into Elasticsearch (and appbase. Estimated number of the downloads is more than 100. Download this app from Microsoft Store for Windows 10. Summary: Learn four easy ways to use Windows PowerShell to import CSV files into SQL Server. Before you begin. Now there is one less. Type mongo import dash dash help to see the options available. When you export an excel workbook to a csv file, you would then import your file and insert it into a MongoDB database and collection using the mongoimport utility. Site administrators can import users to a particular site; server administrators (Tableau Server only) can import users at the server level, to later add them to multiple sites. The Simba MongoDB ODBC Driver officially supports MongoDB 3. csv file extension. Being able to load CSV files into Neo4j makes it easy to import data from another database model (for example, a relational database). PostgreSQL Data Wizard is a Windows GUI utility to transfer both schema and data from any ADO-compatible source (like MS Access, MySQL, SQL Server, Oracle, etc) to PostgreSQL. What i am trying to do is to open a txt file that has rows and columns of numbers so that it opens in the product in cells - when i try it just seems to display the page without any cell placement. A CSV is a comma separated values file which allows data to be saved in a table structured format. Important : do not forget to delete the exported csv file from your hard drive when you are done. bin/mongorestore - MongoDB restore a dump bin/mongoexport - Export a single collection to test (JSON, CSV) bin/mongoimport - Import from JSON or CSV bin/mongofiles - Utility for putting and getting files from MongoDB GridFS bin/mongostat - Show performance statistics Aqui vamos usar apenas o mongod e mongo. Note: If you have opened the file in Excel to look at it, close it without saving. mongoimport is located in the bin directory (eg, /mongodb/bin or wherever you installed it). See fix problems importing an Outlook. • Rich experience with MongoDB 3. Important : do not forget to delete the exported csv file from your hard drive when you are done. To Import a CSV File. CSV file (comma-separated value). From the terminal, use the mongoimport command to import the Titanic CSV file into your Compose MongoDB deployment. CSV to JSON - array of JSON structures matching your CSV plus JSONLines (MongoDB) mode CSV to Keyed JSON - Generate JSON with the specified key field as the key value to a structure of the remaining fields, also known as an hash table or associative array. Because of the clean and light user interface, you can execute the typical MongoDB commands fast and effective, without using the MongoDB shell. We should make clear that by import and export in this article we mean dealing with data. How to Add Contacts to Gmail Using a CSV File. TXT file: Start with a list that has the same columns as the data you are importing. js driver to 3. As you said you are trying to import a MongoDB database, And you are using the MongoDB command such as mongorestore. MongoDB mongoimport with CSV Example. The CSV stands for comma separated values. If the Decimal Separator is a point then the default CSV separator will be a comma, but if the Decimal Separator is a comma, then the default CSV separator will be a semicolon. Both Windows and Mac users get garbage characters in Excel. Create a products database and a collection in MongoDB. Linux distribution. We can't edit the spool file enough to only take out the first page and delete the rest The way I worked around this in my old job was to stop any print jobs over 4 pages with the job name of 'Microsoft Outlook' or 'Microsoft Office Outlook'. When a file has the. Those quotation characters could be included in the data also, so an escape character is necessary. This is an Excel based VBA script used to import bulk. 2 Answers 2. json output. Comma separated values text files (. MongoBooster - MongoDB GUI Tool. com MongoDB is meant for rapid and agile web development (say bye to migrations) If MongoDB had existed 10 years ago the vast majority of data used to drive modern web applications would be stored in MongoDB and not a relational database. As soon as you do that, all the passwords will be added to the list of the saved passwords. csv) text file format. mongoimport - Convert data from JSON, TSV or CSV and insert them into a collection mongoexport - Write an existing collection to CSV or JSON format mongodump/mongorestore - Dump MongoDB backups to disk in. Import Amazon S3 files into SQL Server (CSV, JSON or XML files). 4, which provides update-in-place, fluent query builder, ES6 syntax support and true intellisen. • Rich experience with MongoDB 3. This may be necessary to make sure that the import or export operation works the way that you want it to. You can import contact lists and address books that are saved in a comma-separated (. I am trying to Import data from csv file to mongodb CSV file having bellow data 7259555112 774561213 3 4 7259555112 774561214 4 5 7259555112 774561215 1 3 7259555112 774561216 the-mongodb MongoDB is a scalable, high-performance, open source, document-oriented database. Follow these simple steps to import the CSV : Step 1: Go to the directory where MongoDB is kept. 4 Pitfalls when importing MongoDB into Redshift. test employee = db. json mongoexport --collection collection --out collection. ) Collection is the concept of MongoDB , which is equivalent to Table concepts in relational databases ( Oracle , SQL Server , MySQL ,. by using the mongod command), you can now connect to that instance and start working with MongoDB. This will tell you how to export or import a copy of a DHCP database. Export Wizard Export MongoDB to CSV, JSON, BSON/mongodump, SQL, and another collection in a few clicks with Studio 3T's Export Wizard. To do this, use the LOAD CSV clause. Click Tools drop-down box and click Web Options. RDF123 has Windows and Linux applications to download, a Java application and servlet. The program allows you to add, delete, recall, sort, zap, pack records, view and edit files in DOS or Windows character sets, get detailed database information, export dbf to Excel, import dbf database, convert dbf to csv, dbf to xls, xls to dbf, csv to dbf, search in a file. csv writes compliant files on Windows: use eol = "\r " on other platforms. You will see the Text Import dialog. This Script expect MIB information to be in CSV format. vrt file, which can be done in any simple text editor. csv extension, select the file. These cmdlets are the same as the Export-Csv and Import-CSV cmdlets, except that they do not save the CSV strings in a file. I also need to remove any single quotes from a specific field. Windows PowerShell Import-CSV Cmdlet. Running MongoDB deployments to which to connect. MongoDB already has a perfectly good (and much faster) mongoimport program that is available for free in the standard MongoDB community download. Create a NodeJS application to generate CSV using NodeJS and mongodb. 0 (either Relaxed or Canonical mode) by default. Maybe you're making the switch to MongoDB for the first time and migrating your data over, or maybe you have data from some other source that you'd like to have in your database, whatever the case we'll show you how to do it. Download and open a sample. On one hand, working with a CSV file couldn't be easier. The data can be imported using a file upload. This will override any data that is on Shopify. Import Contacts to Mail app in Win 10 After upgrading to Win 10 I can't figure out how to get my Outlook. On the toolbar, click Import. I have already added the account to the Mail app, but the contacts do not get automatically imported. Because it's annoying to import a large number of vcards unless you use a macro, I recommend exporting in CSV format. The issue is with Regional settings and it has been tested on Win 7. From the NodeChef Task Manager, click on DB actions > CSV / JSON import to. Convert your vCard files to CSV or LDIF in order to import them to Gmail (like A to G) or Outlook vCard to LDIF/CSV Converter Preferred to export Apple's Address Book to Mozilla Thunderbird. (AVG firewall. Click Import. The program allows exporting much more data than offered by the built-in export feature in Outlook, allowing the export of non-standard user-defined fields from Outlook and is quicker and easier to use. We'll hold your hand each step of the way, beginning with the libraries you will need to install and reference in your Python code in order to open a Mongo database and read from it, as well as the libraries needed to open and write to your PostgreSQL data. com is now LinkedIn Learning! To access Lynda. This makes it possible to export the applications localized data to a CSV format. This will produce a tab-delimited file in UTF-16 encoding, which you can convert in Windows Notepad. Live Mail, Mail, Outlook etc. To change it, click the folder icon below (import into folder) >> select "Import from File. Import Contacts from a CSV File Into Outlook In the database or spreadsheet program, export the contacts data to a CSV (comma separated values) file. csv Extension - List of programs that can open. The first part you need following the PROC IMPORT statement is the datafile argument. Intuitive interface and high performance of the desktop application save time for beginners and professional database developers and administrators. And the Employee. Studio 3T is the professional GUI and IDE for MongoDB available for Windows, Mac, and Linux. The CSV module allows you to read data from tutorial. With almost every database system exporting to CSV, the following recipe is sure to come in handy. Connect to MongoDB from Python - In this MongoDB Tutorial, we shall learn to connect to MongoDB from Python Application. Your JSON will appear below as a table. You can type whatever file name that you’d like The green part represents the file type,. We're the creators of MongoDB, the most popular database for modern apps, and MongoDB Atlas, the global cloud database on AWS, Azure, and GCP. CodeTwo Outlook Export is a free tool for exporting data from Microsoft Outlook to CSV text files. Spreadsheet. This article will show you how to import a CSV into MongoDB through the command line and the MongoDB shell. writerows (someiterable) Since open() is used to open a CSV file for reading, the file will by default be decoded into unicode using the system default encoding (see locale. Though, Outlook contacts are saved as PST but one can export contacts to vCard and other files formats such as MS Excel, CSV, etc as per requirements. convert csv to pst free download - OI Convert CSV, CSV To XLSX Convert Software, vCard VCF To CSV Converter Software, and many more programs All Windows Mac iOS Android. In this Spring Data MongoDB Example, we will build a Simple Spring Application and perform CRUD operations on the Mongo Database with the help of Spring Data MongoDB and MongoRepository. Microsoft Scripting Guy, Ed Wilson, is here. (*Note: the file name must be less than 64 characters otherwise Microsoft Access will not be able to import it). High-Performance Techniques for Importing CSV to SQL Server using PowerShell Posted on January 18, 2015 by Chrissy LeMaire — 35 Comments ↓ If you’ve ever tried to use PowerShell’s Import-CSV with large files, you know that it can exhaust all of your RAM. Net using C# and VB. Now I want to import data from. CSV extension, DBMS= is optional. * mongoimport -help. Highlight the table (or part of the table) that you want and copy it. When your CSV ain’t a file… Often you get your CSV data in a file. Running the attached Python script can be done a number of ways: 1. CSV Import Template; Windows Server (1) Archives. ) which they wish to import into a Windows 10 PC for use in the email app they are using there e. For CSV import (if you don't have excel) Choose the 'UTF-8' file option format if asked when importing. The import of data into MongoDB is done using the "mongoimport" command. UMongo Alternatives and Similar Software - AlternativeTo. Choose the Delimited option, then on the next screen, choose the Comma option. Running MongoDB deployments to which to connect. Please refer Bulk Import from CSV files about how to import CSV files or Bulk Import from JSON files about how to import JSON files.