siri | Web service oriented , markup | Blog library

I have a pandas dataframe and for each row (column value) I would like to add +5. Meaning that I would leave the original numbers and add 5 to each.

Dataframe:

My app was rejected for TestFlight Beta as follows:

"Guideline 2.5.4 - Performance - Software Requirements

Your app declares support for external-accessory in the UIBackgroundModes key in your Info.plist file but does not declare any external accessory protocols supported by your app. The external accessory background mode is intended for apps that communicate with hardware accessories through the External Accessory framework.

If your app is meant to work with external hardware, supported protocols must be included in the UISupportedExternalAccessoryProtocols key in your app's Info.plist file - and the hardware's PPID # should be provided in the Review Notes field of your app in App Store Connect.

Additionally, your app must be authorized by MFi to use the desired hardware. If you are not yet in the MFi Program, you can enroll at MFi program."

I read similar questions, but none answer or solve my problem.

In Xcode project settings I have checked "Uses Bluetooth LE accessories" under Background Modes.

In info.plist I have NSBluetoothPeriperalUsageDescription="Uses Bluetooth for switches and adaptive toys".

If I uncheck "Uses Bluetooth LE accessories" under Background modes I think my app will be approved, but it leaves out the following important set of users of the app as follows:

The app is for capability switch users in the Accessibility realm, which is already a small set of users. The feature requiring background communication between the app (central) and switches (peripheral) is for a specific subset of switch users that have a visual impairment and significant cognitive delays. This is an even smaller set of users, probably < 100 in the world, but it is an extremely important use case for these users. It is not practical to have the app always in the foreground when they use the app to use audio to say 1 or 2 words, typically "Yes"/"No", or "I need help!”, needed even when there is no WiFi or cell signal. For example, my test user (downloaded to her app directly from my Xcode dev env) with Fox G1 syndrome uses this mode exclusively and has seen great improvements in having some minimal control of things in her life (e.g., saying “I need help” when she feels a seizure coming on or requires diapering).

Current capability switches on the market use the Bluetooth HID profile, which does not allow for background use or 2-way communication between central (my app) and accessory (switch box), to do important feedback like adjusting delay time for switch activations for users with movement disorders and tremors, also the case of my test user.

Has anyone successfully received app approval for background communication with an accessory as a peripheral that is not MFi or HomeKit approved? When I read the MFi FAQ, this peripheral accessory does not appear to fall into the MFi umbrella, and with HomeKit I already came across the limitation that it does not work when the device is sleeping (this latter case is another bone I have to pick, since non-touch users cannot turn on lights, open auto-doors, turn up heaters... unless the device is open which they cannot physically do, and Siri is not an option since they are non-verbal!).

Additional technical background regarding the app: I use only CoreBluetooth (UART), where the app is the central. My API is so simple I am slightly embarrassed to list it, but here goes:

// BLE UART API

let receiveSwitch1On: NSString = "SWITCH1_ON"

let receiveSwitch1Off: NSString = "SWITCH1_OFF"

let receiveSwitch2On: NSString = "SWITCH2_ON"

let receiveSwitch2Off: NSString = "SWITCH2_OFF"

let sendSwitchboxOn: NSString = "ON"

let sendSwitchboxOff: NSString = "OFF"

let updateDebouncePrefix: NSString = "DEBOUNCE="

let updateGraceOffPrefix: NSString = "GRACE_OFF=“

Does anyone have a suggestion on what I could change technically, or advice for navigating the app approval process on what my lowest cost option would be to keep this use case of background comm between app and peripheral? Already I've spent significant time and money to create this capability. I am not in this to make money, but to provide some benefit to a small set of users that are largely left out of technology. I am willing to spend more time and money to reach the finish line, but I really can't afford a lot of ongoing program costs as I expect MFi or HomeKit might be.

Thanks for reading!

I am trying to use the Spotify PKCE authorization with Siri Shortcuts. Unfortunately, none of the solutions I have found have been applicable to my specific situation. I have this bit of code And I really have no idea what I am doing. Basically I need a SHA256 hash of a string of characters, but this needs to be by bytes vs the hex. This then needs to be base64Url encoded. I’ve have tried most of the solutions on stack but I can’t seem to output the final product onto a webpage, which is the main way I am able to run Java script natively on iPhone. Any help would be greatly appreciated

In SiriShortcut, if I am giving a parameter of Boolean then Siri is not asking for the bool value in the dialog. This is because it is taking default value.

Is there any way to overcome this issue?

Long Story short. I have data that I'm trying to identify duplicate records by address. The address can be matched on the [Address] or [Remit_Address] fields. I use a JOIN and UNION to get the records, but I need the matched records to appear with each other in the results.

I can't sort by any of the existing fields, so a typical 'ORDER BY' won't work. I looked into RANK as suggested by someone and it looks like it might work, but I don't know how to do the Partition, and I think the Order gives me the same issue with ORDER BY.

If RANK is not the best option I'm open to other ideas. The goal ultimately is to group the matched records someway.

• SSMS 18
• SQL Server 2019

Here is the setup:

Backstory: I have created a bunch of stored procedures that analyze my client's data. I am reviewing a list of vendors and trying to identify possible duplicates. It works pretty well, but each record has 2 possible addresses, and I'm getting duplicate results when matches are found in both addresses. Ideally I'd just need the records to appear in the results once.

Process: I created a "clean" version of the address where I remove special characters and normalize to USPS standards. This helps me match West v W v W. or PO Box v P.O. Box v P O Box etc. I then take all of the distinct address values from both addresses ([cleanAddress] and [cleanRemit_Address]) and put into a master list. I then compare to the source table with a HAVING COUNT(*) > 1 to determine which addresses appear more than once. Lastly I take that final list of addresses that appear more than once and combine it with the source data for output.

Problem: If you view the results near the bottom you'll see that I have 2 sets of dupes that are nearly identical except for some slight differences in the addresses. Both the Address and Remit_Address are essentially the same so it finds a match on BOTH the [cleanAddress] and [cleanRemit_Address] values for "SouthWestern Medical" and "NERO CO" so both sets of dupes appear twice in the list instead of once (see the desired results at the bottom). I need to match [cleanAddress] OR [cleanRemit_Address] but I don't know how to limit each record appearing once in the results.

• SSMS 18
• SQL Server 2019

Queries:

My end goal is to click the "Enable Switch Control" checkbox, which can be found under Accessibility-> Switch Control in System Preferences. I have had some trouble getting the applescript to work and would like to find out what is causing the issue. My current code:

In my app, I have two targets.

1. Target 1 -> Main App
2. Target 2 -> Siri Intent Extention.

I have a function in my Target 1 (Main app) which I want to call from Target 2 (Intent Extention)

I need to use replace a file checking exact matches of the word he or "he" but not replacing 'he' inside weather so I decided to use the sed command on macOS. I tries using both double quotes and single quotes but it doesn't change anything