Skip to the content
Documentation
Help Start
Reading in:
  • German: 9,059 of 9,059 pages
About the help in other languages
All help pages

Patterns in extension/sqliimport

Every class, view, fetch function, operator and plugin point of extension/sqliimport with its design patterns.

Download as PDF

Address: https://doc.exponential.earth/exphelp/viewer/standards/patterns/area-extension-sqliimport.md

On this page

Patterns in extension/sqliimport

Note

This page is generated from the source code by php bin/php/exppatterncatalogue.php --write. Do not edit it by hand: change the code or the generator, then run the command again. How the patterns are recognized: the pattern catalogue.

Every class, interface and trait of extension/sqliimport with the patterns it was recognized as, followed by the module views, policy functions, fetch functions, template operators, cronjobs, event hooks and INI plugin points of the area. All patterns.

Classes (203)

ClassKindPatternsFileDescription
expImportclassUtility (static helper)extension/sqliimport/classes/exp/expimport.php:13The small shared helpers of the 2.x engine: time, JSON, settings, the storage directory and the audit trail.
expImportAbstractSourceabstract class implements expImportSourceInterfaceTemplate Method / abstract base classextension/sqliimport/classes/exp/expimportabstractsource.php:14The common part of the file sources: the configuration, the record reference from a key field, the sample and the text encoding.
expImportAdminclassUtility (static helper)extension/sqliimport/classes/exp/expimportadmin.php:15What the admin pages of the Imports tab show: the figures of the dashboard, the imports with their last run and next schedule, the runs filtered by v…
expImportAiclassUtility (static helper)extension/sqliimport/classes/exp/ai/expimportai.php:35The AI assist of the import editor and the run page, through the extension expai (expImportAiExpaiTransport):
expImportAiExceptionclass extends expImportExceptionException hierarchyextension/sqliimport/classes/exp/ai/expimportaitransport.php:39The AI assist could not answer: not available, refused (switch, permission, data policy, budget) or unreadable.
expImportAiExpaiTransportclass implements expImportAiTransportStrategy / handlerextension/sqliimport/classes/exp/ai/expimportaiexpaitransport.php:25The AI assist through the extension expai (Exponential Intelligence), the only way it reaches a model.
expImportAirtableSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportairtablesource.php:30The records of an Airtable table through the Airtable Web API (v0): one record is one row of the table (of a view, of a formula's filter), its fields…
expImportAiTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/ai/expimportaitransport.php:16The way the AI assist of 7x SQLI Import (expImportAi) reaches a model.
expImportApiHttpclassUtility (static helper)extension/sqliimport/classes/exp/sources/expimportapihttp.php:18The JSON requests of the sources that read a hosted service's API with a token (Airtable, Notion, Supabase, Baserow, Salesforce, HubSpot): a pause be…
expImportArangoDbSourceclass extends expImportHttpQuerySourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportarangodbsource.php:23The results of an AQL query against ArangoDB, read through its HTTP cursor API.
expImportArrowclass–extension/sqliimport/classes/exp/formats/expimportarrow.php:23A reader of Apache Arrow IPC data in PHP alone: the file format (ARROW1 ...
expImportArrowSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportarrowsource.php:19Apache Arrow IPC files (.arrow), Feather version 2 files (.feather, the same format) and Arrow IPC streams (.arrows), as pandas, Polars, R and DuckDB…
expImportAuditBranchclass implements expAuditTaxonomyBranchINI plugin point (extension point)extension/sqliimport/classes/exp/expimportauditbranch.php:15The audit taxonomy branch of 7x SQLI Import (registered in settings/audit.ini.append.php): system.import., one event per run that starts, ends, fails…
expImportAvroclass–extension/sqliimport/classes/exp/formats/expimportavro.php:24A reader of Apache Avro object container files (Avro 1.x specification), in PHP alone: the header (magic Obj1, the metadata with avro.schema and avro…
expImportAvroSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportavrosource.php:18Apache Avro object container files (.avro), as Kafka connectors, Hadoop and data pipelines write them: one record is one Avro record, nested records…
expImportAwsSigV4classUtility (static helper)extension/sqliimport/classes/exp/sources/expimportawssigv4.php:17AWS Signature Version 4 for a request to an AWS service (no SDK): the canonical request, the string to sign, the signing key derived from the secret…
expImportBaserowSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportbaserowsource.php:29The rows of a Baserow table through its REST API (baserow.io or a self-hosted Baserow): one record is one row, its fields the table's fields by name…
expImportBigQuerySourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportbigquerysource.php:33The rows of a Google BigQuery query (GoogleSQL), read through the BigQuery REST API v2 with a service account (expImportGoogleAuth).
expImportBoltClientclassFactory and static factory methodsextension/sqliimport/classes/exp/nosql/expimportboltclient.php:37A minimal client of the Bolt protocol, versions 4.0 to 4.4 (Neo4j 4 and 5, Memgraph), for a PHP without a Neo4j driver: the handshake, HELLO with bas…
expImportBoltSocketclass implements expImportBoltTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportbolttransport.php:35A TCP connection, with TLS (certificate and name verified) for bolt+s:// and neo4j+s://.
expImportBoltStructureclass–extension/sqliimport/classes/exp/nosql/expimportboltclient.php:13A structure of PackStream as the server sent it: a node, a relationship, a path, a temporal value, a point.
expImportBoltTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/nosql/expimportbolttransport.php:13The byte stream the Bolt client (expImportBoltClient) talks over: a socket (expImportBoltSocket) or a test double.
expImportCassandraClientclass implements expImportCassandraTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportcassandraclient.php:23A minimal client of the CQL native protocol, version 4 (Cassandra 2.2 and later, ScyllaDB), over a socket (driver "socket"), for a PHP without the ex…
expImportCassandraExtensionclass implements expImportCassandraTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportcassandraextension.php:15The Cassandra/ScyllaDB source's connection through the PHP extension cassandra of DataStax (Cassandra\Cluster, Cassandra\SimpleStatement).
expImportCassandraSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportcassandrasource.php:30The rows of a CQL SELECT against Apache Cassandra or ScyllaDB.
expImportCassandraTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/nosql/expimportcassandratransport.php:21The connection the Cassandra/ScyllaDB source reads through: the PHP extension cassandra of DataStax (expImportCassandraExtension) where it is install…
expImportCieSourceclass extends expImportCsvSourceFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportciesource.php:17The CSV export of CIE (bccie): the form submissions of an information collector, one row each.
expImportClickHouseSourceclass extends expImportHttpQuerySourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportclickhousesource.php:27The rows of a SELECT against ClickHouse, read through its HTTP interface (port 8123, or 8443 with TLS) in the format JSONEachRow.
expImportCloudHttpclassUtility (static helper)extension/sqliimport/classes/exp/sources/expimportcloudhttp.php:18The JSON requests of the sources that read a cloud database over its HTTPS API (Amazon DynamoDB, Firestore, BigQuery, Firebase Realtime Database): th…
expImportCommandclassCommand (console, scripts, cronjobs), Factory and static factory methodsextension/sqliimport/classes/exp/expimportcommand.php:17The commands ./console ext:sqliimport: (extension/sqliimport/bin/php/.php); each file only calls expImportCommand::main( '' ).
expImportCommerceclassUtility (static helper)extension/sqliimport/classes/exp/sources/expimportcommerce.php:14What the product feed sources share: prices as decimal strings with their currency, lists written in one cell, and the mapping preset to the class pr…
expImportContentLineSourceabstract class extends expImportAbstractSourceTemplate Method / abstract base classextension/sqliimport/classes/exp/sources/expimportcontentlinesource.php:21The common part of the text formats made of "content lines" (iCalendar, RFC 5545, and vCard, RFC 6350 and 2426):
expImportContextclass–extension/sqliimport/classes/exp/engine/expimportcontext.php:14What a handler gets besides the record: the run and its import, the validated options, the target, the behaviour, the log, whether this is a dry run,…
expImportCosmosDbSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportcosmosdbsource.php:31The items of an Azure Cosmos DB container (the API for NoSQL, formerly the SQL API) that a query selects, read through the REST API.
expImportCouchbaseSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportcouchbasesource.php:31The results of a SQL++ (N1QL) query of Couchbase Server or Capella, read through the REST API of the Query service (/query/service, port 8093, with T…
expImportCouchDbSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportcouchdbsource.php:32The documents of a CouchDB database (also PouchDB servers and IBM Cloudant, which speak the same API), read over HTTP: all documents (_all_docs), the…
expImportCrawlerclassFactory and static factory methodsextension/sqliimport/classes/exp/crawl/expimportcrawler.php:25The polite reader of public web pages behind the formats sitemap and webpage.
expImportCrawlSourceabstract class extends expImportJsonSourceTemplate Method / abstract base classextension/sqliimport/classes/exp/sources/expimportcrawlsource.php:16The common part of the formats that read public web pages (sitemap, webpage).
expImportCronclassUtility (static helper)extension/sqliimport/classes/exp/expimportcron.php:28When a schedule runs next.
expImportCssSelectorclassUtility (static helper)extension/sqliimport/classes/exp/crawl/expimportcssselector.php:21The selectors of the "picks" of the crawl sources: a practical subset of CSS turned into XPath, or XPath itself (written "xpath:"), and the value to…
expImportCsvSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportcsvsource.php:16CSV and TSV files, read as a stream: one record per line (a quoted field may span lines), keyed by the header line.
expImportDataTableFieldsclassUtility (static helper)extension/sqliimport/classes/exp/expimportdatatablefields.php:18The fields of a new data table, guessed from the sample of a source (the kernel's "Module table" wizard asks for them through expImportDataTableField…
expImportDataTableFieldSourceclass extends expImportDataTableFieldSourceBase implements expDataTableFieldSourceINI plugin point (extension point)extension/sqliimport/classes/exp/expimportdatatablefieldsource.php:18–
expImportDataTableFieldSourceBaseabstract classTemplate Method / abstract base classextension/sqliimport/classes/exp/expimportdatatablefieldsourcebase.php:17The fields of an import's source for the kernel's "Module table" wizard (Exponential 6.0.15, the data table layer): the card "Create a new table from…
expImportDataTableHandlerclass implements expImportHandlerInterfaceINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/exp/handlers/expimportdatatablehandler.php:23The target "A data table": each record becomes a row of a persistent class (a module's own table, Exponential 6.0.15, Setup › Data tables), written t…
expImportDataTablesclassUtility (static helper)extension/sqliimport/classes/exp/expimportdatatables.php:16The data tables of Exponential 6.0.15 (Setup › Data tables) as 7x SQLI Import offers them: the catalogue's group "Data tables" (import into a table,…
expImportDefinitionclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methodsextension/sqliimport/classes/exp/model/expimportdefinition.php:24An import (sqliimport_definition): where the data comes from, what processes it (the no-code mapping or a handler), where the content goes, how it be…
expImportDocumentHttpclassUtility (static helper)extension/sqliimport/classes/exp/nosql/expimportdocumenthttp.php:21What the document stores read over HTTP have in common (CouchDB, the Couchbase Query service, Azure Cosmos DB): the check of the server address (http…
expImportDrupalSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportdrupalsource.php:23Content of a Drupal site through its JSON:API (core module jsonapi, Drupal 8.7 and later).
expImportDuckDbSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportduckdbsource.php:33The rows of a DuckDB query over files on the server: Parquet, CSV or JSON files (one or many, also a pattern such as data/*.parquet), or a DuckDB dat…
expImportDynamoDbSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportdynamodbsource.php:34The items of an Amazon DynamoDB table or index, read through the DynamoDB HTTPS JSON API (protocol version 20120810) with AWS Signature Version 4 (ex…
expImportEditorclass–extension/sqliimport/classes/exp/expimporteditor.php:28The import editor of the administration (sqliimport/edit): six steps, each a form that is saved on its own, so an import is never lost half-way and e…
expImportExceptionclass extends RuntimeExceptionException hierarchyextension/sqliimport/classes/exp/expimportexception.php:11The base of the exceptions of the 2.x engine.
expImportExponentialSiteSourceclass extends expImportJsonSourceFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportexponentialsitesource.php:26Content of another Exponential site through its REST API (v1, the API of the mobile applications, served by the extension ezprestapi): the source rea…
expImportExternalFileclassFactory and static factory methods, Utility (static helper)extension/sqliimport/classes/exp/expimportexternalfile.php:25A file another tool hands to Imports: "Re-import this file" of an export, the file of a CIE export.
expImportEzpkgSourceclass extends expImportAbstractSourceFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportezpkgsource.php:26A package of Exponential's package system (.ezpkg: a tar.gz with package.xml, ezcontentobject/contentobjects.xml and one XML file per content object,…
expImportFirebaseSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportfirebasesource.php:29The children of a path of a Firebase Realtime Database, read through its REST API (GET .json).
expImportFirestoreSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportfirestoresource.php:34The documents of a Google Cloud Firestore collection (or collection group), read through the Firestore REST API v1 with a service account (expImportG…
expImportFrontMatterclassUtility (static helper)extension/sqliimport/classes/exp/expimportfrontmatter.php:15Front matter of Markdown files (Jekyll, Hugo, Obsidian, Eleventy ...): YAML between "---" lines or TOML between "+++" lines at the start of the file,…
expImportFunctionCollectionclassFetch function (Query Object, Facade), Utility (static helper)extension/sqliimport/classes/exp/expimportfunctioncollection.php:11The template fetch functions of the module sqliimport (modules/sqliimport/function_definition.php).
expImportGoogleAuthclassUtility (static helper)extension/sqliimport/classes/exp/sources/expimportgoogleauth.php:21The access token of a Google Cloud service account, for the sources that read Firestore, BigQuery and the Firebase Realtime Database: the service acc…
expImportGoogleMerchantSourceclass extends expImportXmlSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportgooglemerchantsource.php:28Google Merchant Center product feeds: RSS 2.0 (or Atom) with the g: namespace, as shops export their catalogue for Google Shopping and many price com…
expImportGoogleSheetsSourceclass extends expImportCsvSourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportgooglesheetssource.php:15A Google Sheets spreadsheet by its address: the link of the sheet (shared so that anyone with the link can view) or its "Publish to the web" link.
expImportHandlerInterfaceinterfaceInterface (contract)extension/sqliimport/classes/exp/engine/expimporthandlerinterface.php:21A handler of the 2.x engine: it turns records into content.
expImportHttpQuerySourceabstract class extends expImportJsonSourceTemplate Method / abstract base classextension/sqliimport/classes/exp/sources/expimporthttpquerysource.php:19What the sources have in common that send a query in a database's own language to its HTTP API (Neo4j, ArangoDB, ClickHouse, Snowflake, InfluxDB): th…
expImportHubSpotSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimporthubspotsource.php:34The objects of a HubSpot CRM object type through the CRM API v3: contacts, companies, deals, tickets, products, line items or a custom object (by its…
expImportIcalSourceclass extends expImportContentLineSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimporticalsource.php:29iCalendar files (.ics, RFC 5545), as calendars, booking systems and event platforms publish them, from a file or an address.
expImportImapClientclass implements expImportImapTransportStrategy / handlerextension/sqliimport/classes/exp/mail/expimportimapclient.php:20A small IMAP4rev1 client (RFC 3501) for PHP without the imap extension: it speaks just what the IMAP source needs, over TLS from the start (port 993)…
expImportImapExtensionclass implements expImportImapTransportStrategy / handlerextension/sqliimport/classes/exp/mail/expimportimapextension.php:14The IMAP transport of the PHP extension imap (imap_open).
expImportImapSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportimapsource.php:22The messages of an IMAP mailbox (a press inbox, a submissions address): one record is one message, with its message ID, sender, recipients, subject,…
expImportImapTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/mail/expimportimaptransport.php:15The connection to an IMAP mailbox the IMAP source reads: the PHP extension imap where it is installed (expImportImapExtension), else a small client o…
expImportInfluxDbSourceclass extends expImportHttpQuerySourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportinfluxdbsource.php:29The rows of a query against InfluxDB: Flux through the API of InfluxDB 2 and Cloud (POST /api/v2/query, the answer in annotated CSV), or InfluxQL thr…
expImportJobHandlerclass extends expQueueHandlerBaseINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/exp/engine/expimportjobhandler.php:19The jobs of a run in the job queue (expqueue.ini [JobType_sqliimport.*]): sqliimport.run, sqliimport.chunk and sqliimport.finish (see expImportRunner…
expImportJoomlaSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportjoomlasource.php:22Joomla articles (com_content) exported as CSV (the columns of the content table: id, title, alias, introtext, fulltext, catid or category, state, cre…
expImportJsonSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportjsonsource.php:15JSON and NDJSON files.
expImportLdapExtensionclass implements expImportLdapTransportStrategy / handlerextension/sqliimport/classes/exp/ldap/expimportldapextension.php:15The LDAP transport of the PHP extension ldap: LDAPv3, referrals not followed, the certificate of ldaps:// and StartTLS demanded, searches with ldap_s…
expImportLdapSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportldapsource.php:33The entries of an LDAP directory (OpenLDAP, Active Directory, 389 Directory Server ...): one record is one entry of a search, its fields the DN (dn)…
expImportLdapTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/ldap/expimportldaptransport.php:15What the LDAP source needs of a directory server: connect, StartTLS, bind and search, nothing that writes.
expImportLegacyclassUtility (static helper)extension/sqliimport/classes/exp/expimportlegacy.php:24What the 2.x pages do with the import requests (sqliimport_item, SQLIImportItem) and the scheduled imports (sqliimport_scheduled, SQLIScheduledImport…
expImportLegacyHandlerAdapterclass implements expImportHandlerInterface, expImportRecordProviderInterfaceAdapter / bridge / wrapper, Strategy / handlerextension/sqliimport/classes/exp/handlers/expimportlegacyhandleradapter.php:21Runs a handler of sqliimport 1.x (ISQLIImportHandler extending SQLIImportAbstractHandler) in the 2.x engine, untouched: the handler is built with its…
expImportLoggerclass–extension/sqliimport/classes/exp/engine/expimportlogger.php:15The log of a run (sqliimport_run_log), what upstream PR #13 asked for: every warning, error and notice of a run, with the record it is about and a co…
expImportMailMessageclassUtility (static helper)extension/sqliimport/classes/exp/mail/expimportmailmessage.php:16An e-mail message (RFC 5322 with MIME) as a record: the message ID, sender and recipients, the subject and the names of the headers decoded to UTF-8…
expImportMapperclassUtility (static helper)extension/sqliimport/classes/exp/expimportmapper.php:30The no-code mapping: which source field fills which attribute of a content class, how a record finds the object it updates, and where a new object is…
expImportMappingclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methodsextension/sqliimport/classes/exp/model/expimportmapping.php:14The no-code mapping of an import (sqliimport_mapping, one row) and its lines (sqliimport_mapping_field).
expImportMappingFieldclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/model/expimportmapping.php:128One line of a mapping (sqliimport_mapping_field).
expImportMappingHandlerclass implements expImportHandlerInterfaceStrategy / handlerextension/sqliimport/classes/exp/handlers/expimportmappinghandler.php:23The no-code handler "mapping": it applies the import's mapping (expImportMapper) to each record and publishes the result with the content API of 1.x…
expImportMarkdownclassFactory and static factory methodsextension/sqliimport/classes/exp/expimportmarkdown.php:22Markdown to HTML for imported content, without a library: the Markdown that notes, blogs and documentation use.
expImportMarkdownSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportmarkdownsource.php:29Markdown files with front matter, one file or a ZIP of a folder (a Jekyll or Hugo site, an Obsidian vault, a documentation folder).
expImportMediaSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportmediasource.php:27Media files: a ZIP of a folder (photos, documents, audio, video) or one file.
expImportMigrationclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportmigration.php:25The migration of an installation of sqliimport 1.x (./console ext:sqliimport:migrate-1x):
expImportMongoDbExtensionclass implements expImportMongoDbTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportmongodbextension.php:15The MongoDB source's connection through the PHP extension mongodb (MongoDB\Driver\Manager, without the composer library).
expImportMongoDbSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportmongodbsource.php:28The documents of a MongoDB collection: one record is one document, its nested documents flattened into dotted fields (author.name) and its BSON value…
expImportMongoDbTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/nosql/expimportmongodbtransport.php:15The connection the MongoDB source reads through: the PHP extension mongodb (expImportMongoDbExtension), or a test double.
expImportNeo4jSourceclass extends expImportHttpQuerySourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportneo4jsource.php:33The rows of a Cypher query against Neo4j or Memgraph.
expImportNoticeclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/engine/expimportnotifier.php:218A notice of a run for a user (sqliimport_notice).
expImportNotifierclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportnotifier.php:22Who hears of a run that ended, by the import's settings (Processing step, behaviour):
expImportNotionSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportnotionsource.php:32The pages of a Notion database through the Notion API (version 2022-06-28): one record is one page (one row of the database), its fields the database…
expImportOpmlSourceclass extends expImportAbstractSourceFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportopmlsource.php:25OPML files (outline lists; most often the list of feeds a feed reader exports).
expImportOptionSchemaclassFactory and static factory methods, Utility (static helper)extension/sqliimport/classes/exp/expimportoptionschema.php:28Typed options.
expImportPlatformHttpclassUtility (static helper)extension/sqliimport/classes/exp/sources/expimportplatformhttp.php:20The HTTP requests of the sources that read a site's API themselves (Drupal JSON:API, another Exponential site).
expImportPreviewclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportpreview.php:21The sample and the preview of the import editor, in the request itself (no job, no run stored):
expImportPriceclassUtility (static helper)extension/sqliimport/classes/exp/expimportprice.php:17The value of a price attribute (ezprice) as the kernel reads and writes it: "price|VAT type id|1 or 0" (VAT included).
expImportRecordclassFactory and static factory methodsextension/sqliimport/classes/exp/expimportrecord.php:17One record read from a source: its stable reference (a key or a line number), its position, its data and the cursor that resumes the source right aft…
expImportRecordProviderInterfaceinterfaceInterface (contract)extension/sqliimport/classes/exp/engine/expimporthandlerinterface.php:52A handler that reads its records itself (a 1.x handler through the adapter): the engine takes the records from it instead of from a source.
expImportRedisClientclass implements expImportRedisTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportredisclient.php:15A minimal Redis client over a socket (driver "socket"), for a PHP without the extension redis: commands as RESP arrays of bulk strings, answers in RE…
expImportRedisExtensionclass implements expImportRedisTransportStrategy / handlerextension/sqliimport/classes/exp/nosql/expimportredisextension.php:15The Redis source's connection through the PHP extension redis (phpredis, driver "phpredis").
expImportRedisSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportredissource.php:26The keys of a Redis database that match a pattern: one record is one key, with _key (its name), _type and _ttl, and its value by type: a hash's field…
expImportRedisTransportinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/exp/nosql/expimportredistransport.php:15The connection the Redis source reads through: the PHP extension redis (expImportRedisExtension), else a small RESP client of its own over a socket (…
expImportRegistryclassINI plugin point (extension point), Registry, Singleton / instance()extension/sqliimport/classes/exp/engine/expimportregistry.php:23The catalogue of a site: its sources, handlers and transforms.
expImportReportclassUtility (static helper)extension/sqliimport/classes/exp/expimportreport.php:18The CSV report of a run: one line per record with what was done to which object.
expImportRestApiHttpclass extends expImportPlatformHttpUtility (static helper)extension/sqliimport/classes/exp/sources/expimportrestapihttp.php:20The requests of the REST API source (rest_api) on the network.
expImportRestApiSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportrestapisource.php:37The records of any JSON REST API, read page by page (rest_api): one record is one object of the list of an answer, at its top or at a record path (da…
expImportRobotsclassFactory and static factory methodsextension/sqliimport/classes/exp/crawl/expimportrobots.php:19The rules of one host's robots.txt (RFC 9309): groups of User-agent lines with their Allow and Disallow rules and Crawl-delay, and the Sitemap lines.
expImportRowResultclassFactory and static factory methodsextension/sqliimport/classes/exp/engine/expimportrowresult.php:14What a handler did with one record: the outcome, the object, its version before and after, the nodes it added and a message.
expImportRssSourceclass extends expImportXmlSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportrsssource.php:18RSS 2.0 and Atom feeds, from a file or a URL (the engine downloads a URL into the run's snapshot first).
expImportRunclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/model/expimportrun.php:17One run of an import (sqliimport_run): who and what started it, its job group in expqueue, its status and counters.
expImportRunLogclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/model/expimportrun.php:259A line of the log of a run (sqliimport_run_log): severity, the record it is about, message, context.
expImportRunnerclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportrunner.php:23Starts, cancels and watches runs.
expImportRunRowclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/model/expimportrun.php:217One record of a run (sqliimport_run_row): what was done to which object.
expImportSalesforceSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportsalesforcesource.php:37The records of a SOQL query through the Salesforce REST API: one record is one row of the answer, relationship fields flattened to dotted names (Acco…
expImportScheduleclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/exp/model/expimportschedule.php:18When an import runs by itself (sqliimport_schedule).
expImportSchedulerclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportscheduler.php:15The work of the cron part "sqliimport" (every minute): start the runs of the schedules that are due, end runs whose jobs ended without them, hand the…
expImportSchemaclassUtility (static helper)extension/sqliimport/classes/exp/expimportschema.php:35The tables of 7x SQLI Import, defined once here in the kernel's generic schema format.
expImportSearchSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportsearchsource.php:34The documents of an Elasticsearch or OpenSearch index (or index pattern), read through the search API over HTTP.
expImportSecretsclassUtility (static helper)extension/sqliimport/classes/exp/expimportsecrets.php:25Secrets of sources (database passwords, mailbox passwords, API keys).
expImportServerFunctionsclass extends ezjscServerFunctionsINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/expimportserverfunctions.php:22The ezjscore server functions of the Imports tab (ezjscore.ini [ezjscServer_sqliimport]), called by javascript/sqliimport_admin.js through Exp.io:
expImportShopCsvSourceabstract class extends expImportCsvSourceTemplate Method / abstract base classextension/sqliimport/classes/exp/sources/expimportshopcsvsource.php:18The product exports of shop systems as CSV, where one product may span several rows (its variants, its images): the file is read as the CSV source re…
expImportShopifyCsvSourceclass extends expImportShopCsvSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportshopifycsvsource.php:25The product CSV export of Shopify (Products, Export).
expImportSitemapSourceclass extends expImportCrawlSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportsitemapsource.php:17The sitemap crawl: the pages a site's sitemap lists (a sitemap, a sitemap index, or the Sitemap lines of robots.txt when a site's root is given), fil…
expImportSnowflakeSourceclass extends expImportHttpQuerySourceINI plugin point (extension point), Utility (static helper)extension/sqliimport/classes/exp/sources/expimportsnowflakesource.php:26The rows of a query against Snowflake, read through the SQL API v2 (POST /api/v2/statements) with key-pair authentication: a JWT signed with the user…
expImportSourceEntryclassFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/expimportsourceentry.php:37One entry of the catalogue of formats: a source class, or one variant of it (TSV is the CSV source with a tab, NDJSON the JSON source with one object…
expImportSourceExceptionclass extends expImportExceptionException hierarchyextension/sqliimport/classes/exp/expimportexception.php:16A source cannot be read (missing file, bad format, network error).
expImportSourceFilesclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimportsourcefiles.php:21Where the data of a run comes from, made into a local file once per run (the snapshot every chunk reads):
expImportSourceInterfaceinterfaceInterface (contract)extension/sqliimport/classes/exp/expimportsourceinterface.php:19A source type: it reads records from a file (or, for later source types, an endpoint).
expImportSpreadsheetSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportspreadsheetsource.php:16Spreadsheets: Excel (XLSX) and OpenDocument (ODS) files, read without a library: both are ZIP files of XML, read as streams (ext-zip and XMLReader).
expImportSqlSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportsqlsource.php:36The rows of an SQL query against a MySQL or MariaDB, PostgreSQL, SQLite, Oracle or SQL Server database, or against this site's own database when the…
expImportStatisticsclassUtility (static helper)extension/sqliimport/classes/exp/expimportstatistics.php:27The statistics of the run history: the charts of the dashboard (sqliimport/list) and the Statistics page (sqliimport/statistics) with its periods, fi…
expImportSupabaseSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportsupabasesource.php:34The rows of a table or view of a Supabase project through its REST API (PostgREST), or of any other PostgREST server: one record is one row, its fiel…
expImportTemplatesclassFactory and static factory methods, Utility (static helper)extension/sqliimport/classes/exp/expimporttemplates.php:28Templates of imports: an import definition without its source data (no file, address or server path, no schedules, trigger, run user or notification…
expImportTransferclassUtility (static helper)extension/sqliimport/classes/exp/expimporttransfer.php:38Import definitions as a JSON file, to move them between installations (staging to live), keep them with a project or share them: "Download as JSON" o…
expImportTransferRunsclassUtility (static helper)extension/sqliimport/classes/exp/engine/expimporttransferruns.php:20Imports in the run history of Exponential's import and export tools (kernel 6.0.15 and later, expKernelTransferHistory, table exp_transfer_run): ever…
expImportTransferSiteclass–extension/sqliimport/classes/exp/expimporttransfersite.php:18What expImportTransfer asks the site while it exports or reads import definitions: references for node, section and user IDs (so a definition names i…
expImportTransformExceptionclass extends expImportExceptionException hierarchyextension/sqliimport/classes/exp/expimportexception.php:21A value cannot be transformed; the record fails with this message.
expImportTransformInterfaceinterfaceInterface (contract)extension/sqliimport/classes/exp/expimporttransforminterface.php:18A named transform of a mapping line: it turns a source value into the value a class attribute takes (the fromString() form of its datatype).
expImportTransformsclassRegistry, Utility (static helper)extension/sqliimport/classes/exp/expimporttransforms.php:18The transforms of a mapping: the built-in ones and those of kernel services tagged sqliimport.transform.
expImportTriggerclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methodsextension/sqliimport/classes/exp/model/expimporttrigger.php:23The webhook / API trigger of an import (sqliimport_trigger), one row per import, off until it is switched on in the schedule step of the editor:
expImportTriggerAuthclassUtility (static helper)extension/sqliimport/classes/exp/expimporttriggerauth.php:86The checks of the webhook / API trigger of an import, without a database (expImportTriggerEndpoint does the request):
expImportTriggerCallStoreinterfaceInterface (contract)extension/sqliimport/classes/exp/expimporttriggerauth.php:14Where the trigger keeps its recent calls: the signatures already used (replay protection) and the calls counted by the rate limit.
expImportTriggerDbCallStoreclass implements expImportTriggerCallStore–extension/sqliimport/classes/exp/expimporttriggerauth.php:38The calls of the trigger in sqliimport_trigger_call.
expImportTriggerEndpointclass–extension/sqliimport/classes/exp/expimporttriggerendpoint.php:31What the view sqliimport/trigger answers (a machine, never a person; JSON, no session, no cookies, no CORS):
expImportTriggerKeyclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methods, Utility (static helper)extension/sqliimport/classes/exp/model/expimporttrigger.php:89An API key of a trigger (sqliimport_trigger_key): its label, its key id (the part of the key that finds it) and the HMAC of the key (expImportTrigger…
expImportUndoHandlerclass implements expImportHandlerInterfaceStrategy / handlerextension/sqliimport/classes/exp/handlers/expimportundohandler.php:22Takes the changes of an earlier run back (an undo run, run_kind undo).
expImportValidationExceptionclass extends expImportExceptionException hierarchyextension/sqliimport/classes/exp/expimportexception.php:26A definition, mapping, schedule or option is not valid.
expImportVcardSourceclass extends expImportContentLineSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportvcardsource.php:28vCard files (.vcf; versions 4.0, 3.0 and, as far as it goes, 2.1), as address books and phones export contacts.
expImportWebPageSourceclass extends expImportCrawlSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportwebpagesource.php:17The web page scraper: one page or a list of addresses, optionally an "item" selector that repeats on a page (a product of a list), so one page gives…
expImportWooCommerceCsvSourceclass extends expImportShopCsvSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportwoocommercecsvsource.php:30The product CSV export of WooCommerce (Products, Export, with the English column names).
expImportWxrSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportwxrsource.php:29WordPress export files (WXR, Tools › Export in WordPress): RSS 2.0 with the wp: namespace.
expImportXmlSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportxmlsource.php:18XML files, read as a stream with XMLReader: every element at the record path is one record, turned into an array (attributes as "@name", child elemen…
expImportXrowextractSourceclass extends expImportAbstractSourceFactory and static factory methods, INI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportxrowextractsource.php:21The export files of Export (xrowextract): a class export as CSV, JSON or XML, with or without its typed column manifest.
expImportYamlclassFactory and static factory methodsextension/sqliimport/classes/exp/expimportyaml.php:22YAML and TOML for data files and front matter, without a library and the same on every server (the PHP extension yaml reads YAML 1.1, where y and n a…
expImportYamlSourceclass extends expImportAbstractSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportyamlsource.php:16YAML and TOML data files: a list of records at the top or at a record path (products, data.items), as static site generators, configuration-driven ca…
expImportYouTubePageSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportyoutubepagesource.php:27The videos listed on a youtube.com page (a channel's /videos page or a playlist page), read from the page's ytInitialData without an API key.
expImportYouTubeSourceclass extends expImportJsonSourceINI plugin point (extension point)extension/sqliimport/classes/exp/sources/expimportyoutubesource.php:33The videos of a YouTube channel, of a playlist or of a search through the YouTube Data API v3: one record is one video with its details (title, descr…
ISQLIDiffHandlerinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/content/diffhandlers/isqlidiffhandler.php:27Interface for diff handlers.
ISQLIImportHandlerinterfaceInterface (contract), Strategy / handlerextension/sqliimport/classes/sourcehandlers/isqliimporthandler.php:11Interface for import handlers Must be implemented by all import handlers
SQLIBinaryFileDiffHandlerclass implements ISQLIDiffHandlerINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/content/diffhandlers/sqlibinaryfilediffhandler.php:17Diff handler for ezbinaryfile attributes.
SQLIContentclassFactory and static factory methodsextension/sqliimport/classes/content/sqlicontent.php:54Proxy class for eZContentObject.
SQLIContentExceptionclass extends SQLIImportBaseExceptionException hierarchyextension/sqliimport/classes/content/sqlicontentexception.php:15This exception is thrown when an issue related to content has been detected
SQLIContentFieldclassFactory and static factory methodsextension/sqliimport/classes/content/sqlicontentfield.php:15SQLIContentField is a proxy and simplified object for eZContentObjectAttribute
SQLIContentFieldsetclass implements IteratorFactory and static factory methods, Iteratorextension/sqliimport/classes/content/sqlicontentfiedset.php:12SQLIContentFieldset
SQLIContentFieldsetHolderclass implements ArrayAccess, IteratorFactory and static factory methods, Iteratorextension/sqliimport/classes/content/sqlicontentfieldsetholder.php:12SQLIFieldsetHolder
SQLIContentOptionsclass extends SQLIImportOptionsIteratorextension/sqliimport/classes/content/options/sqlicontentoptions.php:16Class containing basic options for SQLIContent
SQLIContentPublisherclassSingleton / instance()extension/sqliimport/classes/content/sqlicontentpublisher.php:26SQLIContentPublisher is a class allowing to publish a content $options = new SQLIContentOptions( array( 'class_identifier' =› 'article', 'remote_id'…
SQLIContentPublishOptionsclass extends SQLIImportOptionsIteratorextension/sqliimport/classes/content/options/sqlicontentpublishoptions.php:12–
SQLIContentUtilsclassUtility (static helper)extension/sqliimport/classes/content/sqlicontentutils.php:15Utility class aggregating several helper methods related to content
SQLICSVDocclass–extension/sqliimport/classes/sourcehandlers/csv/sqlicsvdoc.php:18Utility class for CSV file handling.
SQLICSVExceptionclass extends SQLIImportBaseExceptionException hierarchyextension/sqliimport/classes/sourcehandlers/csv/sqlicsvexception.php:13–
SQLICSVOptionsclass extends SQLIImportOptionsIteratorextension/sqliimport/classes/sourcehandlers/csv/sqlicsvoptions.php:13–
SQLICSVRowclass implements IteratorIteratorextension/sqliimport/classes/sourcehandlers/csv/sqlicsvrow.php:13–
SQLICSVRowSetclass implements ArrayAccess, Iterator, CountableFactory and static factory methods, Iteratorextension/sqliimport/classes/sourcehandlers/csv/sqlicsvrowset.php:13–
SQLIDefaultDiffHandlerclass implements ISQLIDiffHandlerINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/content/diffhandlers/sqlidefaultdiffhandler.php:18Default diff handler for content fields.
SQLIImageDiffHandlerclass implements ISQLIDiffHandlerINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/content/diffhandlers/sqliimagediffhandler.php:17Diff handler for ezimage attributes.
SQLIImportAbstractHandlerabstract classStrategy / handler, Template Method / abstract base classextension/sqliimport/classes/sourcehandlers/sqliimportabstracthandler.php:13Abstract class for all import handlers All import handlers must inherit from this class
SQLIImportBaseExceptionclass extends ezcBaseExceptionException hierarchyextension/sqliimport/classes/exceptions/sqliimportbaseexception.php:11SQLIImportBaseException
SQLIImportConfigExceptionclass extends SQLIImportBaseExceptionException hierarchyextension/sqliimport/classes/exceptions/sqliimportconfigexception.php:14This exception is thrown when a config issue has been detected
SQLIImportFactoryclassFactory and static factory methods, Singleton / instance()extension/sqliimport/classes/sqliimportfactory.php:12Import factory Will trigger import for all declared and activated import handlers
SQLIImportHandlerOptionsclass extends SQLIImportOptionsFactory and static factory methods, Iteratorextension/sqliimport/classes/sourcehandlers/options/sqliimporthandleroptions.php:16Options class for import handlers.
sqliimportInfoclassValue object / structextension/sqliimport/ezinfo.php:7–
SQLIImportItemclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methodsextension/sqliimport/classes/sqliimportitem.php:15Class handling items Objects of this class are stored in ezpending_actions table and are normally processed by CRON to trigger an import.
SQLIImportLoggerclassUtility (static helper)extension/sqliimport/classes/sqliimportlogger.php:12SQLIImportLogger Class for logging and/or display messages during import process
SQLIImportOptionsabstract class extends ezcBaseOptions implements IteratorIterator, Template Method / abstract base classextension/sqliimport/classes/options/sqliimportoptions.php:18Base of all options classes for SQLIImport Simple override of ezcBaseOptions from eZComponents, implementing Iterator interface
SQLIImportRuntimeExceptionclass extends SQLIImportBaseExceptionException hierarchyextension/sqliimport/classes/exceptions/sqliimportruntimeexception.php:14This exception is thrown when a runtime issue has been detected
SQLIImportTokenclass extends eZPersistentObjectActive Record (eZPersistentObject), Factory and static factory methods, Registry, Utility (static helper)extension/sqliimport/classes/sqliimporttoken.php:12Token class for SQLI Import Handles import status
SQLIImportUtilsclassUtility (static helper)extension/sqliimport/classes/sqliimportutils.php:11SQLIImportUtils
SQLILocationclassFactory and static factory methodsextension/sqliimport/classes/location/sqlilocation.php:12–
SQLILocationExceptionclass extends SQLIImportBaseExceptionException hierarchyextension/sqliimport/classes/location/sqlilocationexception.php:15This exception is thrown when an issue related to a location has been detected
SQLILocationSetclass implements ArrayAccess, IteratorIteratorextension/sqliimport/classes/location/sqlilocationset.php:12–
SQLIRSSImportHandlerclass extends SQLIImportAbstractHandler implements ISQLIImportHandlerINI plugin point (extension point), Strategy / handlerextension/sqliimport/classes/sourcehandlers/sqlirssimporthandler.php:12–
SQLIScheduledImportclass extends eZPersistentObjectActive Record (eZPersistentObject)extension/sqliimport/classes/sqlischeduledimport.php:11–
SQLIXMLExceptionclass extends SQLIImportBaseExceptionException hierarchy, Factory and static factory methodsextension/sqliimport/classes/sourcehandlers/xml/sqlixmlexception.php:13–
SQLIXMLInputParserclass extends eZXMLInputParser–extension/sqliimport/classes/ezxmltext/input/handlers/sqlixmlinputparser.php:19XML input parser to be used to add rich text (HTML) to a content.
SQLIXMLOptionsclass extends SQLIImportOptionsIteratorextension/sqliimport/classes/sourcehandlers/xml/sqlixmloptions.php:13–
SQLIXMLParserclass–extension/sqliimport/classes/sourcehandlers/xml/sqlixmlparser.php:13–

Module views (20)

ViewScriptPolicy functionsDefined in
/sqliimport/listlist.php–extension/sqliimport/modules/sqliimport/module.php:36
/sqliimport/runrun.php–extension/sqliimport/modules/sqliimport/module.php:44
/sqliimport/mappingmapping.php–extension/sqliimport/modules/sqliimport/module.php:52
/sqliimport/reportreport.php–extension/sqliimport/modules/sqliimport/module.php:59
/sqliimport/statisticsstatistics.php–extension/sqliimport/modules/sqliimport/module.php:67
/sqliimport/actionaction.php–extension/sqliimport/modules/sqliimport/module.php:77
/sqliimport/editedit.phpmanage or manageimportsextension/sqliimport/modules/sqliimport/module.php:84
/sqliimport/schedulesschedules.php–extension/sqliimport/modules/sqliimport/module.php:92
/sqliimport/cataloguecatalogue.php–extension/sqliimport/modules/sqliimport/module.php:100
/sqliimport/settingssettings.phpmanage or manageimportsextension/sqliimport/modules/sqliimport/module.php:108
/sqliimport/transfertransfer.phpmanage or manageimportsextension/sqliimport/modules/sqliimport/module.php:116
/sqliimport/templatestemplates.phpmanage or manageimportsextension/sqliimport/modules/sqliimport/module.php:124
/sqliimport/triggertrigger.php–extension/sqliimport/modules/sqliimport/module.php:135
/sqliimport/itemsitems.php–extension/sqliimport/modules/sqliimport/module.php:143
/sqliimport/scheduledlistscheduledlist.php–extension/sqliimport/modules/sqliimport/module.php:151
/sqliimport/addimportaddimport.php–extension/sqliimport/modules/sqliimport/module.php:158
/sqliimport/addscheduledaddscheduled.php–extension/sqliimport/modules/sqliimport/module.php:167
/sqliimport/removescheduledremovescheduled.php–extension/sqliimport/modules/sqliimport/module.php:186
/sqliimport/alterimportalterimport.php–extension/sqliimport/modules/sqliimport/module.php:193
/sqliimport/purgelistpurgelist.php–extension/sqliimport/modules/sqliimport/module.php:200

Policy functions (4)

FunctionLimitationsDefined in
sqliimport/manageSQLIImport_Typeextension/sqliimport/modules/sqliimport/module.php:222
sqliimport/runSQLIImport_Typeextension/sqliimport/modules/sqliimport/module.php:223
sqliimport/listimports–extension/sqliimport/modules/sqliimport/module.php:225
sqliimport/manageimportsSQLIImport_Typeextension/sqliimport/modules/sqliimport/module.php:226

Fetch functions (3)

FetchImplemented byDefined in
fetch( 'sqliimport', 'recent_runs' )expImportFunctionCollection::fetchRecentRuns()extension/sqliimport/modules/sqliimport/function_definition.php:17
fetch( 'sqliimport', 'failed_runs_24h' )expImportFunctionCollection::fetchFailedRuns24h()extension/sqliimport/modules/sqliimport/function_definition.php:22
fetch( 'sqliimport', 'notices' )expImportFunctionCollection::fetchNotices()extension/sqliimport/modules/sqliimport/function_definition.php:27

Cronjob parts (3)

CronjobFileDescription
sqliimport_cleanupextension/sqliimport/cronjobs/sqliimport_cleanup.phpSQLi Import cleanup cronjob Will clear imported content objects caches if needed Will trigger imported content objects indexing if needed
sqliimport_runextension/sqliimport/cronjobs/sqliimport_run.phpCronjob running scheduled and "one shot" imports as configured in the admin
sqliimport_scheduleextension/sqliimport/cronjobs/sqliimport_schedule.phpThe cron part "sqliimport" (php runcronjobs.php -q sqliimport, every minute): queues the runs of the schedules that are due and the pending imports o…

INI plugin points (135)

SettingClassSet in
[AuditEventSettings] Branches[sqliimport]expImportAuditBranchextension/sqliimport/settings/audit.ini.append.php:6
[JobType_sqliimport.run] HandlerexpImportJobHandlerextension/sqliimport/settings/expqueue.ini.append.php:6
[JobType_sqliimport.chunk] HandlerexpImportJobHandlerextension/sqliimport/settings/expqueue.ini.append.php:13
[JobType_sqliimport.finish] HandlerexpImportJobHandlerextension/sqliimport/settings/expqueue.ini.append.php:20
[ezjscServer_sqliimport] ClassexpImportServerFunctionsextension/sqliimport/settings/ezjscore.ini.append.php:10
[Service_sqliimport.registry] ClassexpImportRegistryextension/sqliimport/settings/kernelservices.ini.append.php:9
[Service_transfer.sqliimport] ClassexpKernelTransferToolextension/sqliimport/settings/kernelservices.ini.append.php:15
[Service_sqliimport.source.csv] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:108
[Service_sqliimport.source.csv] Arguments[]expImportCsvSourceextension/sqliimport/settings/kernelservices.ini.append.php:110
[Service_sqliimport.source.tsv] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:116
[Service_sqliimport.source.tsv] Arguments[]expImportCsvSourceextension/sqliimport/settings/kernelservices.ini.append.php:118
[Service_sqliimport.source.spreadsheet] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:125
[Service_sqliimport.source.spreadsheet] Arguments[]expImportSpreadsheetSourceextension/sqliimport/settings/kernelservices.ini.append.php:127
[Service_sqliimport.source.json] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:133
[Service_sqliimport.source.json] Arguments[]expImportJsonSourceextension/sqliimport/settings/kernelservices.ini.append.php:135
[Service_sqliimport.source.ndjson] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:141
[Service_sqliimport.source.ndjson] Arguments[]expImportJsonSourceextension/sqliimport/settings/kernelservices.ini.append.php:143
[Service_sqliimport.source.avro] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:150
[Service_sqliimport.source.avro] Arguments[]expImportAvroSourceextension/sqliimport/settings/kernelservices.ini.append.php:152
[Service_sqliimport.source.arrow] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:158
[Service_sqliimport.source.arrow] Arguments[]expImportArrowSourceextension/sqliimport/settings/kernelservices.ini.append.php:160
[Service_sqliimport.source.elasticsearch] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:166
[Service_sqliimport.source.elasticsearch] Arguments[]expImportSearchSourceextension/sqliimport/settings/kernelservices.ini.append.php:168
[Service_sqliimport.source.duckdb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:174
[Service_sqliimport.source.duckdb] Arguments[]expImportDuckDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:176
[Service_sqliimport.source.google_sheets] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:182
[Service_sqliimport.source.google_sheets] Arguments[]expImportGoogleSheetsSourceextension/sqliimport/settings/kernelservices.ini.append.php:184
[Service_sqliimport.source.yaml] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:190
[Service_sqliimport.source.yaml] Arguments[]expImportYamlSourceextension/sqliimport/settings/kernelservices.ini.append.php:192
[Service_sqliimport.source.toml] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:198
[Service_sqliimport.source.toml] Arguments[]expImportYamlSourceextension/sqliimport/settings/kernelservices.ini.append.php:200
[Service_sqliimport.source.xml] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:207
[Service_sqliimport.source.xml] Arguments[]expImportXmlSourceextension/sqliimport/settings/kernelservices.ini.append.php:209
[Service_sqliimport.source.rss] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:216
[Service_sqliimport.source.rss] Arguments[]expImportRssSourceextension/sqliimport/settings/kernelservices.ini.append.php:218
[Service_sqliimport.source.opml] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:224
[Service_sqliimport.source.opml] Arguments[]expImportOpmlSourceextension/sqliimport/settings/kernelservices.ini.append.php:226
[Service_sqliimport.source.wxr] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:232
[Service_sqliimport.source.wxr] Arguments[]expImportWxrSourceextension/sqliimport/settings/kernelservices.ini.append.php:234
[Service_sqliimport.source.markdown] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:240
[Service_sqliimport.source.markdown] Arguments[]expImportMarkdownSourceextension/sqliimport/settings/kernelservices.ini.append.php:242
[Service_sqliimport.source.podcast] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:248
[Service_sqliimport.source.podcast] Arguments[]expImportRssSourceextension/sqliimport/settings/kernelservices.ini.append.php:250
[Service_sqliimport.source.video_feed] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:257
[Service_sqliimport.source.video_feed] Arguments[]expImportRssSourceextension/sqliimport/settings/kernelservices.ini.append.php:259
[Service_sqliimport.source.imap] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:266
[Service_sqliimport.source.imap] Arguments[]expImportImapSourceextension/sqliimport/settings/kernelservices.ini.append.php:268
[Service_sqliimport.source.xrowextract] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:275
[Service_sqliimport.source.xrowextract] Arguments[]expImportXrowextractSourceextension/sqliimport/settings/kernelservices.ini.append.php:277
[Service_sqliimport.source.sql] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:283
[Service_sqliimport.source.sql] Arguments[]expImportSqlSourceextension/sqliimport/settings/kernelservices.ini.append.php:285
[Service_sqliimport.source.mongodb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:291
[Service_sqliimport.source.mongodb] Arguments[]expImportMongoDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:293
[Service_sqliimport.source.redis] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:299
[Service_sqliimport.source.redis] Arguments[]expImportRedisSourceextension/sqliimport/settings/kernelservices.ini.append.php:301
[Service_sqliimport.source.couchdb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:307
[Service_sqliimport.source.couchdb] Arguments[]expImportCouchDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:309
[Service_sqliimport.source.couchbase] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:315
[Service_sqliimport.source.couchbase] Arguments[]expImportCouchbaseSourceextension/sqliimport/settings/kernelservices.ini.append.php:317
[Service_sqliimport.source.cosmosdb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:323
[Service_sqliimport.source.cosmosdb] Arguments[]expImportCosmosDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:325
[Service_sqliimport.source.dynamodb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:331
[Service_sqliimport.source.dynamodb] Arguments[]expImportDynamoDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:333
[Service_sqliimport.source.firestore] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:339
[Service_sqliimport.source.firestore] Arguments[]expImportFirestoreSourceextension/sqliimport/settings/kernelservices.ini.append.php:341
[Service_sqliimport.source.bigquery] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:347
[Service_sqliimport.source.bigquery] Arguments[]expImportBigQuerySourceextension/sqliimport/settings/kernelservices.ini.append.php:349
[Service_sqliimport.source.firebase_rtdb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:355
[Service_sqliimport.source.firebase_rtdb] Arguments[]expImportFirebaseSourceextension/sqliimport/settings/kernelservices.ini.append.php:357
[Service_sqliimport.source.cassandra] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:363
[Service_sqliimport.source.cassandra] Arguments[]expImportCassandraSourceextension/sqliimport/settings/kernelservices.ini.append.php:365
[Service_sqliimport.source.neo4j] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:371
[Service_sqliimport.source.neo4j] Arguments[]expImportNeo4jSourceextension/sqliimport/settings/kernelservices.ini.append.php:373
[Service_sqliimport.source.arangodb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:379
[Service_sqliimport.source.arangodb] Arguments[]expImportArangoDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:381
[Service_sqliimport.source.clickhouse] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:387
[Service_sqliimport.source.clickhouse] Arguments[]expImportClickHouseSourceextension/sqliimport/settings/kernelservices.ini.append.php:389
[Service_sqliimport.source.snowflake] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:395
[Service_sqliimport.source.snowflake] Arguments[]expImportSnowflakeSourceextension/sqliimport/settings/kernelservices.ini.append.php:397
[Service_sqliimport.source.influxdb] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:403
[Service_sqliimport.source.influxdb] Arguments[]expImportInfluxDbSourceextension/sqliimport/settings/kernelservices.ini.append.php:405
[Service_sqliimport.source.ldap] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:411
[Service_sqliimport.source.ldap] Arguments[]expImportLdapSourceextension/sqliimport/settings/kernelservices.ini.append.php:413
[Service_sqliimport.source.cie] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:419
[Service_sqliimport.source.cie] Arguments[]expImportCieSourceextension/sqliimport/settings/kernelservices.ini.append.php:421
[Service_sqliimport.source.exponential_rss] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:427
[Service_sqliimport.source.exponential_rss] Arguments[]expImportRssSourceextension/sqliimport/settings/kernelservices.ini.append.php:429
[Service_sqliimport.source.sitemap] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:436
[Service_sqliimport.source.sitemap] Arguments[]expImportSitemapSourceextension/sqliimport/settings/kernelservices.ini.append.php:438
[Service_sqliimport.source.webpage] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:444
[Service_sqliimport.source.webpage] Arguments[]expImportWebPageSourceextension/sqliimport/settings/kernelservices.ini.append.php:446
[Service_sqliimport.source.exponential_site] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:452
[Service_sqliimport.source.exponential_site] Arguments[]expImportExponentialSiteSourceextension/sqliimport/settings/kernelservices.ini.append.php:454
[Service_sqliimport.source.ezpkg] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:460
[Service_sqliimport.source.ezpkg] Arguments[]expImportEzpkgSourceextension/sqliimport/settings/kernelservices.ini.append.php:462
[Service_sqliimport.source.drupal] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:468
[Service_sqliimport.source.drupal] Arguments[]expImportDrupalSourceextension/sqliimport/settings/kernelservices.ini.append.php:470
[Service_sqliimport.source.joomla] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:476
[Service_sqliimport.source.joomla] Arguments[]expImportJoomlaSourceextension/sqliimport/settings/kernelservices.ini.append.php:478
[Service_sqliimport.source.airtable] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:484
[Service_sqliimport.source.airtable] Arguments[]expImportAirtableSourceextension/sqliimport/settings/kernelservices.ini.append.php:486
[Service_sqliimport.source.notion] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:492
[Service_sqliimport.source.notion] Arguments[]expImportNotionSourceextension/sqliimport/settings/kernelservices.ini.append.php:494
[Service_sqliimport.source.supabase] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:500
[Service_sqliimport.source.supabase] Arguments[]expImportSupabaseSourceextension/sqliimport/settings/kernelservices.ini.append.php:502
[Service_sqliimport.source.baserow] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:508
[Service_sqliimport.source.baserow] Arguments[]expImportBaserowSourceextension/sqliimport/settings/kernelservices.ini.append.php:510
[Service_sqliimport.source.salesforce] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:516
[Service_sqliimport.source.salesforce] Arguments[]expImportSalesforceSourceextension/sqliimport/settings/kernelservices.ini.append.php:518
[Service_sqliimport.source.hubspot] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:524
[Service_sqliimport.source.hubspot] Arguments[]expImportHubSpotSourceextension/sqliimport/settings/kernelservices.ini.append.php:526
[Service_sqliimport.source.youtube] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:532
[Service_sqliimport.source.youtube] Arguments[]expImportYouTubeSourceextension/sqliimport/settings/kernelservices.ini.append.php:534
[Service_sqliimport.source.youtube_page] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:540
[Service_sqliimport.source.youtube_page] Arguments[]expImportYouTubePageSourceextension/sqliimport/settings/kernelservices.ini.append.php:542
[Service_sqliimport.source.rest_api] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:548
[Service_sqliimport.source.rest_api] Arguments[]expImportRestApiSourceextension/sqliimport/settings/kernelservices.ini.append.php:550
[Service_sqliimport.source.media] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:556
[Service_sqliimport.source.media] Arguments[]expImportMediaSourceextension/sqliimport/settings/kernelservices.ini.append.php:558
[Service_sqliimport.source.ical] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:563
[Service_sqliimport.source.ical] Arguments[]expImportIcalSourceextension/sqliimport/settings/kernelservices.ini.append.php:565
[Service_sqliimport.source.vcard] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:571
[Service_sqliimport.source.vcard] Arguments[]expImportVcardSourceextension/sqliimport/settings/kernelservices.ini.append.php:573
[Service_sqliimport.source.google_merchant] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:580
[Service_sqliimport.source.google_merchant] Arguments[]expImportGoogleMerchantSourceextension/sqliimport/settings/kernelservices.ini.append.php:582
[Service_sqliimport.source.shopify] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:588
[Service_sqliimport.source.shopify] Arguments[]expImportShopifyCsvSourceextension/sqliimport/settings/kernelservices.ini.append.php:590
[Service_sqliimport.source.woocommerce] ClassexpImportSourceEntryextension/sqliimport/settings/kernelservices.ini.append.php:596
[Service_sqliimport.source.woocommerce] Arguments[]expImportWooCommerceCsvSourceextension/sqliimport/settings/kernelservices.ini.append.php:598
[Service_datatable.field_source.sqliimport] ClassexpImportDataTableFieldSourceextension/sqliimport/settings/kernelservices.ini.append.php:606
[Service_sqliimport.handler.datatable] ClassexpImportDataTableHandlerextension/sqliimport/settings/kernelservices.ini.append.php:614
[ContentSettings] DiffHandlerMap[ezimage]SQLIImageDiffHandlerextension/sqliimport/settings/sqliimport.ini:60
[ContentSettings] DiffHandlerMap[ezbinaryfile]SQLIBinaryFileDiffHandlerextension/sqliimport/settings/sqliimport.ini:61
[ContentSettings] DefaultDiffHandlerSQLIDefaultDiffHandlerextension/sqliimport/settings/sqliimport.ini:66
[rssimporthandler-HandlerSettings] ClassNameSQLIRSSImportHandlerextension/sqliimport/settings/sqliimport.ini.append.php:12

Something wrong on this page? Report an error

Documentation license

This documentation is free documentation, licensed under the GNU Free Documentation License 1.3 or later.

Exponential Copyright © 1998-2026 Exponential Foundation and 7x