CSV to QuarkXPress AppleScript Creation
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!
## 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!