Best way to start

  1. ‹ Older
  2. 11 months ago

    Emile S

    29 Nov 2018 Europe (France, Strasbourg)

    Use Windows 10 Zip built in utility. Or download a more recent version.

    The zip file is 26.987 Bytes… in case your download was bad.

  3. Emile S

    29 Nov 2018 Europe (France, Strasbourg)

    Did you try to re download the archive file ?

  4. Mark S

    29 Nov 2018 Pre-Release Testers, Xojo Pro, XDC Speakers

    OK .... here are two more links. One for the Xojo binary project and one for a sample INI file. Both are NOT ZIPPED. You should be able to load the CSVframework.xojo_binary_project directly into the Xojo IDE. You can open the MyConfigSettings.ini sample file with notepad.

    https://www.dropbox.com/s/wirsj47z4rjjfyh/CSVframework.xojo_binary_project?dl=0

    https://www.dropbox.com/s/47ft2agevk7vchr/MyConfigSettings.ini?dl=0

    Let me know if you have trouble with these links and I will do something else.

  5. Edited 11 months ago

    Thank you Mark. I managed to load it into Xojo and am looking through all the code. Going to take me a while to understand I'm sure. The csv files I access do not have column names in the first row. We have the data file map and code off of it.

    Sure I am going to have questions. I'll be back...LOL

    By the way. I did go ahead and buy the xDev magazine with the Xojo beginners article.

  6. Mark S

    29 Nov 2018 Pre-Release Testers, Xojo Pro, XDC Speakers
    Edited 11 months ago

    Milford,

    Since you don't have column names you can comment out that chunk of code in the FindTheFile method BUT you will also need to modify the data load method (LoadArray) since it assumes the number of names in the first row to be the number of columns in the data portion of the file. You can just modify the code like this:

    'Current code

      'Loop through the input row based on the number of columns found when
      '  the first row was processed by the FindTheFile method.
      for i = 0 to ColumnNames.Ubound

    'To this code since the ColCount is already calculated a few lines above here

      'Loop through the input row based on the number of columns found in
      '  the data row just read.
      for i = 0 to ColCount 

    I hope this helps you get this modified to work with your data.

    Mark

  7. Thanks. Yea I can hard code the col count because it's 1435 columns.

  8. One thing I noticed. You have file type and extension listed as CSV. But the files I use are extension jcp, made the change with no problem. But end users will access drf, or jcp or mcp depending on what data file provider they use. I tried to add all three in place of the csv and it didn't work. How do I include all three extensions?

  9. Mark S

    30 Nov 2018 Pre-Release Testers, Xojo Pro, XDC Speakers

    Put all of the possible file extensions in the Filetype Extension field separated with semi colons.

    Like:

    jcp;drf;mcp

    The HELP info for Xojo has improved recently. Remember to check here:
    http://docs.xojo.com

  10. 10 months ago

    Dale A

    2 Dec 2018 San Diego, California, USA

    @milford w One thing I noticed. You have file type and extension listed as CSV. But the files I use are extension jcp, made the change with no problem. But end users will access drf, or jcp or mcp depending on what data file provider they use. I tried to add all three in place of the csv and it didn't work. How do I include all three extensions?

    Mark's response is correct but if you're on Windows it seems that the leading dot is necessary, as in:

    .jcp;.drf;.mcp
  11. Thanks guys. I have been sick and been away a couple of days. Trying to get better.

  12. Mark,

    I don't understand why a bug shows up here.

    'Open the input file
    try
    InPath = INIfile
    InFile = new FolderItem(InPath,FolderItem.PathTypeNative)
    *** BUG HERE*** InStream = TextInputStream.Open(InFile)
    catch err as IOException
    er = "Input File Error : " + str(err.ErrorNumber)
    return ""
    end try

  13. Dave S

    7 Dec 2018 San Diego, California USA
    Edited 10 months ago

    no need to specifiy NEW with Folderitem
    plus you should verify that InFile is both "Not Nil" and does "Exist"

  14. Edited 10 months ago

    What does "INIfile" mean as I can not find it anywhere in the docs.

  15. Dave S

    7 Dec 2018 San Diego, California USA

    depends on what you defined it as... you won't find it in the docs, because it isn't an Xojo construct....
    If you cut/pasted that code from somewhere else, you need to read and understand the context in which it exists.

  16. Edited 10 months ago

    It was from code Mark shared. That's what I am attempting to do. Is go through the code and understand how it works.
    Thanks.

    Just found it. It is a string in a function.

  17. Mark S

    7 Dec 2018 Pre-Release Testers, Xojo Pro, XDC Speakers

    INIfile is the full path to a configuration file that contains info your program might need. I included this code in the sample because I figured you might need to handle a configuration file in your final code.

    The error is probably because the file is missing in the folder where the EXE file exists when you are running it in debug mode.

    The INI File that I included called MyConfigSettings.ini is assumed to be in the same folder with the EXE file. The CopyFile setting in the Build Settings should copy the sample file to the same place the EXE file. Based on how you set up your folder structure is probably the issue.

    For now just comment out the call to the INIfunctions.GetKey in the App.Open event.

  18. Thanks

  19. 3 months ago

    im new to coding and programming seeking help. Want to use this skill to make side money. any one willing to steer me in the right direction??

  20. Louis D

    Jul 22 Pre-Release Testers, Xojo Pro QC, Canada

    Welcome to Xojo!

    Now, just a few housekeeping points to keep in mind:

    • don't hijack threads, start your own even if the topic seems the same;
    • don't double post

    In the other thread, @Norman P gave you good advise. Once you study and try things, ask specific questions. This community is among the most helpful around. People here will help. You will get the best answers when you ask clear and well documented questions, where you show what you tried and clearly describe your issue.

    Best success.

  21. brian f

    Jul 22 Pre-Release Testers, Xojo Pro Chilly California

    @JustinMcCall im new to coding and programming seeking help. Want to use this skill to make side money. any one willing to steer me in the right direction??

    Automotive repair is a solid side hustle also

or Sign Up to reply!