Explore Fido
Moving from spreadsheets or another system
What to bring, the order to import it, how the CSV and XLSX templates work, and how Fido reports any row that needs attention.
Most organizations arrive with their records in spreadsheets or in another scheduling system. Fido reads CSV and XLSX files, so an export from either one is a starting point.
What to bring
| List | Useful to have |
|---|---|
| Clients and locations | Names, contact details, addresses, time zones. |
| Consumers | Name, contact details, communication modes, time zone, guardians for minors. |
| Providers | Contact details, address, employment status, service roles, skills, certifications and clearances with dates, travel radius, weekly availability. |
| Assignments and shifts | Dates and times, location, service types, number of providers needed, status. Upcoming work is the most useful. |
| Rates | Billing rates and provider pay by service type, set in Settings. |
| Finance records | Invoices, payables, pro forma statements and payment statements, when you want them in Fido. |
Import in order
- Clients, then their locations
- Consumers
- Providers
- Assignments and shifts
- Finance records
Assignments and shifts refer to the clients, consumers and providers already in Fido, so they come after the people. Set your rates before you import assignments, so each one is priced with your own rates.
How an import works
- Open the list and select the export and import icon on the toolbar.
- Choose Import.
- Download the sample template, as XLSX or CSV. It carries your organization's own dropdown values and an example row.
- Fill it in and keep the column headings as they are.
- Drag the file in. Fido accepts
.csvand.xlsxfiles up to 10 MB. - Select Import file.
The assignment template has four sheets: Quick Start, Template, Lookups and Instructions. Header colors show what each column needs, with red for required, pink for required in some cases and the rest optional. A yellow example row shows the format, and Fido skips it.
Imports run in the background. A progress bar shows the rows processed. When the run ends, it reads Success, Failed or Partial Success, with the counts of rows processed, succeeded and failed. An in-app notice follows, and an email too when some rows are rejected.
Creating and updating
- Leave ID blank to create a record. Enter an ID to update one.
- Clients, consumers and providers also match on email address, so a row whose email is already on file updates that record.
- Locations match on name.
- Assignments, shifts and portal requests match on ID only.
- On an update, a blank cell keeps the value already stored.
A new provider imported with an empty availability cell starts with Monday to Friday, 08:00 to 17:00. Include each provider's real hours so matching offers them work when they are free.
Every run has an error report
When rows need attention, select Download Error Report. It lists each row with its row number and an error message. Fix the listed rows and import them again. A dropdown value in your file, such as a service type or certification, must exist in your organization, and the error names any value Fido does not find.
Bring request forms along
Organizations that take requests through a web form can use Fido's request page, which clients and visitors use without signing in. A scheduler approves each request into an assignment. Fido also turns a calendar invite that lists your organization's calendar email into a request or assignment. See Client and consumer self-service portals.
Export works the same way
Every main list exports to CSV or XLSX, for the whole list or for the rows you select. Use an export to check your data, to share a list or to keep a copy. See Data ownership and export.
How it works
One sample job, step by step: what you see, and what Fido does behind it.
SampleClients import · clients.xlsx · Lincoln ISD
- MondayWhat you see: Dana K. opens the import menu on the Clients list and downloads the sample workbook.What Fido does: The workbook carries the organization's own dropdown values, color-coded headers and an example row, so the sheet matches the account.
- MondayWhat you see: Dana fills in her rows and puts a client's ID on one existing row.What Fido does: A row with an ID that Fido finds updates that record. Other clients are matched by email, and a row with no match is created.
- TuesdayWhat you see: Dana uploads the file and keeps working while a progress bar counts the rows.What Fido does: The import runs in the background and creates each record through the same service the screen uses, so the usual notifications and history entries fire.
- TuesdayWhat you see: An in-app notice and an email tell her the import finished with a few rows to fix.What Fido does: The person who ran the import gets both messages. The progress bar shows Partial Success with the rows processed, succeeded and failed.
- TuesdayWhat you see: Dana downloads the error report, fixes those rows and uploads again.What Fido does: The error file lists each failed row with its ROW NUMBER and ERROR MESSAGE, in the same CSV or XLSX format she uploaded.
Related
Plan a move with the Fido team
A live walkthrough built around your kind of work.