Pardon my naivety.

We are using Epicor's Avante with a Unidata database.

I need the ability to import an excel spreadsheet as a record into a Unidata
file. I would not consider myself to be a programmer, but I have written a
few paragraphs and might be able to slog through this with a little
direction.

Tips or resources would be appreciated.

TIA

the Moderator wrote:
One time deal, or recurring?
Manual or automated process?
Unidata clients are...
Dumb terminals? =`;^>
PC running terminal emulator?
PC running web browser?

--
jet

"frosty" <frostyj (AT) bogus (DOT) tld> wrote

Recurring

Process does not exist at this time. We will need to either set up an Excel
Macro or run a SBClient process to load data.

PC running SBClient terminal emulator.

"the Moderator" wrote:

This can be done pretty easily by coding into the Excel object model
and then transferring the data to Unidata using mv.NET (my preference)
or UniObjects.

You can also use macros to save sheets as CSV, HTML, or XML, and then
import those into Unidata for processing. This involves parsing and
more manual intervention.

If you want a custom solution that does this for you with complete
automation, let me know and you'll have it. The cost would be
somewhere around $800 which is $500 for my time plus $250 for a single
mv.NET server license, and there would be a recurring $52/year support
fee for mv.NET.

Questions I'd ask include:
- How do you want to trigger the data transfer?
- How many users would have this feature?
- How often would users be triggering it?
- Will users have Excel up to click a button or do you just want to
trigger activity from the app?

No need to answer those questions now, but that's the sort of info one
would need to code this to-spec.

As an example of other things that can be done between Excel and MV
apps, have a look at the following page. Please note that the
software is no longer available as a product but the functionality can
still be made available in individual projects:
http:// removethisNebula-RnD.com/products/analysis.htm

HTH
Tony
TG@ remove.this.antispam.textNebula-RnD.com

I have used UniObjects to connect and pass data back and forth in an Excel
spreadsheet. However, you would have to make sure UniObjects is installed on
every PC you would run the import from.

With SBClient you have a lot of options you can explore:

1. File Transfer. See TU.TO.EXCEL and TU.UPLOAD.
2. DDE. See TU.DDE.CONNECT, TU.DDE.READ
3. ODBC, See TU.SQL.CONNECT and TU.SQL.EXEC
4. VBScript interface.

It will depend on how much data there is, where you prefer to do the work,
and which side you want to "start" the process from. I'll have a similar
project this summer; however, it will be a one-time thing so I'll likely
just export the data to CSV files on the UD server and then load them as I
already have routines for that.

hth
Colin Alfke
Calgary Canada

"the Moderator" wrote >

I have some standard SB+ utilities that can get you most of the way
there and they're free. I do have to add the standard caveat that
loading data directly into an application like Avante is extremely
risky, as there is a risk of creating inconsistencies in the data that
the application would normally mitigate.

But contact me off-list and I'll send you a document of standard
processes I use in all SB+ applications which includes IMPORT.DATA, the
tool for importing from a flat file created from Excel, et al.

Have a look at UniObjects.

It allows you to directly access the UniData database using Visual Basic and
VBA.

You could write a macro script in VBA within Excel using UniObjects to
upload the into the database.

Not that difficult either.

"the Moderator" <sparky (AT) no_spam_engineer (DOT) com> wrote

Nexus wrote:
save as a comma delimited file
in Unidata: Openseq...
then read and parse.

ben