manusjude Posted July 22, 2009 Share Posted July 22, 2009 Hi, i've been given the task to sort out our joblist at work. At the moment it is about 1000 entries all stored in excel. This is not a viable solution so I was hoping to create a joblist with php which would display all the jobs and could be filtered by client, status etc. Also it could be searchable. I am extremely new when it comes to this and was hoping for some suggestions...i am running wamp. any help is totally appreciated. thanks Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/ Share on other sites More sharing options...
Mark Baker Posted July 22, 2009 Share Posted July 22, 2009 Access the data directly from the Excel workbook using PHPExcel Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880395 Share on other sites More sharing options...
manusjude Posted July 22, 2009 Author Share Posted July 22, 2009 Thanks for that but it's still beyond my knowledge. I think I might bow out or is there somewhere I could get a ready made script...sorry for my laziness. thanks Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880441 Share on other sites More sharing options...
Mark Baker Posted July 22, 2009 Share Posted July 22, 2009 Thanks for that but it's still beyond my knowledge. I think I might bow out or is there somewhere I could get a ready made script...sorry for my laziness.PHPExcel is a "ready made" library, a tool that allows you to read Excel workbooks from within a PHP script... a ready-made script would be a lot harder to find, because only you know the way that the information is "structured" within your Excel workbooks; and any script would need to be configured to read that structure. If you can find a joblist script, I could perhaps help migrate the existing data from Excel to whatever database that script might use, but for the moment your question/requirements are very general so I can't advise in any more specific manner Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880462 Share on other sites More sharing options...
manusjude Posted July 22, 2009 Author Share Posted July 22, 2009 I have an excel sheet with 6 columns (fields) and about a thousand records. At the top of the page I would have an add job button which I could fill out the fields and a search box. Ideally I would like an edit button for each record so that I can change the status or paid fields. Also a view button where I could just view current jobs etc. Is this possible? Thanks for your help. Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880483 Share on other sites More sharing options...
Mark Baker Posted July 22, 2009 Share Posted July 22, 2009 I have an excel sheet with 6 columns (fields) and about a thousand records. At the top of the page I would have an add job button which I could fill out the fields and a search box. Ideally I would like an edit button for each record so that I can change the status or paid fields. Also a view button where I could just view current jobs etc. Is this possible? Thanks for your help. PHPExcel can read the 6 columns and 1000 rows. It can also rewrite the data, either modified or new additions. What it can't do is execute an Excel forms as HTML forms, or Excel macros: you'd need to create a PHP script using PHPExcel to read the data from the workbook and display it in an HTML page, with appropriate "add job", "edit job" and "search" forms. You can then use the library to modify existing data in any row, or add new rows before saving it back to Excel. All of that is fairly straightforward Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880499 Share on other sites More sharing options...
manusjude Posted July 22, 2009 Author Share Posted July 22, 2009 Cheers. I'll give it a go. Link to comment https://forums.phpfreaks.com/topic/166986-total-need-help/#findComment-880556 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.