VNClaw — Odoo 17 Integration Skill

Execution Rules (MUST follow)

1. 1. ALWAYS run the command immediately. Never ask the user to confirm or explain what the command does before running it. Translate the request → pick the command → execute it in one step.
2. Never say "Would you like me to execute this?" — just execute it.
3. Never ask "Do you want me to run this?" — just run it.
4. If the command fails, show the error and try to fix it. Do not ask the user for help diagnosing unless you have exhausted all options.
5. Credentials: If env vars are missing, inform the user which variable is missing and stop. Do not ask for the value interactively.

Path Resolution

IMPORTANT: All commands below use SKILL_SCRIPTS as shorthand for the absolute path to the scripts directory. The skill may be installed in two locations — resolve it by checking both:

CODEBLOCK0

Possible install locations:

Environment Variables (Required)

Credentials are loaded from environment variables. Never hardcode credentials.

Common Features (All Modules)

All module scripts share these capabilities:

• - --my — Filter to current authenticated user's records
• Name-based lookups — Use --user "Alice", --project "Website" etc. instead of IDs
• Date shortcuts — --today, --yesterday, --this-week, --last-week, --this-month, --last-month, INLINECODE18
• Custom date range — INLINECODE19
• Log notes — log-note action to post internal notes on records (where supported)
• Notify — notify action to schedule activity notifications by user name (where supported)
• JSON output — All scripts output JSON to stdout, logs go to stderr

DATE FIELD RULE for tasks.py: Date shortcuts filter date_deadline by default.
To filter by when a task was created, always add --date-field created.
To filter by when a task was last updated, use --date-field updated.

Natural Language → Command Mapping

Use this table to translate common user requests into the correct command:

Quick Decision: Which Script to Use

Module: Tasks (tasks.py)

Manages project.task. Actions: list, get, create, update, log-note, notify, stages.

Date filter field — use --date-field to choose which date to filter on:

• - deadline (default) — filters by INLINECODE68
• INLINECODE69 — filters by create_date (when the task was created)
• INLINECODE71 — filters by write_date (when the task was last modified)

CODEBLOCK1

Module: Projects (projects.py)

Manages project.project. Actions: list, get, create, update, log-note, notify, stages.

CODEBLOCK2

Module: Timesheets (timesheets.py)

Manages account.analytic.line. Actions: list, summary, log, update.

CODEBLOCK3

Module: Calendar Events (calendar_events.py)

Manages calendar.event. Actions: list, get, create, update.

CODEBLOCK4

Module: Helpdesk (helpdesk.py)

Manages helpdesk.ticket. Actions: list, get, create, update, log-note, notify, stages.

CODEBLOCK5

Module: Time Off (time_off.py)

Manages hr.leave. Actions: list, get, create, update, leave-types.

CODEBLOCK6

Module: Knowledge (knowledge.py)

Manages knowledge.article. Actions: list, get, create, update.

CODEBLOCK7

Module: Documents (documents.py)

Manages documents.document. Actions: list, get, create, update, folders.

CODEBLOCK8

Module: Custom App (custom_app.py)

For any Odoo model not covered by the dedicated scripts — CRM, Sales, Purchase, Inventory, Manufacturing, Accounting, or any custom app installed in the Odoo instance.

Recommended workflow:

1. 1. Discover the model technical name with INLINECODE124
2. Inspect available fields with INLINECODE125
3. Then list, get, create, update as needed

CODEBLOCK9

Generic Client (odoo_core.py)

For raw low-level access or testing the connection:

CODEBLOCK10

Security Rules

1. 1. No delete — unlink is blocked in all scripts.
2. Sensitive models blocked — ir.rule, ir.model.access, ir.config_parameter, etc.
3. Read-only models — res.users, hr.employee, stage/type models cannot be modified.
4. Credentials from environment only — Never pass credentials as arguments.
5. Audit logging — All operations are logged to stderr with timestamps.

Troubleshooting

Field Reference

See Odoo Models Reference for detailed field lists per model.