Re: [Citrusdb-users] Import New Accounts format

2012-08-20 Thread bryan
Paul, Yup! the organization id was missing. Then that goes on the first line then. Thank you for your help. Bryan On 2012-08-20 23:48, Paul Yasi wrote: > The organization ID is the 17th input, it is not inserted into the > customer table, but is used in the next step when it creates the > bil

Re: [Citrusdb-users] Import New Accounts format

2012-08-20 Thread Paul Yasi
The organization ID is the 17th input, it is not inserted into the customer table, but is used in the next step when it creates the billing record. Paul On Wed, Aug 15, 2012 at 1:45 AM, bryan wrote: > Paul, > > After doing a regex substitutions of my data like in your > safe_value_with_newlines

Re: [Citrusdb-users] Import New Accounts format

2012-08-14 Thread bryan
Paul, After doing a regex substitutions of my data like in your safe_value_with_newlines function (include/citrus_base.php), it came back up with the wrong number of items again... So looking at line 75 of tools/modules/billing/importnew.php found that the check of the number of fields was 17. Bu

Re: [Citrusdb-users] Import New Accounts format

2012-08-11 Thread bryan
Paul, Thanks. I will try just the service line(s) without quotes. Got crazy with the quotes because of commas in the addresses. On 2012-08-11 22:56, Paul Yasi wrote: > I think the quotes around the service attributes may be screwing it > up, can you try it without quotes, just comma separated. >

Re: [Citrusdb-users] Import New Accounts format

2012-08-11 Thread Paul Yasi
I think the quotes around the service attributes may be screwing it up, can you try it without quotes, just comma separated. Paul On Thu, Aug 9, 2012 at 2:58 AM, bryan wrote: > Paul, > > I have been unsuccessful in moving from our old invoicing system to > citrusdb. > All the data for the import

[Citrusdb-users] Import New Accounts format

2012-08-09 Thread bryan
Paul, I have been unsuccessful in moving from our old invoicing system to citrusdb. All the data for the import file is there even got the cards masked and GPG ascii armored. But the services line, I think, is giving me an incorrect number of items on each line when trying to import. The samp