jnllnd / csvbuddy Goto Github PK

CSV Buddy helps you make your CSV files ready to be imported by a variety of software. Load/save/export files with various delimiters and lots of options. Freeware.

Home Page: http://code.jeanlalonde.ca/csvbuddy

AutoHotkey 71.42% CSS 0.86% HTML 27.72%

csvbuddy's People

Contributors

Stargazers

Watchers

Forkers

wyrover uella123 standardgalactic

csvbuddy's Issues

In Fixed-width export, auto-detection of max width of each field

Load using HTTP and FTP protocols

Rename button in dialog box when only one row selected

At launch, load file entered in command line parameter

Using detected delimiters, default multiline for safety

Using CSVBuddy in a List View Script generated with AutoHotKey

Hallo!
The CSV Buddy project is for me and what I do, almost a gift from God.
I write in English, German, French and almost in Spanish and Italian.
My first use of the concept of language pairs was in English, German, English.
I built a rules framework for the support process. It is not programmed but rules driven.
It has the concept of workspace management.
My core will be CSV Buddy and its creation of List Views with AutoHotKey.
Who can help with an AutoHotKey script which creates a list view from CSV Buddy?
I am planning to publish the frameworks I have created and will create.
Regards and have a nice week, pmjforkin.

When filter column, enter a filter but hit cancel, cancel not considered if field not empty

If add row and cancel, remove newly added row

In status bar, it size 0 kb, show first decimal

Save using FTP protocol

Give acces to options from a Options button and Gui

intDefaultWidth=16
strTemplateDelimiter=~
strTextEditorExe=notepad.exe
blnSkipHelpReadyToEdit=1
blnSkipConfirmQuit=1

Default filename wien saving/exporting a newly created file

Add default save delimiter/encapsulator in the ini file, overriding the values in the loaded file

From Eric:
Y a-t-il des variables "cachée" à mettre dans le fichier INI pour forcer par défaut le séparateur et l'encapsuleur de "sortie" du 3e onglet (càd avec une valeur indépendante de ce qui est détecté dans le fichier lu dans le 1er onglet) ?

In the listview context menu, add a "Global Filter" command

Add new record in the file loaded

Add keyboard shortcuts help in the HTML help

Notes:

Ctrl-Tab: move from one tab to to another
Tab: move from one control (field, option or button) to another
Atl-[letter]: select the control with the letter underline, for example "[S]elect" (Note: Not all controls have shortcuts)
Enter: equivalent to a click in the selected button

Add multi-column sorting

http://code.jeanlalonde.ca/csvbuddy/comment-page-1/#comment-242

Save load / save / export configurations using the ini file

Add batch search-and-replace at load time

Create .ini file if it does not exists in the program's folder

Import files with equal sign before opening encapsulator to indicate text data or formula not to be interpreted as numeric when re-imported by XL (eg. ...;="12345";...)

From Eric:

j'ai un format de fichier csv qui prévoit en tête de zone un signe 'égal' ( = ) en avant d'un délimiteur classique 'guillement' ( " ) pour indiquer que la zone contient des chiffres à traiter comme du texte.
Du fait de ce caractère supplémentaire en tête de zone, l'application ne considère pas les 2 guillements suivants comme des délimiteurs.

Exemple:
NOM;VILLE;ZIP;TEL;NOMBRE;INFO
MonNom;"MaVille";="12345";="+99-9-99999999";7896;"MonMemo"

en sortie avec tabulation (simulée avec {t})
NOM{t}VILLE{t}ZIP{t}TEL{t}NOMBRE{t}INFO
MonNom{t}MaVille{t}="12345"{t}="+99-9-99999999"{t}7896{t}MonMemo

Est-il possible de prendre ce cas de figure en compte dans le traitement du fichier ?

Update dialog box button names when saving and only one row is selected

Add a example of HTML template

Option to change font of data list

Default load folder to last used folder in previous session

From Raymond
http://code.jeanlalonde.ca/csvbuddy/comment-page-1/#comment-533

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?

Remember and restore the position/size/state of previously field-by-field editor

Allow to create a CSV with the capability to add rows and columns.

See: http://code.jeanlalonde.ca/csvbuddy/#comment-10852

Option to set a default record separator (like "|")

Add sample CSV files to the zip distribution file

Check for an update

In the Column Click menu, add a "Filter" command

Confirm before quitting

Allow running multiple instances of the app

Add interactive search-and-replace with confirmation

Example, to replace "." by "," in numbers.

Option to change font of forms

Left padding with zero in fixed-width export

From Roberto:

Hi Jean, I have a request.
Is possible to padding with zero ("0") and not only with space??

In your example "test-countrycode.csv" I find something like this for export with fixed width: Sort Order,16,Common Name,16,Formal Name,16,Type..............
Is not possible to padding with zero, only for some field? like: Sort Order,(0)16,Common Name,16,Formal Name,(0)16,Type....................
So, only for the field with (0) CSV Buddy put zero instead of space in the fixed width file...

I use your sw for trasform my gps file track from my multicopter rc to working with google earth.

Very good job and save time!!!
Thank you

See this page for details on the tools I'm using: http://ahkscript.org/docs/commands/FileEncoding.htm

A nice feature to have would be to duplicate a row so i dont have to type in the values all over again. Maybe that feature already exists but then i'm not able to see it.