Seedcode Complete - Importer Trouble
Posted: Mon Mar 05, 2012 9:57 amHi, Been working on this for 20 hours, clearly not a productive use of time. First of long list of questions, but for now Ive got to get this database up and running.
1) How do I get the "Seedcode importer" to work? The problem that a everytime we do an import a new contact his company is added to the "Company List" regardless of the fact that the company is already listed (Yes, same spelling, etc..). IS the only solution to import direct to the database without the Importer?
*FYI, it became clear that this was not working when the new Company's added at each import had a Company_id that matched the Contact_id for the contacts imported (regardless of the fact that we set the serial number to generate differing "next value"s, 25000 for Company and 22000 for contact...). For example, 5 contacts added from ABC Co with the Contact_id such as 22005 to 22010 would result in an additional Company entry with the Company_ID of 22005 (rather than 25000..).
This is getting serious considering after 4 months we cannot launch this DB being as that I'm the one to work on it (and I'm the owner of the firm, with other duties that badly need my attention..). My minimum request was a DB that could readily import data, and we cant even get the initial contacts (less than 2000..) migrated and we have 60000 to go. We are trying to get this going so we can integrate sparx and zulu, but at this point we dont have the luxury to spend more time.
1) How do I get the "Seedcode importer" to work? The problem that a everytime we do an import a new contact his company is added to the "Company List" regardless of the fact that the company is already listed (Yes, same spelling, etc..). IS the only solution to import direct to the database without the Importer?
*FYI, it became clear that this was not working when the new Company's added at each import had a Company_id that matched the Contact_id for the contacts imported (regardless of the fact that we set the serial number to generate differing "next value"s, 25000 for Company and 22000 for contact...). For example, 5 contacts added from ABC Co with the Contact_id such as 22005 to 22010 would result in an additional Company entry with the Company_ID of 22005 (rather than 25000..).
This is getting serious considering after 4 months we cannot launch this DB being as that I'm the one to work on it (and I'm the owner of the firm, with other duties that badly need my attention..). My minimum request was a DB that could readily import data, and we cant even get the initial contacts (less than 2000..) migrated and we have 60000 to go. We are trying to get this going so we can integrate sparx and zulu, but at this point we dont have the luxury to spend more time.