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 <br...@inter.net> wrote:
> 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.
> But looking below that there are only 16 from the $line input.
> The signup_date column is filled in with the CURRENT_DATE SQL and
> doesn't count?
>
> Now if I did something wrong, just yell at me because I am just
> looking at the parts.
>
>
> On 2012-08-12 01:02, bryan wrote:
>> 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.
>>>
>>> Paul
>>>
>>> On Thu, Aug 9, 2012 at 2:58 AM, bryan <br...@inter.net> wrote:
>>>> 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 sample shows this:
>>>> Service ID, (any fields that make up the services options_table)
>>>> inthis
>>>> case, Username, Password, OS, Street, Device
>>>>
>>>> I assumed that Service ID means this:
>>>> master_services.id
>>>> That would then link to the service option table linked to that
>>>> service.
>>>> mysql> SELECT id, options_table FROM master_services WHERE id = 19;
>>>> +----+---------------+
>>>> | id | options_table |
>>>> +----+---------------+
>>>> | 19 | base_service |
>>>> +----+---------------+
>>>> So I included the fields from the base_service table which aren't
>>>> assigned by citrusdb:
>>>> base_service.ext_contract_id, base_service.login,
>>>> base_service.password, base_service.active_cci
>>>>
>>>> mysql> describe base_service;
>>>>
>>>>
>>>> +-----------------+------------------+------+-----+---------+----------------+
>>>> | Field | Type | Null | Key | Default | Extra
>>>> |
>>>>
>>>>
>>>> +-----------------+------------------+------+-----+---------+----------------+
>>>> | id | int(11) | NO | PRI | NULL |
>>>> auto_increment |
>>>> | user_services | int(11) | NO | | NULL |
>>>> |
>>>> | ext_contract_id | int(10) unsigned | YES | | NULL |
>>>> |
>>>> | login | char(64) | YES | | NULL |
>>>> |
>>>> | password | char(64) | YES | | NULL |
>>>> |
>>>> | active_cci | enum('y','n') | YES | | NULL |
>>>> |
>>>>
>>>>
>>>> +-----------------+------------------+------+-----+---------+----------------+
>>>>
>>>> What did I miss?
>>>>
>>>> Sample of my import file (with all the info made up):
>>>>
>>>> Online,"Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310,
>>>> 307
>>>> Bash
>>>>
>>>>
>>>> St.","WA","Clarkston","USA","83622","03-3498-4499","","03-3498-4899","u...@foo.com","","","",""
>>>> "Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310, 307 Bash
>>>>
>>>>
>>>> St.","WA","Clarkston","USA","83622","03-3498-4499","03-3498-4899","u...@foo.com","1","3***********9999","1110","1"
>>>> "19","455662","username","PaSwORd","y"
>>>> -----BEGIN PGP MESSAGE-----
>>>> Version: GnuPG v1.4.5 (GNU/Linux)
>>>>
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> scP0MWk5N6mujQ6nsA2IV2GcP/T2QfTtrivPF6yRdVPMQWzyiqWfoYMkii8H6N99
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
>>>> Js5LfEsKh9fEIVletA==
>>>> =mr5H
>>>> -----END PGP MESSAGE-----
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Live Security Virtual Conference
>>>> Exclusive live event will cover all the ways today's security and
>>>> threat landscape has changed and how IT managers can respond.
>>>> Discussions
>>>> will include endpoint security, mobile security and the latest in
>>>> malware
>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>> _______________________________________________
>>>> Citrusdb-users mailing list
>>>> Citrusdb-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond.
>> Discussions
>> will include endpoint security, mobile security and the latest in
>> malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
