TheLe
First Post
There is an RPGNOW sales reporting tool available now, which I like to call Unorthodox Sales Report. I wrote it in MS Access and it is now up to version 1.1.
It's free and can be downloaded HERE.
Master Interface:
Sample Report 1:
Sample Report 2:
To use it:
1) run an rpgnow.com sales report, and turn on Output Details as a .CSV file.
Then save those results into a text file (do not copy the header).
2) Go to Access and Select File->Get External Data->Import and select the
text file.
3) Import the data In an Existing Table: -- use the table called Sales
3a) Make sure before you import that it is set for Delimited (comma) and
uses a Text Qualifier ("). First Row Contains Field Names is not needed,
assuming (because I said not to copy the header, remember?).
There you go! Once imported, you can access the reports in the form called _MAIN.
You can rename the database file name all you want, but do not rename the queries or tables.
When I update this product in the future, you can just import the sales table from your old database to the new one (make sure you delete the empty table first!).
And keeping your database up to date is a snap. Just run a new rpgnow.com report for the new time period and import it into sales as outlined above. It should concatonate the data into the table for you.
Sorry, but this is only available in MS Access.
Comments and suggestions are welcome and encouraged. I don't have any "testers" for this app, so I am hoping you all can give me some feedback!
~The Le Games, We Enahance Worlds
It's free and can be downloaded HERE.
Master Interface:
Sample Report 1:
Sample Report 2:
To use it:
1) run an rpgnow.com sales report, and turn on Output Details as a .CSV file.
Then save those results into a text file (do not copy the header).
2) Go to Access and Select File->Get External Data->Import and select the
text file.
3) Import the data In an Existing Table: -- use the table called Sales
3a) Make sure before you import that it is set for Delimited (comma) and
uses a Text Qualifier ("). First Row Contains Field Names is not needed,
assuming (because I said not to copy the header, remember?).
There you go! Once imported, you can access the reports in the form called _MAIN.
You can rename the database file name all you want, but do not rename the queries or tables.
When I update this product in the future, you can just import the sales table from your old database to the new one (make sure you delete the empty table first!).
And keeping your database up to date is a snap. Just run a new rpgnow.com report for the new time period and import it into sales as outlined above. It should concatonate the data into the table for you.
Sorry, but this is only available in MS Access.
Comments and suggestions are welcome and encouraged. I don't have any "testers" for this app, so I am hoping you all can give me some feedback!
~The Le Games, We Enahance Worlds