MIP Definition File

To import transactions into MIP, you need to set up a MIP Definition File. When you set up the file, you specify the starting position and length of each transaction split that you track in MIP. For each split, this information varies based on where you store the matching information in eTapestry.

For each transaction in your eTapestry query, the MIP Export file includes a credit and debit record. The export file is formatted with fixed length fields. The starting position and length for each field appear in the following table.

MIP Export File Format
MIP Field Name	Starting Position	Length	eTapestry Data Source
Session Number	1	12	Session ID from Export Launch Page
Document Number	13	15	Document Number from Export Launch Page
Session Description	28	60	Session Description from Export Launch Page
Session Date	88	10	Date from Export Launch Page
Transaction Debit Amount	98	17	Debit amount (blank on Credit line)
Transaction Credit Amount	115	17	Credit amount (blank on Debit line)
Transaction Split(s) from Fund	132	36	From Fund: Credit Account on Credit Line, Debit Account on Debit line
Transaction Date	168	10	Date from eTapestry transaction
Transaction Split(s) from Location	178	10	Location user-defined field
Transaction Split(s) from Program	188	10	Program user-defined field
Transaction Split(s) from Department	198	10	Department user-defined field
Transaction Split(s) from Grant	208	10	Grant user-defined field
Donor Name	218	45	Donor Name
Transaction ID	263	3	Generated during export to mark each donation as a separate MIP transaction

For example, you may have stored three splits in the Account fields on the Fund. The first split is the GL code, which is 6 digits long. The second split is the Cost Center, which is 4 digits long. Third split is the Restriction, which is one digit long. You separated the splits using a dash (-), so that the accounts on the Fund have values such as: 156430-5299-1. The export file will include this entire value starting in position 132. Your MIP Definition file would specify that the GL Code starts in position 132 and is 6 characters long, the Cost Center split starts in position 139 and is 4 characters long, and the Restriction split starts in position 144 and is one character long.

Sample:

Session ID	Document Number	Description	Session Date	Amount	GL Number	Location	Program	Department	Grant
session#	session#	description	06172002	25.25	revenue #	UDF	UDF	UDF	UDF