9-27-19 EZ Scan Update

[bubbaearle]

Ahhh gotcha - using the CSV export from EZScan as a template of sorts, then filling in the blanks. I'm wondering if a single character somewhere in that alpha/freq paste could throw something? The notepad++ app would show something that could be "invisible" in Libre or Excel, shows up as an odd unicode or ascii character. When you import the data back, like the conventional import do you get a review screen of the data being imported? And if so, scroll to the bottom and see if it made it all the way or choked on something midway through. Also, do you have any empty columns you're not populating? If so, try removing those columns.

I remember similar on the Conventional imports, it didn't like something. I'm looking at mine now and can't remember. But I have a column now I labeled "ch" that I basically use as a line number, as well as something I can sort by. The line number where the import chokes lets me refer back to the csv to see right where the error was.

Good luck!

Look @ the .PDF file, on the second page is the import dialog box that shows what is to be imported into the software.

Looks identical to the .csv on the first page...

Last page is the software after import with corruption of alpha tags...

I'll download Notepad++ this evening and check it out.

 

[norcalscan]

So it looks like the import process is choking on that hyphen in your alpha tag. Notice the next data viewed in the "corrupted" alpha is actually data further in on your CSV file. No No On. I'm not sure where the TE and stuff is in your CSV. Since the "preview" page looks correct, it might be out of your control and a bug in EZ Scan, if indeed the hyphen is a legal character, then it breaks between the preview and the actual import.

I'd do two things. Duplicate your CSV to make a test file, and in the test file in Libre do a Find and Replace for that column and remove the hyphens in the Alpha column. Then import that and see if it behaves.

Second, open the CSV (the one with the hyphen) in Notepad++ (it's a clean, lightweight and solid app, I've used it forever). Notepad++ will open it and display the raw text of the CSV instead of trying to be "helpful" and format the data into cells etc. You want to see the raw text. You'll see either data like...

1,Alpha Tag Here,855.5625,No,No,On​

​

or​

​

1,"Alpha Tag Here","855.5625","No","No","On",​

Pay attention around that alpha tag and see if there's a comma missing or extra comma in middle of the alpha, or the quotes aren't encompassing the entire alpha tag. If it looks proper (no extra commas or quotes around that hyphen area), then I'd say you're providing a clean CSV and it's EZ Scan that is choking, and it's choking on that hyphen. Either it's illegal and they didn't state that, or they can't parse the hyphen properly. And then report it here to Whistler with the findings, screenshots, CSV etc. (edit: don't send attachments on the initial email, they might get stuck in a spam/malware filter. Offer them up, when they reply then you can send them...)

 

[bubbaearle]

I'll try again this evening & drop the hyphen. I don't recall it being an issue before.

The reason it's there is that AR State Police divides the state into troops, A-L, and I sorted the sites that way with the troop letter preceding the site name. RR lists them in order by site number. I label them as such to make it easier to lock them out as needed manually via the keypad since I can't remember what troop each site is in. I have early stages of CRS...Can't Remember Shi.... LOL

I submitted the issue to the bug e-mail address and linked this thread.

 

[gmclam]

I created an extensive profile in Excel which I copied to the clipboard and imported into EZ Scan (older version). It was not handled well. Excel likes to round off numbers so 074 becomes 74. To get around that I'd enter '074 which makes Excel think it is a string (rather than number). I was later told by Whistler that thinks like NAC codes were not imported properly. Hmmm.....

In a later version of EZ Scan they started reporting errors when you start the code. NOT the correct solution to this issue. EZ Scan MUST not just take what it is importing literally. It needs to be intelligent about it. While this latest version may have added some new feature(s), it looks like a big step backwards as well.

 

[bubbaearle]

Losing the hyphen worked!! I didn't download Notepad++, just replaced the hyphen with a space & imported with no issue.

Funny thing is, you can import a TRS & sites via the library DB and edit the site name with a hyphen in the alpha tag adn it displays it with no problem, just when ya try to import from text or clipboard. Looks as if norcalscan get a cookie for figuring that bug out.....

Next task is to see if TGID import has any issues.