Import what you already keep in spreadsheets into a cockpit, so it starts from your real records. Each import is checked before anything is written, and it writes every row or none of them.
Choose what to import
| Cockpit | What you can bring in | Where to start |
|---|---|---|
| People | Who works here, who they report to and the leave they have left. | Import your data after install, or the import screen in People's settings. |
| Finance | Where your old books left off: the chart of accounts, opening balances, contacts and open invoices and bills. | Import your data after install, or the import screen in Finance's settings. |
| Customers | The companies, contacts and leads you already track. | Import your data after install, or the import screen in Customers' settings. |
| Work | The projects you run and the open tasks on them. | Work > Import data. |
Import a CSV file
-
Open the import screen
After installing a cockpit, choose Import your data, or open the cockpit's import screen. If the cockpit offers more than one kind of import, pick what to import.
-
Start from the template
Under 1. Start from the template, choose Download the template and fill it in. What each column takes lists the columns and marks the required ones.
-
Check your file
Under 2. Check your file, choose Choose a CSV file. Checking writes nothing. Every row is tested exactly as the import would test it.
-
Fix any errors
If rows are marked as errors, fix them in your spreadsheet, save it as CSV and choose it again. Nothing is imported while a row has an error.
-
Import
Under 3. Import, choose the Import button, which names what it will add and update.
Every row is checked again when you import. If one fails, nothing is written. Files can be up to 2 MB. Split a larger file into smaller ones.
Work with older cockpits
A workspace that installed cockpits before the current six keeps using them, along with the features below. These features exist only in older cockpits.
Import a file into an older cockpit
-
Open the data tab
In the cockpit, open Data & sources. Under No tool to connect?, choose Upload and map.
-
Choose the file
Choose Choose a CSV or Excel file. Files must be .csv or .xlsx and up to 5 MB.
-
Match columns to fields
Under Match columns to fields, pick a column for each field, or Not used to skip it.
-
Choose how rows are matched
Under Update existing rows that match, pick a field to match on, or Add every row as new.
-
Import
Choose Import. Hoppflow reports how many rows were added, updated and skipped, and which had problems. Choose Done.
An import loads up to 5,000 rows, and a record type shows at most 5,000 rows.
Connect a source to an older cockpit
An older cockpit can keep several sources, one per record type and tool. The tool must be connected in your own account first. Choose Manual only (use Sync now) or Daily, automatically. On Free, sources do not sync on a schedule, so use Sync now.
A source shows one of these states: Connected, Needs reconnect, Failed, Out of date, Partly synced, Rate limited, Syncing, Disabled or Needs setup.
To run someone else's source under your own account, choose Take over as me.
Share a frozen view
A shared view is a snapshot. It shows the numbers at the moment you create the link, never later ones.
-
Open sharing
On the cockpit's dashboard, choose Share this view.
-
Choose how long it lasts
Under Stops working after, choose 7, 30 or 90 days, or Never expires. The default is 30 days.
-
Create the link
Choose Create link. Hoppflow creates the link and copies it.
Shared links are not indexed by search engines. A link that has expired or been turned off shows "This link is not available".
Turn off a shared link
Find the link under Links you have shared and choose Turn off link. Anyone opening it after that sees nothing.