You just received the SFTP credentials now what?
You will need an SFTP client to access the data. Follow the instructions in this article on how to access the data - https://help.franconnect.com/hc/en-us/articles/41172923063323-How-to-Access-your-SFTP-Export. Now that you have the data downloaded, here is a breakdown of how all of the data is stored.
Folder Structure
Within the 'writable' folder you will find a dated fold, a dated folder with 'csv' at the end and a 'Documents' folder. Additionally, if you have the FranConnect Training module, you will also have a 'Media'.
The dated folder, 2026-04-28 in the example above, will contain the data for all of the modules within your FranConnect platform in JSON format. While this format is readable and can be opened with any text editor, these files are primarily meant to be used as source files to be read programatically.
The dated csv folder, 2026-04-28-csv in the example above, will contain the data for all of the modules within your FranConnect platform in CSV format. These are more readable and can be used is you are looking for a specific piece of information.
The Documents folder will contain all of the documents from your FranConnect platform.
These 3 folders will have all of the data organized by module. The 'fim' folder contains all of the Info Manager module data. The 'fs' folder contains the Sales module data. The remaining folders are named accordingly per module.
If you have the FranConnect Training module, you will also have the media folder. This folder will contain all of the media files from your training courses.
File Structure
Each of the module folders within the dated folders will contain the data files for that module.
FIM (Info Manager) Module
Within the 'fim' folder, you will find a data file for each of the tabs within Info Manager. The 'fim_centerInfo_data' file is the primary file for identifying your locations. Within that file you will find the 'referenceId' column. This is the unique identifier for each location. You can use the 'referenceId' to correlate information about a location across all of the other data files. If any of the files contain references to documents, you can use the file name and locate the actual documents in the 'Documents\FIM_DOCUMENTS' folder.
FS (Sales) Module
Just like 'fim' folder, the 'fs' folder contains a data file for each of the tabs within the Sales module. The 'fs_lead_data' file is the primary file for identifying each of the leads within the platform. This file contains a 'referenceId' column that is the unique identifier for each individual lead. You can use the 'referenceId' to correlate information about a lead across all of the other data files. If any of the files contain references to actual documents, you can use the file name and locate the document in the 'Documents\FS_DOCUMENTS' folder.
Hub Module
The 'hub' folder will contain a 'hub_library_data' file. This file contains all of the details for all of your Hub Library documents. On the backend of FranConnect, Library files are stored in a single directory. The data file provides the folder hierarchy for each of the documents in the 'documentPath' column. The 'libraryDocumentFile' column is the actual name of the file. This can be used to search for that file in your export package or you can look for it directly in the 'Documents\intranet\library' folder.
Opener Module
The 'opener' folder will contain a data file for each of the opener checklists.
Support Module
The 'support' folder will contain a data file that is the details for every Support ticket created within the module.
Training Module
The 'training' folder will contain data files for all Training Sections and Quizzes.
Documents
When you see a reference to a document in any of the data files, it is strongly recommended that you use your computer's search function to locate that file in your download package. For most of the documents you will be able to locate them directly in the Documents\[modulename] folder, however there are instances where particular files are stored in different folders. One example is FDD documents. Those are stored in the 'Documents\UFOC' folder.
Additional Help
If you have additional questions regarding your data export, please reach out to helpdesk@franconnect.com.