ListGen preliminary release

[zander]

Hey I've been experimenting with result.tmp. If you rename the file result.txt you can easily import the data into ms access. The pipes are actually a good thing cause they work well as a value delimiter for any app that wants to import the data. You can leave listgen light and tight. All we really need out of it is SELECT * FROM gamedata. Then once the data is in access we can make whatever queries we want and shape the data how we want,save them and share them. Access has a very nice visual query builder that ms spends much time on. Views equal queries in access and you can save em. So could make all the front end templates in there. Access can also goes well beyond what standard sql can do.

SQL is what I do. The casual user will never want to deal with sql. But access shields them from sql. I have seen time and time again that with a little nudge most casual computer users/no programmers pick up on access very well.

I would suggest that within result.tmp you add the column headers separated by pipes or add an option that turns it on. Many import apps use the first row of data as the column headers.

Access is ignored by most hardcore programmers but it does have it's place. Give it a try.

[screaming]

Access is ignored by most hardcore programmers but it does have it's place. Give it a try.

  ..Are you offering to buy me and everyone else a copy of MS Access 2003? At 7013 members and $229 a pop I hope you have some gold teeth to sell.

SQL is what I do. The casual user will never want to deal with sql. But

  I agree, but with SQL behind ListGen the power is unmatched by any tool out there right now. All ListGen needs is some user-friendlyness (think tiny tim, minus the crutch).

I would suggest that within result.tmp you add the column headers separated by pipes or add an option that turns it on. Many import apps use the first row of data as the column headers.

Insert ".headers on" (without the quotes) at the top of your filter.sql file.

sab

[zander]

Nice one with the headers on I'll give it a try. Any version of access will work all the way back to win 95. It don't cost no where near as much as mame games

[Buddabing]

Hey I've been experimenting with result.tmp. If you rename the file result.txt you can easily import the data into ms access. The pipes are actually a good thing cause they work well as a value delimiter for any app that wants to import the data. You can leave listgen light and tight. All we really need out of it is SELECT * FROM gamedata. Then once the data is in access we can make whatever queries we want and shape the data how we want,save them and share them. Access has a very nice visual query builder that ms spends much time on. Views equal queries in access and you can save em. So could make all the front end templates in there. Access can also goes well beyond what standard sql can do.

SQL is what I do. The casual user will never want to deal with sql. But access shields them from sql. I have seen time and time again that with a little nudge most casual computer users/no programmers pick up on access very well.

I would suggest that within result.tmp you add the column headers separated by pipes or add an option that turns it on. Many import apps use the first row of data as the column headers.

Access is ignored by most hardcore programmers but it does have it's place. Give it a try.

You can do the rename with the latest revision. Just put
"skip_final_step 1" and "output result.txt" in your listgen.ini file.

You guys can create the canned SQL to create game lists if you like. I think the casual user would prefer just to set the frontend name and be done with it. I know I do.

[zander]

i tried the new versions works good for importing data. Except the default config is now strip_description 1. If this is turned on many of the games disapper(3581 rows) turning it to 0 gives a full list (5538 rows) for mame94. For example with strip_description 1 I do not get the original ddragon or it's clones, they all are excluded.

[Buddabing]

i tried the new versions works good for importing data. Except the default config is now strip_description 1. If this is turned on many of the games disapper(3581 rows) turning it to 0 gives a full list (5538 rows) for mame94. For example with strip_description 1 I do not get the original ddragon or it's clones, they all are excluded.

That's what I want, I don't want the duplicates.  My whole purpose behind this program was to have pacman but not a zillion versions of pacman.

If you want the duplicates and clones, use strip_description 0 and use_clones 1 in your listgen.ini.

[evlbeaver]

Any idea when the source might be available?