102 results found

1. Extend functionality of sample Excel file

   I will start this post off by saying that I am not a designer or coder, and that will probably be evident by my questions!

   I love the new contact record API and using the supplied Excel file I was able to pull our membership database.

   My question is this: Is it possible to set up the file to pull just members from a specific region or state and not the entire pool of members? The file for the full membership was around 6mb and took several minutes to run. I'd like to be able to narrow the query so that our officers can quickly download members in their regions. I see on the Fields tab where I can turn on and off particular fields, but I don't see how I can narrow down the search of a field. (Example: Field Name = Region, search and pull only results for Pacific Northwest).

   I now that once I run the full database I can sort by anything that I want, but I was hoping there would be a way that I could run a report for specific criteria making it quicker and a smaller file.

   Like I said, I am sure that my questions verified that I do not know what I am doing! But any help would be greatly appreciated.

   Thank you.

   I will start this post off by saying that I am not a designer or coder, and that will probably be evident by my questions!

   I love the new contact record API and using the supplied Excel file I was able to pull our membership database.

   My question is this: Is it possible to set up the file to pull just members from a specific region or state and not the entire pool of members? The file for the full membership was around 6mb and took several minutes to run. I'd like to be able to narrow the query so… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team Mobile responded

   The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.

2. Sample Excel File for API Connect to WA Make Available for Excel for MAC [14851]

   It seems that the Sample Excel file for importing data from Wild Apricot was developed in Excel for WIndows. The Import Data macro does not compile because of a Missing:Microsoft XML,v3.0 reference. This XML object is only available in Excel for Windows.

   Wild Apricot states that it will not be supporting this Excel file at all. That leaves out all MAC users.

   I have not been able to find any suggestions on line on how to run this Macro or replace the XML object.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team Mobile responded

   The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.