[freeside] Question about imported data.
mark at ns2.pc-intouch.com
Wed Jul 14 16:08:51 PDT 1999
-----BEGIN PGP SIGNED MESSAGE-----
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v0.9.7 (GNU/Linux)
Comment: PGPEnvelope - http://www.bigfoot.com/~ftobin/resources.html
-----END PGP SIGNATURE-----
More information about the freeside-users