ClearLevy DEX file check
Make your monthly upload file
This tool is for CHSP meal delivery and transport providers. It turns your spreadsheet into the bulk upload file for the Data Exchange. Checking is free.
1 Who's using it
2 Your Data Exchange reference files
Your Organisation Administrator downloads these three files from the Reference data page in the Data Exchange. They tell this tool your codes, services and outlets, and the exact rules your upload file must follow. They contain no client details. Your browser keeps them on this computer, so you only need to load them again when they change.
The tool uses the schema file to check your finished file against the Data Exchange's own rules before you upload it. You can go on without it, but it's worth loading.
3 Your spreadsheet
You need two lists: your clients (one row per client) and your deliveries (one row per client per delivery or trip). They can be two sheets in one Excel file, or two files. Excel (.xlsx) and CSV both work.
4 Match your columns
The tool has matched the columns it can. Check each match, and fill in any gaps. If a column isn't in your sheet but is the same for everyone (for example "Delivered by a volunteer: Yes"), choose it once under Same for every row. The tool remembers your choices for next month.
Client list
Deliveries
5 What to fix
6 Get your upload file
Check your client IDs before you upload. If a client ID in this file is already in the Data Exchange, uploading this file updates that client's record there. Each client ID must be the one that client already has in the Data Exchange, or a new one for a new client.
If you've been typing clients into the Data Exchange by hand, try your first file in the Data Exchange's test (staging) area. Your organisation can ask the Data Exchange helpdesk for access.
The upload file costs A$29 a month per organisation (no GST), and you can cancel any time. Each file is checked against the published Data Exchange rules, but we can't promise every file will be accepted. If the Data Exchange rejects a file because of a mistake in our file, we refund that month.
Stripe opens in a new tab, so you keep your place here. When you've paid, your unlock code appears straight away and is filled in below. Each month after that, this computer gets your new code by itself while your subscription is active.
Paid on another computer, or lost your code? Email thomas@clearlevy.com with your Stripe receipt, and we'll send your code.
How to upload it
- Your Organisation Administrator signs in to the Data Exchange.
- Go to Uploaded files, then Upload new file, and choose this file.
- When it's processed, check the upload's details. If anything failed, download the error file, fix those rows in your spreadsheet, and make a new file here.