CSV to QuarkXPress AppleScript Creation

Job ID: 39412438

Budget: $10 – $30 USD

# QuarkXPress 10 AppleScript Automation — Task Description

## Overview

Since **QuarkXPress 10** does **not support QX.js**, the goal of this task is to **develop an AppleScript** that can create multiple text and picture boxes in a QXP document, based on structured data from a **CSV file** (exported from Excel).

---

## Environment Requirements

- **Operating System**: macOS Mojave (10.14) or earlier
- **QuarkXPress Version**: 10.5.2.4
- **Tools**: Script Editor (built into macOS)

Please note: QuarkXPress 10 will not run on M1 or modern macOS versions. You must use Mojave or earlier (physical or virtual machine).

---

## Input Format

- Data comes from an **Excel file**, exported as **CSV**
- Each row represents a box to be created
- All box properties are stored in column format

---

## Table Fields (CSV Columns)

| Column Name | Description |
|--------------|----------------------------------------|
| `x` | X position (in points) |
| `y` | Y position (in points) |
| `width` | Width of the box |
| `height` | Height of the box |
| `type` | `text` or `picture` |
| `textContent`| Text to insert (for text boxes) |
| `imagePath` | Image file path (for picture boxes) |
| `color` | (Optional) Fill/background color |

You are also encouraged to reserve additional columns for future styling support (e.g., opacity, borderColor, etc.).

---

## Script Functional Requirements

1. **Read and parse CSV file**
- Open file via file dialog
- Extract header and rows
- Map each column to a property

2. **Create boxes**
- For each row, create a `text box` or `picture box`
- Set `x`, `y`, `width`, `height`, and `color`

3. **Insert content**
- If text box: insert `textContent`
- If picture box: import image from `imagePath`

4. **Basic error handling**
- Show user-friendly error messages on file or parsing issues

---

## Deliverables

- AppleScript code file (.scpt or .applescript)
- Sample test file(s) if needed
- Short instructions on how to run the script

---

## Resources

- AppleScript documentation for QuarkXPress 10
- QXP 10 installer (Mac): [Official Download Link](https://www.quark.com/dl-installers?utm_source=website&utm_medium=installer&utm_campaign=version_track&utm_content=qxp10&file_url=https://files.quark.com/Protected/qxp/qxp1052_26410_mac.dmg)

---

## Additional Notes

I'm currently using an M1 Mac, so I cannot run QuarkXPress 10 myself. That's why I'm looking for someone who can help write and test the script in the proper environment.

If you have a working setup (macOS 10.14 or earlier + QXP 10), this task should be relatively straightforward. Let me know if you're available and how much you would charge.

Thank you!
Related categories: Visual Basic Data Processing Excel Mac OS Applescript