Automating Excel import?

Follow

William Willman

• December 30, 2015 02:06

not sure how to really word what i need but i will try....

 

i use MRIS (MLS Service for realtors) to export property information into podio. that part is automated, i know how to set up macros on excel to automate some minor editing as well. 

what kills alot of time and therefore makes it less usable is that i am importing them into podio via excel import and have to do the same exact mapping each time....

 

is there a way to automate the mapping or possibly even a better process all together? ideally i am able to do updates on properties on the fly but i at least need to do a mass update once per day, and with 20-30 fields its alot to do "by hand"

6

• 

  William Willman

  • December 30, 2015 02:09

  (ie i have everything automated up to the point i have to map my excel import to podio) 

  1

  Comment actions Permalink
• 

  Andreas Garnæs

  • January 04, 2016 10:46

  Hi William,

  You can use the API to do the Excel importing: https://developers.podio.com/doc/importer/import-app-items-212899

  Best,
  Andreas

  0

  Comment actions Permalink
• 

  Joan Juvanteny

  • February 04, 2016 09:56

  Just mentioned your request into another one https://help.podio.com/hc/en-us/community/posts/200521648-Map-Excel-imports-automatically-based-on-header-name

  0

  Comment actions Permalink
• 

  Fabio Lepore

  • March 31, 2016 14:05

   

  I agree with that request

  1

  Comment actions Permalink
• 

  Jerold Mark Skaggs

  • September 27, 2019 18:20

  Any progress on this? Or an update? I'm searching and not finding anything. Thx. 

  2

  Comment actions Permalink

Please sign in to leave a comment.