This repository contains the serialization components required for serializing PCAxis data represented in PAXIOM from .px-files or CNNM-enabled databases. It enables the conversion from PAXIOM to various formats.
- Csv
- DecimalJson
- Excel
- Html5Table
- Json
- Xml
- Json-stat v1 & v2 (https://json-stat.org/format/)
- Parquet (https://parquet.apache.org)
- SDMX (https://sdmx.org/)
- Xslx (https://learn.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/f780b2d6-8252-4074-9fe3-5d7bc4830968)
- .NET Core 3.1 or later.
dotnet add package PCAxis.Serializers using System;
using System.IO;
using PCAxis.Paxiom;
using PCAxis.Serializers;
namespace MyPxConverter
{
class Program
{
static void Main(string[] args)
{
if (args.Length == 0)
{
Console.WriteLine("Please provide the PX filename as an argument.");
return;
}
string pxFileName = args[0];
string baseFileName = Path.GetFileNameWithoutExtension(pxFileName);
string outputFileName = $"{baseFileName}.parquet";
try
{
// Initialize and build the PX file model
var builder = new PXFileBuilder(pxFileName);
var selection = Selection.SelectAll(builder.Model.Meta);
builder.BuildForPresentation(selection);
// Serialize to Parquet
using (var stream = new FileStream(outputFileName, FileMode.Create))
{
var parquetSer = new ParquetSerializer();
parquetSer.Serialize(builder.Model, stream);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
}We welcome contributions to this project. Please see CONTRIBUTING.md for details.
This project is licensed under the Apache-2.0 License - see the LICENSE file for details.
For support, feature requests, and bug reporting, please open an issue on the GitHub project page.
- PxWeb Project Website
- PxWeb on GitHub
- For the C# Serializers, see PxWeb issue #163.