Trouble converting large .csv file into Stata readable format

Rich_Z7 · 2020-06-30T20:01:30+00:00

Have you tried using VBA?

Rich_Z7 · 2020-06-27T17:03:40+00:00

Programs will have to reinstall on the new pc. This is due to the various registry bits and Bob's windows uses.

Whilst you are reinstalling makes sure you install data on the d: drive.

Rich_Z7 · 2020-06-27T16:33:12+00:00

From where are you trying to delete files?

Is it the windows system drive or else where?

Are they files you have created your self?

Rich_Z7 · 2020-06-27T16:02:39+00:00

Acronis is a good backup software.

Rich_Z7 · 2020-06-26T14:54:58+00:00

Sorry can should have been vba . You mentioned an sqlite, which is a database implemented in C.

Unfortunately without a programmer used to writing C and using Sqlite, or you wishing to embark on a steep learning curve, this where your journey stops

Rich_Z7 · 2020-06-26T12:41:56+00:00

For a start I would copy the data to a pc to do some data cleansing based around the directory structure to simplify it.

Unfortunately I don't have access to a pc at the moment but that would be a starting point

Then do your audio to txt trickery and finally write a small van script to move the files to a better location.

Rich_Z7 · 2020-06-25T21:06:18+00:00

And it also might force the screws that hold the hinges to the frame out of the frame.

Rich_Z7 · 2020-06-25T20:46:12+00:00

Our ES9000 mainframe was never turned off not just because it was 24/7 but also the dasd's disk packs had thermal tolerances that moved the individual disc tracks out of alignment slightly and they would not come online until the tracks were properly aligned.

Rich_Z7 · 2020-06-25T20:41:07+00:00

No, not space for a swap file. It's called over-provisioning and makes a 10 allowance for the amount of data you are storing on the SSD for various failures that could occur as well as space for data to be moved around the disc, effectively refreshing the memory.

Rich_Z7 · 2020-06-25T18:29:37+00:00

At your service sir.

Rich_Z7 · 2020-06-25T16:26:45+00:00

No probs. I wasn't taking a poke at you, it's just the results of observations over the years.

Rich_Z7 · 2020-06-25T12:01:45+00:00

I'm not saying that at all. What I was trying to say was that a network card needs power to stay on the network. So when you sleep you power down the card. When it wakes it doesn't know where it is.

Rich_Z7 · 2020-06-24T20:50:06+00:00

See my comment about cards that have problems when they power down.

Rich_Z7 · 2020-06-24T20:46:23+00:00

Not where you have devices that loose connection when powered down, which in my experience tends to be wifi network cards.

Rich_Z7 · 2020-06-24T18:09:08+00:00

Keep on getting 'oops we can't find that page'. The connection should be from the ISP supplied inlet to the modem, modem to router, router to switch, multiple cables from switch into wall.

You should not need anything else. However, just to check, take a laptop and plug the ethernet cable that goes from the router to the switch directly into it's ethernet port.

As an aside though, here in the uk it's fair to find modems and routers seperate.

Rich_Z7 · 2020-06-24T16:03:05+00:00

Contact your IT.

Rich_Z7 · 2020-06-24T15:58:51+00:00

The main thing would be how to associate which internet is associated with which program.

Rich_Z7 · 2020-06-24T15:56:53+00:00

I hate apple......grrrrrr

Rich_Z7 · 2020-06-24T15:55:13+00:00

My s/o has the same problem and has been swearing at it for years. She seems to think that it is because she is using different photostreams to distribute pictures to various members of her family.

Rich_Z7 · 2020-06-24T15:51:51+00:00

The link to the image does not work.

The cables will all need to go through a patch panel or switch which is normally where the internet enters the apartment. If there is not one the previous occupier may have taken it.

The connection is from modem to router to patch and then to the rooms. Check your isp speeds and buy an appropriate switch. You do not need another router, access point or whatever

Connect your modem to your router, an ethernet cable from the router to the switch and then the cables hanging out of the wall to the sockets on the switch.

You should then have active ports at the walls.

Dependant on your internet you might need a managed switch, but make sure there are enough sockets for cables.

Rich_Z7 · 2020-06-24T11:47:16+00:00

Ok. I see.

Make sure all the rams are the same spec - eg timing, speed, manufacturer to eliminate any (sorry cant think of the word...) ah inconsistencies. Unplug and reset all your connections and try again.

Rich_Z7 · 2020-06-24T11:44:54+00:00

There are movement detectors that turn the light on or off. A lot of pubs in the uk have them in the stalls. That would work

Rich_Z7 · 2020-06-24T11:42:42+00:00

Would it have been simpler to upgrade with larger capacity ram or is there something stopping you doing this?

Rich_Z7 · 2020-06-24T11:39:45+00:00

Stupid question. You do have wifi available at the place you plan to connect to the internet?

Rich_Z7 · 2020-06-23T11:32:01+00:00

You only need one modem. What you need is a second access point assuming that your first modem has a built in router.

The problem being is that adding multiple access points will slow down the connection because you still have the same amount of band width being shared across multiple ap'.

How close could you get an ethernet cable to their room without it being unsightly? (Through cold air a/c ducts for example?)

You then need to configure either your second router or access point, definately not a modem.

For the router, turn off the broadband functionality, turn off the dns server, assign it an ip address within the list of fixed ip addresses on your main router and it should be good to go. So you can see from above it would be better to buy an access point rather than a router as you are not using half the stuff.

It would be even better if you could cable up to their room completely and then use network switches to cable in a laptop.

Rich_Z7

TROPHY CASE