Home » Guidelines » AI Prompt to Create a Jazz Near You Event CSV File

AI Prompt to Create a Jazz Near You Event CSV File

The Prompt Starts Here...

I want your help preparing my upcoming jazz performances for submission to Jazz Near You, a worldwide jazz event calendar.

I'll provide my event information, and I'd like you to organize it into a CSV file that meets Jazz Near You's requirements. Please follow the instructions below.

Step 1: Gather My Event Information

I'll provide my upcoming performances using text, website links, calendar listings, spreadsheets, or other available sources.

Please extract the relevant information for each performance. If anything essential is missing, ask me for it before proceeding. Don't invent event details or make assumptions about information you can't verify.

Step 2: Format My Events for Jazz Near You

Create a CSV file containing exactly 11 columns, in the following order:

Use the following exact column headings, in this order, for the first row of my CSV file:

• Date (in mm/dd/yy format only)
• Time (start time only; use 24 hour clock outside US and Canada)
• Event Title
• Headliner / Leader
• All Participating Musicians including leader (place in double quotes, comma separated, no instruments)
• City, State (optional)
• Venue Name (must match the venue name in the database)
• Festival Name (if associated with one)
• Price (digits only)
• Currency (three letter currency code like USD, EUR, JPY, GBP)
• Ticket URL (optional)

Preserve these headings exactly as written, including capitalization, punctuation, and spacing. Do not rename, reorder, add, or remove columns.

Step 3: Follow These Rules

• Create a separate row for each performance.
• If I have two performances on the same date, create two rows with their respective start times.
• Preserve the correct spelling of musicians, venues, festivals, and event titles.
• Don't substitute guessed venue names for unverified ones.
• Don't include instrument names in the participating musicians field.
• Don't invent ticket prices, performance times, URLs, or musician personnel.
• Leave optional fields blank when information is unavailable.
• Use proper CSV formatting for fields containing commas or quotation marks.
• Don't add columns or change their order.

Step 4: Check Your Work

Before generating my CSV file, please verify that:

• Every event contains exactly 11 fields.
• All dates use MM/DD/YY format.
• Performance times follow the appropriate regional convention.
• Venue names match Jazz Near You listings wherever you can verify them.
• Participating musicians are contained within a single CSV field.
• Ticket prices contain digits only.
• Currency codes contain three uppercase letters.
• There are no duplicate event records.

If you find missing, conflicting, or questionable information, bring it to my attention. Don't claim you've verified something unless you've actually checked it.

Step 5: Create My CSV File

Once you've organized and checked my events, show me a preview and identify anything that needs my attention.

After I approve the information, create a downloadable UTF-8 CSV file named JNY_Events.csv.

Make sure the file uses the official Jazz Near You column headings in the correct order and is ready to upload.

If you can't generate a downloadable CSV file, provide the complete CSV content in a code block so I can save it as a .csv file myself.

My Upcoming Performances

I'm ready to provide my upcoming performances. Please use the instructions above to organize them into a Jazz Near You-compatible CSV file.