Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. corporatepunkrocker

    excel data coversion

    Moonie, Unfortunately, the .col method for importing data is outside of my experience. My recommendation is that you define the delimiter most likely ";" or "," if the file is a comma separated values file. Then you will need to use instring and mid commands in order to...
  2. corporatepunkrocker

    excel data coversion

    Moonie, Never apologize for asking questions. It's always better to have an open mind to different points of view and to feel free to ask questions in order to learn from other people's experiences. That in my mind, is the true purpose of this forum. That having been said... It might be...
  3. corporatepunkrocker

    excel data coversion

    Moonie, I understand that there is an existing export agent which creates a csv file. My point was that this file would be more easily imported if it were first converted to a text file. Microsoft Excel will enable you to open csv files and save them as straight text. However, if you need to...
  4. corporatepunkrocker

    excel data coversion

    Moonie, Just a suggestion but I've always had better luck importing data from fixed-field length formatted text files, rather than Excel files. I would recommend structuring your data and then converting your Excel file to a straight text file. From there, you could write a LotusScript...
  5. corporatepunkrocker

    Monthly Reporting

    LuckieIrie, Depending on how your data is formatted, you have several options. First, you will need to determine if the documents being captured in the current view have date-formatted fields which can be referenced easily in view selection formulas. For instance, if you have a date formatted...
  6. corporatepunkrocker

    Database Launch Option

    muralibmk, Notes has two default options available for presenting the &quot;About Database&quot; document when a database is launched. Unfortunately, these two options will only display the About document under one or two specific conditions. <b>1. Show &quot;about database&quot; document...
  7. corporatepunkrocker

    What does is mean? A error message.

    It sounds like you are attempting to delete a document which is either currently open or being viewed. Depending on your role in the organization, I would recommend asking your local Notes administrator for assistance in resolving this issue. It sounds like a bug in the...
  8. corporatepunkrocker

    replication problem thru ISP

    I have a couple of recommendations which you may have already implemented, but may be worthy of mention: 1. Index your local database's views. Lengthy replications are often the product of unindexed views. Invoke the database-referesh view indexes command by using the keystroke combination...
  9. corporatepunkrocker

    copy document from one database to another one, using pickist

    Hey the_egyptian: I'm not certain if the syntax would carry over from R4 to R5. However, I'm pretty sure the following logic would be consistent. If you can get a handle to a document using the @Picklist function, then you should be able to set an environment variable to grab the...
  10. corporatepunkrocker

    Variable Not Declared: WS

    &quot;Beaker600&quot; WS is often used as an abbreviation for Workspace when assigning names to variables in LotusScript. It's possible that the WS reference is either not accessible to your specific username, or that this is a larger-scale issue happening on the server side. I would...
  11. corporatepunkrocker

    developing lotus notes database using version 4.6

    Judy, I just read your post, and thought of a short checklist of tips to ease implementation of your database. 1. The database resides on a network, which is accessible by the intended user group. 2. You have a form/forms in the database which can store attachments. These should be...

Part and Inventory Search

Back
Top