mapping-from-excel

Key Facts (verified)

• Mapper activity type: act_general_mapper
• Logger activity type: act_general_log
• Timer trigger type: tr_timer
• String concatenation in Flogo expressions: use string.concat(a, b) — NOT the & operator
• Mapper output path: $activity[<activity_name>].output.<field> — NOT .output.output.<field>
• All set-attribute calls for schemas and mappings need the --force flag (attributes don't pre-exist)
• create-trigger-handler inline syntax: fda cth <flow-name> <trigger-id>
• create-activity inline syntax: fda ca <flow-name> <activity-name> <activity-type>

---

Step 1: Read the Excel file

Read the Excel file using Python (openpyxl). Extract:

• Column 1 → Input field names
• Column 2 → Output field names
• Column 3 → Mapping rules (source expression per output field)

python3 -c "
import openpyxl
wb = openpyxl.load_workbook('<excel-file>')
ws = wb.active
for row in ws.iter_rows(values_only=True):
    print(row)
"

---

Step 2: Create project, flow, activities, trigger

Run all commands from your Flogo apps directory (e.g. ./Flogo_Apps/).

# Create flow (creates project file if it doesn't exist)
fda create-flow mapping_from_excel -f <AppName>.flogo

# Add activities (automatically linked in sequence)
fda ca mapping_from_excel mapper1 act_general_mapper -f <AppName>.flogo
fda ca mapping_from_excel mapper2 act_general_mapper -f <AppName>.flogo
fda ca mapping_from_excel logger  act_general_log    -f <AppName>.flogo

# Add timer trigger + handler
fda create-trigger timerTrigger tr_timer -f <AppName>.flogo
fda cth mapping_from_excel timerTrigger -f <AppName>.flogo

# Format flow
fda format-flow mapping_from_excel -f <AppName>.flogo

---

Step 3: Create JSON schemas

Create one schema for input fields and one for output fields.

fda cs InputSchema  '{"$schema":"http://json-schema.org/draft-04/schema#","type":"object","properties":{"<field1>":{"type":"string"},...}}' -f <AppName>.flogo
fda cs OutputSchema '{"$schema":"http://json-schema.org/draft-04/schema#","type":"object","properties":{"<field1>":{"type":"string"},...}}' -f <AppName>.flogo