PDF to CSV Conversion

slowhandfan
slowhandfan Member Posts: 56
edited 2013-07-25 in NAV/Navision Classic Client
I have a client that is installing ALOHA from NCR and they asked me to write an interface to import that data into Navision.

The EOD folders in ALOHA (aka "the grind files") are produced in DBF format. In testing, I have been opening the DBF files I need in EXCEL and saving them as a .CSV file, and I have dataports and codeunits (for automation) to import the CSV files. It works great.

But nearing install now, obvioulsy in automation (on the NAS), I cannot open the files in excel and save them as a CSV


Does anyone know a utility (an exe program) I can call out of a shell command in navision where I tell it where the ITM.DBF file is and it creates a ITEM.CSV file in the same library....

I would greatly appreciate any input on this I could get, it is a little late in the game to rewrite the entire interface....

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Maybe this old download can help you: dBase conversion tools
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • vaprog
    vaprog Member Posts: 1,163
    slowhandfan wrote:
    obvioulsy in automation (on the NAS), I cannot open the files in excel and save them as a CSV

    Why? Why can't you use Excel automation?

    Alternatively you might want to try ADO.

    Or, as some software I used to use does: chip off the header of the dbf file and treat the rest as fixed length records.

Categories