TargetTalk

A forum to talk about Olympic style shooting, rifle or pistol, 10 meters to 50 meters, and whatever is in between. Hosted by Pilkguns.com
It is currently Thu Feb 22, 2018 3:58 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: SCATT File Export
PostPosted: Fri Aug 31, 2012 6:26 pm 
Offline

Joined: Fri Aug 31, 2012 6:21 pm
Posts: 1
Hi there,

I am trying to export data into excel from SCATT using the scattexp.vbs script found on the SCATT site (in scattsdk.zip).
http://www.scatt.com/faq/12/faq/#11

I am having some difficulties getting it to run though, the most recent version of the SCATT Profesional software gave me this error when I ran the VBS script:
Error: Scatt Professional was not installed properly

and the previous version gave me this one (one step further in the process):
Error: File not found or invalid file format

I am using the sample file ka1902971830.scatt to test this on.

Does anyone have any guidance or have run into similar issues?

Thank you,
Darren


Top
 Profile  
 
 Post subject: Re: SCATT File Export
PostPosted: Thu Jun 01, 2017 10:01 pm 
Offline

Joined: Fri Jan 23, 2015 12:48 am
Posts: 6
I know this is an old post, but has anybody been able to successfully complete export of the .scatt files into Excel/CSV by using the VBS (Visual Basic Scripts). I'm getting the error about "Error: Scatt Professional was not installed properly." I put in a help request to SCATT, but I have yet to get a reply. I suspect it might be an issue with Windows 10. I did run the script as Administrator.

Mark


Top
 Profile  
 
 Post subject: Re: SCATT File Export
PostPosted: Fri Jun 16, 2017 3:28 pm 
Offline

Joined: Mon Nov 29, 2004 2:49 pm
Posts: 2374
Location: Valencia County 4-H, NM USA
I had no troubles.
Using W10 - 64-bit ... used the 64-bit cmd.exe as noted.
All the scripts ran fine
===========================================
Image
===========================================
The one thing that I did do was to put the scripts in a directory close to the root (C:\test) and shortened the long .scatt filename to something like 170523_REM.scatt. Sometimes windows does not like long filenames or directory names with a space in them.


Top
 Profile  
 
 Post subject: Re: SCATT File Export
PostPosted: Mon Jan 01, 2018 9:32 am 
Offline

Joined: Thu Apr 13, 2017 7:28 pm
Posts: 3
mhbower wrote:
I know this is an old post, but has anybody been able to successfully complete export of the .scatt files into Excel/CSV by using the VBS (Visual Basic Scripts). I'm getting the error about "Error: Scatt Professional was not installed properly." I put in a help request to SCATT, but I have yet to get a reply. I suspect it might be an issue with Windows 10. I did run the script as Administrator.

Mark


Did you solve the problem and how? I have the same problem and I donĀ“t know how to fix it


Top
 Profile  
 
 Post subject: Re: SCATT File Export
PostPosted: Fri Jan 19, 2018 9:35 am 
Offline

Joined: Thu Dec 13, 2007 4:40 pm
Posts: 2
Location: Niagara
Just acquired a scatt system. Found a reference to exporting Scatt to Excel:

https://github.com/zliobaite/Scatt-anal ... attexp.vbs

but not sure how to make this work.

Also, seems scatt has for some time discontinued ematch. Certainly would appreciate any info on how to make the export happen.


Top
 Profile  
 
 Post subject: Re: SCATT File Export
PostPosted: Tue Jan 30, 2018 2:13 am 
Offline

Joined: Fri Sep 05, 2014 8:55 am
Posts: 168
Location: Utah
What I've figured out is for some reason the line
%windir%\SysWOW64\cmd.exe
in the .bat file is executing the .bat via the system32\cmd.exe instead of the cmd.exe in syswow64.
At this point I dunno why.

Before trying to run, in the .bat file make sure the line
for %%f in (<scatt folder>\*.scatt) do (
to replace with the folder name where your .scatt file is... Mine is in folder named fp located in the same folder as the .bat file. So the above line looks like:
for %%f in (fp\*.scatt) do (
in my .bat file

There's probably a better way to do this bit....
Then, in windows explorer browse to c:\windows\syswow64 and double click on cmd.exe.
Then using dos commands change directory to where your .bat file is.
Type the .bat file name into the command window command prompt.
A short while later excel will open with tabular data as shown above for the shots in the .scatt file.

If you want the trace data then repeat the for block in the batch file, replacing scattexp.vbs with samples.vbs. Next time the .bat is run a .txt file with the same name as the .scatt file will appear in your data folder.

Line 70 in samples.vbs sets the time range for outputting data.

The 3_data_scatt folder contains a subfolder ua_online which contains pdf files with links to .scatt files. Or at this page https://github.com/zliobaite/Scatt-analysis there are two URLs that go to places where .scatt files can be found.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group