[freeside] Question about imported data.

[Mark Wells]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 14 Jul 1999, Tech Account wrote:

> I set them all to the same package, and this seems to have worked.
> However, even though I had created the package and services ahead of
> time, none of the customers packages have services attached.

I don't know if you've checked this, but are the pkgnums and svcnums
correct in the cust_svc table?  This seems like the most likely suspect.

> Also, is there a way to import data such that multiple entries for
> the same name simply get different packages? I couldn't find a way
> to do this, but it would be helpful, since our current system sends
> out a different invoice for each package.

That's similar to the problem we had.  We dealt with it by doing a SELECT
DISTINCTROW on the import table and only specifying the fields that need
to go in cust_main, and then doing the same with cust_pkg, cust_svc, and
svc_acct.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v0.9.7 (GNU/Linux)
Comment: PGPEnvelope - http://www.bigfoot.com/~ftobin/resources.html

iD8DBQE3jRVl2GOwREX5+xQRAnPUAJ0XZHq5iGMYjKKI9KuMWixjO17bVQCg3RNC
UkDc5cytfrqY9GeTSJJSOEU=
=svr/
-----END PGP SIGNATURE-----