PowerChurch API?

mrbgty · Post by **mrbgty** » Tue Feb 05, 2008 11:55 am

Sorry if this question is obvious. I can't seem to find it anywhere on the site.

Does PowerChurch have an API reference I can use to work with the program? Thanks a bunch.

Matt · Post by **Matt** » Tue Feb 05, 2008 8:02 pm

What's an API reference?

mrbgty · Post by **mrbgty** » Tue Feb 05, 2008 10:47 pm

Does PowerChurch provide an API(Application Program Interface) library to allow other programs to interact with it?

I was looking for a reference for one but I guess there might not be one at all. The API would allow someone to write a program that could call PowerChurch functions to execute various tasks.

Post by **Jeff** » Wed Feb 06, 2008 9:07 am

There is no publicly exposed API for PowerChurch. If you let us know what you are trying to accomplish, we may be able to offer other suggestions to help.

mrbgty · Post by **mrbgty** » Wed Feb 06, 2008 9:18 am

It's OK. I want to pull transactions from an excel sheet and put them into PowerChurch. I know some other ways to do it but wanted to be sure there wasn't an API already.

thanks a bunch.

Post by **Jeff** » Wed Feb 06, 2008 10:45 am

You can import general ledger transactions into Fund Accounting from a CSV or tab delimited file. This was originally developed to interface with a Canadian payroll company. Go to Accounting -> Fund Accounting -> Import Transactions. Press F1 on the dialog that is displayed and it will give you the file format that we are expecting.

mrbgty · Post by **mrbgty** » Fri Feb 08, 2008 6:41 pm

Thanks, this may help. Is this the format I am to use?

For a successful import:

♦ The file must be in an ASCII format (comma separated or tab delimited).

♦ The header record must be the first line and must contain the names of the fields in the order they appear in the following layout:

Check number
Check number or reference number

Batch Date
Format: mm/dd/yy

Memo
Transaction description, 25 characters maximum

Account number
Format: FFMMMMSSS

Note: Do not use hyphens

Debit amount
Format: #########9.99

Credit amount
Format: #########9.99

From the text, It looks like the first line in the file should be this?
Check number Batch Date Memo Account number Debit amount Credit amount

I enter credits/debits into different account #'s, thought, so I'm not quite sure if this will work.

Post by **Jeff** » Mon Feb 11, 2008 9:23 am

That is the correct format. For each transaction you are going to have at least 2 lines. The import would look like this.

Code: Select all

"CONTRIB.",03/26/2007,"Contributions 03/26/2007","011110000",985.00,0.00
"CONTRIB.",03/26/2007,"Contributions 03/26/2007","014030000",0.00,935.00
"CONTRIB.",03/26/2007,"Contributions 03/26/2007","014210100",0.00,50.00

mrbgty · Post by **mrbgty** » Tue Mar 11, 2008 1:01 am

Thank you. This is very helpful.