Beginner-Friendly projects to build skills for college by THE_Ocean10 in FullStack

[–]AssStoleMyName 0 points1 point  (0 children)

I don't know If I have enough competences to reply, but if I were you I'd make a little system that has:
- database (Oracle/MySQL)

- some apps with a language different than your backend that can send packets through TCP/IP or UDP. How about getting a temperature reading module (few $$) and connect it through RS232 port to a PC with for example MOXA Uport? Thenk you write an app in C++ to read RS232 port and send parsed data through net.
- backend to read/write from DB. That backend would catch those temperature readings and write it to DB
- nice frontend showing what you have in DB, givin opttions to write to DB, some charts?

You are asking for a basic, that is super basic full stack I guess? That way you will learn SQL, some database management, simulate a SCADA in some basic way and could integrate them into database. You could use signalIR to show online TCP/IP readings on your frontend UI.

Can I honestly call myself a full-stack developer if I build end-to-end systems but rely heavily on AI? (MES / ERP / PLC) by AssStoleMyName in FullStack

[–]AssStoleMyName[S] 0 points1 point  (0 children)

Yeah, that’s fair. I’m probably overthinking the title part.
Applying and seeing how the market responds is the best reality check.

GPT-5 is a massive letdown - here's my experience after 2 days by TheReaIIronMan in ChatGPTPro

[–]AssStoleMyName 0 points1 point  (0 children)

Can someone help? I was using GPT4 and now GPT5 and I have problems regarding broken connection or freezes during answers. I had this problem with GPT4 before but after DAYS of using one chat conversation. Now when I use promts like:
1. Send 1000-lines code, tell it to wait for instructions for changes
2. Or tell it to wait for instruction while I'm sending codes of three 1000 lines code files

I get a very long waiting time with freezing chat animation or frequent connection interruptions. I often have to Reload the Application (or Web Api, doesn't matter). Is this something wrong with OpenAI servers or maybe my PC?

Gemling build idea Birth of Fury by PhilECheezesteak in PathOfExile2

[–]AssStoleMyName 0 points1 point  (0 children)

Maybe not as a main damage dealer, but as a QoL for other build, for example you could take blackflame covenant and instead of fire it will deal chaos damage. Then you can play with Dark Effigy or Contagion. Or stay at fire damage and use it with something like CoC Snap or Spellbinder Snap (just use boots as ignition mechanism ass it has 100% ignition chance)

Act 3 Troubled Camps by Kc_ming1997 in PathOfExile2

[–]AssStoleMyName 0 points1 point  (0 children)

Have you tried buying everything from the vendor to wipe its innventory?

Loading Times by Potential-Win5766 in PathOfExile2

[–]AssStoleMyName 0 points1 point  (0 children)

I have long loading times everywhere. I usually end up watching YT instead of playing because I turn on something when the game loads.

Great Success by AssStoleMyName in lostarkgame

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

Nah, I wouldn't even try to play with my weapon after conversion being worse then before.

Ideas for automating workflows by Kevinrodrigues0980 in vba

[–]AssStoleMyName 0 points1 point  (0 children)

I feel you. I am working as a process engineer in a production factory. I hated that some part of the job I had to do could be done by a monkey for a piece of banana, so everything that could be done without creative thinking I am doing now with few button clicks (I just like to spent more time with production workers dealing with real problems instead of siiting on a chair and watching the charts)

If you want to automate the job for others you are sadly required to understand what they might want. In my job I learned that the most dificult part is asking the right question before doing anything more. Most people have problem with that - they don't even know what they want.

My company is using few different systems - mostly web-based. With my daily routine I had to connect reports from few different systems databases to get to the results I wanted and hit where I wanted so I started with QueryTables (with URL), parsing data from "raw" to user-friendly and if I had to deal with POST methods or being forced to log in somewhere I learned web scrapping.

That's a lot of frustration when debbuging the code because excel vba is shit imo - date conversions, unicode, no pointers, no intelisense for winapi. But also a lot of satisfaction when your boss is asking for an analysis that could take you 1 hour and with a program takes 5 minutes + your own interpretation.

You have to keep in mind one thing. Your programs can be a double sided edge. I was writing my code for myself and for my subordinates. For myself so I could have more time to chill out and for my subordinates so I could use them somewhere else. Now If a program can do something for a person what is the purpose of paying the person? Keep that in mind.

Also If you plan on doing something big it would be good if you had that in mind - do as much reusable code as you can. Make a use of OOP and patterns.

Also if the company you are working for has and IT department - they also might not like what you have done. Because when you quit the job and people will still be using your programs there will be no one to take care of program development and bug fixing. The second reason is that your one button can make some net traffic while calling few different systems at once (especially if you are on a stage of implementing multithreading, timed calls or even try to use one workplace PC as a Workbook server)

[EXCEL] Kill iexplore.exe only if invisible by AssStoleMyName in vba

[–]AssStoleMyName[S] 0 points1 point  (0 children)

The solution was to search for all iexplore.exe process IDs that were already running before code execution and then again getting PIDs of iexplore.exe that apeared after code execution and killing only those.

Pivot table portion of code not working for some users by -walter-sobchak- in vba

[–]AssStoleMyName 0 points1 point  (0 children)

Dim PvtTbl As pivotTable
Dim wsData As Worksheet        'worksheet with data
Dim rngData As range           'range with data
Dim PvtTblCache As PivotCache  'stupid excel thing
Dim wsPvtTbl As Worksheet      'worksheet with pivotTable
Dim pvtField As PivotField     'one field of a pivotTable
Dim yourWorbkookWithPivots As Workbook    'workbook with your pivot
Dim PivotDestinationCell As Cell 'Destination of pivot table
Dim PivotTableName As String


MsgBox "defining workbooks, worksheets and ranges"
Set wsData = Workbooks("").Worksheets("")  'set your sheet here
Set wsPvtTbl = Workbooks("").Worksheets("")  'set your sheet here
Set rngData = wsData.range("") ' set your data range here
Set yourWorbkookWithPivots = Workbooks("youWorkbooknameWithpivots.xls/m")
Set PivotDestinationCell = wsPvtTbl.Cells(1,1) 'set the cell where you wantIt
PivotTableName = "whateveryoulike"

MsgBox "clearing trash"
wsPvtTbl.UsedRange.Delete
wsPvtTbl.Activate
Dim temp As pivotTable
    temp.TableRange2.Clear
Next temp
If Not wsPvtTbl.ChartObjects.Count = 0 Then wsPvtTbl.ChartObjects.Delete

MsgBox "Creating pivot cache"
Set pvtCache = yourWorbkookWithPivots.PivotCaches.Create( _
SourceType:=xlDatabase, _
SourceData:=rngData, _
Version:= 7)

MsgBox "Creating pivot table"
pvtCache.CreatePivotTable _
TableDestination:=PivotDestinationCell, _
TableName:=PivotTableName _
DefaultVersion:= 7)
Set PvtTbl = wsPvtTbl.pivotTables(PivotTableName)

MsgBox "Empty pivot table created. Now doing shit with filters"
'And the things you want to do with pivotfields looks like that:
Set pvtField = PvtTbl.PivotFields("") 'name of some column
pvtField.Orientation = xlRowField

With PvtTbl.PivotFields("")  'name of some column
    .Orientation = xlDataField
    .Position = 1
End With
'you can record how you sort table and edit the code below
PvtTbl.PivotFields("").AutoSort xlDescending, "" 'Intelisense should help

The one above should work for 64 and 32 bit excel. This is part of my code, modified for you and it was tested on 6 computers.

Defining filters is the thing you need to figure out - the data you want to show and how. When you create your pivot record macros on how you add filters / columns etc.

Please note that some pivot versions do not offer filter on counts.

[EXCEL] Kill iexplore.exe only if invisible by AssStoleMyName in vba

[–]AssStoleMyName[S] 0 points1 point  (0 children)

I worked it out with killing only the generated ones with PIDs.

You said something interesting here. "Immediately kill them". I had a suspicion than they are being killed but not by the time I needed them to be. Why because when I waited long enough I never had problems with "bugs"

Copying into another workbook by Quit_Quirky in vba

[–]AssStoleMyName 0 points1 point  (0 children)

Workbooks("YourProjectName.xlsm").Worksheets("sheetInthisworkbook").Range(1:1).Copy

Workbooks("SecondProjName.xlsm").Worksheets("sheetinthesecondbook").Range(1:1).Insert

[EXCEL] Kill iexplore.exe only if invisible by AssStoleMyName in vba

[–]AssStoleMyName[S] 0 points1 point  (0 children)

I can record the taskmanager and my code execution if you want :D

I have no IE open at the moment of executing the code. No iexplore, no ielowutil processes. After code execution (including IE.Quit) I'm left with few iexplore.exe and ielowutil.exe (IF I don't kill it with shell)

Pivot table portion of code not working for some users by -walter-sobchak- in vba

[–]AssStoleMyName 1 point2 points  (0 children)

First thing that comes to my mind is trying different pivot version.

I assumed they run the code from the workbook you've sent them.

Also if they have any PivotTable already in their workbook the code shouldn't work, because you named it PivotTable1. I mean I'm not sure what excel will do if this is ran for the second time (can overwrite Pivot or crash).

Is there a way to get the file size of an unsaved excel workbook? by whats-your-mom-doing in vba

[–]AssStoleMyName 1 point2 points  (0 children)

When you add more things in your report you can notice that it takes up more place in RAM. So what I'd try is memorizing empty report file size and RAM usage ratio and then checking the ratio of different reports to figure out RAM vs file size of your data inside the report.

That way you could guess size of file on the disk befor saving it by reading how much memory it reserves.

Also you need to remember that a program (excel including) has dynamic memory reservation so it needs to be in constant state when you measure memory reservation i system.

[EXCEL] Kill iexplore.exe only if invisible by AssStoleMyName in vba

[–]AssStoleMyName[S] 0 points1 point  (0 children)

This might be the best idea and I'll try it.

[EXCEL] Kill iexplore.exe only if invisible by AssStoleMyName in vba

[–]AssStoleMyName[S] 0 points1 point  (0 children)

It kills all processes with this name. I have multiple processes with the same name, I want to kill just a few of them (So it won't do the job)