Old 06-12-2015, 05:34 AM   #1
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default Script: HTML exporter

Hi !

I just made a script that analyses all items in the project and output a report in an HTML 5 semantic table.
Currently it check for track, item source path, length, and state (muted, in active or inactive take).

----
Script Release on: ReaScripts: Export Project to HTML and CSV Pack / ExtremRaym
----



It is pretty nice as it is very fast to execute ! (few milliseconds)

This is adaptive, it could work for other type of parameters (position in project, source time position, rate, item end... anything you can imagine), and objects: I make it for items, but can imagine the same thing for regions, tracks or anything. It is just a concept

I build personally for a very specific need, but I guess it can be useful for all people who made sound libraries, mastering, ADR, audio for video, team work, cross softwares exchanges... There is a lot of potential but my question is : Does anyone every feel the need of such functionalities ? What would you need ? Probably everyone would need a custom table so I could integrate it with great spk77 lua checkboxes... I even thought about of version without table but only colored rectangles that would mimic the proportion of the item in the project for items notes export. I don't how how useless/useful it could be ^^
This table is already WAaaaaay overkill for what I wanted !

Note: It works but I don't uploaded it online yet, I am consider making it a "freemium" script or something like that... I don"t know. I like sharing for free but I'm afraid I can't really afford it anymore, at least for the moment. I hope you'll understand.

Anyway, what do you think of that script ?

Cheers !

Last edited by X-Raym; 08-20-2016 at 04:22 AM.
X-Raym is offline   Reply With Quote
Old 06-12-2015, 06:49 AM   #2
heda
Human being with feelings
 
heda's Avatar
 
Join Date: Jun 2012
Location: Spain
Posts: 7,239
Default

Great stuff, this is only the beginning
and very very precise Length in seconds.
heda is offline   Reply With Quote
Old 06-12-2015, 07:58 AM   #3
hopi
Human being with feelings
 
hopi's Avatar
 
Join Date: Oct 2008
Location: Right Hear
Posts: 15,618
Default

you might like to see this:

http://forum.cockos.com/showthread.php?t=162926

In the #2 post by karbo, there is a working dl link for this little .exe file that does a great job of converting an .rrp file to HTML. Well, it IS an .exe so it would not be much help on a Mac. Still it might give you some good ideas for further work on your script.
__________________
...should be fixed for the next build... http://tinyurl.com/cr7o7yl
https://soundcloud.com/hopikiva
hopi is offline   Reply With Quote
Old 06-12-2015, 08:06 AM   #4
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

@Hopi
Thank you so much for the link !

You save me a lot of hard time of work haha, it it already exist well... I may do something else :P

Actually, there is some "new features" that this .exe could not read (such as recently added TagLib support in SWS extensions). (it seems to not having been updated since a while)

With my template, it may be handy to output this kind of new infos.
X-Raym is offline   Reply With Quote
Old 06-12-2015, 08:26 AM   #5
richie43
Human being with feelings
 
Join Date: Dec 2009
Location: Minnesota
Posts: 9,090
Default

Quote:
Originally Posted by X-Raym View Post
@Hopi
Thank you so much for the link !

You save me a lot of hard time of work haha, it it already exist well... I may do something else :P

Actually, there is some "new features" that this .exe could not read (such as recently added TagLib support in SWS extensions). (it seems to not having been updated since a while)

With my template, it may be handy to output this kind of new infos.
(I posted this in the other thread too)
Please do continue developing yours! In all respect to the creators of ReaperDoc, they have stopped development years ago. And for my selfish needs, it does not do what I need it to do, at least not on Windows 8.1.....
I don't know if yours will either, but I can find out...I need something that can extract plugin info from a session. I need fx names, and all settings, and preferably the entire chain order too......
__________________
The Sounds of the Hear and Now.
richie43 is offline   Reply With Quote
Old 06-12-2015, 08:36 AM   #6
hopi
Human being with feelings
 
hopi's Avatar
 
Join Date: Oct 2008
Location: Right Hear
Posts: 15,618
Default

Quote:
Originally Posted by X-Raym View Post
@Hopi
Thank you so much for the link !

You save me a lot of hard time of work haha, it it already exist well... I may do something else :P

Actually, there is some "new features" that this .exe could not read (such as recently added TagLib support in SWS extensions). (it seems to not having been updated since a while)

With my template, it may be handy to output this kind of new infos.
I agree with Richie... you should really keep on with your own development since yours would be usable for both pc and mac...

I only wanted to point out that .exe to you as an example of what other info might be good to include in the HTML and also to suggest a format or look for how it gets shown...

One thing that is nice about that .exe IMHO, is that when you get the HTML it is easy to also 'print' it as a PDF file. Not super critical, but nice to have in an easy to do option.

Again... PLEASE do continue with your script!
__________________
...should be fixed for the next build... http://tinyurl.com/cr7o7yl
https://soundcloud.com/hopikiva
hopi is offline   Reply With Quote
Old 06-12-2015, 11:35 AM   #7
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

@hopie, @richie
Thanks both of you for your support in this project idea.

@richie
Well, be reassured of one thing: your request IS possible.
But it is a bit different from what I started as I currently work with items, and no with tracks, so it would involve a bit of rewriting to transpose it.
FX names, FX chains all that is relatively easy from a code point of view but it takes a lot of times.
Curiosity: what would you need such detailed reports ?

@hopie
It is already responsive and so... print friendly :P

Here is a direct to printer preview from the HTML page:

I anticipated :P
But I'm not sure for the moment how it will behave with more and more columns. maybe print in landscape !

And if you ask, it is almost mobile friendly (but well, it is a table of datas... it take space, it is not really meant for a 400px wide display).

What kind of reports would you like ? items or tracks ? other ?
X-Raym is offline   Reply With Quote
Old 06-12-2015, 11:41 AM   #8
richie43
Human being with feelings
 
Join Date: Dec 2009
Location: Minnesota
Posts: 9,090
Default

Quote:
Originally Posted by X-Raym View Post
@richie
[/B]Well, be reassured of one thing: your request IS possible.
But it is a bit different from what I started as I currently work with items, and no with tracks, so it would involve a bit of rewriting to transpose it.
FX names, FX chains all that is relatively easy from a code point of view but it takes a lot of times.
Curiosity: what would you need such detailed reports ?
I need those details because I need to gather data from many different fx chains that are made in reaper, but the chains need to load correctly on another platform. And fxb/fxp is not an option because this other platform is not a DAW, it is really "pure code" (no actual gui's,just processing audio). You should PM me, the people I am working with may want to "hire" you for this (they are currently being financed from investors, this involves something that is now 2 years in development and hopefully launched by October....)

PM me.
__________________
The Sounds of the Hear and Now.
richie43 is offline   Reply With Quote
Old 06-15-2015, 07:35 AM   #9
heda
Human being with feelings
 
heda's Avatar
 
Join Date: Jun 2012
Location: Spain
Posts: 7,239
Default

@X-Raym
Look what I've found to generate HTML from Lua.
maybe it is worth to look at it.
https://github.com/forflo/h5tk
heda is offline   Reply With Quote
Old 06-15-2015, 08:57 AM   #10
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

@heda
Interesting !

I think about using very similar functions which would have indentation number as argument, but I end up writing all spaces so that the code look like the html output it will give.
I keep your library in mind for more complex stuff.

@all
Here was HTML table export related to item, but of course we can imagine track related export, HTML but not in table and even other databse language such as JSON, SQL, or YML.

we could export any kind of REAPER project data in these format, and with different type of structure (lable, nested list, plain text...).

You can alos import the HTML table in a spreadsheet editor to export the data in another format (CSV for eg...).

I also think about adding TagLib metadatas in the HTML version.

Well, I will not develop all this further unless someone request it for his workflow.
I have highest priority scripts to code for the moment !

But now you know the potential we have
X-Raym is offline   Reply With Quote
Old 06-15-2015, 11:21 AM   #11
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

If anyone knows how to output the file in UTF-8 for Lua REAPER, make a sign :P
X-Raym is offline   Reply With Quote
Old 06-23-2015, 04:35 PM   #12
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

An suggested by richie43, a version with Track Effects Parameters :



I also made a version with item position, duration, end and notes, very useful to send infos to a composer for a film for example !
X-Raym is offline   Reply With Quote
Old 12-18-2015, 06:24 PM   #13
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

So, I digg this script a bit more, and I change the table libraries so now...
Code:
 * v2.0 (2015-12-15)
    + Datatables initialization from CDN (need internet connection)
    + CSV Export
    + Column reorder
    + Toggle column visibility
    + Fixed header and footer
    + Output one file only
    + Restore visibility state
    + Text color in Color columns according to background color
    + UTF-8 character support
Of course, other fields could be added to the export.

Video Demo Here:
[B]ReaScript: REAPER Items to HTML Table to CSV Spreadsheet - Demo 1 - YouTube


Screenshot:



Note: it could also support Tag Libs audio metadatas (Author, Year, Comments genre...) and other fields.

Still a work in progress.

Last edited by X-Raym; 12-18-2015 at 06:30 PM.
X-Raym is offline   Reply With Quote
Old 04-16-2016, 05:20 AM   #14
memyselfandus
Human being with feelings
 
memyselfandus's Avatar
 
Join Date: Oct 2008
Posts: 1,598
Default

This is great!!
memyselfandus is offline   Reply With Quote
Old 06-14-2016, 07:36 AM   #15
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

Hi,

I just released this script as premium scripts,
I also updated the track version of it

Enjoy !
X-Raym is offline   Reply With Quote
Old 08-18-2017, 03:12 AM   #16
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

Updates :

For the item version :
Code:
 * v2.1.5 (2017-06-18)
    # Time format in user config area
 * v2.1.4 (2017-06-18)
    # Take Name and Track Name columns
X-Raym is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 04:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.