• Jump to Main Content
  • Jump to Footer

My Coding Projects Portable Freeware Applications for Windows

  • Folders Popup
  • My Tunes Covers
  • ObjCSV Library
  • Quick Access Popup (new site)
  • CSV Buddy (new site)
  • Support Freeware

Archives - CSV Buddy

58 Comments on Archives - CSV Buddy

  • Add your comment
  • Comments feed for this post
  1. a55efee5@opayq.com says:
    2013-12-30 at 09:11

    I really like your code and the tool would become very handy if I were able to automatically change in bulk the the decimal separator for a complete file. Now I have csv files with a "." as separator but they should become a ","

    Is this possible?

    Thanks

    Reply
    • Jean Lalonde says:
      2013-12-30 at 09:15

      Yes it is. In the v1.1 that should be released today, I added a search function. A future release could implement search-and-replace that could be done to do what you suggest. I'm taking note of this. Thanks for your comment.

      Reply
      • a55efee5@opayq.com says:
        2014-01-06 at 03:06

        Hi Jean, search is working as it should. For now this is not a solution for my type of files. I'm looking forward to testing your search & replace function. Maybe it is possible to integrate this in the "load" screen? Thanks anyway.

        Reply
        • Jean Lalonde says:
          2014-01-06 at 18:08

          Yes. There would be 2 S&R aproaches: one interactive (where you can confirm each replacement) and one by batch (at load time). I add it to the wish-list https://github.com/JnLlnd/CSVBuddy/issues?state=open

          Thanks for your input again.

          Reply
        • Jean Lalonde says:
          2014-03-07 at 20:58

          Just a note to let you know that the interactive search-and-replace approach (where you can confirm each replacement or click "Replace all") is implemented in v1.2 released today. The batch search-and-replace at load time is for the next version. It will require a little more work on the interface side. But stay tuned!

          Reply
  2. Raymond Clements says:
    2014-01-29 at 15:40

    Hello,
    I just tried out v1.1 of CSV Buddy and wanted to thank you for adding support for multi-line fields. Does CSV Buddy support multi-column sorting? I didn't see any sort arrows (ie. ^ or v type arrows) so I wasn't sure. With multi-column sorting sort arrows are really needed so the user can remember how the columns are sorted. Thanks for all of your hard work maintaining CSV Buddy.

    Reply
    • Jean Lalonde says:
      2014-01-29 at 17:26

      Hello Raymond,

      Thank you for your good words. Multi-line fields was my primary motivation for writing CSV Buddy. I added various features around the primary load/save functions. But I will have to stop somewhere because my goal is not to replace Excel :-)

      This being said, simple sorting and filtering has been implemented. I may improve it in future releases but I could not say what/when at this time. Right now, multi-field sorting can only be achieved by successive sorting. And no arrow will indicate which field was the last one used as sort key. I take note of this suggestion.

      Thanks again.

      Reply
  3. Patrick Forkin says:
    2014-02-03 at 06:04

    Hallo!
    I have just begun to use your CSV Buddy software and have created the first simple csv file to export and want to find out how to input the created file into an AutoHotKey list view.
    What help can you please offer me.?
    I am located in Southern Germany and write in various languages translating into others.
    I have built a concept for the process which I call in English "Framework Support" and in German "Unterstützungsrahmen". I would like to use CSV Buddy as a core element in the process.
    Thank you Patrick Forkin

    Reply
    • Jean Lalonde says:
      2014-02-03 at 06:57

      Bonjour Patrick,

      The core functions of CSV Buddy come from my ObjCSV library (http://code.jeanlalonde.ca/objcsv-library/). This is probably what you need to load a CSV to a listview, save it, etc. See tutorials liks in this discussion http://www.autohotkey.com/board/topic/96618-lib-objcsv-library-v01-library-to-load-and-save-csv-files-tofrom-objects-and-listview/ .

      Reply
  4. Raymond Clements says:
    2014-02-03 at 10:55

    What is the chance that CSV Buddy will include an option to display grid lines in a future version? For those of us that use CSV files that don't always have data in each cell it would make it a LOT easier when scrolling through the columns to follow the same row of data. Thanks for considering this request.

    Reply
    • Jean Lalonde says:
      2014-02-03 at 20:54

      Hello Raymond,

      Chances are excellent. This is a good idea. This will be included in v1.2. An option in the .ini file will allow to turn the grid on or off (what should be the default for this?). The grid's color could be changed but I'll add other options to change the list background and text colors to make the grid stand out.

      Reply
    • Jean Lalonde says:
      2014-03-07 at 21:00

      Hello Raymond. Just a note to let you know that grid lines and background/text colors are implemented in v1.2 released today. They just require you to edit the .ini file. See the help page http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy-doc.html in the "Advanced Topics" section.

      Reply
      • Raymond Clements says:
        2014-03-22 at 13:24

        I just finished trying CSV Buddy v1.2.2 and liked it. At first I couldn't see the grid lines until I changed the default ListBackgroundColor=0D0D0D (grey) to ListBackgroundColor=FFFFFF (white) then they were visible.

        Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file's directory when first opening a file? Thanks for your help.

        Reply
        • Jean Lalonde says:
          2014-03-23 at 22:41

          Hello Raymond,

          Background color "0D0D0D" looks OK on my side. It probably depends on screens specifics.

          > Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file’s directory when first opening a file?

          I prefer to default to the last folder. Good idea. Noted for future release. Thanks again.

          Reply
          • Jean says:
            2016-08-31 at 20:04

            This as been implemented in v1.3.9.1

            Reply
  5. Kyle Borchers says:
    2014-04-24 at 00:17

    I donated. Nice software. I think your software is pretty cool. I like the stability and reliability. I stumbled across it while reviewing the many ways other people have parsed raw data. I was thinking about writing a routine utilizing TF.ahk and CSV.ahk but honestly your program is really good. It would be amaze balls if the program allowed you "Search Column" for "Keyword" and then allowed an option to insert a cell in matched "keyword" cell (i.e. insert a cell to push "keyword" from column b to
    column c.

    Reply
    • Jean Lalonde says:
      2014-04-24 at 11:37

      Thanks for your donation Kyle. Much appreciated.

      Regarding your suggestion, could you give a practical "real life" example of this? Just to help me understand the objective behind this featrure request.

      Reply
  6. Jean Lalonde says:
    2014-08-31 at 22:39

    I just uploaded an update to fix a bug in v1.2 that caused a column with sort indicator to be skipped while saving or exporting. Sorry about that. Please, for safe file saving, update to v1.2.3 here: http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy.zip

    Reply
  7. Gabriel Fantana says:
    2014-10-15 at 18:54

    Very small and effective software! Thank you dev! Maybe a native linux version can be done? (Of course can be used this one with WINE, but would be nice a linux-oriented one).

    Reply
    • Jean Lalonde says:
      2014-10-15 at 19:04

      Thank you for your comment Gabriel. There is no plan for a linux version for my part. But this is open source if a linux dev wants to undertake it.

      Reply
      • Gabriel Fantana says:
        2014-10-15 at 19:36

        Oky, understood! Can your software be localized? I would like to translate it to my native language if possible.

        Reply
        • Jean Lalonde says:
          2014-10-15 at 20:13

          No. It can't at this time. Actually, I work more on my other project Folders Popup (http://code.jeanlalonde.ca/folderspopup/) that is localized in various languages but not in Romanian if whenever you are interested :-)

          Reply
          • Gabriel Fantana says:
            2014-10-15 at 20:39

            I am already using Folders Popup software! Very very nice and practical! 'CVS budy' I need to translate it for a person which doesn't know english so well.

            Reply
            • Jean Lalonde says:
              2014-10-15 at 20:49

              Sorry but I have no plan to implement multi-language in CSVBuddy at this time. If you are familiar with AHK, source is available and all language is in a separate file. You could compile your own version.

              Reply
              • Gabriel Fantana says:
                2014-10-15 at 20:56

                I am not familiar with AHK, but I can learn...Just give me some indications and I'll try...:)

                Reply
                • Jean Lalonde says:
                  2014-10-15 at 21:13

                  There is a tutorial and a beginners section on the AHK language home page. But be prepared for a quite long learning curve.

                  Reply
                  • Gabriel Fantana says:
                    2014-10-15 at 21:28

                    And where I can find source and language files to be able to compile?

                    Reply
                    • Jean Lalonde says:
                      2014-10-15 at 21:49

                      Link is in the Source section above.

            • Jean Lalonde says:
              2014-10-15 at 20:50

              And thanks for you good word about my apps :-)

              Reply
  8. paolo sioli says:
    2014-11-17 at 20:58

    hi guys
    i tried your product, 64 bit version
    i have windows 7 64 bit, and a very big CSV files (about 4gb)
    unfortunately after clic LOAD button, the csv file is NOT imported
    it appears only columns name, but no rows
    can you help me please?
    i need to use your tool to sort my csv file
    thanks

    i'll be happy to donate some money, thanks

    Reply
    • Jean Lalonde says:
      2014-11-17 at 21:16

      Unfortunately, I'm not sure I can help you. CSV Buddy read the whole file in memory before processing it. With the 64-bits version, there is no limitation to file size thanks to virtual RAM. However, there may be a limit in the virtual memory availability and, for sure, loading and saving time could increase to a point where it would not be workable. I did tests with files in the hundreds of megs, but not in the gigs. Maybe someone with knowledge in virtual memory management could help. Or you could look at other tools such as CSVed (but I don't know how they handle very large files).

      See this http://listoffreeware.com/list-of-best-free-csv-editor-software-for-windows/ and this http://alternativeto.net/software/csv-buddy/ . Good luck!

      Reply
  9. roy says:
    2014-11-27 at 06:39

    Bonjour
    Sur votre logiciel CSV Buddy qui est SUPER, ne serait-il pas possible de numéroté les colonnes ?

    Bien cordialement
    Mr Roy Michel

    Reply
    • Jean Lalonde says:
      2014-11-27 at 07:03

      Merci pour vos bon mots. En fait, ce sont plutôt les noms de colonnes qui sont utilisées comme entêtes de colonnes. Vous pourriez utiliser le champ "Rename fields" pour donner des numéros à vos noms de champs. Mais je ne suis pas certain que cela réponde à votre objectif.

      Reply
      • roy says:
        2014-11-28 at 06:23

        Bonjour
        Le renommage des colonnes par "Rename fields" est parfait car j'utilise CSV Buddy pour importer des fichiers CSV dans un logiciel appelé WINDEV.
        Encore BRAVO et merci de votre réponse
        Mr Roy Michel

        Reply
  10. ALAIN ADAMSKI says:
    2015-01-01 at 06:56

    Hi,
    Is it possible to create a CSV file with CSV Buddy?
    Thank you for you program.

    Reply
    • Jean Lalonde says:
      2015-01-01 at 09:19

      Hi Alain,

      No. CSV Buddy's goal is to edit existing files. Would you find it useful to create files in it?

      Jean

      Reply
  11. ALAIN ADAMSKI says:
    2015-01-02 at 14:19

    Hi Jean,
    Of course if possible....
    But it's good like this for me.
    Thank you and Happy new year Jean.

    Reply
    • Jean Lalonde says:
      2015-01-02 at 14:28

      It is possible. I don't know when I'll re-work on this app but I added it to the wish-list, along with the capability to add rows and columns.

      Thank you and Happy New Year to you too.

      Reply
  12. Jason says:
    2015-05-18 at 14:38

    What editor did you use to put together the GUI for CSVBuddy?
    Are you available to modify CSVBuddy for a specific use?

    Thanks

    Reply
    • Jean says:
      2015-05-18 at 15:10

      Hi Jason,

      I'm using a regular code editor (SciTE for AutoHotkey). Unfortunately, I'm not available to custom coding. But, if you wish, you can describe your needs and I will consider it in a future release.

      Reply
  13. Mihai says:
    2015-07-01 at 15:34

    Hello,
    I have dl the app, and when i load a csv and then go to modify some numbers and then try to save what I have modified I can not see a save button. Is there a shortcut or something?

    Thx in advance for you response

    Reply
    • Jean says:
      2015-07-01 at 15:40

      Hi Mihai,

      Use the tabs. You are in tab 1) Load CSV File. Go to tab 2) if you need to work woth fields (rename, move, delete, etc.0) then to tab 3) Save CSV File to save your changes to an export file. There are too many options for a simple save button. This is why CSV Buddy uses tabs.

      Hope this helps.

      Jean

      Reply
    • Jean says:
      2015-07-01 at 16:14

      I received your reply by email. I'll follow up here for other users who could be interested.

      I see from the screenshot you sent me that the issue is related to the "Edit row" form (see regular example here) where you have a very large number of fields. Too large to stand on a single screen. I'm sorry but the CSV buddy edit form cannot support this large number of columns.

      However, it can support it for column manipulation and CSV conversion (using tabs 2, 3 or 4). I would suggest that you edit your file in XL (or any other CSV file editor) and use CSV Buddy if you need to manipulate columns or output format.

      Jean

      Reply
      • Mihai says:
        2015-07-01 at 16:16

        Thx a lot Jean

        Will fallow your suggestion

        Reply
  14. Christian Arnold says:
    2015-09-18 at 04:53

    Hello,
    I like your editor very much. Would it be possible, having an Option handle UTF-8 encoded Files?

    Thank you

    Christian

    Reply
    • Jean says:
      2015-09-18 at 08:45

      Hi Christian,

      CSV Buddy can read and save files in UTF-8. Do you mean an option to read an ANSI file and save it as UTF-8, for example?

      Jean

      Reply
      • Christian Arnold says:
        2015-10-12 at 03:27

        Hi Jean,

        yes, UTF-8-Files are read. But when I change some data using special characters like ÜÖÄ ß the Encoding changes to ANSI when I save the file. Also, when a UTF-8 File includes special characters, they are displayed as ANSI-Characters like ÄÜÖ. A conversion of Encoding, like you described above, would also be very helpfull. It would be perfect for me and my collegues to have Encoding Options ANSI, UTF8 and UTF8 without BOM.

        Thanks

        Chritsian

        Reply
        • Jean says:
          2015-10-15 at 18:18

          Hi Christian,

          Sorry for the delay. If you could send me at ahk@jeanlalonde.ca a sample of your data files, I will look at it. Please send them in a ZIP file to make sure the format is not altered by the email. .

          Thanks,

          Jean

          Reply
      • Jean says:
        2016-08-28 at 20:48

        An update on this request: file encoding is supported since v1.3. Supported encodings: ANSI, UTF-8, UTF-16, UTF-8-RAW,
        UTF-16-RAW or CPnnn (where nnn is a codepage)

        Reply
  15. francois says:
    2016-05-13 at 03:44

    hello,
    is there a solution? i have the same problem with special characters like ÜÖAß they ar displayed as ÄÜÖ. A.
    thanks, francois

    Reply
    • Jean says:
      2016-05-13 at 06:28

      Hi François,

      Your comment reminds me the email exchange I had with Christian following the previous comment. Sorry, this got deep on my to-do list. I should get on this soon.

      Jean

      Reply
  16. Jean says:
    2016-05-15 at 00:59

    I started to work on the file encoding request. I'm looking for beta testers for v1.2.9., Please drop me an email at ahk@jeanlalonde.ca.

    Features:
    - set or detect the file encoding when loading files
    - set the file encoding when saving or exporting files

    Reply
  17. Jean says:
    2016-05-15 at 18:17

    Here is a summary of the changes to v1.2.9 (that will be released as v1.3 after beta tests):

    2016-05-15 v1.2.9 BETA
    - Select file encoding when loading, saving or exporting files
    - Automatic detection of loaded file encoding (this is not possible for files without byte order mark (BOM))
    - Encoding supported: ANSI (default), UTF-8 (Unicode 8-bit), UTF-16 (Unicode 16-bit), UTF-8-RAW (no BOM), UTF-16-RAW (no BOM) or custom codepage CPnnnn
    - Set custom codepage values in CSVBuddy.ini file
    - Other changes:
    - deselect all rows after global search is cancelled
    - add status bar right section to display hint about list menu
    - add help message when right-clicking on column headers
    - remove global search and replace (needing to be reworked)

    Reply
  18. Raymond Clements says:
    2016-05-15 at 20:48

    Hello,
    I just started testing v1.2.9. It looks good so far. Thanks for telling me about it.
    While I have you here, is there any chance multi-line fields could use more than two lines to display their contents (a lot more than two lines if possible based on the window size) in the edit row window? Thanks for considering this request.

    Reply
    • Jean says:
      2016-05-16 at 08:24

      Hi Raymond. Thanks for testing. Suggestion noted. I'll see if I can do include it in v1.3.

      Jean

      Reply
  19. Jean says:
    2016-05-18 at 22:39

    Here is a summary of the changes to v1.2.9.1 (that will be released as v1.3 after beta tests):

    2016-05-18 v1.2.9.1 BETA
    - when editing a record, zoom button to edit long strings in a larger window
    - when there is not enough space on screen to edit all fields in a file, support editing the visible fields without loosing the content of the missing fields

    If you would like to give some help testing this beta release, here is the download link:
    http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy-1_2_9_1-beta.zip

    Please, let me know if everything runs OK or if something needs to be fixed. You can do it by email (ahk@jeanlalonde.ca) or on this page.

    Reply
  20. Raymond Clements says:
    2016-05-23 at 10:08

    v1.2.9.1 beta works great. Thanks for the zoom button. Now I can have up to a full screen if I want it. :-) This is something small, but would it be possible to keep the current sort when reloading the same file? Thanks for considering this request.

    P.S.
    I've tried to send you and email message (with an attachment) to both your @gmail.com and @jeanlalonde.ca addresses and it bounced back both times. Any ideas how I can send it to you? Thanks again for your help.

    Reply
    • Jean says:
      2016-05-23 at 10:55

      Hi Raymond. I will release v1.3 today with current v1.2.9.1 features. I'm taking note of your suggestion about sorting.

      Thanks for your input and help testing.

      PS: I will contact you by email about the email issue.

      Reply

Leave a Reply Cancel reply

Search this site

  • Top
  • Log in
  • RSS Blog RSS feed
  • RSS Comments RSS feed

Author: Jean Lalonde

Powered by the ZenLite Theme