Understanding the FranConnect Data Export

1 min read

Make sense of your FranConnect data export: what's in each folder, which file identifies your records, and how to find the documents they reference.

Before you begin

You need the export downloaded to your computer. If you have just received SFTP credentials, follow How to Access your SFTP Export first.

Folder structure

Inside the writable folder you'll find a dated folder, a dated folder ending in -csv, a Documents folder, and a Media folder if you have the Training module.

Top-level folders inside the writable folder of the export

Fig 1 — Top-level folders in the export.
Folder What's in it
Dated folder (e.g. 2026-04-28) All module data in JSON — readable in a text editor, but meant to be read programmatically
Dated -csv folder The same data in CSV — easier to read when you're looking for one specific value
Documents Every document from your platform
Media Training course media files (Training module only)

Data organised by module

Each of those folders is split by module — fim is Info Manager, fs is Sales, and the rest are named after their module.

Module subfolders inside a dated export folder

Fig 2 — Module folders inside the dated folder.

Which file to start with

Module Key file and identifier
fim (Info Manager) fim_centerInfo_data identifies your locations. Use its referenceId to join to every other fim file. Documents live in Documents\FIM_DOCUMENTS.
fs (Sales) fs_lead_data identifies each lead. Use its referenceId to join to every other fs file. Documents live in Documents\FS_DOCUMENTS.
hub hub_library_data lists every Hub Library document. documentPath gives the folder hierarchy and libraryDocumentFile the real file name, found under Documents\intranet\library.
opener One data file per Opener checklist
support One data file with every Support ticket created
training Data files for all Training sections and quizzes

Finding a referenced document

When a data file names a document, search your download package for that file name rather than browsing by hand.

Note

Most documents sit in Documents\[modulename], but some are elsewhere — FDD documents, for example, are stored under Documents\UFOC.

Need more help

For questions about your data export, contact helpdesk@franconnect.com.

Was this article helpful?
Your feedback helps us improve our documentation.