PHPackages                             dprmc/clear-structure-sentry-data-service - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. dprmc/clear-structure-sentry-data-service

ActiveLibrary[API Development](/categories/api)

dprmc/clear-structure-sentry-data-service
=========================================

A library that allows you to import standard import files into the Sentry system.

v2.0.21(9mo ago)04.2k[2 PRs](https://github.com/DPRMC/ClearStructure-Sentry-DataService/pulls)MITPHP

Since Jul 13Pushed 9mo ago1 watchersCompare

[ Source](https://github.com/DPRMC/ClearStructure-Sentry-DataService)[ Packagist](https://packagist.org/packages/dprmc/clear-structure-sentry-data-service)[ RSS](/packages/dprmc-clear-structure-sentry-data-service/feed)WikiDiscussions master Synced 1w ago

READMEChangelog (10)Dependencies (4)Versions (41)Used By (0)

ClearStructure - Sentry - Data Service
======================================

[](#clearstructure---sentry---data-service)

[![Coverage Status](https://camo.githubusercontent.com/2d2f6e8ad69234047f5fd73ee9f4ef0c036e00d32d47990b7da7a21f93050268/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f4450524d432f436c6561725374727563747572652d53656e7472792d44617461536572766963652f62616467652e7376673f6272616e63683d6d6173746572)](https://coveralls.io/github/DPRMC/ClearStructure-Sentry-DataService?branch=master) [![Build Status](https://camo.githubusercontent.com/f43fcd3bfde7896b9707246909d21c45efb36e668967e4abe35fc9f5ed644b13/68747470733a2f2f7472617669732d63692e6f72672f4450524d432f436c6561725374727563747572652d53656e7472792d44617461536572766963652e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/DPRMC/ClearStructure-Sentry-DataService) [![Total Downloads](https://camo.githubusercontent.com/8b31f960d1661ffc4e006c68b5acbc51471c411d78a33f31e816cced76b1f869/68747470733a2f2f706f7365722e707567782e6f72672f6470726d632f636c6561722d7374727563747572652d73656e7472792d646174612d736572766963652f646f776e6c6f616473)](https://packagist.org/packages/dprmc/clear-structure-sentry-data-service) [![Latest Stable Version](https://camo.githubusercontent.com/085f44e1d2b6e23e64ed333503aea9f1910f247013fc550076686d9595369dae/68747470733a2f2f706f7365722e707567782e6f72672f6470726d632f636c6561722d7374727563747572652d73656e7472792d646174612d736572766963652f76657273696f6e)](https://packagist.org/packages/dprmc/clear-structure-sentry-data-service) [![License](https://camo.githubusercontent.com/5f85d0d10bee85685f4f0505c5ed3915af632376a74a0bad6acfa804a12dda71/68747470733a2f2f706f7365722e707567782e6f72672f6470726d632f636c6561722d7374727563747572652d73656e7472792d646174612d736572766963652f6c6963656e7365)](https://packagist.org/packages/dprmc/clear-structure-sentry-data-service)

ImportExcel
-----------

[](#importexcel)

Used to import Standard Import Files as defined by ClearStructure.

Check Sentry's documentation for the proper format if a Standard Import File.

```
// This will attempt to import the contents of 'standard_import_file.xlsx' into the UAT site.
// Change the 2nd parameter of the run() method to true to import to your production site.

use DPRMC\ClearStructure\Sentry\DataService\Services\ImportExcel;

$uatUrl           = 'http://your-uat-url';
$prodUrl          = 'http://your-prod-url';
$user             = 'yourSentryUserName';
$pass             = 'yourEncryptedSentryPassword';
$pathToImportFile = 'standard_import_file.xlsx';
$postToUAT        = true;

$importExcelResponse = ImportExcel::init( $uatUrl, $prodUrl, $user, $pass, $postToUAT )
                           ->setData($pathToImportFile)
                           ->run();

// Contents of $importExcelResponse->response() if everything goes well:
Array
(
    [time] => Carbon\Carbon Object
        (
            [date] => 2018-08-03 16:12:23.000000
            [timezone_type] => 3
            [timezone] => UTC
        )

    [name] => Security_Attribute_Update
    [num] => 2
    [runtime] => 296.8872
    [errors] => Array
        (
        )

    [warnings] => Array
        (
        )
)

// Call path() to get the local filepath of the xlsx that was uploaded to Sentry.
$importExcelResponse->path();
```

Deleting Data
-------------

[](#deleting-data)

```
$data   = [];
$data[] = [
    'scheme_identifier'          => 42,
    'scheme_name'                => 'SentryId',
    'market_data_authority_name' => 'DB',
    'action'                     => 'DELETE',
    'as_of_date'                 => '1/1/2018',
];

$data[] = [
    'scheme_identifier'          => 'ABCDEFGH1',
    'scheme_name'                => 'CUSIP',
    'market_data_authority_name' => 'DB',
    'action'                     => 'DELETE',
    'as_of_date'                 => '1/1/2018',
];

$deleteExcelResponse = DeleteExcelSecurityPricing::init( $uatUrl, $prodUrl, $user, $pass, $postToUAT )
                                  ->setData($data)
                                  ->delete();

```

Testing
-------

[](#testing)

Want to run the PHPUnit tests?

```
foo@bar:~$ php ./phpunit-5.7.27.phar
```

###  Health Score

44

—

FairBetter than 90% of packages

Maintenance58

Moderate activity, may be stable

Popularity21

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity75

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~70 days

Recently: every ~101 days

Total

38

Last Release

272d ago

Major Versions

v0.18 → v1.02018-08-02

v1.0.7 → v2.0.02019-12-27

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/17033570?v=4)[DPRMC](/maintainers/DPRMC)[@DPRMC](https://github.com/DPRMC)

---

Top Contributors

[![michaeldrennen](https://avatars.githubusercontent.com/u/5288190?v=4)](https://github.com/michaeldrennen "michaeldrennen (87 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/dprmc-clear-structure-sentry-data-service/health.svg)

```
[![Health](https://phpackages.com/badges/dprmc-clear-structure-sentry-data-service/health.svg)](https://phpackages.com/packages/dprmc-clear-structure-sentry-data-service)
```

###  Alternatives

[statamic/cms

The Statamic CMS Core Package

4.8k3.5M901](/packages/statamic-cms)[team-reflex/discord-php

An unofficial API to interact with the voice and text service Discord.

1.1k406.5k25](/packages/team-reflex-discord-php)[temporal/sdk

Temporal SDK

4082.7M22](/packages/temporal-sdk)[smodav/mpesa

M-Pesa API implementation

16167.1k1](/packages/smodav-mpesa)[icawebdesign/hibp-php

PHP library for accessing the Have I Been Pwned API.

2548.8k2](/packages/icawebdesign-hibp-php)[codebar-ag/laravel-docuware

DocuWare integration with Laravel

1122.7k](/packages/codebar-ag-laravel-docuware)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)