Hi Tom, I added some assets to AssetCAT and wanted the XLS export to be converted into csv using DBConvert, however I get an Java related error msg.: "Message: java.lang.ClassCastException: class java.lang.String cannot be cast to class java.time.LocalDate (java.lang.String and java.time.LocalDate are in module java.base of loader 'bootstrap') Level: SEVERE Stack Trace: class java.lang.String cannot be cast to class java.time.LocalDate (java.lang.String and java.time.LocalDate are in module java.base...
Hallo Herzi, Thank you very much for your request and feedback. Before the end of this week, I'll release a new DBConvert version that add these new extended fields to the list of export fields. Best regards, Tom
I use "extended" fields (entities) from vCard specification 3.0 like: categories and user defined fields 1-4. CATEGORIES:INTERNET,IETF,INDUSTRY,INFORMATION TECHNOLOGY X-CUSTOM1;VALUE=TEXT:Verein X-CUSTOM2;VALUE=TEXT:123456 (Knr) X-CUSTOM3;VALUE=TEXT:0987654321 (VNr) X-CUSTOM4;VALUE=TEXT:13579-24680 (GZ) Is it possible to enhance these fields in the list of export fields in DBConvert? A thanks for your work, tomvb62! Your solution is at the moment the best solution I found for converting vCards into...
Dear friends of DBConvert, A lot of things have happed since my last "News from the developer". There have been three new releases, which mainly added more SQL database to export to, namely to MS-Access in the recently released version 8.5; MariaDB and SQL Server in version 8.4 and to Firebird in version 8.3. For the moment I do haver some ideas of what could be changed and improved in future DBConvert releases. No fixed schedule has been set. Since the last two years I've been severely disabled...
Hallo Jan, vielen Dank für die Info. ich habe die Fehlermeldung für die nächsten Release korrigiert. Viele Grüße, Tom
Hallo Jan, DBConvert erfordert mindestens eine JRE 17. JDKs werden nur für die Entwicklung von Java-Programmen benötigt. Wenn sowohl JREs als auch JDKs installiert sind, können Sie die aktuelle Java-Version überprüfen, indem Sie in die Befehlszeile gehen und „java -version“ oder „set java_home“ eingeben. VG, Tom
Hallo Tom, nachdem ich in der Datei-> DBConvert_batch den fehler : Fehler: Beim Laden der Klasse dbconvert.DBConvert ist ein LinkageError aufgetreten java.lang.UnsupportedClassVersionError: dbconvert/DBConvert has been compiled by a more recent version of the Java Runtime (class file version 61.0), this version of the Java Runtime only recognizes class file versions up to 55.0 habe ich JDK 17 installiert das lief dann. Oben nicht JRE sondern auch immer JDK. Schönen Gruß und vielen Dank!!! Jan
Hallo Tom ich bekomme deine DBConvert nicht zum laufen. Nach installation kam fehlermeldung -> JRE 11 installieren Habe dann die neuste JRE installiert -> gleicher fehler Habe dann JRE11 (Verschiedene versionen ausprobiert x86 und 64 sowie unterschiedliche JRE 11.0.12 + JRE 11-0-22) Kein fehler mehr aber das Programm lässt sich nicht öffnen. Windows 10. Sorry das ich fragen muss. Schönen Gruß Jan PS: Dein Donate geht nicht!
Hallo dear friends of DBConvert, A new version of DBConvert will be released in a couple of days. I'm now finalizing the tests on Windows, Mac and Linux. As discussed in my previous post, I'm slowly adding more and more SQL databases as an exported to option. On the list for the next release is PostgreSQL. Since it is an remote access database, it required some major changes in how DBConvert stores and accesses data. Other changes for the new release includes: - appending records to existing Excel...
Hallo dear friends of DBConvert, I just tried to upload version 8.1 of DBConvert but unfortunately the SourceForge server timed out. So, I'll have to try it a bit later. What is new in 8.1, you may ask. Well, I thought it was about time to export to SQL type of databases. This was something that I postponed for quite some time. Version 8.1 will start with SQLite, one of the most common, least complex and most "forgiving" database. Other SQL database are likely to follow at a later stage. Important...
Hello friends of DBConvert, A new version of DBConvert will be released in the first week of September. It will have the following new features: Database paging. This limit the number of records to be read from the database. We can also split our large dataset into chunks ( or pages ) that we can gradually fetch, thus reducing the load on the database. vCard support will be extended to include hCards (Html), jCards (Json) and xCards (xml). iCalendar support will be added for Events, To Do's, Free...
Hello friends of DBConvert, A new version of DBConvert will be released in the first week of September. It will have the following new features: Database paging. This limit the number of records to be read from the database. We can also can split our large dataset into chunks ( or pages ) that we can gradually fetch, thus reducing the load on the database. vCard support will be extended to include hCards (Html), jCards (Json) and xCards (xml). iCalendar support will be added for Events, To Do's,...
Hello friends of DBConvert, A new version of DBConvert will be released in the first week of September. It will have the following new features: Database paging. This limit the number of records to be read from the database. We can also can split our large dataset into chunks ( or pages ) that we can gradually fetch, thus reducing the load on the database. vCard support will been extended to include hCards (Html), jCards (Json) and xCards (xml). iCalendar support will be added for Events, To Do's,...
Hallo friends of DBConvert, Last months have been rather quiet on the DBConvert front. Main reason for that was a personal health issue that left me out of "business" for several months. I'm still recovering from that health scare and slowly picking up life again. FYI: I released a new version of DBConvert today. Nothing spectacular, but just a SQLite driver update (for security reasons) and some bug fixes. Best regards, Tom
Hallo Rob, Sorry to hear that you have problems with exporting your Foxpro file. The correct syntax for exporting files in batch mode can be found in the command file DBConvert_batch.sh Which is: java -jar DBConvert.jar [Profile Name] [Export Type] Where: Profile Name= the name that you used in DBConvert to identify your file export. Export Type = the DBConvert Export file type In the profile you define where your Foxpro file is located, what you want to export from it and to which export file type...
I have a FoxPro claim.dbf I have DBConvert in a directory. I have move the claim.dbf into root dir of DBConvert. I have tried: java -jar DBConvert.jar claim CSV sudo java -jar DBConvert.jar claim CSV I have tried many variations of CSV.... see image of terminal session. Seems to be very straight forward command line. but does not work.
Dear friends of DBConvert, Now that we are nearing the end of the year, it is time to reflect about the things to come. Main goal of 2022 was to add the support of more advanced relational databases and modern file formats. Now that DBConvert supports several modern databases, it is time to focus in 2023 more on usability and stability. First thing that I'm going to add are SQL table joins. DBConvert will recognise foreign key fields in tables and add the fields of the associated table to the list...
Dear friends of DBConvert, Now that we are nearing the end of the year, it is time to reflect about the things to come. Main goal of 2022 was to add the support of more advanced relational databases and modern file formats. Now that DBConvert several modern databases, it is time to focus in 2023 more on usability and stability. First thing that I'm going to add are SQL table joins. DBConvert will recognise foreign key fields in tables and add the fields of the associated table to the list of fields...