Files and databases
Multogram Modules Constructor modules for files and databases: Filesystem, Path, Excel/CSV, Archive, Database, SQL, MongoDB — all actions.
Modules that read and save data on disk and in databases: target lists, reports, exports.
Filesystem
| Job | Actions |
|---|---|
| Files | Read File, Write File, Append File, Copy File, Move File, Delete File, File Exists, Get File Info |
| Folders | Create Directory, Delete Directory, Directory Exists, List Directory, Get Directory Size |
| Search and checks | Find Files, Find Files Advanced, Compare Files, Calculate File Hash, Wait For File |
| Attributes | Set File Attributes, Get File Attributes |
Append File is a simple way to keep a module report: one line for each processed account.
Path
Get Filename, Get Directory, Get Extension, Parse Path, Get Current Path, Get System Path, Path Exists.
Excel/CSV
| Job | Actions |
|---|---|
| File | Create Excel File, Create CSV File, Open File, Save File, Save As, Close File |
| Sheets | List Sheets, Create Sheet, Delete Sheet |
| Reading and writing Excel | Read Cell, Read Range, Read Sheet, Write Cell, Write Range |
| CSV | Read CSV File, Write CSV File, Append Rows to CSV |
Archive
Create Archive, Extract Archive, List Archive, Add to Archive, Remove from Archive, Extract File, Archive Exists, Get Archive Info, Compress File, Decompress File, Compress Archive, Decompress Archive, Set Archive Password.
Database
Connecting to a database and working with its structure: Create Database, Connect to Database, Disconnect from Database, Create Table, Get Tables List, Get Table Columns, Export to CSV, Import from CSV.
SQL
Queries to the database connected with the Database module: Select Data, Insert Data, Insert Multiple Rows, Update Data, Delete Data, Execute SQL, Begin Transaction, Commit Transaction, Rollback Transaction.
MongoDB
Create Collection, Find Documents, Insert Document, Update Document, Delete Document, Aggregate, List Collections, Drop Collection.
Paths go into resources
Set the files and folders the module works with as a resource of the Path Picker type: the user picks them in the form, and the module doesn't depend on someone else's disk.
Updated
Logic and data
Multogram Modules Constructor modules for logic and data processing: Logic, String, Array, JSON, Math, Regex, DateTime, Encode, Crypto, Identity — all actions.
Network
Multogram Modules Constructor modules for the network: TLS Client (HTTP requests, headers, cookies, proxies, WebSocket), Proxy, Mail (IMAP and SMTP), Remote (FTP, SFTP, SSH) — all actions.