/DATA_MIGRATION

Binary, CSV, JSON, SQL, and XML data migration scripts in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel).

Primary LanguageVisual Basic .NET

DATA_MIGRATION

Binary, CSV, JSON, SQL, and XML data migration scripts in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel).

Using Craigslist Missed Connections NYC/CHI/LA August 2015 posts as example data, scripts include 12 data migration processes in attached folders. Each folder contains examples in above programming language/software types.

  1. BINARY

  2. CSV

    • CSV to JSON Each script migrates CSV data into JSON format. Attached CSV file is included.
    • CSV to SQL Each script migrates CSV data into SQL database table. Attached CSV file is included.
    • CSV to XML Each script migrates CSV data into XML format. Attached CSV file is included.

  3. JSON

    • JSON to CSV Each script migrates JSON data into CSV format. Attached JSON file is included.
    • JSON to SQL Each script migrates JSON data into SQL database table. Attached JSON file is included.
    • JSON to XML Each script migrates JSON file into XML format. Attached JSON file is included.

  4. SQL

    • SQL to CSV Each script migrates SQL database table into CSV format. Attached SQLite table schema and database included.
    • SQL to JSON Each script migrates SQL database table into JSON format. Attached SQLite table schema and database included.
    • SQL to XML Each script migrates SQL database table into XML format. Attached SQLite table schema and database included.

  5. XML

    • XML to CSV Each script migrates XML data into CSV format. Attached XML file is included.
    • XML to JSON Each script migrates XML data into JSON format. Attached XML file is included.
    • XML to SQL Each script migrates XML data into SQL database tables. Attached XML file is included.

REQUIREMENT: Sscripts require various non-standard modules:

  • JSON scripts: Java - gson 2.2.2 jar file; R - jsonlite, VBA - VBA-JSON w/ MS Script Runtime library reference;
  • XML scripts: Python - lxml, R - XML, SAS - proc xsl;
  • SQL scripts: Java - SQLite jdbc jar file; PHP - PDO extension; R - RSQLite; SAS - ODBC; VBA - SQLite ODBC driver;