Pulsar Admin Login

Browser Storage Blocked: Your browser settings are preventing the dashboard from saving your session. Please disable "Tracking Prevention" or add this site as an exception.

Pulsar

Traffic Overview

Filter by Endpoint

Total Requests

Errors

{{ dashboardStats.total_requests > 0 ? ((dashboardStats.total_errors / dashboardStats.total_requests) * 100).toFixed(1) : 0 }}%

Recent Traffic Logs

Time	Endpoint	Status	IP
{{ formatDate(log.occurred_at) }}	{{ log.endpoint_path }}	{{ log.status_code }}	{{ log.client_ip }}

API Configurations

POST /api/ingest/{{ config.endpoint_path }}

Collected Data

Filter by Endpoint:

Time	Endpoint	Payload Preview	Sync Status	Action
{{ formatDate(item.received_at) }}	{{ item.endpoint_name }} ({{ item.endpoint_path }})	[Purged] {{ JSON.stringify(item.payload).substring(0, 50) }}...	Success Failed Pending Skipped
No data found.

Export Management

Source: {{ ex.source_type === 'query' ? 'SQL Query' : ex.source_name }}

Scheduled: {{ ex.schedule_cron }} Manual Only

No export configurations found. Click "+ New Export Config" to get started.

Database Connections

Import Manager (Sync from Excel)

Tip: Use the Import Manager to sync data from Excel files back to your database. You can set independent input paths and schedules for each table.

Scheduled: {{ im.schedule_cron }}

Target Table: {{ im.target_table_name }} | Pattern: {{ im.filename_pattern }}

Source Path: {{ im.input_path }}

Trigger: {{ im.trigger_column }} = '{{ im.trigger_value }}' Elite Mode (Sheet ID) Optimized Diff Audited: {{ im.history_log_table }}

No import tasks configured yet.

{{ editingExportId ? 'Edit' : 'Create' }} Export Configuration

Configure automated data extraction and formatting rules.

Identity & Source

Config Name

Use Multi-Sheet Mode

Source Type

Database

{{ newExport.source_type === 'query' ? 'SQL Query' : 'Table Name' }}

Multi-Sheet Configuration (JSON)

Database Connection is shared across all tabs.

Shared Database

Schedule Execution

Enable Automation

Cron Expression

Example: 0 0 * * * (Daily at midnight)

Destination & Sync

Destination Type

Local / Google Drive Sync

Saves to server path, synced via Desktop client.

Google Drive (Direct API)

Uploads directly to Cloud storage. Preferred.

Output Path (Server)

Google Drive Folder ID

Sync Mode & Format

Excel (.xlsx) Google Sheet (Native) Direct Update (Elite Mode)

Target Google Sheet ID

Elite mode writes directly to existing cells without creating new files.

File Properties

Filename Prefix

Append Timestamp (_YYMMDD_HHMMSS)

Excel Formatting

Freeze Row

Freeze Col

Font Name

Font Size

Tab Name

Enable Content Protection

Protected Column Ranges

Leave empty to protect only frozen areas.

File Password

Row Range Coloring

No row ranges defined

Start Row

End Row

Color

Custom Logic Columns

Column Name

Input Type

Excel Pos

Color

Dropdown Options

Target

Default Value Column (Source DB)

Pre-fills the cell with data from this DB column (prioritized over formula).

{{ col.type === 'dropdown' ? 'Auto-Selection Logic' : 'Excel Formula' }}

Display Text (Static or {Vars})

OR Display Column (DB Source)

Click "+ Add Logic" to define interactive columns.

Running Numbers (Sequences)

Type	Year	Art	Template	Number
{{ seq.admission_type }}	{{ seq.admission_year }}	{{ seq.art_form }}
No sequences generated yet.

Test Tool

Template

Type

Year

Art

Global System Settings

Global Rate Limit (Req/Min)

Default limit for all endpoints unless overridden.

User Management

Username	Email	Group	Role	Status	Actions
{{ user.username }}	{{ user.email \|\| '-' }}	{{ user.group.name }} None	{{ user.role }}	{{ user.is_active ? 'Active' : 'Inactive' }}

Group Management

Group Name	Description	Module Access	Actions
{{ group.name }}	{{ group.description }}	{{ mod }}

Generated Index History

Full history and status for this generator

Latest Numbers by Art Form (Grouped by Admission Type)

Track:

Art Forms for {{ selectedSummarySubType || selectedSummaryType }}

Select a track above to view latest index numbers

Click an Admission Type above to view latest index numbers by Art Form

Active Filters: {{ filter.type }} / {{ filter.art }}

Index Numbers	Applicant Info	Attempt	Status	Synchronization	Generated Date	Actions
{{ idx.index_number }} {{ getDisplayAdmissionType(idx.admission_type) }} {{ idx.art_form }}	{{ group.applicant_name }} {{ group.applicant_email \|\| '-' }} ID: {{ group.applicant_identifier }}	ATTEMPT #{{ group.attempt_count \|\| 1 }}	{{ group.indices[0].email_status }}	{{ group.indices[0].db_sync_status }}	{{ formatDate(group.created_at) }}
No records matched your filters.

Showing {{ (indexGenHistoryPage - 1) * indexGenHistoryPageSize + 1 }} to {{ Math.min(indexGenHistoryPage * indexGenHistoryPageSize, getFilteredGroupedHistory().length) }} of {{ getFilteredGroupedHistory().length }} groups

Index Generator

Auto-generate index numbers for SOTA applications

Format: {{ ig.format_template }}

API Config ID: {{ ig.api_config_id }} | Starting #: {{ ig.starting_number }}

Email: {{ ig.gmail_address }} DB Sync Enabled {{ ig.is_active ? 'Active' : 'Inactive' }}

No index generator configurations found. Click "+ New Config" to get started.

{{ editingIndexGenId ? 'Edit' : 'Create' }} Index Generator

Configure index number format, field mappings, and email settings.

Identity & Source

Config Name

Linked API Config

Target DB

Target Table

Data Source

Use Target Table if collected payloads are purged after sync.

Index Column 1

Index Column 2

Lookup Column

Duplicate Control

Skip duplicated applications in batch

Control Field (e.g. applicant_id)

Threshold (Submissions Allowed)

Allow Submissions with Indices

Record subsequent attempts with new index numbers

Auto-Generate

Trigger on new API collection

Format & Fields

Format Template

Placeholders: {admission_type}, {admission_year}, {art_form}, {running_no}

Starting Number

Padding (digits)

Payload Field Names

Admission Type

Admission Year

Art Form 1

Art Form 2

Email Field

Name Field

Code Mappings (JSON)

Admission Type Mapping

Art Form Mapping

Gmail Email Settings

Gmail Address

App Password

Generate at myaccount.google.com → Security → App Passwords

Subject Template

Body Template (HTML, optional)

Consolidated Body Template (Dual Art Forms)

Allowed Duplicate Subject (E.g. 2nd App)

Allowed Duplicate Body

Allowed Duplicate Subject (Dual Art Forms)

Allowed Duplicate Body (Dual Art Forms)

Duplicate Alert Subject (When rejected)

Duplicate Alert Body

Receiver Email for Test

Active

Inactive configs will be hidden from the generation workflow.

Daily Email Summary

Enable Daily Summary

Schedule Time

Daily summary will be sent at this time.

Recipients (comma separated)

Summary Range (for scheduled email)

Running Numbers (Sequences)

Type	Year	Art	Template	Number
{{ seq.admission_type }}	{{ seq.admission_year }}	{{ seq.art_form }}
No sequences generated yet.

Test Tool

Template

Type

Year

Art

Audit Logs

System activity, login history, and error events

Loading…

No logs found.

Timestamp (SGT)	Event	Severity	Status	Actor	IP	Target	Detail
{{ formatAuditDate(log.created_at) }}	{{ log.event_type }}	{{ log.severity }}	{{ log.status }}	{{ log.actor \|\| '—' }}	{{ log.ip_address \|\| '—' }}	{{ log.target \|\| '—' }}	{{ log.detail \|\| '—' }}

Showing {{ auditLogs.length }} of {{ auditTotal }} entries

Page {{ auditPage }}

Error Alert Settings

Send email alerts when critical errors occur. Uses the Gmail configured in the selected Index Generator config.

Enable Error Alerts

Recipient Email(s)

Separate multiple with commas

Gmail Source (Index Generator Config)

Alert on:

API Errors (unhandled 5xx) DB Sync Errors Index Generation Errors Email Sending Failures

{{ editingDbId ? 'Edit' : 'Add' }} Database Connection

Username

User Group

Basic Role (Legacy)

Active

{{ editingConfigId ? 'Edit' : 'New' }} Endpoint Configuration

Name

Endpoint Path (unique)

/api/ingest/

Description

Active

Rate Limiting

Use Global Setting Custom Limit

Security

Allowed IPs (comma separated CIDRs)

Leave empty to allow all IPs (not recommended).

Current API Key

Data Destination

Target Database

Target Table Name

Is Raw/Delimited Data?

Delimiter (Default: |)

Input Validation (JSON Schema)

Field Mapping (JSON)

{{ editingImportId ? 'Edit' : 'New' }} Import Task

Config Name

Target DB Connection

Target Table Name

Elite Mode & Audit Settings

Direct Spreadsheet ID (Elite Mode Only)

* Used only when Source Type is Google Drive.

Audit Sync Optimization (Diff Only)

History Log Table

Log Column

History ID Match (e.g. ref_id)

Source File Settings

Source Type

Local / Google Drive Sync Google Drive (Direct API)

Input Folder Path (Server)

Google Drive Folder ID

Sync From Format

Excel (.xlsx) Google Sheet

File Password (if encrypted)

Filename Pattern

Sync Conditions

Trigger Column

Trigger Value

Excel Lookup Field

DB Lookup Field

Last Modified Timestamp Field (DB)

Specify a column name (e.g. `last_synced`) to automatically update with the current time.

Update Columns (Optional)

Comma-separated list of columns to sync back to DB.

Field Mapping (JSON)

Optional: Map Excel headers to specific database columns.

Revert Authorized Role

Which role is authorized to revert changes for this task. Admin can always revert.

Scheduling

Enable Scheduled Sync

Cron Expression

Example: 0 * * * * (Every hour)

Sync History Explorer

View and revert changes from previous sync sessions.

Sync Sessions

{{ log.rows_updated }} rows updated

No sync history yet.

Row Level Changes Session #{{ selectedSessionId }}

Select a session on the left to see details

Match ID: {{ entry.row_match_id }}

Reverted ({{ entry.reverted_by }})

Remark: {{ entry.revert_remarks }}

No row-level details captured for this session

Confirm Revert Action

You are about to restore the row(s) to their original values. This action cannot be easily undone.

Confirm Identity (Password)

Remarks (Required)

Data Details

Sync Error: {{ currentSyncError }}

History: {{ selectedExportForLogs?.name }}

Time	Status	Result
{{ formatDate(log.occurred_at) }}	{{ log.status }}	{{ log.status === 'SUCCESS' ? log.file_saved_at : ('ERROR: ' + log.error_message) }}
No execution history found.

Index Number Generation Preview

Review the index numbers below before confirming generation.

Loading preview...

Admission Year:

New to Generate

Already Generated

Errors

Applicant	Email	Art Form	Index Number	Status
{{ item.applicant_name \|\| item.applicant_id \|\| '-' }}	{{ item.applicant_email \|\| '-' }}	{{ item.art_form_raw \|\| item.art_form \|\| '-' }}	{{ item.index_number \|\| '-' }}	{{ item.error }} Ready
No new applicants to generate index numbers for.

Generated Index History

Latest Numbers by Art Form

{{ item.admission_type }} / {{ item.art_form }}

Index #	Attempt	Applicant	Art Form	Email	Email Status	DB Sync	Created	Action
{{ idx.index_number }}	#{{ idx.attempt_count \|\| 1 }}	{{ idx.applicant_name \|\| idx.applicant_identifier }}	{{ idx.art_form }}	{{ idx.applicant_email \|\| '-' }}	{{ idx.email_status }}	{{ idx.db_sync_status }}	{{ formatDate(idx.created_at) }}
No generated indices found.

Send Summary Email

Select the date range for the application summary report.

Yesterday

Full day (00:00 - 23:59 SGT)

Today

From 00:00 SGT until now

Custom Range

Select specific start and end dates

Start Date

End Date

Change Your Password

Current Password

New Password

Forgot Password

Enter your username and registered email to receive a temporary password.

Username

Email Address

Pulsar Admin Login

Pulsar

Traffic Overview

Total Requests

Errors

Recent Traffic Logs

API Configurations

{{ config.name }}

Collected Data

Export Management

{{ ex.name }}

Database Connections

{{ conn.name }}

Import Manager (Sync from Excel)

{{ im.name }}

{{ editingExportId ? 'Edit' : 'Create' }} Export Configuration

Identity & Source

Schedule Execution

Destination & Sync

File Properties

Excel Formatting

Row Range Coloring

Custom Logic Columns

Running Numbers (Sequences)

Test Tool

Global System Settings

User Management

Group Management

Generated Index History

Latest Numbers by Art Form (Grouped by Admission Type)

Index Generator

{{ ig.name }}

{{ editingIndexGenId ? 'Edit' : 'Create' }} Index Generator

Identity & Source

Format & Fields

Code Mappings (JSON)

Gmail Email Settings

Daily Email Summary

Running Numbers (Sequences)

Test Tool

Audit Logs

Error Alert Settings

{{ editingDbId ? 'Edit' : 'Add' }} Database Connection

{{ editingUserId ? 'Edit User' : 'Add User' }}

{{ editingGroupId ? 'Edit Group' : 'Create Group' }}

{{ editingConfigId ? 'Edit' : 'New' }} Endpoint Configuration

Rate Limiting

Security

Data Destination

{{ editingImportId ? 'Edit' : 'New' }} Import Task

Elite Mode & Audit Settings

Source File Settings

Sync Conditions

Scheduling

Sync History Explorer

Confirm Revert Action

Data Details

History: {{ selectedExportForLogs?.name }}

Index Number Generation Preview

Generated Index History

Latest Numbers by Art Form

Send Summary Email

Change Your Password

Forgot Password