exporting billing data

[johnsonrv]

Shawn,
I have a new customer that is a Telecom reseller he currently get his data from SBC, Verizon in a text file format.
He needs us to send the data for just his customers in a text file format so he can bill it to his customers.

I know you have and export function for billing cycle data but I can not find a lot of info in the manual.

I envision the line to look something like:
Login, Company Name, product ID, Dollar amount
If one of his customers has several product ID’s then
there could be a line for each item with the Login, Company Name staying the same.

Question 1: Will this work and if so how would I go about setting it up?
Question 2: If not do you have another idea?

Thanks

Bob

[l0cke]

You can do this a couple of ways:

If you have FileMaker Unlimited you can pull the customer data from 'MainMenu' and the billing cycle data from 'LineItems_' via XML or CDML.
You can use Optigold's built in export. You would need to export the Customer Data and the Billing Cycle Items. Once you have these two data files you can tie the records together by the Customer Id.

I would recommend using XML if possible as you can create a script which will pull the data for you on demand.

[digitalpoint]

Best way would be to export billing cycle data with the following fields:

Billing Cycle Customer::Login
Billing Cycle Customer::Company Name
Product ID
Unit Price

[johnsonrv]

:confused:

Shawn,

I tryed your method:

Best way would be to export billing cycle data with the following fields:

Billing Cycle Customer::Login
Billing Cycle Customer::Company Name
Product ID
Unit Price
__________________
- Shawn


But it did it for all my customers.
I need it to do it for the found set only.

Bob

[digitalpoint]

But it did it for all my customers.
I need it to do it for the found set only.

There is not a way to do it for a found set of customers, because you are exporting something other than customers (billing cycle items), which comes from a different table.