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

    Monday, August 29 2016, 10:26 PM - #Permalink
    0
    Hello,

    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?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 31 2016, 01:28 AM - #Permalink
    0
    With 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.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 31 2016, 01:52 AM - #Permalink
    0
    FYI: 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.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 31 2016, 02:02 AM - #Permalink
    0
    For 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
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, November 16 2016, 08:22 PM - #Permalink
    0
    I was hoping this new release would address this but it didn't. Paper Shape Contacts will not save. Put on a show like it saved when you hit the save button, but once you refresh the "saved" record disappears from the list on the left.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, November 17 2016, 10:28 AM - #Permalink
    0
    the contacts in PS are you saved in your database? that's definitely not normal
    if you want to send me access I'll be glad to take a look.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, November 17 2016, 01:14 PM - #Permalink
    0
    How do you want me to send you access? This forum being public and all... Do you have an open/close tag that will make the contents within the tags available only to your administrators?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, November 17 2016, 01:15 PM - #Permalink
    0
    Or an email address I can send them to?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, November 17 2016, 01:16 PM - #Permalink
    0
    support@ joomlathat.com
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, September 30 2017, 07:54 AM - #Permalink
    0
    Germinal, I agree with DorothyDavis that this should be a feature. It would enhance your products.
    The reply is currently minimized Show
Your Reply