sqliimport

Written by Graham Brookins, 11/05/2026 Updated 11/05/2026 by Graham Brookins

Available since Exponential 6.0.15 (in development, not in a release yet).

Summary

7x SQLI Import for Exponential: imports content from more than 60 sources (files, feeds, web pages, APIs, SQL and NoSQL databases, other CMS, mailboxes, office documents) through a no-code mapping or import handlers, all in the administration, run by the job queue in chunks with a log and a row per record, on demand, on schedules or by a webhook. Handlers of sqliimport 1.x keep working.

Properties

Property	Value
Directory	extension/sqliimport
Name	7x SQLI Import
Version	2.0.5
License	GNU General Public License v2.0
Website	https://github.com/se7enxweb/sqliimport

Module sqliimport

The admin module "sqliimport" (the Imports tab).

View	Parameters	Policy	Summary
action	-	sqliimport/manage or run or listimports or manageimports	sqliimport/action: every change of the 2.x pages, POST only (ezformtoken checks the form token of every POST): run, dryrun, duplicate, ...
addimport	-	sqliimport/manage or manageimports	sqliimport/addimport (1.x): a request of an immediate import of a 1.x handler.
addscheduled	ScheduledImportID	sqliimport/manage or manageimports	sqliimport/addscheduled/<id> (1.x): a 1.x scheduled import.
alterimport	Action, ImportID	sqliimport/manage or manageimports	sqliimport/alterimport/<action>/<id> (1.x): cancel a pending 1.x import request or interrupt a running one.
catalogue	(example), (n)	sqliimport/manage or run or listimports or manageimports	sqliimport/catalogue: what this site can import from and with.
edit	ImportID, (step), (source), (parent), (class), (preset), (from), (job)	sqliimport/manage or manageimports	sqliimport/edit/<id>/(step)/<step>, sqliimport/edit/new: the import editor (expImportEditor).
items	(offset)	sqliimport/manage or run or listimports or manageimports	sqliimport/items (1.x): the list of the 1.x import requests is part of the dashboard now (sqliimport/list, section "1.x import requests").
list	(status), (import), (offset), (legacyoffset), (tool)	sqliimport/manage or run or listimports or manageimports	sqliimport/list: the dashboard of the Imports tab.
mapping	ImportID	sqliimport/manage or run or listimports or manageimports	sqliimport/mapping/<import id>: the import's mapping as a JSON file, to load in the editor of another import or installation ("Load a ...
purgelist	-	sqliimport/manage or manageimports	sqliimport/purgelist (1.x): remove the ended 1.x import requests.
removescheduled	ImportID	sqliimport/manage or manageimports	sqliimport/removescheduled/<id> (1.x): remove a 1.x scheduled import.
report	RunID, (outcome)	sqliimport/manage or run or listimports or manageimports	sqliimport/report/<run id>[/(outcome)/<outcome>]: the CSV report of a run, one line per record (expImportReport).
run	RunID, (outcome), (offset)	sqliimport/manage or run or listimports or manageimports	sqliimport/run/<id>: one run.
scheduledlist	-	sqliimport/manage or run or listimports or manageimports	sqliimport/scheduledlist (1.x): the 1.x scheduled imports are part of sqliimport/schedules now (section "1.x scheduled imports").
schedules	(legacy)	sqliimport/manage or run or listimports or manageimports	sqliimport/schedules: every schedule of the 2.x imports with its next run, Pause, Resume and Edit; and the scheduled imports of 1.x ...
settings	-	sqliimport/manage or manageimports	sqliimport/settings (policy sqliimport/settings): the settings of 7x SQLI Import as they stand, the export of the import definitions as ...
statistics	(days), (from), (to), (import), (source), (user), (scope), (compare), (cfrom), (cto), (format), (tool)	sqliimport/manage or run or listimports or manageimports	sqliimport/statistics: the run history for review and tuning.
templates	(format), (use)	sqliimport/manage or manageimports	sqliimport/templates (policy Manage imports): the templates of imports (expImportTemplates), this site's ("Save as template" of an import) ...
transfer	-	sqliimport/manage or manageimports	sqliimport/transfer (policy Manage imports): "Import definitions".
trigger	Identifier, Action, RunID	-	sqliimport/trigger/<identifier> (POST: start a run) and sqliimport/trigger/<identifier>/run/<run id> (GET: its status): the webhook / API ...

Policy functions: listimports; manage (SQLIImport_Type); manageimports (SQLIImport_Type); run (SQLIImport_Type).

Source: extension/sqliimport/modules/sqliimport/module.php

Fetch functions

Function	Parameters	Calls
fetch( 'sqliimport', 'failed_runs_24h' )	-	expImportFunctionCollection::fetchFailedRuns24h()
fetch( 'sqliimport', 'notices' )	limit (optional)	expImportFunctionCollection::fetchNotices()
fetch( 'sqliimport', 'recent_runs' )	limit (optional)	expImportFunctionCollection::fetchRecentRuns()

Settings files

File	Groups
extension/sqliimport/settings/audit.ini.append.php	[AuditEventSettings]
extension/sqliimport/settings/cronjob.ini.append.php	[CronjobSettings], [CronjobPart-expqueue], [CronjobPart-sqliimport], [CronjobPart-sqliimport_cleanup], [CronjobPart-sqliimport_run]
extension/sqliimport/settings/dashboard.ini.append.php	[DashboardSettings], [DashboardBlock_sqliimport]
extension/sqliimport/settings/design.ini.append.php	[ExtensionSettings], [StylesheetSettings], [JavaScriptSettings], [AdminHeaderSettings]
extension/sqliimport/settings/exphelp.ini.append.php	[ContextHelp]
extension/sqliimport/settings/expqueue.ini.append.php	[JobType_sqliimport.run], [JobType_sqliimport.chunk], [JobType_sqliimport.finish]
extension/sqliimport/settings/ezjscore.ini.append.php	[ezjscServer], [ezjscServer_sqliimport]
extension/sqliimport/settings/kernelservices.ini.append.php	[Service_sqliimport.registry], [Service_transfer.sqliimport], [Service_sqliimport.source.csv], [Service_sqliimport.source.tsv], [Service_sqliimport.source.spreadsheet], [Service_sqliimport.source.json], [Service_sqliimport.source.ndjson], [Service_sqliimport.source.avro], [Service_sqliimport.source.arrow], [Service_sqliimport.source.elasticsearch], [Service_sqliimport.source.duckdb], [Service_sqliimport.source.google_sheets], [Service_sqliimport.source.yaml], [Service_sqliimport.source.toml], [Service_sqliimport.source.xml], [Service_sqliimport.source.rss], [Service_sqliimport.source.opml], [Service_sqliimport.source.wxr], [Service_sqliimport.source.markdown], [Service_sqliimport.source.podcast], [Service_sqliimport.source.video_feed], [Service_sqliimport.source.imap], [Service_sqliimport.source.xrowextract], [Service_sqliimport.source.sql], [Service_sqliimport.source.mongodb], [Service_sqliimport.source.redis], [Service_sqliimport.source.couchdb], [Service_sqliimport.source.couchbase], [Service_sqliimport.source.cosmosdb], [Service_sqliimport.source.dynamodb], [Service_sqliimport.source.firestore], [Service_sqliimport.source.bigquery], [Service_sqliimport.source.firebase_rtdb], [Service_sqliimport.source.cassandra], [Service_sqliimport.source.neo4j], [Service_sqliimport.source.arangodb], [Service_sqliimport.source.clickhouse], [Service_sqliimport.source.snowflake], [Service_sqliimport.source.influxdb], [Service_sqliimport.source.ldap], [Service_sqliimport.source.cie], [Service_sqliimport.source.exponential_rss], [Service_sqliimport.source.sitemap], [Service_sqliimport.source.webpage], [Service_sqliimport.source.exponential_site], [Service_sqliimport.source.ezpkg], [Service_sqliimport.source.drupal], [Service_sqliimport.source.joomla], [Service_sqliimport.source.airtable], [Service_sqliimport.source.notion], [Service_sqliimport.source.supabase], [Service_sqliimport.source.baserow], [Service_sqliimport.source.salesforce], [Service_sqliimport.source.hubspot], [Service_sqliimport.source.youtube], [Service_sqliimport.source.youtube_page], [Service_sqliimport.source.rest_api], [Service_sqliimport.source.media], [Service_sqliimport.source.ical], [Service_sqliimport.source.vcard], [Service_sqliimport.source.google_merchant], [Service_sqliimport.source.shopify], [Service_sqliimport.source.woocommerce], [Service_datatable.field_source.sqliimport], [Service_sqliimport.handler.datatable]
extension/sqliimport/settings/menu.ini.append.php	[NavigationPart], [TopAdminMenu], [Topmenu_sqliimport], [Leftmenu_sqliimport]
extension/sqliimport/settings/module.ini.append.php	[ModuleSettings]
extension/sqliimport/settings/site.ini.append.php	[RegionalSettings], [SiteAccessSettings], [RoleSettings]
extension/sqliimport/settings/sqliimport.ini	[ImportSettings], [ContentSettings], [SourceSettings], [CrawlSettings], [PlatformSettings], [Source_spreadsheet], [HandlerSettings], [RunSettings], [TriggerSettings], [AdminSettings], [AiSettings], [SecretSettings], [SqlSourceSettings], [ImapSourceSettings], [MongoDbSourceSettings], [RedisSourceSettings], [CouchDbSourceSettings], [CouchbaseSourceSettings], [CosmosDbSourceSettings], [SearchSourceSettings], [Neo4jSourceSettings], [ArangoDbSourceSettings], [ClickHouseSourceSettings], [SnowflakeSourceSettings], [InfluxDbSourceSettings], [DuckDbSourceSettings], [SupabaseSourceSettings], [BaserowSourceSettings], [SalesforceSourceSettings], [YouTubeSettings], [HubSpotSourceSettings], [RestApiSourceSettings], [LdapSourceSettings], [DynamoDbSourceSettings], [GoogleCloudSourceSettings], [CassandraSourceSettings], [HandoverSettings], [TemplateSettings]
extension/sqliimport/settings/sqliimport.ini.append.php	[ImportSettings], [rssimporthandler-HandlerSettings]

Source

extension/sqliimport (extension.xml, ezinfo.php, modules/*/module.php, modules/*/function_definition.php, autoloads/eztemplateautoload.php, datatypes/, eventtypes/, settings/)