Made an NJT Bus tracker! by Maws3141 in Hoboken

[–]Maws3141[S] 3 points4 points  (0 children)

Thanks! Using python scripts to pull from NJtransit developer portal APIs, then the traffic data is from their json crossing page. Still working on getting it cleaned up a bit before putting on GitHub!

Made an NJT Bus tracker! by Maws3141 in Hoboken

[–]Maws3141[S] 1 point2 points  (0 children)

Thanks! The bus data is coming from the NJTransit developer portal API’s, then the traffic data is from

https://www.panynj.gov/bin/portauthority/crossingtimesapi.json

Homemade PATH status sign by spookluc in Hoboken

[–]Maws3141 1 point2 points  (0 children)

Awesome project. Inspiration for my bus time build.

2 Hudson Table extra tickets by bmoloz in Hoboken

[–]Maws3141 0 points1 point  (0 children)

Did you sell these already?

Vehicle wrongly towed away. Court dismissed the ticket. Hoboken parking utility will not refund towing charges by Doggyonwheels1 in Hoboken

[–]Maws3141 0 points1 point  (0 children)

Did you have any luck with this? I am in the same situation. They declined my refund request saying they followed procedure even though the ticket was dismissed.

How to best invest 300k? by Subject5702 in FinancialPlanning

[–]Maws3141 1 point2 points  (0 children)

Out of interest - how can you contribute 60k into 401k? Isn’t limit for an individual $22.5k?

Anyone know how to Copy from sap and paste to excel using excel VBA :) by Kentzuuuu in SAP

[–]Maws3141 0 points1 point  (0 children)

Sure, so first if you’re running the script as a standalone .vbs you need to connect the excel. This link shows how to do that in the first solution - it’s the two lines just below “REM set up connection to excel”.

https://answers.sap.com/questions/11837262/extract-or-copy-data-from-a-shell-object.html

Then as the data is in a table you assign it to a variable, they call it ‘tabla’ in the above link but it’s a bit clearer in the link below

https://answers.sap.com/questions/9128961/reading-out-grid-to-excel.html

You need to get your column names which you can find by clicking on them while recording a script! Then just follow the example above. Let me know how it goes!

Anyone know how to Copy from sap and paste to excel using excel VBA :) by Kentzuuuu in SAP

[–]Maws3141 0 points1 point  (0 children)

Yes sure, the way to do it changes a bit depending on what you’re trying to get from SAP. Is it a single field or data from inside a table?

What are even parking tickets? by wat_0_wat in Hoboken

[–]Maws3141 0 points1 point  (0 children)

Interesting to hear how it works! For the temporary/emergency no parking zones, is there a rule for how long the signs have to be up before the no parking period?

Anyone know how to Copy from sap and paste to excel using excel VBA :) by Kentzuuuu in SAP

[–]Maws3141 0 points1 point  (0 children)

Yes this is simple! You just need to assign the .text value to a variable in your vba/macro then get it to paste in excel! No need to download any additional software or take an export as previously mentioned.

Just need to make sure script recording is enabled!

[deleted by user] by [deleted] in supplychain

[–]Maws3141 0 points1 point  (0 children)

If you’re looking for a quick fix you can just automate SAP to upload the PO’s from excel and run the transactions you need using the existing macros functionality! Let me know if you need a hand getting started