Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Programming

52K

Solutions

40K

Contributors

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have to open csv file after creating from Powerbuilder.
Upon creating csv file , I have to open csv file as excel file automatically.

So I think it is better to use command prompt.
How could I open csv file as excel by using command prompt?
0
Free Tool: Site Down Detector
LVL 11
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi,

Can someone please give me a link to a book on KCML Kerridge C Macro Language (KCML) and any info on how to develop in it please.

Started working for a company that uses it - thanks!
0
I'm contemplating the design of classes, playing with a simple hypothetical design, and wondering if there's some general principle of good design this violates, and if there's a better way.

Say I have a class of Messages. Each message is a string. The Messages class holds a list of all the message strings.

I want to send these messages to their destination. Say, write them to a file. So I have a MessageSender class which does the job.

Class Diagram

using System;
using System.Collections.Generic;
using System.IO;

namespace TestMessages
{
    class Program
    {
        static void Main(string[] args)
        {
            var messages = new Messages();
            var messageSender = new MessageSender();
            messageSender.SendMessages();
        }
    }

    public class Messages
    {
        public static List<string> myMessages;
        public Messages()
        {
            myMessages = new List<String>(new string[] { "one", "two", "three" });
        }
    }

    class MessageSender
    {
        public void SendMessages()
        {
            using (StreamWriter writer = new StreamWriter("myFile.txt"))
            {
                foreach (string s in Messages.myMessages)
                {
                    writer.WriteLine(s);
                }
            }
        }
    }

}

Open in new window

This all works. But I see problems.

First there's the obvious static List in the Messages class, which makes it global and easily accessible, and abusable.

And the Messages class is just data with no behavior.

Second, I see MessageSender reaching in to class Messages and extracting the data. This is the one I'm not sure if it violates encapsulation, or some other good design principle.

I can make the MyMessages list not static:

Class Diagram

Open in new window

0
There are a few custom object types in our database.  This is a new area for me.
Is there anything a DBA should be aware of when these are trickled throughout the database?

Thanks for feedback! Theresa
0
Hi everyone, I have a question, If I have a database (Column for Date_Expiration) how can I use this in VB.net to warn me if the item is reached its expiration date?

OR

How to set this in Stores Procedure in SQL?

Thanks in advance.

Sample
0
have this solution working as needed
then need an clean button to
change faster data as need
29076029__L_a.xlsm
0
I understand Perl is part of my Mac OS, but I hear I would be best served to ensure any programming (learning) in Perl should be isolated so as not to upset the functioning of my El Capitan system.

What kind of installation shall I make to ensure the Perl I access from Mac Terminal does not touch any system files?

Thanks.
0
have data in columns  from column like this
111222.PNG
then need an button to hide
columns
111222AAA.png

the sequence will continues all over the worksheet
Ad_76984--1-.xlsm
0
have data in rows   then  need an button to hide rows 16 to 300  

the button must hide and unhide the rows as needed

button must in this area
11223.PNG76984.xlsx
0
I am trying hard to find a way to automate some calculations on a credit card merchant statement. But I must be 100% within the letter and the intent of the rules which define PCI compliance.

Writing a Java app to run on all platforms was a great suggestion to "pre-process" the data, redacting private data, before upload to my site for further processing. But, I wonder, why not do ALL the processing via a downloadable Java App?

Is that a guarantee that I am 100% PCI compliant?

The problem will be when it fails a user and they need it debugged...I would need that PDF file sent to me for debugging. BUT, isn't that a much safer route to take than putting it on a website?

I would certainly have a high security bar to maintain regarding how I handle my PC, and maybe the methodology I use when choosing a password for that email account. But NOT having a website where any Credit Card info resides seems like a smarter way to go.

So, I am now imaging a simple website, probably WordPress. I would post a current version of the Java App for download and explanation of what it does, etc.

Users could download it and privately process their merchant account report on their own PC's. In the LIKELY event they have an unsupported report format, they could email me their full report. (Redacting private data from a PDF itself seems like a pretty high bar for users to handle)

On receipt of the PDF, I would redact all private data for that statement, and delete all un-redacted…
0
Receive 1:1 tech help
LVL 11
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

I have no experience with Perl and suspect it may be the best choice of technology for a financial analysis and reporting website I am making. I expect to allow users to upload PDF's or CSV files to my website, which my site will then parse, summarize and generate new reports.

There will be times when my logic needs to access published national standards tables for a specific record with names like:

CPS Retail 2 Max (Developing Markets only)
CPS Retail Key Entered

from a list of thousands of items

So, this is the reason I suspect Perl is a good choice.

Can someone please confirm that and show me why Perl is so good for pattern matching?

Is it a front end or a back end technology? What other technologies often work well with Perl? It is compiled? Or is it a script?



Thanks.
0
I need a tool I can use to digitize a report, like the one attached here...

Report
Will this kind of report get a 100% successful conversion rate?

Eventually, I need the tool to be part of my website, but I have not, as yet, chosen my back-end technology. For now, a simple Mac based tool is fine, just so I can hand convert a report that I can start to use in my programming of the back-end.

Windows is okay, if there are limited Mac FREE versions.

I do have Office 365 (Mac) if there is a tool in there which I can use.

I am also interested in hearing what "plug-ins" can work when I deploy this to my website, for online OCR conversions.
0
Hello,
I have a code which works
    objShape = ppPrsn.Slides(1).Shapes.AddPicture("Selectel.png", False, True, 0, 0, 300, 500)

Open in new window


Need to change the path to bitmap image. As the image is extracted from database in vb.net
So,do not have a filepath.

Thanks
0
I have an Excel spreadsheet , a sample of it is shown below.

Screen-Shot-2017-12-20-at-7.29.55-PM.png
I would like to have each EmpID in a separate worksheet that will display
Date by older date on top row
EmpID
Cost

I do not need it to display Daily .. I need just Week End

that would be perfect if I can have a Chart (Histogram) added on each worksheet of the EmpID, based on Cost for each Date (older date first on the left).
it will display how the cost of each EmpID has fluctuated from 01/2017 going forward to more recent day.

I wonder if there is a script that can accomplish this ?

Thank you very much
0
Hi Experts i am trying to search for data in a sql 2000 data
using select * from table_name where Column_name = "Null";

but the command not work
Please help
12
0
I can upload a into RStudio server using shiny.  However, I cannot open the file for editing and saving for processing by the R code.  Apparently, the randsontable library function ransdontable() takes as input a dataframe.  I am using the code below: DF = as.data.frame(read.delim(inFile$datapath))
    rhandsontable(DF, width = 550, height = 300)

but I get the message:

Warning: Error in as.data.frame.default: cannot coerce class "c("rhandsontable", "htmlwidget")" to a data.frame

Is there a solution for this, or is there any other way to open and edit file using shiny?

EDIT:
My code was completely wrong. If anyone wants to find more about the R rhandsontable, please post a question. I will be happy to help.
0
Can anyone think of a good reason to declare variables as objects instead of the appropriate variable type in VB6?

I'm experimenting with converting a VB6 app to .NET (2008 for now, then, if it works, 2017) and looking over the code, the original dev declared everything as objects.  Dim intLoop1 As Object (why not integer?)  Is there (could there be) a good reason for this or was he being lazy as my gut tells me?)

Thanks!
0
Hi,

Below part of some VB.Net code is shown. It is used to interface data to an online application via SOAP.
The full code can be downloaded here
First some info: Code from de WDSL:
    function CreateStamTabelRecord(const PartnerKey: string; const Omgevingscode: string; const SessionId: string; const Stamtabel: Stamtabel; var Primarykey: string; var Foutmelding: string): Boolean; stdcall;

Open in new window

  Stamtabel = class(TRemotable)
  private
    Fschema: TXMLData;
  public
    destructor Destroy; override;
  published
    property schema: TXMLData  Index (IS_REF) read Fschema write Fschema;
  end;

Open in new window


Can anybody translate the following VB-code to Delphi?
The content of ds_mutatie is important to be correct. How should this be created within Delphi?
Private Sub btnCreateNewDeb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateNewDeb.Click
        If String.IsNullOrEmpty(txtSessionId.Text) Then MsgBox("SessionId is leeg.") : Exit Sub

        Select Case combometh.SelectedItem
            Case "SOAP"
                Dim ws1 As New ws1.ws1
                Dim foutmelding As String = ""
                Dim ds_records As New DataSet

                Dim ds_mutatie As New DataSet
                Dim dt_selection As DataTable = ds_mutatie.Tables.Add : dt_selection.TableName = "METADATA"
                dt_selection.Columns.Add("TABLE", 

Open in new window

0
Hi,
There is a web application where the client side may perform some operations on an entity called process.
So i made an Enum {process_start, process_edit, process_delete, process_complete}

And on each event i send a message to a particular user.

so i have a function like
sendNofication(userId, event) {

switch(event) {
    case process_start :
   case process_delete:
}


What are the pros and cons of this approach and an alternatives ?
I can think of one
instead of having various switch case statements
I can have functions corresponding to each event like :

notifyOnProcessStart();
notifyOnProcessDelete();
Which is the better appraoch.
Any pros and cons one can see...

Thanks
0
Free Tool: Subnet Calculator
LVL 11
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi
I am nearly ready to begin my foray into games in Python. However, is it more advisable to incorporate a JFrame for the game Window? Is Python GUI up to speed?

Thanks
0
I was given a 2013 excel spreadsheet with different kinds of equipment listed. I would like to create different work sheets in the same work book to separate the different types of equipment. I have three different types of equipment. Is there a way to select certain rows and move them to different worksheets without doing it manually?
0
IDENTIFICATION DIVISION.
PROGRAM-ID. HELLO-WORLD.
DATA DIVISION.
WORKING-STORAGE SECTION.
77 A PIC 9(02) VALUE 21.
77 B PIC X(20).
PROCEDURE DIVISION.
DISPLAY 'Hello, world'.
STRING 'VALUE OF A IS '  A
    DELIMITED BY SIZE INTO B
END-STRING.
DISPLAY B.
MOVE 'VALUE OF A IS  '  A TO B.
DISPLAY B.
STOP RUN.
0
Hello Experts,

I am looking for a VBA script to identify errors at following.

1.  COLUMN A: PLEASE HIGHLIGHT YELLOW ANY ROW NOT START WITH RMIRAAxxxxxxxx( X is for  8 digit numbers) OR
RCKIRUxxxxxxxx ( X is for 8 digit numbers)

2.  COLUMN C = COLUMN A, HIGHLIGHT YELLOW ANYROW THAT IS NOT EQUAL.

3.  COLUMN E TAG SHOULD START WITH Axxxxxx (x for 6 numbers ). HIGHLIGHT YELLOW ANY ROW THAT IS NOT  START WITH Axxxxxx.

4.  COLUMN H = COLUMN I + COLUMN J.  HIGHLIGHT YELLOW ANY ROW THAT IS NOT.

5.  COLUMN Q: HIGHLIGHT YELLOW ANY ROW NOT START WITH 0056-XXXX ( X STAND FOR 4 NUMBERS) OR BLANK ROW.

6.  COLUMN S: HIGHLIGHT ANY ROW WITH WORD " Unclassfied" or BLANK ROW

Attached is the sample file.

Please help.  Thank You in Advance !
Sample_December_07_2017.xlsx
0
Hello

How can I print the output of an element to a text file using xml.etree.elementtree from https://docs.python.org/2/library/xml.etree.elementtree.html

Please look at the first FOR loop section. In the example below I want to print or pipe child.tag and child.attrib to separate files.

>>> for child in root:
...     print child.tag, child.attrib

Open in new window

0
Good day everybody,

Even though I've tried many different syntax, I don't get to work the following code:
I define Year and Year1 as variables, where year is 2017 and Year1 is 17
Year= ActiveSheet.Range("C3")
Year1=ActiveSheet.Range("C4")

Then, there's a part of the code where I need to use a SUMIFS to other workbook already open, the original formula is:
=SUMIFS('[Comisiones 2017.xlsm]Stats17'!$F$3:$F$10000,'[Comisiones 2017.xlsm]Stats17'!$E$3:$E$10000,C2,'[Comisiones 2017.xlsm]Stats17'!$B$3:$B$10000,G2)

So, the only thing I want to do is that "2017" and "17" can be defined into the formula with both variables, since the names of the files and sheets will be changing depending on the current year.

I had this problem before and I solved it by inserting, litterally something like: "SUMIFS('[Comisiones "&Sheets("MXN").Range("C3")&"..." as if it took the variable directly from the workbook, however, this solution only works for me when the formula and the referenced cell are on the same workbook, and now, the reference workbook is different from the workbook I want to set the formula in.

Thank you in advance for any help you can provide to me,

Best Regards
0

Programming

52K

Solutions

40K

Contributors

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.