Looking for dBASE IV (old DOS versions) UDL

[PeterJones]

@bofhlusr said in Looking for dBASE IV (old DOS versions) UDL:

I downloaded and installed. I was hoping… to borrow a cliche, ‘it would just work’.

@Lycan-Thrope tried to indicate it was a multi-step by saying “Be warned, though, it apparently downloads as a .zip file, so you’ll have to unzip it somewhere.” – but that’s not exactly what happens.

The first download (at least for me) was a .exe. That installer, as you showed, tries to install into C:\Program Files (x86)\dBASEUDLInstaller . You then have to go into that directory and run the dBASEUDLInstaller.exe that’s in that folder – that is the version that allows you to install the UDL definitions, FunctionList definition, and autocompletion files for dBASE Plus. After restarting Notepad++ after running that second installer, you should have the dBASEPlus and Dark_dBASEPlus entries in the UDL section of the Language menu:

[bofhlusr]

@PeterJones and @Lycan-Thrope Got it working. I was going too fast the first time around and went right past the second .exe which is what threw me off. Thank you both!

P.S. I"m trying to test export and import an Access file to dBASE with about a million records. I am wondering if npp can cope with reformatting the text file for easier import with that record file size.

[PeterJones]

@Lycan-Thrope said in Looking for dBASE IV (old DOS versions) UDL:

I never got through all the documentation for submitting it for the repository

Most is pretty easy – the biggest difficulty is getting the functionList unitTest right. (And making sure that XML and JSON all validate correctly)

I took the files from your installer, and am submitting them to the repo in PR #275

• I did all the busywork for you (creating JSON, etc)
• I renamed the UDL files so they would show up with consistent naming in the UDL list
• I fixed XML errors in the autoCompletion
  • lines 1462, 2745, and 4501 in your version had free text outside of attributes in <Overload> elements
• I fixed XML errors in functionList
  • removed the free-text xmlns and xsi near the start of the <NotepadPlus> element
  • changed \&\& in the commentExpr regex to \x26\x26 so that the regex is compatible with XML (I didn’t want to deal with & looking “weird” in the XML version)

Give it a look-over, and let me know if you’re okay with me merging that PR so that people not in your newsgroups will be able to have easy access, as well.

[Lycan Thrope]

@bofhlusr ,
I use the CSVLint plugin for Notepad++ to work with .csv files to be imported into dBASE. It’s worth looking into. You can do a lot with that plugin. Once it’s the way you need it, you should be able to use the dBASE Append from command to import the data into an empty table setup with the header structure you need.

[Lycan Thrope]

@PeterJones ,
Thanks @PeterJones , that looks like a lot of work. I can’t believe the autocomplete files were working with those mistakes in there. I corrrected the main files in my development directory with those fixes you did.

By the way, the name is wrong. It’s LycanThrope, not LycanThorpe. :-)

Only one thing I see missing is the overrideMap.xml file that I copy into the functionList directory so it can associate the UDL names with the functionList to use…and since you’ve changed the names of the files, those names will have to be changed in the functionList overrideMap.xml file that is used to copy. The exception may be that it has to be pointed out that those changes need to be made to make everything work…if someone doesn’t read the directions on how to do it. :-)

But other than that, I appreciate the work you did. That seemed to be a lot of work that I hadn’t even begun understanding how to do. Thanks.

[bofhlusr]

@Lycan-Thrope said in Looking for dBASE IV (old DOS versions) UDL:

@bofhlusr ,
I use the CSVLint plugin for Notepad++ to work with .csv files to be imported into dBASE. It’s worth looking into. You can do a lot with that plugin. Once it’s the way you need it, you should be able to use the dBASE Append from command to import the data into an empty table setup with the header structure you need.

Thanks. I’ll check out the CSVLint plugin. But first I need to figure out how to export without having to chop up the data in Access due to size limitations for an exported csv file.

[PeterJones]

@Lycan-Thrope ,

Sorry about the name spelling; I will fix have fixed that.

overrideMap does not go into the repo, because it’s something the user has to edit, because we cannot know how many other languages they have already

—

update: the udl-list.md FunctionList section now includes the overrideMap.xml’s <association> element, so users can easily paste it into their overrideMap.xml

[Lycan Thrope]

@bofhlusr ,
This is starting to get off topic now, but…if you can’t save the access database as a .csv without exporting it to a csv format, I’m not sure what you can do. I don’t use Access, but there are users in the newsgroups who have dealt with such subjects, but as I mentioned they are down.

More importantly, you don’t indicate you use a dBASE version that can directly via OLE use Access to do the transferring of data from other Windows apps, which started I believe with the dBASE Plus 2.8 version or so.

[Lycan Thrope]

@PeterJones ,
Thanks again @PeterJones . I understand the overrideMap isn’t usually included, but it seemed easier at the time to just save their original into a backup and use the one I supplied to get them started if they’re not real familiar with how to use NPP to accomplish it.

I’ll have to write a program to insert it into the file with the installer, but at the time, it was just quicker for me to do it this way, since there were many questions about “do what to what?”. So I found including and installing the file, easier.

Thanks again.

[bofhlusr]

Thank you @Lycan-Thrope . Got it all sorted out. I was able to wrestle with the data, exported to a csv file and imported about 2.4m records to another database. The problem was that there were 26 fields in the table and each one had 255 characters (data originated from a mainframe). That’s 6,630 characters. But Access has a limit of only 4000 characters for each record (row).

No problems loading the csv file in npp. Impressive.

[Lycan Thrope]

@bofhlusr ,
Glad that worked out for you. That’s one of the reasons for setting up Notepad++ as an alternate editor for dBASE, because of the built in capabilities of NPP and also the option to use plugins to do other things useful for dBASE programmers.

As an aside, we do have an alternate newsgroup that is run by a fellow programmer that was originally setup when dBASE lost their newsgroups years ago and a patch until things got straightened out at news.dbasetalk.com that may help you with any other info.

I’ll admit most of us have moved on to dBASE Plus, from the old procedural coding, but should you get ready to move over as well, or if some of the older coders are still fluent with version IV that can help, you can try using that address for a newsgroup reader.

If it gives you any trouble, let me know, and I can give you the IP address. They had a little hiccup, as well, a few years ago with the transfer of this user operated newsgroup and we had to go to the IP directly while the ownership was transferred over. I haven’t changed my reference in settings, so am not even sure if it’s been changed yet via the newsgroup domain.

I check in here pretty regularly, so if you have any further questions or need any further info, just let me know.

[James Burke 0]

@bofhlusr Not sure if this helps, but SharkBase can handle up to 4 billion records in any dbf file format. It’s easy to find and setup. Useful for sorting those monster CSV year-end reports.

[Lycan Thrope]

@James-Burke-0 ,
Unless it has the ability to read dbf7 tables, it doesn’t read all dbf formats. Just an FYI.