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
--
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
