PHPackages                             gpaddis/datalo - 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. [Utility &amp; Helpers](/categories/utility)
4. /
5. gpaddis/datalo

ActiveLibrary[Utility &amp; Helpers](/categories/utility)

gpaddis/datalo
==============

ISBN &amp; ISSN list generator for the SFX Dataloader.

v0.1.4(8y ago)218MITPHP

Since Sep 15Pushed 8y ago1 watchersCompare

[ Source](https://github.com/gpaddis/datalo)[ Packagist](https://packagist.org/packages/gpaddis/datalo)[ RSS](/packages/gpaddis-datalo/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependencies (3)Versions (6)Used By (0)

Datalo: List Converter for the SFX Dataloader
=============================================

[](#datalo-list-converter-for-the-sfx-dataloader)

[![Build Status](https://camo.githubusercontent.com/1019b32bd932b3acb8e1fbb7422c34c72eb2692f430bfe2a991b76d4147bf119/68747470733a2f2f7472617669732d63692e6f72672f677061646469732f646174616c6f2e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/gpaddis/datalo)[![StyleCI](https://camo.githubusercontent.com/bb271668656201ec55461edceeec61138eb5d8befd7a2efd6191d14050fc04bd/68747470733a2f2f7374796c6563692e696f2f7265706f732f3130313531353134342f736869656c643f6272616e63683d6d6173746572)](https://styleci.io/repos/101515144)

**Warning: this software is in development and might change significantly before v1.0 is released.**

A tool for librarians working with ExLibris' SFX
------------------------------------------------

[](#a-tool-for-librarians-working-with-exlibris-sfx)

When mass updating SFX target portfolios via the *dataloader*, we need a clean, tab separated list of ISBNs or ISSNs. Usually, we have to fetch the identifiers manually from messy lists (CSV, TSV, Excel), which have different standards for different publishers. The identifiers we need are sometimes merged in single fields, arbitrarily separated by different delimiters each time.

We start with this...

```
KBID,Title,PrintISBN,OnlineISBN,DOI
63601,Social Capital,978-1-60692-973-5,978-0-511-30338-8|978-1-60876-294-1,
103645,Georgia: Russian Foreign Energy Policy and Implications for Georgia's Energy Security (Global market briefings),978-1-905050-35-2,978-1-280-48056-0|978-1-905050-84-0,
117409,"Cellular Neural Networks and Their Applications: Proceedings of the 7th IEEE International Workshop on Cellular Neural Networks and Their Applications: Institute of Applied Physics, Johann Wolfgang Go",978-981-238-121-7,978-1-281-92935-8|978-981-277-679-2,

```

...aiming for this:

ISBNStatus9781606929735ACTIVE9780511303388ACTIVE9781608762941ACTIVE9781905050352ACTIVE9781280480560ACTIVE9781905050840ACTIVE...**Datalo** parses the first list in search of valid identifiers and generates the second **automatically** within seconds.

Requirements
------------

[](#requirements)

Datalo requires **PHP 7**. You will also need to have [composer](https://getcomposer.org/) installed in your system in order to install the script.

Installation
------------

[](#installation)

Install **datalo** globally on your system with **composer**. Open your terminal and digit:

```
$ composer global require gpaddis/datalo

```

After the installation, datalo will be available in any directory. Make sure to place the `$HOME/.composer/vendor/bin` directory (or the equivalent directory for your OS) in your $PATH so the datalo executable can be located by your system.

Usage
-----

[](#usage)

Use the command `datalo isbn` to process a **list of eBooks** (passed as the first argument, in our case: `eBook_list.csv`) and `datalo issn` for a **list of journals**. The second argument is the **destination file** you want to generate: `destination_file.txt`.

```
$ datalo isbn eBook_list.csv destination_file.txt

```

The script will detect the delimiter, extract all valid ISBNs from your source file and save them in the destination file. If the file already exists, you will get a warning. You can **overwrite an existing file** by setting the option `--force`:

```
$ datalo isbn eBook_list.csv destination_file.txt --force

```

### Status

[](#status)

If you don't specify an **activation status**, all identifiers are flagged as ACTIVE by default in the second column. You can set a custom status (ACTIVE / INACTIVE) or add any string using the option `--status` followed by a word or a sentence enclosed in *"quotation marks"*:

```
$ datalo isbn eBook_list.csv destination_file.txt --force --status "eBook list updated on 12.01.2017"

```

To save only the list of identifiers, set the `--status` explicitly to `NONE`.

### Delimiter

[](#delimiter)

If the delimiter-autodetection does not work, maybe the file has an unusual delimiter (say... pipe: `|`). In this case, you can use the option `--delimiter` to set a custom delimiter:

```
$ datalo isbn eBook_list.csv destination_file.txt --force --status INACTIVE --delimiter |

```

You will have to make sure that you are actually using the correct delimiter to avoid unexpected or partial results.

### Credits

[](#credits)

Copyright (c) 2017 Gianpiero Addis - MIT License

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity57

Maturing project, gaining track record

 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 ~1 days

Total

4

Last Release

3160d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/17858de4f7a60f8cf85710013e1e4c87b167c7fb0457d59902f6e645c1192a7d?d=identicon)[gpaddis](/maintainers/gpaddis)

---

Top Contributors

[![gpaddis](https://avatars.githubusercontent.com/u/29100294?v=4)](https://github.com/gpaddis "gpaddis (99 commits)")

---

Tags

dataloaderexlibrisisbnissnlibrarieslibrary-automationlibrary-cataloguelibrary-managementlibrary-systemssfxsfx-dataloader

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/gpaddis-datalo/health.svg)

```
[![Health](https://phpackages.com/badges/gpaddis-datalo/health.svg)](https://phpackages.com/packages/gpaddis-datalo)
```

###  Alternatives

[shlinkio/shlink

A self-hosted and PHP-based URL shortener application with CLI and REST interfaces

4.8k4.3k](/packages/shlinkio-shlink)[civicrm/civicrm-core

Open source constituent relationship management for non-profits, NGOs and advocacy organizations.

728272.9k20](/packages/civicrm-civicrm-core)[php-soap/wsdl

Deals with WSDLs

173.5M12](/packages/php-soap-wsdl)[phel-lang/phel-lang

Phel is a functional programming language that compiles to PHP

4743.5k10](/packages/phel-lang-phel-lang)[symfony/ai-bundle

Integration bundle for Symfony AI components

30282.3k6](/packages/symfony-ai-bundle)[aedart/athenaeum

Athenaeum is a mono repository; a collection of various PHP packages

245.2k](/packages/aedart-athenaeum)

PHPackages © 2026

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