Print

Print


Bob et al.,

I am not working with this process, however, can you confirm that
FitnessGram works using FTP and does not work with SFTP?  I read in this
thread that they do not support FTP (an assumption is that SFTP is included
in this) but it seems the service is allowed?  Clarification or a
definitive answer to whether it is "supported" or not might be helpful.
 If FTP works, a further assumption is that SFTP could also be allowed (but
perhaps configuration on FitnessGram's side?)

Keith


On Wed, Feb 28, 2018 at 4:26 PM, Bill Fitzgerald <[log in to unmask]>
wrote:

> From looking at the screenshot, one issue that could be arising is a
> disconnect between the protocol and the port.
>
> FTP generally uses port 21.
>
> SFTP generally uses port 22.
>
> The screenshot shows the SFTP protocol attempting to use port 21.
>
> Two observations:
>
> 1. I really hope that they don't support FTP at all - it's an accident
> waiting to happen.
> 2. If this works with SFTP/port 22, attempt to connect with FTP/port 21.
> If you can connect with FTP, that's a flag that there are potentially other
> security issues.
>
> Cheers,
>
> Bill
>
>
>
> On Wed, Feb 28, 2018 at 1:04 PM, Bob Owens <[log in to unmask]> wrote:
>
>> That's the direction I'm going now.
>>
>> PowerSchool (hosted) > Local FTP Server > FitnessGram
>>
>> On Wed, Feb 28, 2018 at 2:51 PM, Richard Adams <[log in to unmask]>
>> wrote:
>>
>>> Not sure if you can do this if you are hosted by PowerSchool, but try
>>> using a CSV autosend to a local server folder, then perform the upload with
>>> curl.
>>>
>>> On Wed, Feb 28, 2018 at 2:41 PM, Tina Scheindel <
>>> [log in to unmask]> wrote:
>>>
>>>> Yes, I also tried this.  I have gotten conflicting stories from the
>>>> Fitnessgram helpdesk.  I was told that they don't support sftp.  You
>>>> might want to put in a ticket and see if you get the same answer.  If you
>>>> can make sftp work through PowerSchool, please share how you get it done.
>>>> This would be my preferred method.  Fitnessgram is suggesting FileZilla.
>>>>
>>>> On Wed, Feb 28, 2018 at 2:31 PM, Bob Owens <[log in to unmask]> wrote:
>>>>
>>>>> Hi Tina,
>>>>> I'm trying to set up an FTP session between PowerSchool and
>>>>> Fitnessgram.
>>>>> I always get "Operation timed out"
>>>>>
>>>>> [image: Inline image 2]
>>>>>
>>>>> On Wed, Feb 28, 2018 at 2:20 PM, Tina Scheindel <
>>>>> [log in to unmask]> wrote:
>>>>>
>>>>>> This came up in my support call as well.  Fitnessgram says we need to
>>>>>> set the 'time out in' in the PowerSchool Autosend set-up window to 120
>>>>>> seconds.  Not sure if this will help you or not.
>>>>>>
>>>>>> On Wed, Feb 28, 2018 at 1:55 PM, Bob Owens <[log in to unmask]> wrote:
>>>>>>
>>>>>>> ​I keep getting "Connection Failed. Operation timed out​."
>>>>>>>
>>>>>>> On Wed, Feb 28, 2018 at 1:27 PM, Tina Scheindel <
>>>>>>> [log in to unmask]> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I just got off the phone with Fitnessgram support.  The problem
>>>>>>>> isn't resolved.  However, I did learn something.  Fitnessgram says you
>>>>>>>> can't cut and paste your credentials from the Fitnessgram import window
>>>>>>>> into your ftp client.  I was able to connect after typing them in by hand.
>>>>>>>> I hope that helps someone out there!
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Feb 27, 2018 at 3:01 PM, George Martin <[log in to unmask]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Sure thing, Bob!
>>>>>>>>>
>>>>>>>>> I have students and staff loaded too, but definitely want utilize
>>>>>>>>> the auto update feature via the FTP...
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>>
>>>>>>>>> George
>>>>>>>>>
>>>>>>>>> George Martin
>>>>>>>>> District Data Manager
>>>>>>>>> Champlain Valley School District
>>>>>>>>> Office: (802) 985-1915
>>>>>>>>> Google Voice: (802) 382-0077
>>>>>>>>> www.cvsdvt.org
>>>>>>>>>
>>>>>>>>> This message contains PRIVILEGED AND CONFIDENTIAL INFORMATION
>>>>>>>>> intended
>>>>>>>>> solely for the use of the addressee named above. Any disclosure,
>>>>>>>>> distribution, copying, or use of the information
>>>>>>>>> in this email by others is strictly prohibited. If you have
>>>>>>>>> received this
>>>>>>>>> message in error, please advise the sender and delete the original
>>>>>>>>> message.
>>>>>>>>> Thank you.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Tue, Feb 27, 2018 at 1:25 PM, Bob Owens <[log in to unmask]>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> George,
>>>>>>>>>> I have my staff and students loaded into FitnessGram and will
>>>>>>>>>> also be working with the FTP connection.
>>>>>>>>>> Please let us know when/if you are successful.
>>>>>>>>>>
>>>>>>>>>> Thanks,
>>>>>>>>>> Bob
>>>>>>>>>>
>>>>>>>>>> On Tue, Feb 27, 2018 at 1:19 PM, Tina Scheindel <
>>>>>>>>>> [log in to unmask]> wrote:
>>>>>>>>>>
>>>>>>>>>>> Please let me know how it goes George.  Thank you!
>>>>>>>>>>>
>>>>>>>>>>> On Tue, Feb 27, 2018 at 12:54 PM, George Martin <
>>>>>>>>>>> [log in to unmask]> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> I've been working on it and establishing a connection to their
>>>>>>>>>>>> FTP server has been challenging for some reason.  I've been back and forth
>>>>>>>>>>>> with support numerous times and they've finally escalated the issue to
>>>>>>>>>>>> their "Tier 3" support.  I have many other file transfers setup, with other
>>>>>>>>>>>> systems, using SFTP/FTP and these are all working fine and were easy to
>>>>>>>>>>>> setup.  I've had to be persistent with them.  I'll let you know what
>>>>>>>>>>>> happens...
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>
>>>>>>>>>>>> George
>>>>>>>>>>>>
>>>>>>>>>>>> George Martin
>>>>>>>>>>>> District Data Manager
>>>>>>>>>>>> Champlain Valley School District
>>>>>>>>>>>> Office: (802) 985-1915
>>>>>>>>>>>> Google Voice: (802) 382-0077
>>>>>>>>>>>> www.cvsdvt.org
>>>>>>>>>>>>
>>>>>>>>>>>> This message contains PRIVILEGED AND CONFIDENTIAL INFORMATION
>>>>>>>>>>>> intended
>>>>>>>>>>>> solely for the use of the addressee named above. Any
>>>>>>>>>>>> disclosure,
>>>>>>>>>>>> distribution, copying, or use of the information
>>>>>>>>>>>> in this email by others is strictly prohibited. If you have
>>>>>>>>>>>> received this
>>>>>>>>>>>> message in error, please advise the sender and delete the
>>>>>>>>>>>> original message.
>>>>>>>>>>>> Thank you.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Tue, Feb 27, 2018 at 12:40 PM, Tina Scheindel <
>>>>>>>>>>>> [log in to unmask]> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>
>>>>>>>>>>>>> I'm wondering if anyone else is working on ftp from
>>>>>>>>>>>>> PowerSchool to Fitnessgram.  While Fitnessgram provides ftp credentials
>>>>>>>>>>>>> they say they do not support it.  I have run into some challenges.  Has
>>>>>>>>>>>>> someone else made this work?  Can you share the secret?
>>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks for any clues!
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> Tina Scheindel, Technology Director and Integration Specialist
>>>>>>>>>>>>> Orange Southwest Supervisory District
>>>>>>>>>>>>> 24 Central Street
>>>>>>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>>>>>>> Randolph, Vermont 05060
>>>>>>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>>>>>>>
>>>>>>>>>>>>> www.orangesouthwest.org
>>>>>>>>>>>>>
>>>>>>>>>>>>> 802-728-5052 <(802)%20728-5052>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> ------------------------------------------------------------
>>>>>>>>>>>>> -----------
>>>>>>>>>>>>>
>>>>>>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the
>>>>>>>>>>>>> SCHOOL-IT Archive
>>>>>>>>>>>>>
>>>>>>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1>
>>>>>>>>>>>>> your Subscription to SCHOOL-IT
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> ------------------------------------------------------------
>>>>>>>>>>>> -----------
>>>>>>>>>>>>
>>>>>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the
>>>>>>>>>>>> SCHOOL-IT Archive
>>>>>>>>>>>>
>>>>>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1>
>>>>>>>>>>>> your Subscription to SCHOOL-IT
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Tina Scheindel, Technology Director and Integration Specialist
>>>>>>>>>>> Orange Southwest Supervisory District
>>>>>>>>>>> 24 Central Street
>>>>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>>>>> Randolph, Vermont 05060
>>>>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>>>>>
>>>>>>>>>>> www.orangesouthwest.org
>>>>>>>>>>>
>>>>>>>>>>> 802-728-5052 <(802)%20728-5052>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> ------------------------------------------------------------
>>>>>>>>>>> -----------
>>>>>>>>>>>
>>>>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the
>>>>>>>>>>> SCHOOL-IT Archive
>>>>>>>>>>>
>>>>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1>
>>>>>>>>>>> your Subscription to SCHOOL-IT
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Bob Owens
>>>>>>>>>> Technology Director
>>>>>>>>>> Addison Northwest School District
>>>>>>>>>> 11 Main St., Suite B100
>>>>>>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>>>>>>> Vergennes, VT 05491
>>>>>>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>>>>>>> (802) 870-8904
>>>>>>>>>>
>>>>>>>>>> ------------------------------------------------------------
>>>>>>>>>> -----------
>>>>>>>>>>
>>>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the
>>>>>>>>>> SCHOOL-IT Archive
>>>>>>>>>>
>>>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1>
>>>>>>>>>> your Subscription to SCHOOL-IT
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ------------------------------------------------------------
>>>>>>>>> -----------
>>>>>>>>>
>>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the
>>>>>>>>> SCHOOL-IT Archive
>>>>>>>>>
>>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>>>>> Subscription to SCHOOL-IT
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Tina Scheindel, Technology Director and Integration Specialist
>>>>>>>> Orange Southwest Supervisory District
>>>>>>>> 24 Central Street
>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>> Randolph, Vermont 05060
>>>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>>>
>>>>>>>> www.orangesouthwest.org
>>>>>>>>
>>>>>>>> 802-728-5052 <(802)%20728-5052>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------
>>>>>>>> -----------
>>>>>>>>
>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>>>> Archive
>>>>>>>>
>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>>>> Subscription to SCHOOL-IT
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Bob Owens
>>>>>>> Technology Director
>>>>>>> Addison Northwest School District
>>>>>>> 11 Main St., Suite B100
>>>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>>>> Vergennes, VT 05491
>>>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>>>> (802) 870-8904
>>>>>>>
>>>>>>> ------------------------------------------------------------
>>>>>>> -----------
>>>>>>>
>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>>> Archive
>>>>>>>
>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>>> Subscription to SCHOOL-IT
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Tina Scheindel, Technology Director and Integration Specialist
>>>>>> Orange Southwest Supervisory District
>>>>>> 24 Central Street
>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>> Randolph, Vermont 05060
>>>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>>>
>>>>>> www.orangesouthwest.org
>>>>>>
>>>>>> 802-728-5052 <(802)%20728-5052>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------
>>>>>> -----------
>>>>>>
>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>> Archive
>>>>>>
>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>> Subscription to SCHOOL-IT
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Bob Owens
>>>>> Technology Director
>>>>> Addison Northwest School District
>>>>> 11 Main St., Suite B100
>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>> Vergennes, VT 05491
>>>>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>>>>> (802) 870-8904
>>>>>
>>>>> ------------------------------------------------------------
>>>>> -----------
>>>>>
>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>> Archive
>>>>>
>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>> Subscription to SCHOOL-IT
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Tina Scheindel, Technology Director and Integration Specialist
>>>> Orange Southwest Supervisory District
>>>> 24 Central Street
>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>> Randolph, Vermont 05060
>>>> <https://maps.google.com/?q=24+Central+Street+Randolph,+Vermont+05060&entry=gmail&source=g>
>>>>
>>>> www.orangesouthwest.org
>>>>
>>>> 802-728-5052 <(802)%20728-5052>
>>>>
>>>>
>>>>
>>>> -----------------------------------------------------------------------
>>>>
>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>> Archive
>>>>
>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>> Subscription to SCHOOL-IT
>>>>
>>>
>>>
>>>
>>> --
>>> Richard Adams
>>> Technology Coordinator
>>> Windham Northeast Supervisory Union
>>> Phone: (802) 460-7240 <8024607240>
>>> Website:  Helpdesk.wnesu.org
>>>
>>> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> CONFIDENTIALITY NOTICE: This message (including any attachments)
>>> contains confidential information intended for a specific individual
>>> and purpose.  If you are not the intended recipient, you should delete this
>>> message and are hereby notified that any disclosure, copying, or
>>> distribution of this message, or the taking of any action based on it is
>>> strictly prohibited.
>>>
>>>
>>> ᐧ
>>> ᐧ
>>>
>>> -----------------------------------------------------------------------
>>>
>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>> Archive
>>>
>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>> Subscription to SCHOOL-IT
>>>
>>
>>
>>
>> --
>> Bob Owens
>> Technology Director
>> Addison Northwest School District
>> 11 Main St., Suite B100
>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>> Vergennes, VT 05491
>> <https://maps.google.com/?q=11+Main+St.,+Suite+B100+Vergennes,+VT+05491+(802&entry=gmail&source=g>
>> (802) 870-8904
>>
>> -----------------------------------------------------------------------
>>
>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>> Archive
>>
>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>> Subscription to SCHOOL-IT
>>
>
> -----------------------------------------------------------------------
>
> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT Archive
>
> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
> Subscription to SCHOOL-IT
>



-- 
Keith Puffer
Technology Coordinator
Harwood Unified Union School District
340 Mad River Park, Suite 7
Waitsfield, VT 05673
802-583-7959
Fax: 802-496-6515