Download–transform–upload across portals
Pull files from one portal, transform them and submit to another with no API on either side.
20 project-authored proposals · taxonomy v1.1 · 0 new benchmark runs. Verifiers and partial-credit rules below are designs, not executed results.
- Typical applications
- browsers · Excel · portals
- Class GUI-need label
G3· GUI-only
Task proposals · 20
Expand to inspect the complete original wording and proposed checks. Original proposal text remains English in both interfaces.
R04.07.01.02-T01 Move a bank statement export into an accounting portal's import
Original instruction
Log in to the sandbox bank portal (test credentials provided), download the September 2026 statement for account ending 4471 as CSV, then log in to the sandbox accounting portal and import it on the 'Bank feeds › Import' page for the matching bank account, mapping Date, Description and Amount columns.
- Platforms
web· Any OS (web)- Applications
- browsers · portals
- Interfaces
brow· Browser- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicknav· Pan/zoom/scroll- Work product
WP08· App/system state- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
Accounting portal DB: one import batch for the right account with 63 transactions equal to the bank's September data; column mapping correct (signs); file hash equals bank download. Neither portal has an API; uploads require UI session tokens.
Proposed partial credit
30% correct statement downloaded; 20% right target account; 35% transactions imported correctly; 15% mapping.
R04.07.01.02-T02 Attach a customer PO from one portal to an invoice in another
Original instruction
Download purchase order PO-88213 (PDF) from the sandbox customer procurement portal, then in the sandbox billing portal open draft invoice INV-3307, type the PO number into its 'Customer PO' field and attach the PDF. Save the invoice as draft.
- Platforms
web· Any OS (web)- Applications
- browsers · portals
- Interfaces
brow· Browser- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicktype· Text & formsmulti· Cross-app- Work product
WP08· App/system state- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
Billing DB: INV-3307 customer_po = 'PO-88213', one attachment whose hash equals the PO PDF served by the procurement portal; status still draft. No API access to either portal.
Proposed partial credit
35% correct PDF downloaded and attached; 35% PO number field; 30% invoice left in draft with nothing else changed.
R04.07.01.02-T03 Summarize a timesheet export by project and upload it to payroll
Original instruction
Export last month's timesheet report (XLSX) from the sandbox time-tracking portal, aggregate hours by employee and project in Excel into the payroll portal's template input/payroll_template.csv (EmpID, ProjectCode, RegularHrs, OTHrs; OT = hours over 40/week), and upload it on the payroll portal's 'Import hours' page.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Payroll DB import batch rows equal key (EmpID, ProjectCode, hours to 0.25); weekly OT split correct; batch status 'accepted' with 0 rejected rows; source export hash matches the period requested. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
15% right export; 50% aggregated rows correct; 20% OT split; 15% upload accepted.
R04.07.01.02-T04 Pull invoices from a 2FA vendor portal and file them as expense claims
Original instruction
Sign in to the sandbox vendor portal with the test password and the TOTP code from the provided test authenticator, download the 6 invoices dated in August 2026, rename them '<PO>_<InvoiceNo>.pdf', and upload each to the matching PO in the sandbox expense system with the invoice amount entered.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicktype· Text & formsmulti· Cross-app- Work product
WP09· Files & folders- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Expense DB: 6 attachments linked to the right POs with filenames per convention and hashes equal portal files; amounts exact; no invoices outside August uploaded. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
20% login + correct 6 downloads; 20% renaming; 40% matched to POs; 20% amounts.
R04.07.01.02-T05 Send lab results from an EHR to a referral clinic via an e-fax portal
Original instruction
In the sandbox EHR, export the latest lipid panel PDF for the 4 synthetic patients listed in input/referrals.csv, then in the sandbox e-fax web portal send one fax per patient to the referral clinic's number with a cover sheet (patient initials, DOB, 'Lipid panel'). Stop after each fax shows 'Queued'.
- Platforms
web· Any OS (web)- Applications
- browsers · portals
- Interfaces
brow· Browser- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicktype· Text & formsmulti· Cross-app- Work product
WP08· App/system state- Conditions
risk· Irreversible/risky- Proposed difficulty
- 3 / 5
Proposed verifier
e-fax DB: 4 jobs to the right number; attachments hash-equal to the EHR's latest lipid panel for each patient (not older panels); cover fields exact; status queued; no other recipients. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
35% correct documents exported; 30% faxes addressed correctly; 20% cover sheets; 15% no extra sends.
R04.07.01.02-T06 Move consented CRM leads into an email-marketing list
Original instruction
Export the 'Webinar Oct' leads view (CSV) from the sandbox CRM, in Excel keep only rows with Consent = Yes, dedupe by email (keep newest), split full name into first/last, then import into the sandbox email-marketing portal's list 'Webinar follow-up' mapping fields to its merge tags.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Marketing DB list: subscriber set equals key (consented, deduped), FNAME/LNAME fields exact; no non-consented emails present (hard fail if any); import log shows one import from a browser session; the portal issues no API token and requires CSRF tokens.
Proposed partial credit
30% consent filter (any violation zeroes this); 25% dedupe; 20% name split; 25% import mapped correctly.
R04.07.01.02-T07 Build a county table in a statistics portal and publish it internally
Original instruction
In the sandbox statistics portal's table builder, select median household income and population for all counties of state 'NV' for 2024, download CSV, reshape in Excel to the internal dashboard schema (FIPS, County, Year, Metric, Value), and upload it as dataset 'NV county 2024' in the sandbox dashboard portal.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clickmulti· Cross-apptype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Dashboard DB dataset rows equal key (17 counties × 2 metrics); FIPS zero-padded; dataset name exact; the table-builder query log shows the right selections. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
30% correct portal query; 40% reshape; 15% FIPS formatting; 15% upload with name.
R04.07.01.02-T08 Convert an LMS gradebook export into registrar letter grades
Original instruction
Export the final gradebook for course BIO-210 from the sandbox LMS, convert percentages to letter grades with input/grading_scale.pdf (incl. +/−), apply the 2 approved incompletes ('I'), and upload the registrar portal's grade roster CSV for section 02 only.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-apprisk· Irreversible/risky- Proposed difficulty
- 3 / 5
Proposed verifier
Registrar DB roster: 38 section-02 students with letter grades equal key; 2 'I' grades; no section-01 students; roster left in 'submitted for review' (not finalized). Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
15% correct export; 45% letter grades; 15% incompletes; 25% section filter and stop before finalization.
R04.07.01.02-T09 Map a supplier price list to a marketplace bulk template and fix rejects
Original instruction
Download the supplier price list (XLSX with merged headers) from the sandbox supplier portal, map it to the marketplace's bulk-upload template (SKU, Title, Price, Stock, Category ID via input/category_map.csv), upload it in the sandbox seller portal, download its error report and fix and re-upload the rejected rows.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Seller DB: all 240 SKUs live with price/stock/category equal key; final upload batch has 0 errors; the first batch's rejected SKUs appear in a later batch. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
35% mapping correct; 25% first upload; 30% rejects fixed; 10% no duplicate listings.
R04.07.01.02-T10 Round-trip orders to a carrier portal and post tracking numbers back
Original instruction
Export today's unshipped orders from the sandbox store admin, transform to the sandbox carrier portal's batch template (address split, weight in oz), upload and buy labels (test mode), download the tracking CSV and labels PDF, then upload tracking numbers back to the store's 'Bulk fulfil' page.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP08· App/system state- Conditions
multiapp· Multi-apprisk· Irreversible/riskylong· Long-horizon- Proposed difficulty
- 4 / 5
Proposed verifier
Carrier sandbox: one batch with 27 shipments, addresses/weights equal key; store DB: each order fulfilled with the matching tracking number; labels PDF page count 27; no order fulfilled twice. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
15% export; 30% carrier batch correct; 25% labels and no duplicate fulfilment; 30% tracking posted back.
R04.07.01.02-T11 Consolidate policy schedules from three insurer portals for a client
Original instruction
Download the current policy schedules for client 'Harbor Foods' from three sandbox insurer portals (PDF, XLSX and an HTML table view), consolidate into input/schedule_template.xlsx (policy no., insurer, line, limit, deductible, premium, renewal), and upload it to the client's folder in the sandbox broker client portal.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
multi· Cross-appvis· Visual judgmenttype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 4 / 5
Proposed verifier
Uploaded workbook hash matches the file in the client folder; rows equal key (11 policies) with exact numbers and ISO dates; no policies of other clients included. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
30% three sources retrieved; 50% consolidated values; 20% uploaded to right folder.
R04.07.01.02-T12 Create new-hire records from signed offers in an e-sign portal
Original instruction
From the sandbox e-signature portal download the 5 completed offer letters signed this week, read each start date, salary and manager, then create new-hire records in the sandbox HRIS portal with those values and attach the signed PDF to each record.
- Platforms
web· Any OS (web)- Applications
- browsers · portals
- Interfaces
brow· Browser- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clickvis· Visual judgmenttype· Text & forms- Work product
WP08· App/system state- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
HRIS DB: 5 new-hire records with start date, salary, manager equal key; attachments hash-equal to the completed (signed) envelopes, not drafts; no records for unsigned offers. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
25% correct envelopes; 45% record fields; 20% attachments; 10% no extras.
R04.07.01.02-T13 File a sponsor financial report from a university finance export
Original instruction
Download the FY26 Q1 expenditure detail for award AWD-5521 from the sandbox finance portal, map 63 transactions to the sponsor's budget categories using input/object_code_map.csv, and complete the sponsor portal's quarterly financial report form (category totals, cumulative, attachment), saving it ready for certification.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
multi· Cross-apptype· Text & formsclick· Point & click- Work product
WP02· Records/table- Conditions
multiapp· Multi-apprisk· Irreversible/risky- Proposed difficulty
- 4 / 5
Proposed verifier
Sponsor DB report: category totals equal key to the dollar; cumulative = prior + current; attachment present; status 'ready_for_certification' (not certified). Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
15% export; 45% category totals; 15% cumulative; 25% attachment and left uncertified.
R04.07.01.02-T14 Reconcile four bank portals and a payout report into a journal upload
Original instruction
Download September statements from 4 sandbox bank portals and the payment processor's payout report, reconcile them in Excel against input/gl_cash_sept.xlsx, build the adjusting journal entry CSV in the accounting portal's import format, upload it, and fix any upload validation errors until accepted (unposted).
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-applong· Long-horizonrisk· Irreversible/risky- Proposed difficulty
- 5 / 5
Proposed verifier
Accounting DB: one accepted, unposted JE batch whose lines equal key (accounts, amounts, memo refs) and balance to zero; all 5 source files retrieved for the right period (hashes). Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
20% sources retrieved; 40% JE lines correct; 20% upload errors resolved; 20% balanced and unposted.
R04.07.01.02-T15 Transform an EDC export to the sponsor template and upload with queries
Original instruction
Export the 'AE' and 'VS' instruments for study DEMO-07 from the sandbox REDCap, transform them in Excel to the sponsor's SDTM-like templates (AE, VS domains; ISO 8601 dates; controlled terms via input/ct_map.csv), upload both to the sponsor data portal, then answer the 3 data queries it raises by correcting the source in REDCap.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · REDCap · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-apptype· Text & formsclick· Point & click- Work product
WP02· Records/table- Conditions
multiapp· Multi-applong· Long-horizon- Proposed difficulty
- 5 / 5
Proposed verifier
Sponsor DB: AE and VS datasets equal key after query fixes; controlled terms valid; ISO dates; 3 queries closed with REDCap audit trail entries showing the corrections. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
20% exports; 40% transformed datasets; 15% upload accepted; 25% queries resolved at source.
R04.07.01.02-T16 Carry 25 listings with photos from an MLS portal into a brokerage CRM
Original instruction
The sandbox MLS portal has no export. For the 25 listings in saved search 'Agent Lee – Active', copy key fields (address, price, beds, baths, sqft, status) into input/listings_import.xlsx, download each listing's first 3 photos, then bulk-import the sheet into the sandbox brokerage CRM and attach the photos to each listing.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
nav· Pan/zoom/scrollmulti· Cross-apptype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-applong· Long-horizon- Proposed difficulty
- 5 / 5
Proposed verifier
CRM DB: 25 listings with fields equal key; 75 photos with hashes equal the MLS first-3 photos per listing; no listings outside the saved search. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
45% listing fields; 35% photos; 20% correct set and no duplicates.
R04.07.01.02-T17 Control pair of T03: build the payroll CSV from the export by script
Original instruction
Control pair of T03. Given the timesheet export already saved as input/timesheets_export.xlsx, produce output/payroll_hours.csv in the payroll template with the same aggregation and weekly overtime rule using pandas from the terminal. No portal interaction.
- Platforms
mac· macOSwin· Windowslin· Linux- Applications
- pandas
- Interfaces
term· Terminal- GUI need · task setting
CL· CLI-sufficient- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
code· Code & commands- Work product
WP02· Records/table- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
CSV rows equal T03 key; isolates the transform step to measure how much of T03's difficulty is the portal interaction.
Proposed partial credit
60% aggregated rows; 25% OT split; 15% template format.
R04.07.01.02-T18 Finish a 30-file transfer through a portal that keeps timing out
Original instruction
The sandbox document vault logs out after 5 idle minutes and randomly expires sessions. Download the 30 contract PDFs in folder 'Renewals 2026' and upload each to the matching customer record in the sandbox CRM (map by contract number), resuming after every logout without duplicating uploads.
- Platforms
web· Any OS (web)- Applications
- browsers · portals
- Interfaces
brow· Browser- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicknav· Pan/zoom/scrollmulti· Cross-app- Work product
WP09· Files & folders- Conditions
interrupt· Interruptionslong· Long-horizonmultiapp· Multi-app- Proposed difficulty
- 4 / 5
Proposed verifier
CRM DB: 30 attachments on the right customers with hashes equal vault files; zero duplicate uploads; vault access log shows ≥3 forced re-logins handled. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
60% files correctly attached (pro-rata over 30); 25% no duplicates; 15% complete despite interruptions.
R04.07.01.02-T19 Retrieve a protected ZIP and file selected documents with metadata
Original instruction
Download the encrypted ZIP from the sandbox secure-transfer portal link in the test mailbox; its password arrives in a second email. Extract it, then upload only the 4 executed agreements (not drafts) to the sandbox document management portal under 'Legal/Contracts/2026' with metadata Counterparty, Effective Date and Type.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · portals · Mail
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
multi· Cross-appclick· Point & clicktype· Text & forms- Work product
WP09· Files & folders- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
DMS DB: 4 documents in the right folder whose hashes equal the executed versions in the ZIP; metadata equal key; no drafts uploaded. Portals expose no API; uploads need UI session (CSRF) tokens and are logged per page view.
Proposed partial credit
20% ZIP retrieved and opened; 35% right 4 files; 35% metadata; 10% no drafts.
R04.07.01.02-T20 Reprice 60 SKUs from a partner feed through a web bulk-edit grid
Original instruction
Download the competitor price feed (CSV) from the sandbox partner portal, compute new prices in Excel per input/pricing_rules.md (match minus 2%, floor at cost × 1.15, round to .99), then update the 60 SKUs in the sandbox store admin's bulk-edit grid (paste into the web grid; it has no file import) and save.
- Platforms
web· Any OS (web)mac· macOSwin· Windows- Applications
- browsers · Excel · portals
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
HY· Hybrid- Interaction primitives
multi· Cross-apptype· Text & formsclick· Point & click- Work product
WP08· App/system state- Conditions
multiapp· Multi-app- Proposed difficulty
- 4 / 5
Proposed verifier
Store DB: 60 SKU prices equal rule-computed key; other SKUs unchanged; the grid's save log shows edits through the UI session; no price below floor.
Proposed partial credit
15% feed retrieved; 35% computed prices; 40% grid updates saved; 10% other SKUs untouched.
Mapped research references
Existing benchmark-to-class links from the research catalog. They are not record-level annotations, executions or product endorsements.