Forum Replies Created
-
Posts
-
Hi Dmitri,
You can down load the Nv Library from this link.http://www.prgms.com/newviews/Export/NV_Export3.zip
Paste in to your internet browser window, and then “Save” the file. Please put it into any directory and unzip it and then from NewViews, import the library (GETLIB) and then run “_Export”.
The purpose of this program is to export all the data from any set of books, and then use an other one of my programs will build this into an MS Access database. A beta of the dB Builder is also available.
The files are exported as Comma Delimited Text. Simply change the ending from “*.txt” to “*.csv” to import them. Excel can also link or import *.txt or *.csv files.
While you may not require it, I have a program that will correctly parse the files for such items that are not acceptable to Excel or Access – such as the single double quote. That alone, really screws up the import. YOU should use the parser, I found it to be necessary for most books.
You can download the Parser program (also beta & free) fromhttp://www.prgms.com/newviews/Export/dbParser3.zip
The parser includes the Nv Library files. The programs are fully tested, but there still may be a bug or two. Please let me know if you have any problems. Thanks.
The export program does not make any changes inside your books and is 100% safe to run. By default, everything is exported to a directory called IMEX.
The NV History is found in the nvREPT.txt files. However you will need to read your users manual to understand how all the columns work to give the Monthly Balances. Column FA0 is the Current Balance (See NV User’s Guide Pg 247)
If you need further assistance, please do not hesitate to contact me here or directly at david@ica.net Feedback would be nice to have, thanks.
Regards
DavidPS – any one else is also welcome to try the programs too.
Post Edited (03-26-05 09:06)
I have a beta program to do exactly that, but not exactly for your purpose. However it will do the same task. It will dump a full set of books (any books) into coma delimited files.
If you are interested, you can have a copy for your NV1. Depending on the size of your books, please remember that Excel can not have a “sheet” size of more than 66,000 items.
Regards
DavidDPustovalov wrote:
> Hi,
>
> I’m trying to dump data from NV1 for uploading to new system.
> Can somebody give me an idea how I can download Notes field and
> G/L history into Excel.
> Thank you.Don’t know about NV2 yet – the folks at QW Page would have to answer that question.
NV1 Directly, generally handles only TEXT or CSV type files. BUT that does not mean a translater / helper program could not be built for it.
What is the internet address to view the spec’s ? (http://www.newpage.com)
David
Of course you know that this is an “Optical Illusion” –
When you use the /DL it freezes the “tabs” to the left side. and the rest scrolls around. Put some text such as “This is a test of window scrolling” on the left side and on the same line put “XX” on the farthest right sides, and then do /DL 1 with the /WLAnd you will see the wrapping effect chop off the left text and move it to the right side. It is simply wrapping the internal Video Buffer.
But we can always use the ‘”games” for fun !!
RegardsHmm, sounds like you backed up the books while they were open?
Rare, but possible !A simple REORG should take care of the “size” problem.
David
Post Edited (02-01-05 19:53)
Ah – since it is a problem in only a “few books” – perhaps the problem books require a reorg?
This is usually the first thing I do when books come from a client, having any strange problems.
David
Like Henry, I have never heard of this problem – happening all the time. So I too am at loss to make a suggestions.
The only question I have is – is your Scroll Lock, on or off ?
David
Well – that certainly is a solution and will continue to be a good solution !
The only difference is that for 50$, nvPRNq lets you print to any printer connected to your computer or network.
Regards
DavidOh, that is not such a simple question. The POS programs were custom made. WE found nothing “off the shelf” that could work correctly.
What I really would suggest, is any POS system you like – and then write an interface that exchanges info between the POS and NewViews.
Additionally – NV is a great program for Accounting, its really not the best program for inventory control details. It is extremely hard to do normal inventory things, such as count items, average price, etc.
Find a POS you like, and then we could write the interface for you.
Hope this helps
RegardsHCassity wrote:
> Thank you for your info. Since you’ve done this, could you share what program you used to “exchange” the required info between New Views and the cash register? Thanks in advance!Ah – you may want to consider using nvPRNq – it will allow you to print with any Windows printer (For NV1)
You can find more info at http://www.prgms.com
David
Then I guess my program nvPRNq will continue to have life in NV2
So that people can print to “anything”.
Regards
For the moment, in testing – NV2 appears to create an XLS file which is then printed using Excel. However any program (such as Quatro) should also be able to do the job.
But the folks at QW Page – should really answer the question for you.
Regards
JWeir wrote:
> Hello all.
>
> Can anyone can clarify the following statement from the NV2 FAQ
> page:
>
> Does this mean that you must own a copy of Excel in order to
> create and run reports (reporting is done through OLE
> Automation) or does it mean that you can use any Excel
> compatible file as a template for a report?
>
> regards,
>
> jeffYes, it is possible and very do-able. I have done it, in the past. AND I would really STRONGLY suggest using a program to “exchange” (import/export) the required information between NewViews and your cash register.
Hi
I would think that everybody who has recently purchased NV1 will get the NV2 – but how far back that will apply – is a question only QW Page can answer.
David
HMah wrote:
> You can currently export nv reports and transactions to excel.
> Set the /PO to a filename rather than LPT1.Ah – not that it doesn’t work, but I don’t think this really solves the “Export” Problem quite the way PDhillon wanted.
I assume he’s really looking for a “custom” method – and really should consider have a program (nv proc) written to suit his needs.
But if he’s inclined to write his own proc’s – then
– EXPSETUP Export report setup in ASCII
– EXPTRANS Export transactions in ASCII
would be good places to start.Regards
David
