APX Excel

[onsceno]

Good morning, all,

Is is possible, similar to the XTS/XTL CPS, to EASILY create an Excel spreadsheet based off the conventional personality drop down?

 

[N1GTL]

You can copy and paste all the frequencies and channels between APX CPS and Excel if that's what you mean.

 

[onsceno]

It is, yes... but, unless I'm doing something wrong, it isn't allowing me to pull a "Ctrl + A" (select all), copy and paste.

Any ideas?

 

[N1GTL]

Click on the first record to highlight the entire row.

Put your cursor on the last record.

Hold SHIFT and click the last record. You can then right click and select copy. Move to your Excel sheet and you can paste.

When you highlight the row in CPS, click all the way to the left to highlight the entire row, not just the first cell.

 

[onsceno]

Wow... that definitely wasn't letting me do that before - though I'm not sure if I was clicking to the left of "name" or "name" itself. Thank you!!!

 

[N1GTL]

You're welcome!

 

[masstech]

If you're amazed that you can copy from the CPS into a spreadsheet... Wait until you learn that you can paste into the CPS too!

This is how we have been preparing our codeplugs - we have a big spreadsheet meant for pasting into frequency/talkgroup options for personalities, and we can easily generate the right columns for the parts that need to be pasted into a zone.

Now if only there was a UCL tool that is not akardam.net...

 

[N1GTL]

I wrote one! I have a program that takes a spreadsheet, accounts for MDC, Astro25, Trunking, etc and creates an xml file that can be imported into CPS in > 1 second will import a UCL into CPS and be programmed into an APX code plug.

I created a spreadsheet for our sales people to give to customers. Fill out MDC, P25, Trunked, IDs, etc.

If done correctly, it willl, in seconds, create the properly formatted XML files, ready to be imported and create an XML UCL list for APX radios. I was chastised on this site, as this already existed on someones website. I found it confusing and was not about to learn something new so I wrote something that was easier to use.

Search my user name and forward me a formatted spreadsheet as I explained and I will send you a UCL file ready for importing.

 

[masstech]

I wrote one! I have a program that takes a spreadsheet, accounts for MDC, Astro25, Trunking, etc and creates an xml file that can be imported into CPS in > 1 second will import a UCL into CPS and be programmed into an APX code plug.

I created a spreadsheet for our sales people to give to customers. Fill out MDC, P25, Trunked, IDs, etc.

If done correctly, it willl, in seconds, create the properly formatted XML files, ready to be imported and create an XML UCL list for APX radios. I was chastised on this site, as this already existed on someones website. I found it confusing and was not about to learn something new so I wrote something that was easier to use.

Search my user name and forward me a formatted spreadsheet as I explained and I will send you a UCL file ready for importing.

Very cool! Is the tool for generating a UCL xml file from the spreadsheet available online as well?

 

[mikewazowski]

Very cool! Is the tool for generating a UCL xml file from the spreadsheet available online as well?

akardam.net has an online version you can use.

 

[masstech]

We mentioned Peter's website in #7.

 

[N1GTL]

akardam.net has an online version you can use.

This is the one I found confusing. Someone else would find mine confusing as well because I can modify a control file to match the Conventional System names versus leaving them at Cnv Sys 1, Cnv Sys 2, etc.

 

[iuHx3TtQys]

You can copy and paste all the frequencies and channels between APX CPS and Excel if that's what you mean.

It is, yes... but, unless I'm doing something wrong, it isn't allowing me to pull a "Ctrl + A" (select all), copy and paste.

Any ideas?

Click on the first record to highlight the entire row.

Put your cursor on the last record.

Hold SHIFT and click the last record. You can then right click and select copy. Move to your Excel sheet and you can paste.

When you highlight the row in CPS, click all the way to the left to highlight the entire row, not just the first cell.

Wow... that definitely wasn't letting me do that before - though I'm not sure if I was clicking to the left of "name" or "name" itself. Thank you!!!

I'm very familiar with excel, and microsoft key commands, but its not working for me. In the left hand pane, I can select all the channels i want to copy, and then click "copy", but I can't paste in excel. Any reason why?

 

[N1GTL]

Your trying to copy from the tree view pane. Click on the CONVENTIONAL PERSONALITY in the tree view pane. Then move to the right window and under FREQUENCY OPTIONS, you can copy and paste as explained above.

 

[iuHx3TtQys]

Your trying to copy from the tree view pane. Click on the CONVENTIONAL PERSONALITY in the tree view pane. Then move to the right window and under FREQUENCY OPTIONS, you can copy and paste as explained above.

Ok I'm lost there. I don't have anything in my CPS that says Conventional Personality. I'm trying to copy channels (analog). I only have analog channels programmed in my XPR right now.

 

[N1GTL]

This thread was referring to APX radios, not XPR radios.

I am not aware of a way to copy channels from Excel into an XPR series radio. APX radios, yes.

 

[iuHx3TtQys]

This thread was referring to APX radios, not XPR radios.

I am not aware of a way to copy channels from Excel into an XPR series radio. APX radios, yes.

Ahhh, ok. I assumed the software would be the same regardless of radio. Thanks.