Making a UI with Processwire

[lokendra]

Hi, i am new to Processwire.

I want to make an user interface using Processwire. So, please let me know, if it is possible!

Requirements are like this : -

1. Login System according to the user type i.e for different user, there should be a different login system.

2. According to the user type, their view page should be different

3. Importing and exporting the excel file(xls, xlsm, xlsx) 

4. Editing the excel file on the user interface (I have seen on the forum, Kongondo has integrate the handsontable with the processwire, so please let me know how he did that).

The 3rd and 4th requirement are important.

Thanks and Regards

Lokender Singh Shekhawat

[mr-fan]

please take a look at lister pro module - this has import/export features build in and for the different views per user it can be adapted with a hook.

https://processwire.com/api/modules/lister-pro/

regards mr-fan

[lokendra]

thanks mr fan. i will surely look at this and will inform you, whether it works or not

[lokendra]

hey, mr fan, i think it's not free

any other solution!!

[bernhard]

hey, mr fan, i think it's not free

any other solution!!

hi lokendra, welcome to the forum!

[offtopic]

two totally free things:

1) coding your own solution

2) asking politely (maybe ? instead of !! )

[/offtopic]

besides that: thanks for bringing my attention to handsontable https://processwire.com/talk/topic/4147-excel-like-crud-in-pw-using-handsontable/

regarding your other questions: it totally depends on your skills. PW is in general not the click-click-and-ready thing. login-systems have been discussed several times, please search the forum https://processwire.com/talk/topic/6196-easy-search-on-pw-forums-with-google/ and go more into detail with your questions - i'm sure there are lots of skilled people here that are willing to help you.

and listerpro was definitely a good recommendation. it's 40$ and imho totally worth the price (there are also discussions about pricing of the pro modules)

good luck with your project

[mr-fan]

39 bugs....come on your kidding me.

You're using a free CMS/CMF wanna some important Requirements and don't want to spend little money on it....

like BernhardB wrote code it yourself or bring in some work to contribute and/or as an exchange get help from some experienced coder.

I'm not a pro so i'm dependent on help sometimes, too.....but i always do it in the same order

search->ask->decide (buy or search for a programmer to give a helping hand)->contribute first (testing, translating, co-working)->get help->search.....

This order should not be the only right way (that don't exist) and maybe we misinterpret your post (may some wrong insistence in the !! and the short words).

So sort up your requirements and think what this end result of software should do for you/or your client and at least what is this achievement of your UI Interface build with PW worth for you and/or your client....and then decide what is to do.

For shure there are other options but none is fitting your requirements like Lister Pro - so i thought to adapt any other free available solution to your needs whould cost more than 39$....but this depends on your hourly rate.

best regards mr-fan

[lokendra]

hello Mr-fan and BernhardB, 

                Sorry, if i make you fell angry, that was not my intention.

Well, i was just asking for advice, will it be possible with processwire to meet my project's requirement(specially 3rd and 4th one). 

and sorry for my bad english(as it's not my native language)

and yes, i will share my code with you guys, once i will start my project work using processwire.

By the way, i am doing this project for my academic purpose.

Best regards

Lokender Singh Shekhawat

[bernhard]

hi lokendra,

sorry that we misunderstood you.

to your questions:

1) http://lmgtfy.com/?q=site%3Aprocesswire.com+login

3) http://lmgtfy.com/?q=site%3Aprocesswire.com+excel+import+export

4) maybe ask directly in the corresponding thread? https://processwire.com/talk/topic/4147-excel-like-crud-in-pw-using-handsontable/

listerpro would also be a possibility for editing things on the fly: https://processwire.com/blog/posts/inline-ajax-page-editing-comes-to-listerpro-processwire-2.6.6/

i'm sorry i have no better answeres for you. maybe others have - but your questions are a bit like "hey, how can i build a car?"

is it possible with processwire? YES

but as i said... there will probably not be a click-click-and-ready solution

[mr-fan]

There is never ever sorry for bad english (this hurt's none since this is no forum about english study)

but less information is always a trigger for misunderstanding....

more source for inport/export could be the batchChildEditor module:

https://processwire.com/talk/topic/6102-batch-child-editor/

it provides an option for import export childpages as csv data.

But like BernhardB mentioned, too - more information == more help.

Best regards mr-fan

[renobird]

Hi lokendra,

ListerPro is a good option, but if the cost is an issue, there are certainly ways to accomplish all your requirements for free. As others have mentioned, probably nothing that is a "turn-key" solution. 

1. Login System according to the user type i.e for different user, there should be a different login system.

Check out the custom login topic. I'm not entirely sure what you mean by different logins, if you just want to style them differently, that is fairly simple. Can you describe what you mean a little more? 

2. According to the user type, their view page should be different

This is possible using a small hook before ProcessHome::execute. Are you talking about a custom "Dashboard" page?

You can probably modify Pete's Dashboard module to display specific information based on the users role (read: type).

3. Importing and exporting the excel file(xls, xlsm, xlsx) 

Are you talking about importing/exporting pages to excel? Adding Excel files to a page is simple with a files field, I assume you have a larger requirement. Can you explain a little further what you need to accomplish with these import/exports?

4. Editing the excel file on the user interface (I have seen on the forum, Kongondo has integrate the handsontable with the processwire, so please let me know how he did that)

I would check in with Kongondo about his module. There is also the Fieldtype JSON module by Martijn that might be worth a look

[Martijn Geerts]

Would like to mention that fieldtypeJson is build before the awesome profields and all data is in one blob of json. I wouldn't trust the json field for important data because javascript is the middle man here and potential data los can happen.

[lokendra]

hey, thanks everyone for giving responses. I will follow all of your advises and will inform you whether it works or not.

So, here is the full detail of my project : -

As there are different stakeholders who are functioning independently, so it is important to provide them different login credential according to their department. Also the view or display page has been different for different stakeholders.

The format for entering the data should be in accordance with the users i.e. it should be customizable. Similarly, if user wants to publish his data, then there should be an option of selection for publishing the data.

Log information of user  should be updated & stored in database automatically and there should be an option for user to view this log information.

Multiple search option will be there for user, so that they can search according to their requirement. In search engine, there will be an option for test name, operator, project’s life cycle and etc.

 

 

So, i am going to start implementing my project with the help of processwire and will update all of you time to time.

 

The only difficulty, i am facing in this project is to editing the excel file on the UI interface because generally the extension of the file is xlsm. 

 I am using PHP right now to implement this. 

[mr-fan]

additional option could be the matrix module from kongondo:

https://processwire.com/talk/topic/8581-module-matrix-fieldtype-inputfield/

and fill it with some kind of excel php lib....

or build a own module from this lib that i think would fit your needs:

http://dhtmlx.com/docs/products/dhtmlxSpreadsheet/

(it has a GPL license for GPL projects)

regards mr-fan