Category Archives: Russ ToolShed Network

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.

Joe Darko Keynote from Tampa Code camp on Channel 9!

It was my please to record the keynote at the recent Tampa Code Camp 2016. Joe Darko, Southeast Program Manager Evangelist provides insight on what developer community is all about. Joe, is the MVP lead for all of the Southeast states with a few hundred MVP’s in his geography. It was great to see Joe come out to support his MVPs at the event and introduce himself to his new community. I am very excited to have Joe Darko as my MVP Lead!

Also, see Greg Leonardo go over updates for TampaDev which is now a non-profit organization! Great job to Greg and Kate Leonardo for pulling off yet another great Tampa Code Camp via TampaDev!

Photos from the Tampa Code Camp 2016 are posted here on Facebook

IMG_2047

Like Russ ToolShed network on Facebook!

https://www.facebook.com/RussToolShedNetwork/

 

Greg and Kate

Channel 9 – Russ’ ToolShed

https://channel9.msdn.com/Series/Russ-ToolShed/Microsofts-Joe-Darko-delivers-Keynote-on-dev-community–Tampa-Code-Camp

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.

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

Gary Fustino Nominated for Good Burger Award. Please vote!

Gary has been nominated for the Good Burger award in St. Pete for “Cool Companies – Small” as Design For Communication. He has contributed much in the community including being an active member of our user groups and design for several Windows Phone and Windows 8 apps.

good burger

Gary is spreading the word to vote for him to become a winner in the St Pete’s Chamber Good Burger Award contest! And this a quite an honor. Voting starts today and runs thru July 17 and we would appreciate your support.

Go to: www.stpete.com/goodburger and cast your vote. “Design For Communication” is in the category “Cool Companies – Small”. It only takes a few seconds to vote.

Thank you for all you do in the community, too.

Also, please joins us on Aug 28 at Jannus Live for the award party from 6-9pm with 5 bands. Non-Member Attendee = $20.

Gary Fustino

· St Pete Chamber & Midstate Chamber – Ambassador

· Bluffs Business Association – eServices Director

· Member of Tampa Bay Computer Society

· Member/Participant of Visual Design League, Tampa Bay Win Dev, Win Phone 8, DevUp, Tampa & Sarasota BarCamp/CodeCamp, Xamarin MeetUp

· Former Employee of the New York State Council on the Arts

· Buffalo Art Directors Club

Facebook for Business – “T!PS”, Monday 5/12 at Noon – Online

InBusinessLinks/FustinoBrothers Live Online Conference Call and Screen Share

RSVP
http://www.meetup.com/InBusinessLinksNetwork-FustinoBrothersInc/events/181785452/

Topic: Facebook for Business – “T!PS”… For Example: Contests to drive business sale; Use of photos to drive awareness; Plug-ins’ to automate user experience and help with closure. …These are some of the tips, and especially those concerning the “pain” points (managing time, measuring results, and task accountability) are open for discussion.

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.

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