Menu
数据采集前完整性校验：cookie/excel/代理/文件，防5/26三联失败
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Automate web browser interactions using natural language via CLI commands. Use when the user asks to browse websites, navigate web pages, extract data from websites, take screenshots, fill forms, click buttons, or interact with web applications.
Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry analysis, SEO planning, or competitor research for content marketing in specific countries and languages.
Build and execute a content marketing strategy for a solopreneur business. Use when planning what content to create, deciding on content formats and channels, building a content calendar, measuring content performance, or systematizing content production. Covers audience research for content, content pillars, distribution strategy, repurposing workflows, and metrics. Trigger on "content strategy", "content marketing", "what content should I create", "content plan", "content calendar", "content ideas", "content distribution", "grow through content".
📊 Powerful ECharts-based data visualization skill optimized for Feishu (Lark) ecosystem. Supports 12+ chart types, 6+ data sources (Excel/CSV/Bitable/Sheet/Markdown), auto chart recommendation, auto analysis reports, generates high-definition PNG charts perfectly displayed in Feishu. No configuration required, works out of the box.
Analyze CSV/Excel files to extract insights, generate statistics, create charts, and produce summaries. Use when user wants to (1) upload or analyze spreadsheet data, (2) get insights from data files, (3) generate charts or visualizations, (4) calculate statistics or trends, (5) clean or transform data.
Knowledge graph operations via Graphiti API. Search facts, add episodes, and extract entities/relationships.
| name | data-integrity-check |
| description | 数据采集前完整性校验：cookie/excel/代理/文件，防5/26三联失败 |
2026-05-26 发生「三联失败」：抖音 cookie 过期(401)、小红书文件被移动、代理断连——三个不同的根因在同一天集中爆发，完全没有事前检查机制。每次失败后需要手动排查重试。
| # | 检查项 | 命令 | 通过条件 |
|---|---|---|---|
| 1 | 抖音Cookie | python3 -c "import json; f=open('/tmp/juLiang_cookies.json'); d=json.load(f); print('ok' if d else 'empty')" | 文件存在且非空 |
| 2 | 小红书Cookie | python3 -c "import json; f=open('/tmp/xiaohongshu_cookies.json'); d=json.load(f); print('ok' if d else 'empty')" | 文件存在且非空 |
| 3 | 代理连通性 | curl -s -o /dev/null -w '%{http_code}' --max-time 5 --socks5 127.0.0.1:7897 http://httpbin.org/ip | 返回 200 |
| 4 | 抖音脚本存在 | test -f ~/.openclaw/workspace/scripts/douyin_index.py | 返回 0 |
| 5 | 小红书脚本存在 | test -f ~/.openclaw/workspace/scripts/xiaohongshu_crawl.py | 返回 0 |
| 6 | 客流Excel存在 | test -f ~/Desktop/2026年电影小镇实际客流.xlsx | 返回 0 |
| 7 | 历年客流存在 | test -f ~/Desktop/2023-2025年门票销售及客流统计数据表.xlsx | 返回 0 |
| # | 检查项 | 命令 | 通过条件 |
|---|---|---|---|
| 8 | 磁盘空间 | df -h ~ | tail -1 | awk '{print \$5}' | sed 's/%//' | <90% |
| 9 | 网络连通性 | curl -s -o /dev/null -w '%{http_code}' --max-time 5 https://api.deepseek.com | 返回 200 或 401（服务活着） |
| 10 | 飞书连接 | curl -s -o /dev/null -w '%{http_code}' --max-time 5 https://open.feishu.cn | 返回 200 |
┌──────────────────────┐
│ 收到任务执行指令 │
└──────────┬───────────┘
↓
┌──────────────────────┐
│ A级检查（全部通过？）│ ← 否 → 跳过任务，报告具体哪个出问题
└──────────┬───────────┘
↓ 是
┌──────────────────────┐
│ B级检查（有警告？） │ ← 是 → 记录到日志，继续执行
└──────────┬───────────┘
↓
┌──────────────────────┐
│ 执行任务 │
└──────────────────────┘
# 一键检查所有A级依赖
python3 -c "
import json, os
checks = {
'抖音Cookie': os.path.isfile('/tmp/juLiang_cookies.json') and os.path.getsize('/tmp/juLiang_cookies.json') > 10,
'小红书Cookie': os.path.isfile('/tmp/xiaohongshu_cookies.json') and os.path.getsize('/tmp/xiaohongshu_cookies.json') > 10,
'抖音脚本': os.path.isfile(os.path.expanduser('~/.openclaw/workspace/scripts/douyin_index.py')),
'小红书脚本': os.path.isfile(os.path.expanduser('~/.openclaw/workspace/scripts/xiaohongshu_crawl.py')),
'客流Excel': os.path.isfile(os.path.expanduser('~/Desktop/2026年电影小镇实际客流.xlsx')),
}
for name, ok in checks.items():
print(f'{\"✅\" if ok else \"❌\"} {name}')
print(f'结论: {\"ALL PASS\" if all(checks.values()) else \"FAIL: \" + \", \".join(k for k,v in checks.items() if not v)}')
"
# 检查代理
curl -s --max-time 5 --socks5 127.0.0.1:7897 http://httpbin.org/ip
| 失败等级 | 处理方式 |
|---|---|
| A级1项失败 | 跳过任务，在报告中标注具体失败项 |
| A级≥2项失败 | 跳过任务，推送到电影小镇群提醒 |
| B级失败 | 记录日志，继续执行 |
| 连续失败≥3次 | 推送到电影小镇群 |
每次校验结果追加到 memory/topics/data-integrity-log.md：
| 日期 | 任务 | A级通过 | B级通过 | 失败项 |
|------|------|--------|--------|--------|
| 6/5 | 抖音指数 | ✅ 7/7 | ✅ 3/3 | 无 |