FATHOM

A deep-dive into all things ORCA.
From core concepts to advanced settings.

Bringing Your Data In

Connecting Another System

Exporting spreadsheets from your old CRM and loading them one by one gets old quickly. Connect the old system instead: you sign in to it once, ORCA proposes where everything goes, and brings it across. It can then keep ORCA in step every night until the day you move over.

Zoho CRM is the first system ORCA can connect to. It's listed where it is switched on for your ORCA. If you don't see it, import from a spreadsheet works for any system, or ask us at support@orca-crm.com.

ORCA only reads the other system. It never changes anything there.


Where to Find It

Go to Settings > Import and look under Or connect the system you are moving from. You need Settings access to see it, and a role that can use every section: a connection writes to whichever sections it is pointed at, so a role limited to some sections, or to its own records, can't manage one.

Each system says where it stands: Not connected., Connected, with when it was last brought in, or Needs connecting again. The button beside it is Connect or Open.


Connecting

The page explains what will happen, then you press Connect Zoho CRM. You're sent to Zoho to sign in and say ORCA may read it, then brought back.

A few things to know before you do:

  • It's read-only. ORCA asks Zoho for permission to read records and how they're laid out, and for nothing else.
  • Sign in as someone who can see everything you want brought across. ORCA sees what they see.
  • Runs act as you in ORCA, with your access to sections and your sign-offs. More on that below.
  • You can disconnect at any time. What has come across stays.

Once you're back, ORCA says "Zoho CRM is connected. Below is what ORCA will bring in. Nothing has been brought in yet."


What ORCA Will Bring In

ORCA reads what kinds of record you keep in Zoho and proposes where each one goes. The aim is that you have nothing to fill in. The table lists each kind of record In Zoho CRM, where it Goes to, its Fields, and when it was Last brought in.

Out of the box:

  • Accounts go to your Accounts.
  • Contacts go to your Contacts, linked to their account.
  • Deals become a new section of their own, called Deals, with a field for each Zoho field it can bring across, picklists with their options, and a board laid out by stage.
  • Anything else starts as Not brought in.

That's a proposal, not a decision. For each kind of record you can choose Not brought in, Accounts, Contacts, a new section made from it, or one of the sections you already have. Press Save changes when you're done. Each place in ORCA takes one kind of record, so two can't both go to Contacts.

A few limits:

  • A new section is only offered to people who could build one by hand in Settings: create sections, templates, fields and picklists.
  • Sections behind a barrier aren't offered.

Which field fills which

For anything going to your Accounts, your Contacts or a section you already have, the Fields column says how many fields are matched. Click it to open Match the fields. ORCA has matched what it could. For each ORCA field, choose the Zoho field that fills it, or leave it on Skip, which brings nothing in and keeps whatever the field holds in ORCA. Press Save matching.

For a new section, See the section shows The section it will become: each field, its kind, and which Zoho field fills it, with the one that names each record marked. Nothing is made until the first time you bring it in. After that, the section is yours to change in Settings like any other.

Some fields stay in Zoho, and Not brought across lists them with the reason. Subforms and multi-select lookups are among them, and files aren't brought across.


Preview

Preview reads Zoho and works out what would be added and changed, with nothing written, not even a new section. For each kind of record it shows the counts To add, To update, Already match and To skip, and underneath:

  • a new section that will be made;
  • stage changes that will be left out, because the stage needs a sign-off you can't give;
  • rows that will be skipped, how many, why, and the first few of their Zoho IDs;
  • values ORCA has no match for, such as a picklist option it doesn't have. The field is left as it is on those;
  • anything deleted in Zoho. See Deleted in the other system.

A preview runs in the background, like a run, and the page keeps up as it reads. When it has finished it says how many records there are in all and about how long bringing them in should take.

Change the plan and press Preview again as often as you like. A preview and a run can't go at the same time: while one is under way, the buttons for the other wait.


Bring It In

Bring it in runs in the background, so you can leave the page. If you stay, it keeps up as it goes, then shows what was Added, Updated, Already matched and Skipped for each kind of record, with the same notes as the preview.

What is already in ORCA is matched and updated, never added twice, so it's safe to run as often as you like. Accounts and contacts you typed in by hand are found by company name and by email, so they aren't doubled up either.

After the first run there are two buttons:

  • Bring in what has changed: only what has changed in Zoho since the last run. Anything left behind last time (a row skipped, a stage held, a value ORCA had no match for) is asked for again.
  • Bring everything in again: the lot.

The first run brings accounts in first, then contacts, then sections, so a deal can find its account. A link that points at something not across yet is filled in by the next run.


Keep in Step Every Night

Tick Keep in step every night under the plan and press Save changes. Each night ORCA brings in what has changed in Zoho since the last run.

While it's on, Zoho's values replace ORCA's for the fields matched here, so make changes in Zoho, not ORCA. Switch it off the day you move over.


Deleted in the Other System

Nothing is ever deleted in ORCA because it was deleted in Zoho.

  • Records in a section that were deleted in Zoho are archived in ORCA, and can be brought back from the archive like any other.
  • Accounts and contacts have no archive in ORCA, so they're left as they are, and the preview and the run list them by name so you can decide.

Who a Run Acts As

A run acts as the person who connected Zoho: their access to sections, and their sign-offs. A stage change that needs a sign-off they can't give is left out and counted, and the rest of the record still comes across. A frozen record is skipped, with the reason.

So connect as someone whose access covers everything that's coming across.


Connecting Again

If Zoho stops accepting the connection, the page asks you to Connect again. That happens when access is withdrawn in Zoho, or the person who connected leaves. Connect again and it carries on where it was. Nothing is brought in twice.


Disconnect

Disconnect at the foot of the page makes ORCA forget its access to Zoho and stops the nightly run. Everything already brought in stays, and connecting again later carries on from there.


Zoho Exports and the Connection Agree

If you have already been loading Zoho exports through the spreadsheet import with "Zoho" as the source, the connection recognises those records by their Zoho IDs and updates them rather than adding them again. The same works the other way round.


Previous
Importing from a Spreadsheet