Tag 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.

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.

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 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!

YouTube For Apps and Biz

Topic: “YouTube” for Apps Dev and Biz Mtg

Date 7/14/14 at Noon EST

Presentations by Gary (dba: Design For Communication), Russ (of Russ’ ToolShed fame), and Rich (entertainment industry’s Steele Productions). Live chat and Q&A. Bring your expertise to the table.

Register here:

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

Theme: How to use You Tube, another very important social media tool, for your application (apps) development and online business marketing. Discussion is open for you to share in your successful expertise or painful experiences.

Pain Points: What is the problem with YouTube?
• Finding (the right) videos can be a challenge
• Playlists help, but how do I use them?
• Who can see videos I post?
• Who can see playlists I create?
• If picture is worth a 100 words. What is a video worth?
• Can I create an app with YouTube videos?

 

Agenda:

•Basics
•Uploading Videos
•Playlists
•Privacy settings
•App Studio and the YouTube API
Join us for a free webinar and discuss this challenges live.

Associated Websites:
www.inbusinesslinks.net
www.fustinobrothers.com

Event Note: Online Meetup only. Takes place every second Monday of each month (unless a holiday). Includes business, B2B, tech talk and online solutions engagement. Meeting starts with participant introductions, then a targeted live presentation on topic. Join us online for free. Your interest and expertise are invited. Advertise with us at a very low investment (not mandatory, but it’s one of the benefits). Live Online Screen Meeting and Conference Call Instructions to Join-In:

1. On Your Calendar – Block-Out Approximately 35-55 Mins for the Live Meeting/Conference Call.

2. On Your Computer- It’s Recommended to Use a Headset. Join-In 5-7 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”.

3. 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, at 12:01PM. When prompted enter access code followed by the “pound” key.

679-256-129# (be sure to include the “#” symbol).

4. Meeting May be Recorded. Meeting ID: 679-256-129

5. For Advertising opportunities go to: http://www.inbusinesslinks.net/about/ads.html

Several RussCam ComponentOne Unplugged Videos released

It was my pleasure to assist in producing these great technical sessions.

Great job to Roger Hobbs and Tommy Hodges at ComponentOne on editing and filming these episodes!

 

Russ Cam® Unplugged: Xamarin Real World Experiences with MVP Bill Reiss who shares some Xamarin real world experiences.

ComponentOne Unplugged: Getting Started with MVC 5 and Visual Studio 2013 with Thom Robbins in front of a packed house, shows MVC5 and Visual Studio 2014. Check out the full session.

Russ Cam® Unplugged: Rock Your Code with Visual Add-ins MVP David McCarter, a ComponentOne Influencer, shares his experience with add-ins for coding, debugging, profiling and more! So let’s check out that session right now as Russ Cam Unplugged presents Rock Your Code with Visual Add-Ins by David McCarter.

Russ Cam® Unplugged: App Studio, Then What? MVP Russ Fustino, ComponentOne Influencer, shows how easy and quick it is to make a Windows Phone app using App Studio!