0
Anyone with any idea how to get the invoice_contacts table to sync with the papershape_table? I purchased in the IM and have used it for around a year now and decided to get the PS to manage my projects with and to give customers something to get a visual on the status of their project/order. I was thinking that since they were 'integrate-able' they would read from the same contacts/clients table, but they don't. When I attempt to export the invoice_contacts data only via SQL and then import into the papershape_contacts table via SQL it wont work; it says there is a duplicate primary which is impossible because the papershape_contacts table is completely empty. So I wrote an SQL statement SELECT * INTO papershape_contacts FROM invoice_contacts to do the job, same error. And if PS is suppose to read from the IM contacts table if it were previously installed, then why can i not select a client name when starting a project. When I attempt to re-enter all my contact via the PaperSpace > Clients tab they will not keep. As soon as the page is refreshed everything I entered goes away. Is there something I am missing to get these two tables to sync. I was thinking about eventually incorporating the expenses extension but does me know good if the contacts table A) won't sync requiring duplicate entry and/or B) wont hold any data.
Responses (10)
-
Accepted Answer
0Hello,
There's no sync between the contacts tables on the two extensions at the moment.
the current sync is "invoices" beloning to "PS projects", so there's no automatic sync between CONTACTS table as you are mentioning (definitely something we will look up for the future)
however, it's a bit weird the error you mention about duplicated keys.. this should definitely not occur if you attempt to copy tables, sort to speak.
What's the exact error you're getting? can you share it with us? -
Accepted Answer
0With SQL statement - SELECT * INTO `fix_papershape_contacts` FROM `fix_invoices_contacts` - I got:
SQL query: Documentation
SELECT * INTO `fix_papershape_contacts` FROM `fix_invoices_contacts` WHERE `id`>"0"
LIMIT 0, 25
MySQL said: Documentation
#1327 - Undeclared variable: fix_papershape_contacts
With Import/Export via phpMyAdmin I exported data only and zipped it as required by phpMyAdmin. I attempted an import with the following settings utf-8, Allow the interuption...checked, skipped 0, format SQL, Compatibility None, do not use auto_increment for zero values checked, and Read and multibytes unchecked. I got:
SQL query:
--
-- Database: `webwiza2_new`
--
--
-- Dumping data for table `fix_invoices_contacts`
--
INSERT INTO `fix_invoices_contacts` (`id`, `name`, `company`, `address`, `email`, `user_id`, `city`, `state`, `country`, `vatid`, `zipcode`, `phone`) VALUES
Listed values of table here, but removed them from here since this is a public forum
MySQL said: Documentation
#1062 - Duplicate entry '2' for key 'PRIMARY'
When I attempt to enter them manually on the Paper Shape > Clients tab they won't keep, they disappear as soon as the page refreshes or when I leave the tab and return to it. It would be nice if the integrate-able extensions would use the same table, each extension would read the list of tables to determine if the table already exists, if it doesn't create it, if it does then skip the creation of the contact table and move on. Also, I like the way the contacts table is for the invoices because from that list of contacts you can create an invoice or quote, as other extensions that are integrate-able with it are added to one's system then new 'add' buttons can be added to the contacts list, (aka +project or +expense, etc.)
But that's food for thought about future endeavors. For now I need a fix my current situation, the inability to add contacts to the Paper Shape extension. Any advice?
Great work on these extensions. I love them. -
Accepted Answer
0FYI: Played around with the SQL Script a bit and this worked:
INSERT INTO `fix_papershape_contacts` SELECT * FROM `fix_invoices_contacts` WHERE `id`>"0"
Now I'm just curious about whether it will now take any new clients from the tab or will I have to copy this way each time a new client comes on board. Just tried it. Didn't keep. Looks like an SQL INSERT SELECT procedure for each new client WHERE 'id'="###" if I want to be able to issue projects for clients to view progress until its resolved.
Is anyone else having this problem? If not, do you think an uninstall/reinstall will fix this? I've cleared the site's cache so I don't think that's it. I look forward to an update where the clients/contacts either sync or are housed all in one table. This piece of code is definitely going in my code journal though, I'll likely need it again. -
Accepted Answer
0For others who may be experiencing this, this is what worked for me:
To copy all of invoices_contacts table to papershape_contacts table, this SQL statement worked:
INSERT INTO `fix_papershape_contacts` SELECT * FROM `fix_invoices_contacts` WHERE `id`>"0"
To copy only one contact from the invoices_contacts table to the papershape_contacts table, this statement should work:
INSERT INTO `fix_papershape_contacts` SELECT * FROM `fix_invoices_contacts` WHERE `id`>"###"
NOTE: (A) fix was my database's prefix, yours will be different; (B) Replace ### with the client's id from the 'fix_invoices_contacts' table -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »