horst Posted June 9, 2021 Share Posted June 9, 2021 2 hours ago, Norman_12 said: i tried the debug option set it to true, still not working. and even when i uploaded it manually, cant find it module processwire to install it On modules list page you need to REFRESH or rebuild to make it aware of new modules (via FTP). Link to comment Share on other sites More sharing options...
diogo Posted June 9, 2021 Share Posted June 9, 2021 47 minutes ago, Macrura said: That's for ProFields Table, but the OP appears to have this info stored in a Page Table. As far as I'm aware there is no way to export the data in a Page Table without writing a custom script. I'm pretty sure it's the ProFields one ? 6 hours ago, Norman_12 said: i have like one more question if you please, How to export the data stored in my "ProFields: Page Table" field in a CSV file ? Link to comment Share on other sites More sharing options...
Macrura Posted June 9, 2021 Share Posted June 9, 2021 Correct, ProFields Page Table is the one that comes for free with PW. Profields Table is not the same thing. 1 Link to comment Share on other sites More sharing options...
Norman_12 Posted June 10, 2021 Author Share Posted June 10, 2021 First, thank you so much guys for the replies...Such a supporting community. Love it i did upload it to cpanel manually, but still not displayed when i refresh, it somehow confusing Like is there any way to export my stored in my "ProFields: Page Table" field in a CSV file ? Looking forward to hear your thoughts guys Link to comment Share on other sites More sharing options...
Macrura Posted June 10, 2021 Share Posted June 10, 2021 2 hours ago, Norman_12 said: Like is there any way to export my stored in my "ProFields: Page Table" field in a CSV file ? i already replied to that question Link to comment Share on other sites More sharing options...
Norman_12 Posted June 10, 2021 Author Share Posted June 10, 2021 @Macrura as i mentioned before im a newbie to PW platform. is there any way to find an example of " custom script. " i need to write in order the export will work. Looking forward to hear your thoughts and thank you so much. Link to comment Share on other sites More sharing options...
Macrura Posted June 10, 2021 Share Posted June 10, 2021 1 hour ago, Norman_12 said: is there any way to find an example of " custom script. " i need to write in order the export will work. Not that I know of; But this forum has heaps of code examples. Writing an export script would assume a decent knowledge of the PW API, and a certain basic level of PHP. If you are willing to invest some money, then you could simply purchase ListerPro, and then use the ListerPro Page Action: Export pages to CSV file "This action enables you to export all pages matching your ListerPro query to a CSV/spreadsheet compatible file." 1 Link to comment Share on other sites More sharing options...
Macrura Posted June 10, 2021 Share Posted June 10, 2021 You might also want to try Batch Child Editor, which is a free module that has CSV export: https://processwire.com/modules/batch-child-editor/ Link to comment Share on other sites More sharing options...
Norman_12 Posted June 11, 2021 Author Share Posted June 11, 2021 @Macrura Thanks the replies and i apologize for the late reply i did download the Batch Child Edit and installed it too, but it seems like i couldn't work it out despite reading this : https://processwire.com/modules/batch-child-editor/ Link to comment Share on other sites More sharing options...
Norman_12 Posted June 11, 2021 Author Share Posted June 11, 2021 i got some errors when i exported the CSV file i'll share the error and Batch setting Link to comment Share on other sites More sharing options...
diogo Posted June 11, 2021 Share Posted June 11, 2021 In "CSV fields separated with" you must must add the character that you want as the csv separator. That would usually be a comma "," or a semicolon ";" 1 Link to comment Share on other sites More sharing options...
adrian Posted June 11, 2021 Share Posted June 11, 2021 13 minutes ago, diogo said: In "CSV fields separated with" you must must add the character that you want as the csv separator. That would usually be a comma "," or a semicolon ";" BCE comes with a comma in that option by default ? Link to comment Share on other sites More sharing options...
Norman_12 Posted June 11, 2021 Author Share Posted June 11, 2021 @diogo yes i did and worked fine, and thank you. is there any way to customize how CSV file will display, cause everything seems crushing, is there any way to set the width and label names of CSV file ? Link to comment Share on other sites More sharing options...
adrian Posted June 11, 2021 Share Posted June 11, 2021 Just now, Norman_12 said: @diogo yes i did and worked fine, and thank you. is there anyway to customize how CSV file will display, cause everything seems crushing, cause there anyway to set the with and label names of CSV file CSVs don't have widths. You are using Excel to view a CSV. If you want a properly formatted Excel file, it's pretty trivial to write an API script to export a series of pages to an Excel file with something like https://github.com/PHPOffice/PhpSpreadsheet which lets you format the spreadsheet almost however you want. 1 Link to comment Share on other sites More sharing options...
Norman_12 Posted June 11, 2021 Author Share Posted June 11, 2021 @adrian Thanks Adrian i really appreciate your help Link to comment Share on other sites More sharing options...
diogo Posted June 11, 2021 Share Posted June 11, 2021 @adrian I think the problem here might the wrong format importing (the separator precisely) and not the widths themselves. @Norman_12 Your question shows that you don't have an understanding of how a csv file works. Please have a look here https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba. This is not related with Processwire at all. I don't know if you're a new web developer or the owner of the website doing some DIY, and I'm personally fine with any of those, but be aware that we're a bunch of seasoned developers offering you some valuable time, and we'll need to draw a limit somewhere. 1 Link to comment Share on other sites More sharing options...
Norman_12 Posted June 11, 2021 Author Share Posted June 11, 2021 Thanks @diogo And thank you guys all for the helpful replies Link to comment Share on other sites More sharing options...
adrian Posted June 11, 2021 Share Posted June 11, 2021 2 hours ago, diogo said: @adrian I think the problem here might the wrong format importing (the separator precisely) and not the widths themselves. Ah sorry, the way I read things, I thought he had already fixed the separator issue and still didn't like the column widths. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now