Jump to content



Photo
- - - - -

Internet Advancement File Format (for National BSA site)


  • Please log in to reply
7 replies to this topic

#1 Loriebenglish

Loriebenglish

    Junior Member

  • Members
  • 1 posts

Posted 26 June 2013 - 08:41 AM

Can someone send me specifications for post their ADVxxxx.csv file? This is the file that is uploaded for the internet advancement reporting on the national BSA Internet Advancement site. I've tried the National support line and they were no help. Did not know what a CSV file was. I obviously did not get to the right person. If someone could just send me a copy of the file they uploaded for advancements that would be so helpful. :D:D:D
  • -1

#2 perdidochas

perdidochas

    Senior Member

  • Members
  • 2192 posts

Posted 26 June 2013 - 11:39 AM

What do you need it for? I won't send you mine for privacy reasons. Unless you are creating a new advancement program, I think you'd be better off just using the option in Internet Advancement and manually enter the information. I have opened the file in Excel, and honestly, there isn't enough information in the .csv to allow you to recreate it. The first two lines of the file are information about the unit. Beginning at the third line, there are two columns of numbers that I have no idea what they mean, then three columns with Scouts first name, middle initial and last name. Then a column of the Scout's scout ID #, a blank column, then a date, then a code for what was earned--RT is rank Tenderfoot, R1 is rank First Class or a number (10 is Personal Fitness MB). There is a row in the spreadsheet for each Scout, and it ends with a row with two columns of numbers.
  • 0

#3 mazumas

mazumas

    Junior Member

  • Members
  • 1 posts

Posted 28 August 2014 - 04:02 PM

I too am looking for the format to upload our Rank and Merit Badge to Internet Advancement from an excel file instead of manually typing them all in. Anyone have the .csv format so I can save my in the same format so IA will accept it? We don't use Troopmaster.
  • 0

#4 Lurking...

Lurking...

    Senior Member

  • Members
  • 12252 posts

Posted 28 August 2014 - 05:08 PM

A .csv file is nothing more than a text file of records that separate the fields of the data with a comma. One can import the file into a spreadsheet or database but the file structure is pretty much just that, a database. If one wishes to make sense out of it they need the interface program that goes along with it. .CSV files are meant to transfer files between interface programs. You have the data, now all you need to do is write your own interface program and you're all set to go. It's doable, but you pretty much have to know what you're doing. Stosh
  • 0

#5 bigmacak

bigmacak

    Junior Member

  • Members
  • 1 posts

Posted 17 April 2017 - 10:49 PM

But if you know what the BSA required specifications for the CSV format is, you can simply have your data in a excel or other spreadsheet file, export it to a CSV format file (microsoft excel, google sheets, or any other spreadsheet program will let you do this) and upload it via internet advancment on scoutnet.scouting.org  that is what everyone asking here is wanting to know, what are the specification requirements for the SCV file format specified by BSA????? can someone either post them, or tell where BSA has them spelled out???


  • 0

#6 qwazse

qwazse

    Senior Member

  • Members
  • 6704 posts

Posted 18 April 2017 - 10:33 AM

I hope there is someone to help you, but in general BSA has been ignorant of open standards for databases. Thus we have reason for you to despair.

 

The logical location would be a page linked from the upload page by an info button. But, providing such specifications may be a violation of agreements with software companies that track scout advancements.

 

Developers of such software are welcome to prove us wrong by providing the location of your software's specs for portable files.


  • 0

#7 Col. Flagg

Col. Flagg

    Robert E. Lee - Patriot

  • Members
  • 1348 posts

Posted 18 April 2017 - 11:20 AM

The easiest way to determine the CSV file data format is to contact TroopMaster or ScoutBook to see what their export CSV file for Internet Advancement looks like. CubMaster, TroopMaster and ScoutBook all port CSV files for input in to Internet Advancement.


  • 0

#8 5yearscouter

5yearscouter

    Senior Member

  • Members
  • 780 posts

Posted 18 April 2017 - 10:51 PM

Well first they say if you make the csv file out of troop master or troop web host or whatever,

they tell you do not open it, cause when you open it, that changes the file somehow so it won't upload properly.

So that's not helpful at all if the format is changed by opening and viewing it. 

 

The problem is there are some fields that make no sense.  They are numbers that mean nothing when you look at unit number, Internet advancement/unit ;log in number, or anything that makes it seem to be reproducible without knowing some secret BSA codes. 

 

If you could get the gobbledygook numbers figured out the rest is sort of

header for unit id/scoutmaster info/date the unit recharters, district in two rows.

then list by row for each rank or mb

with random number, count of what row you are on, then scout name, first, middle, last, date of birth, date of advancement earned and the code for the merit badge or rank

 

But the bsa codes at the top and several other places are unexplainable.

it won't let me upload this type of file to the message board.

 

 


  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


IPB Skin By Virteq