partkeepr / PartKeepr

Open Source Inventory Management
http://www.partkeepr.org
GNU General Public License v3.0
1.38k stars 400 forks source link

Feature request: console/scripted export #946

Closed mindsolve closed 4 years ago

mindsolve commented 6 years ago

System Information

Situation

I would like to publish a list of my parts on my website, but without manual interaction and without giving strangers access to my PartKeepr instance.

As I understood the situation, currently export only works by logging in and manually exporting.

Idea

Maybe add a php command-line-script that allows exporting directly to file/stdout. (So that it is script-usable)

Thanks, MindSolve

Gasman2014 commented 6 years ago

Why not simply access the SQL database directly - it is fairly standard to do this with PHP and SQL queries - the web server and the SQL database don't even need to be on the same machine.

mindsolve commented 6 years ago

To be honest: This idea did not even come to my mind, thank you very much for this idea! I did not know that the database format was that easy to parse 👍 👍

Optional question: Do you think somebody else would like some kind of simple command-line-export-tool? Should I publish it after writing? If yes, just simple, plain PHP?

X3msnake commented 6 years ago

If you have that need it will surely be usefull to someone else. Php is good you can automate it with a cron if you need it

No dia segunda-feira, 29 de janeiro de 2018, Felix E. < notifications@github.com> escreveu:

To be honest: This idea did not even come to my mind, thank you very much for this idea! I did not know that the database format was that easy to parse 👍 👍

Optional question: Do you think somebody else would like some kind of simple command-line-export-tool? Should I publish it after writing? If yes, just simple, plain PHP?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/partkeepr/PartKeepr/issues/946#issuecomment-361423030, or mute the thread https://github.com/notifications/unsubscribe-auth/AKke-nNs9FzPCH8IqprCYlMCrz5SKEswks5tPlQLgaJpZM4RvzBf .

-- Com os melhores cumprimentos, Vinicius Silva

christianlupus commented 4 years ago

@mindsolve Did you succeed in writing you little helper script? If you are willing to share, we can add it to the wiki. Otherwise, I will close this issue for now. Feel free to answer nevertheless.

mindsolve commented 4 years ago

Hey @christianlupus , while I did indeed begin to write such a script some time ago, I did not finish it, and the code quality (of the bits I wrote) are way below "hackish".

I do indeed plan on writing a new script for that purpose, but that may take a while. I will be happy to then add it to the wiki. As such, I am closing this issue now.

christianlupus commented 4 years ago

You are welcome. In case need arises, return back and ask your questions.