Category Archives: app studio

Importing a CSV Into a Windows App Studio data Collection

Steps to import a CSV to App Studio:

Step 1:  Add column headers and data types manually in the IDE

Step 2:  Use same column headers in Excel

Step 3:  For image fields, in your spreadsheet, use URL or fully qualified local file path and file name

Step 4:  Use VB Macro to export with semi colons and put double quotes around all fields. See code below.

Here is some handy code to use in an Excel Macro when importing a CSV file into App Studio collection. This saved me a ton of work!

Public Sub OutputQuotedCSV()
Const DELIMITER As String = ";"
Const QSTR As String = """"
        Dim myRecord As Range
        Dim myField As Range
        Dim nFileNum As Long
        Dim sOut As String

        nFileNum = FreeFile
        Open "File1.txt" For Output As #nFileNum
        For Each myRecord In Range("A1:A" & _
                    Range("A" & Rows.Count).End(xlUp).Row)
            With myRecord
                For Each myField In Range(.Cells(1), _
                            Cells(.Row, 256).End(xlToLeft))
                    sOut = sOut & DELIMITER & QSTR & _
                        Replace(myField.Text, QSTR, QSTR & QSTR) & QSTR
                Next myField
                Print #nFileNum, Mid(sOut, 2)
                sOut = Empty
            End With
        Next myRecord
        Close #nFileNum
    End Sub

Channel 9 Video – Windows App Studio UWP from No Code to Code

Join MVP Russ Fustino and all of the Fustino Brothers in this live studio audience session recorded recently at the Tampa Code Camp. They present a deep dive into Microsoft Windows App Studio. It is a hot off the metal session.

https://channel9.msdn.com/Series/Russ-ToolShed/Windows-App-Studio-UWP-from-No-Code-to-Code

Building universal Windows apps with no code using Microsoft App Studio. It’s all about creating quality apps quickly using templates. The enhanced App Studio (now for Windows 10) gives you a great start. Use the new Universal Windows Platform (UWP) – one binary, one project for phone and tablet. Employ new the pivot control API’s for YouTube and Flickr integration. Deploy ads easier. And wrap-up a responsive website in an app.

We uncovered the new enhancements that the June 2016 release and their recent experience in building the Ani DiFranco LivingMuseum app with data collections, graphic requirements and team testing. We show the new REST API Data source.

Finally, we take a deep dive into the incredible code that the Windows App Studio team created for all us. App Studio is even open source: https://github.com/wasteam/waslibs. Russ shared tips on how to use the Command Bar, crash reporting, master/detail pages, Search, Caching, Ads and all with the generated code. Questions addressed:

  • When importing a CSV for my data in a collection, how do I upload it without getting numerous errors?
  • Is there an Excel macro/Add-in I can use to help this process, so I have the ability to keep commas in the field data, use semi colons as a delimiter and double quotes around all of the field data items?
  • What is the maximum number of items in a collection? Is there a work around?
  • How do I assign actions on a detail page of a collection item?
  • How do I take advantage of Hero images on each page and what sizes are needed? Where do I load the background of the app?
  • Where do I set the splash screen vs the logos for the app?
  • What are the size limitations?
  • Is there an easy way to install the app for reviewers and team members?
  • How do we integrate the UWP Command Bar to execute one set of event handlers for the app?
  • How do we integrate the latest crash reporting from Microsoft called Hockey App?
  • How do master/detail page relationships work in App Studio code?
  • You want a Navigation bar in your app? And search?
  • You want to write an app that functions completely in Airplane mode, once it is cached is created? If you are a UWP coder, you won’t want to miss this caching topic.
  • “IT’S HUGE”, like one of the local car dealers says on his radio and TV ads! We will also show you how to setup the Ad Client using App Studio and look at the generated XAML!

YOU HAVE TO KNOW THE CODE TO GET IN THE SHED! KNOW THE CODE.

App Studio Webcasts now posted to Channel 9!

I am very excited to announce the return of Russ’ ToolShed at my new MVP channel on MSDN’s Channel9 at https://channel9.msdn.com/Niners/russtoolshed/

Here is a great 3 part series you can lick your chops on for the latest release of Windows App Studio.

RussToolShedNetwork3b

Part 1 – App Studio Building Universal Windows Apps with No Code

It’s all about creating quality apps quickly using templates. The enhanced App Studio (now for Windows 10) gives you a great start. Use the new Universal Windows Platform (UWP) – one binary, one project for phone and tablet. Employ new the pivot control API’s for YouTube and Flickr integration. Deploy ads easier. And wrap-up a responsive website in an app. These features for app development including “T!PS” for business were discussed and demonstrated during this webinar. See all of the Fustino Brothers Webcasts at: http://www.inbusinessseo.net/tps-blog

 

Part 2 – App Studio Data, Graphics, REST Services, Updates

Join MVP Russ Fustino and all of the Fustino Brothers in this webcast for the Mobile App Dev Tampa (MAD Tampa) as they present to you this hot off the metal session on a deep dive into Microsoft Windows App Studio. FBI-Apps covered the new enhancements that the June 2016 release brings to building Universal Windows apps that run on the Phone and Tablet/Desktop. They focused on their recent experience in building the Ani DiFranco LivingMuseum app with data collections, graphic requirements and team testing.
Questions addressed:

  • When importing a CSV for my data in a collection, how do I upload it without getting numerous errors?
  • Is there an Excel macro/Add-in I can use to help this process, so I have the ability to keep commas in the field data, use semi colons as a delimiter and double quotes around all of the field data items?
  • What is the maximum number of items in a collection? Is there a work around?
  • How do I assign actions on a detail page of a collection item?
  • How do I take advantage of Hero images on each page and what sizes are needed? Where do I load the background of the app?
  • Where do I set the splash screen vs the logos for the app?
  • What are the size limitations?
  • Is there an easy way to install the app for reviewers and team members?

App Studio – Part 3 Know the Code

Join Microsoft MVP Russ Fustino, brothers Rich and Gary.  FBI Apps, is proud to resurrect “Russ’ ToolShed”!

 

FBI Apps takes a deep dive into the incredible code that the Windows App Studio team created for all us. You know App Studio is even open source… go to: https://github.com/wasteam/waslibs. Russ shared tips on how to use the Command Bar, crash reporting, master/detail pages, Search, Caching, Ads and all with the generated code.

Windows App Studio Questions Answered:

  1. How do we integrate the UWP Command Bar to execute one set of event handlers for the app?
  2. How do we integrate the latest crash reporting from Microsoft called Hockey App?
  3. How do master/detail page relationships work in App Studio code?
  4. You want a Navigation bar in your app? And search?
  5. You want to write an app that functions completely in Airplane mode, once it is cached is created? If you are a UWP coder, you won’t want to miss this caching topic.
  6. “IT’S HUGE”, like one of the local car dealers says on his radio and TV ads! We will also show you how to setup the Ad Client using App Studio and look at the generated XAML!

YOU HAVE TO KNOW THE CODE TO GET IN THE SHED!
KNOW THE CODE.

Know the code, inside App Studio Webcast today!

 

When
Monday, July 11, 2016 from 12:00 PM to 12:45 PM (EDT) – Add to Calendar
Where
IBLN-FBI / MAD Tampa Free Webinar – Online, Webinar Only

register here: https://www.eventbrite.com/e/webinar-part-3-top-10-reasons-to-know-the-code-inside-windows-app-studio-tickets-26478368513

Join Microsoft MVP Russ Fustino and his two brothers, Rich and Gary. Our company, FBI Apps, is proud to resurrect “Russ’ ToolShed”!!! On what topic, you might ask?  CODE!  Let’s take a deep dive into the incredible code the Windows App Studio team creates for us to use. App Studio is even open source. (https://github.com/wasteam/waslibs). We will show how to use a Command Bar, crash reporting, master / detail pages, Search, Caching and Ads in App Studio and then dive into the generated code.

Join this webcast and get answers to these questions:

1. How do I integrate the UWP Command Bar to execute one set of event handlers for the app?

2. How do I integrate the latest crash reporting from Microsoft called Hockey App?

3. How do master/detail page relationships work in App Studio code?

4. You want a Navigation bar in your app? And search?

5. You want to write an app that functions completely in Airplane mode, once it is cached is created? If you are a UWP coder, you won’t want to miss this caching topic.

6. “IT’S HUGE”, like one of the local car dealers says on his radio and TV ads! We will also show you how to setup the Ad Client using App Studio and look at the generated XAML!

Be there or be talked about. Why wouldn’t you start a UWP App, by generating your template with App Studio? Share your experiences with App Studio in this meet up!

YOU HAVE TO KNOW THE CODE TO GET IN THE SHED! KNOW THE CODE.

“T!PS” for business, and apps development. Reserve your virtual seat today.

Live Online Screen Meeting Instructions:
1. On Your Computer- It’s Recommended to Use a Headset.
- Join-In 3-5 minutes before meeting
- Over the Internet, with your computer / laptop / tablet at -this link: https://www.startmeeting.com/wall/679-256-129
- If you don’t already have the “Start Meeting” free software  – A dialog box will come up and ask permission to download, please click/tap Yes.
- The system will guide you through the process to participate in the online meeting.
- Click/Tap “Join”, complete your name and email address, then click/tap “Submit”.
- First, the “Fustino Brothers, Inc.” dashboard with show on screen.  – Test your speaker/mike. If headset doesn’t work, or if connection is lost try “Rejoin”.
- Click/Tap on the green microphone symbol. When the symbol turns red you are live.
- Introduce yourself.

Or, Conference Call Instructions to Join-In: 
1. For the Phone Take Your Call in a Quite Location-
- Join-In using a land line / mobile phone (no computer needed for this option).  – Dial (530) 881-1212(530) 881-1212 when prompted enter access code followed by the “pound” key.
- 679-256-129# (be sure to include the “#” symbol).
- Meeting time approximately 45 mins. Meeting may be recorded.

June’s Free MAD Tampa Webcast: Part 2 Windows App Studio: Data, Graphics & Installation

Lots of new stuff announced in June 2016  release of Microsoft App Studio including consuming REST services and new load/list management for long lists. Good stuff!

Date: June 20, 2016
Start Time: 11:30 AM
Interactive Webinar

RSVP at: https://madtampafbiappsjune202016.eventbrite.com

Join MVP Russ Fustino, Gary and Rich of the Fustino Brothers in our next webcast for the Mobile App Dev Tampa (MAD Tampa) User Group as we bring you this hot off the metal session on a deep dive into Microsoft Windows App Studio. We will also cover the new enhancements that the June 2016 release brings in building Universal Windows apps that run on the Phone and Tablet/Desktop. These new features include, consuming REST services, enhanced list loading, increased size of your YouTube Playlists as well as collections and more! We will focus on our recent experience in building the Ani DiFranco LivingMuseum app with focus on data collections, graphic requirements and team testing. Join this session to learn answers to these questions…

  • When importing a CSV for my data in a collection, how do I upload it without getting numerous errors?
  • Is there an Excel macro/Add-in I can use to help this process, so I have the ability to keep commas in the field data, use semi colons as a delimiter and double quotes around all of the field data items?
  • What is the maximum number of items in a collection? Is there a work around?
  • How do I assign actions on a detail page of a collection item?
  • How do I take advantage of Hero images on each page and what sizes are needed?
  • Where do I load the background of the app?
  • Where do I set the splash screen vs the logos for the app?
  • What are the size limitations?
  • Is there an easy way to install the app for reviewers and team members?
  • Register today and reserve your virtual seat.

Webinar: Building Universal Windows Apps with No Code in Microsoft App Studio

When: Monday 5/9/16 at Noon to 12:30 PM EST

Where: Online using Start Meeting (details below)

Registration link:

http://www.meetup.com/InBusinessLinksNetwork-FustinoBrothersInc/events/229812621/

Join Microsoft MVP Russ Fustino and the Fustino Brothers in Building universal Windows apps with no code using Microsoft App Studio. It’s all about creating quality apps quickly using templates. The enhanced App Studio (now for Windows 10) gives up great start. Use the new Universal Windows Platform (UWP) – one binary, one project for phone and tablet. Employ new the pivot control API’s for YouTube and Flickr integration. Deploy ads easier. And wrap-up a responsive website in an app. These features for app development including “T!PS” for business will be discussed and demonstrated during the webinar. Register today and reserve your virtual seat.

WP_20141021_012

Live Online Screen Meeting Instructions:
1. On Your Computer- It’s Recommended to Use a Headset.
- Join-In 3-5 minutes before meeting
- Over the Internet, with your computer / laptop / tablet at -this link: https://www.startmeeting.com/wall/679-256-129
- If you don’t already have the “Start Meeting” free software – A dialog box will come up and ask permission to download, please click/tap Yes.
- The system will guide you through the process to participate in the online meeting.
- Click/Tap “Join”, complete your name and email address, then click/tap “Submit”.
- First, the “Fustino Brothers, Inc.” dashboard with show on screen. – Test your speaker/mike. If headset doesn’t work, or if connection is lost try “Rejoin”.
- Click/Tap on the green microphone symbol. When the symbol turns red you are live.
- Introduce yourself.

Or, Conference Call Instructions to Join-In:
1. For the Phone Take Your Call in a Quite Location-
- Join-In using a land line / mobile phone (no computer needed for this option). – Dial (530) 881-1212(530) 881-1212 when prompted enter access code followed by the “pound” key.
- 679-256-129# (be sure to include the “#” symbol).
- Meeting time approximately 45 mins. Meeting may be recorded.

Russ Fustino MVP Summit Channel 9 Interview on appdev!

At the recent MVP Summit in Redmond, Russ Fustino, Microsoft MVP developer Windows Platform, chats with Seth Juarez  of Microsoft’s Channel 9 about Microsoft App Studio, Windows 10 and cross platform development, as well as the OutSystems Platform and the MVP summit in general. Enjoy!

 

 

https://channel9.msdn.com/events/Seth-on-the-Road/MVP-Summit-2015/MVP-Summit-2015-Russ-Fustino

Note: I am looking for career opportunities, so if you know of any that I might be interested in, please contact me at russ@fustinobrothers.com

Where is Russ Fustino in July? The tour continues!

IMG_8157 small

July 2, 6:30 PM – Space Coast User Group

  • Topic: Improving Your App Quality with Raygun
  • Register at: http://www.meetup.com/Space-Coast-Net-User-Group/events/222906128/?a=wc1d.2_gnl&gj=wc1d.2_e&rv=wc1d.2_e
  • Location: Aerotek new office, 6767 North Wickham Road Suite B-104, Melbourne, FL
  • Join MVP and Raygun Community Evangelist Russ Fustino as he shares a great error reporting tool that is fast and reliable, no matter what the load. See how he used Raygun this during the development cycle to help debug errors and some weird bugs for the Xamarin Forms Endorsed Jethro Tull app. It is also great for the production environment and gives you real time data and affected user information no matter what the platform including JavaScript, .NET, Ruby and more. Be proactive and fix errors before your users hound you down. See an overview of Raygun and the many supported platforms as well as integrations. Download your free trial today! www.raygun.io and follow @raygunio

July 7, 6PM – Tallahassee Capital City .NET User Group

  • Topic: Rock’in with Russ, Raygun and Xamarin Forms
  • Register at: http://www.meetup.com/tally-dot-net/events/223451975/
  • Location: Domi Station – 914 Railroad Avenue, Tallahassee, FL (map)
  • Join MVP and Raygun Community Evangelist Russ Fustino in this hot off the metal session as he shares insights into the trials, tribulations and joy of building the Endorsed Jethro Tull App. Share the excitement as Russ “tells all” about creating his Jethro Tull app. The app is now published for Android and iOS, Windows Store and Windows Phone. How did he do it? Is Xamarin Forms the real deal? Topics covered include: Custom Renderers, Embedded Resources, XAML, Third party controls and plugins, Building for Phone and Tablet, Dependency Injection, Store app review process,  and Third Party Endorsement Proof. Russ will close with showing his world class error reporting built into the app with proactive email support. He shares this great error reporting tool that is fast and reliable, no matter what the load. See how he used Raygun this during the development cycle to help debug errors and some weird bugs for the Xamarin Forms Endorsed Jethro Tull app. It is also great for the production environment and gives you real time data and affected user information no matter what the platform including JavaScript, .NET, Ruby and more. Be proactive and fix errors before your users hound you down. See an overview of Raygun and the many supported platforms as well as integrations. Download your free trial today! www.raygun.io and follow @raygunio

July 10-11, CodeStock attendee, Knoxville, TN

  • wait list for speaking:
  • Register at: http://www.codestock.org/
  • Location: Knoxville Convention Center 701 Henley Street, Knoxville, TN 37902

July 14, 6PM – South Florida Xamarin User Group

July 18, Tampa Code Camp

  • Topic: Rock’in with Russ, Raygun and Xamarin Forms
  • Register at: http://tampacodecamp.net/
  • Location: KForce 1001 East Palm Avenue, Tampa FL 33605

July 27-28 Disney Developer Days (onsite for internal employees) , Orlando

  • Improving Your App Quality

Rock’in with Russ Fustino, Florida Tour Announced!

Where in the world is Russ Fustino? Here are the dates, locations and topics for this week in Florida! More dates to be published next week. This week includes Bradenton, Miami and Boca Raton! Hope to see you there!

Date: June 2 @ 6:00 pm – 8:00 pm

Location: Station 2 Innovation Center
912 7th Ave E, Bradenton, FL 34208  (map)

Topic: Rock’in Cross Platform Mobile Dev with Russ!

Register here: http://www.meetup.com/Entrepreneurs-Startups/events/222241246/

 

Date: June 3 @ 4:00 pm – 5:00 pm

Location: University of Miami

5030 Brunson Dr #314, Coral Gables, FL 33124

Room 314 Dooley Memorial Building.  In the same building as the Cosford Cinema.

Topic:  Rock’in with Russ on Today’s Software Development Technologies

Register here:   (limited number of public seats available) https://www.eventbrite.com/e/rockin-with-russ-on-todays-software-development-technologies-tickets-17218250250

 

Date: June 4 @ 6:30 pm – 8:30 pm

Location: Coders Café Special meeting at Cendyn Spaces!

Cendyn SPACES Cazbah
980 North Federal Highway #110
Boca Raton, FL 33432

Topic:  Rock’in with Russ! How We Built the Jethro Tull App Using Xamarin Forms and Raygun

Register here:   http://www.fladotnet.com/Reg.aspx?EventID=769

Tour sponsored by Raygun.IO!

raygun-background@128

Russ Fustino shows Jethro Tull app to Ian Anderson

It’s live!  One of the most incredible moments of my life! See a great video produced by Microsoft about Fustino Brothers’  endorsed app, Jethro Tull. Most importantly,  see footage of your truly, Russ Fustino,  showing the app to rock legend, Grammy award winner, Ian Anderson in person!

BLOG: http://blogs.windows.com/buildingapps/2014/12/07/jethro-tull-superfan-builds-app-with-windows-app-studio/

FACEBOOK: https://www.facebook.com/wpdev/posts/10153303992242923

TWITTER: https://twitter.com/wpdev/status/542071103225491456

It’s about a three minute clip and in the first minute you will see background and some cool 3 brother fan shots. In the middle, I go into how I used App Studio to build the app and it ends with the best part of showing Ian Anderson the app. It was filmed in Lynn Mass on Nov 1, 2014 at a concert where he performed the Best of Jethro Tull and his new CD Homo Erraticus . Check out his comment about Jimmy Page! Also, check out the surface pro in the closing credits, firing up the Jethro Tull app. So cool! The video team that Microsoft hired did an incredible job. Enjoy!

The Jethro Tull is endorsed and published to Windows Store and Windows Phone Store.

Here is the link to the channel9 video itself:

http://channel9.msdn.com/Blogs/Windows-Phone/Jethro-Tull-fan-app-made-with-Windows-App-Studio

image

Happy Holidays!