Excel import - using unique ID (or calculcated field) for relation

Comments

10 comments

  • Joshua Barnard

    +1

    0
    Comment actions Permalink
  • Joshua Barnard

    Or/and the new email fields would be nice!?

    0
    Comment actions Permalink
  • Andreas Forstinger

    just for reference:

    The proposed workaround to solve it in the meantime would be to have a textfield holding a copy of the unique ID (export items and then re-import to fill it). Then use it to match references.

    The use case was made clear and will be brought to the product team attention. Hopefully we will get it sometime.

    0
    Comment actions Permalink
  • Alexander Koesters

    Is there a chance to realise this through API? Big show stopper for me, too!

    0
    Comment actions Permalink
  • Rich Siegmund

    +1  will be nice not to need to use the workaround to hold a copy of the unique ID

    0
    Comment actions Permalink
  • Rich Siegmund

    I misunderstood how complicated the workaround is ....  I assumed I could use a calc field to create a copy of the unique ID and then match against it. But it appears that calc fields aren't recognized by the import tool.

    If a text field is used, how would one export say a few hundred items and then reimport while preserving all of the history?   The excel part is easy, the unique ID will be in the exported file, then copy the value into the text field, but you're still left without a way to uniquely associate the reimported items to the existing items. 

    I hope I'm missing something obvious here...  I'm considering using Tags, but a reqt is that I can import several hundred items and apply specific tags in a bulk operation.

    0
    Comment actions Permalink
  • Andreas Forstinger

    @Rich: glad I am not the only one :)

    If you only want to bulk edit one app (setting tags on items) you should be fine, then you can just use the Unique ID when re-importing. The pain point I described here is just for mapping of related apps on import as you can select fields of the related app but not the Unique ID and no calculated fields.

    For the described workaround: if you want to import and match App A (e.g. invoices) with reference to App B (e.g. customers) you would first have to make the dummy textfield on the customer. Then export customers and re-import them to fill the unique ID into the textfield. Now you prepare the Excel for invoices setting the customer ID where you need it. When importing invoices Excel to Podio you can now map the Customer ID with the dummy textfield on the customer app (make sure to use the key button).

    So would still be superb if we could directly access the unique ID of the related item!

    0
    Comment actions Permalink
  • Rich Siegmund

    @andreas  I'm still missing something .....

    Here's what I did (keep in mind I'm still playing with import to see what is possible):

    a) I chose a random app, and exported it (the app has tags enabled)
    b) I added an existing tag to a few rows in the spreadsheet, and then wanted to import it and have Podio simply add the new tag to those rows
    c) During the import process I don't see the true unique ID in the field list at left, and even if I did I don't see a place to drag it on the right side

    Now in this app I do have a calc field where I do '@unique id', so it does show in the list in incoming fields, and it's of course in the exported spreadsheet also.

    So how exactly can I associate the incoming rows?   Keep in mind that in this test I had maybe 95 fields that were unchanged, and I left them in the spreadsheet.  I could have removed them, but I was hoping they just would be ignored.

    0
    Comment actions Permalink
  • Rich Siegmund

    @andreas   I found the problem.  In the test app I chose I hadn't turned on the Unique ID (app settings, advance, show unique ID) and therefore during import the Unique ID field wasn't an option. I just turned it on and my test import worked as expected, where only the items with tags were updated, nothing else.     Thanks for helping guide me here, much appreciated...

    0
    Comment actions Permalink
  • Jonathan Asbell

    Rich or Andreas I would be so grateful to speak with you.  Do you have WhatsApp or Skype?

    Jonathan Asbell www.propertyunderthepalms.com

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk