Total beginner need help with FileUpload and CSV CRUD

[ThomasL]

First I want to say HI! to all of you as an new member of the Forum and the total beginner in term of WEB programming
I have a programming experience (ostly Windows programming) but WEB is just something different !

So, I have to make a small "app" for my company - select CSV file using FormWizard > FileUpload and then show selected file via CSV CRUD.

Sounds easy, right ?
For me it's a nightmare

Pablo was very helpful and show me the right direction, but my problem is following:

1. How can I change SUBMIT button behaviour - instead of SAVING file, i want OPEN file
2. CSV CRUD have option Filename: and then I can nter file name or variable.

But which variable or value I have to enter that CSV CRUD show selected file ?

CSV Crud works perfect with predefinied filenames, but with variable, I don't have idea...
I try a lot of variations, but there is always an error.
And now I just don't know how solve this mistery...

Any help or link for similar topic will be more then welcome

Here is the link for project file if needed:

https://drive.google.com/file/d/1_zD2LI ... sp=sharing

Thanks in advance!

Cheers!

[Pablo]

1. How can I change SUBMIT button behaviour - instead of SAVING file, i want OPEN file

There is not standard option to open the file after uploading it, this is very specific behavior so this will require a custom script.

2. CSV CRUD have option Filename: and then I can nter file name or variable.

The filename is a hardcoded value, so even if you were able to get the name of the file after upload it, it cannot be use

These tools where not webdesign to be used this way.

But maybe this will work?

This will only work if the file name is always the same.
a) upload the file to a folder on the server.
b) redirect the user to the page with CSV crud
c) use CSV crud to edit the file

But what exactly is the use of this? It sounds complicated. Can't the user just update it before uploading the file?

[ThomasL]

Hi Pablo,

Thank You very much for Your quick and informative answer

I will try to explain as simply as possible what the purpose is:

Just me, my boss and my super user have access to original CSV files - everyone else sees the finished edited files.

Have a list of CSV files and, depending on privileges, edit or add new record or just view and/or print, and using a file selector to select available CSV file from server look very "pro"

Of course I can make this on the easiest way possible and just create a menu / buttons to call hard-coded name of CSV file using CSV CRUD.
This actually work like a charm and I think i will follow this path - sometimes the simplest solution is the best solution:-)

Now you can ask why not use database instead (MySQL / SQLite etc) ?

Well, this CSV files are some of my company "public property" , mainly price lists, component lists, etc. with limited size - and all employees have to have access to this files - mostly to view and print, and admin (me) and another employee have rights to modify files.

The values ​​in these CSV files are changed once a month or less often - so mostly static files without much need for administration.
Also my boss (who is also a owner) want to have a option to download CSV files without me dumping/exporting table(s) from database(s).

So, yeah, I think I proceed with easiest possible solution

Once again, thank You very much for Your answer and effort, really apprecite it '!

And...I LIKE Web builder - so powerful, easy to understand and fast to implement all possible scenarios
Help file is very good, Forum is full of useful informations, YT also have a LOT videos which is very useful for me as beginner in WEB development

Have a nice day and cheers!

[onlye]

fyi - there is a standard extension, Bootstrap File Listing, to display the files in a folder. if you upload the csv files to the same folder this extension would allow users to view and select/click on a file to open it.

I use the File Listing, CRUD, DataTables (there are several table extensions that support csv) on several sites - very powerful without programming

[ThomasL]

Hello onlye, thanks for Your answer and tip
Can you share code or procedure or example how to do it, sounds yummy

With best regards,
Thomas

Cheers!

[BaconFries]

Can you share code or procedure or example how to do it, sounds yummy

@ThomasL The code cannot be shared as the mentioned by onlye due to the code belongs to "Paid" extensions which would violate there use. If you require the likes of this I would suggest taking a look at the following to possibly purchasing.
See
https://www.wysiwygwebbuilder.com/promotions.html

[ThomasL]

Oh, I know, I bought WWB package with all paid and free extensions via nice offer from WWB web site, so , yeah, it was a good deal
If any have a doubt or worries I'm more then happy to show proof of purchase

Anyway, I understand, no worries

Cheers!

[BaconFries]

If any have a doubt or worries I'm more then happy to show proof of purchase

No there is no need to do that Pablo himself will have all the details of your purchase.

[onlye]

Hello onlye, thanks for Your answer and tip
Can you share code or procedure or example how to do it, sounds yummy

really no code to share. just install the extension. drag it onto a layout grid and double click the entension to open the options. pretty simple. you can also add a file upload into the same layout grid. then you can see what files are in the folder and upload new or replacment files as needed.

you can do some really powerful stuff with the extensions Pablo provides without having to write any code.

here is a page where we use the file listing extension to display the election results. the customer just uploads each pdf to the folder and visitors can view the result by file name. below the file listing we show all the precints locations that link to the result. the links just go to the specific file in the folder. the files are uploaded by the customer using the file upload extension on a private password protected page.

before a new election we delete all the files from the folder and uplodad as the new results are available.

https://www.monroems.com/circuitclerk/results.php

[ThomasL]

Hi onlye,

Thank You for Your response

Seems like I'm total idiot so I need some extra explanations

1. ...just install the extension

You mean Bootstrap File Listing, right ?
If yes, I did it, set up paths and extensions from Properties for this extension

Path = ./
Files extension = csv

2....drag it onto a layout grid and double click the entension to open the options

This part I don't understand
Drag it into layout - what ?
And which layout ?
File from Bootstrap File listing after publish files ?
When I do this I have a those small icon - drag&drop is not allowing...
If I double click on file, download begin...

Or I have to make in WWB ?

Probably everything is so simple but I'm obviously too stupid to get it...
I'm working really hard to figure all this stuff, some elements are easy, some so-so, but some things are just above MY logic...
Maybe I need to do a hard reset of my brain
Or need more time and experience....

Also, what is your second extension - Data Tables, Bootstrap Table or something else....
Bootstrap CRUD works only with MySQL, CSV CRUD works only if you know EXACTLY how many columns have CSV file (indexing)...

So, any help for stupid me will be more than helpful

Thank You in advance

Cheers!