Did you know you can export your customer data out of PayGo and into a saveable local file? It’s easy!

The formats recommended for your target file are as follows (there are other formats available if the product you are using requires them, but here is a list of commonly used ones):

Tab-separated text document (.tab or .txt)
Comma-separated text document (.csv or .txt)
FileMaker Pro 12 (or above) document (.fmp12, .fmp## for current FileMaker version) 

Locating Your Customer Data

On your central Customers screen (accessed via the Menu button), click the List Customers button at the top of the screen. This will open the Customers screen.

At the top of the Customers screen, click the Export/Import button. This will open a pop-up window asking if you’d like to Import or Export. Click the Export button to continue.

A File Explorer screen for your computer will open. Select the location and file type you would like to use for your export, name your file, and click the Save button.

Note: Depending on your selected file type, you may be asked to provide Worksheet, Author or other types of information. This information is optional.

A Field Order screen will open, which will allow you to select the information you will be exporting. To select an option for export, select the option on the left side of the screen and then click the Move button, or simply double-click your selection and it will be added automatically. To add all data options to your file, click the Move All button. You can reorder your fields by selecting and dragging fields up or down within your selection box. A popular (but not required) format for customer information is as follows:

Note: the label for each item is listed first, followed by the actual field name in PayGo.

Customer Information Spreadsheet

Customer Name: Customer_Name
First Name: First_Name
Last Name: Last_Name
Address: Address
City: City
State: State
Zip: Zip
Country: Country
Email: Email
Phone Number: Phone_Number
Mobile Phone: Cel_Phone
Fax Number: Fax Num

          Targeting Data Spreadsheet

Marketing Fields: m_field1 through m_field20
Birthday: Birthday
Record Type: Customer_Record_Type
Representative: Representative
Comments: Comments

When you have selected all of your fields, click the Export button. Your exported  information will be saved to your specified location.

Tip: Would you like to only export certain customer files? No problem! Simply use the Search bars located on your central Customers screen (or the Search button on your Menu) to locate the customers you’d like to export. Your Find screen will have an Export/Import button at the top for exporting the selected files.