-
FlexPro
- Auf einen Blick
- Features & Optionen
- Einsatzgebiete
- Alle Vorteile
- Neu in FlexPro 2021
- FlexPro gratis testen
- FlexPro View OEM Freeware
- Kaufberatung
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produkte
- News
- Support
- Unternehmen
- Jobs
- Kontakt
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
Importing heavy and comlplicated ascii data files
- Dieses Thema hat 3 Antworten sowie 2 Teilnehmer und wurde zuletzt vor vor 17 Jahren von Gilles Quinton aktualisiert.
-
AutorBeiträge
-
September 25, 2007 um 12:02 am Uhr #12495Gilles QuintonTeilnehmer
I am testing Flexpro in order to know whether we can use it (here at Sopra) for airbus engine noise data analysys. At the moment, we use Excel, which is too lights for our needs.
The data are stored in ascii files so complicated that it is impossible to import them with the import wizard. Files can be up to 100 Mb (but are scarcelly more than 5 mb). Each file contains several sets of data, each with different names, units, columns and with texts between each set. See attachment
We then have to write macros to import them automatically into a flexpro database (as we do so far in Excel)
1/Is it possible?
2/Are they VBA or FPscripts? How to implement and run them?
3/ When drawing Diagrams, based on those data, is it also possible to assign permanently the same colours to curves having the same name (for example the column nammed XCG would be always in blue, whatever the dataset it comes from?
September 25, 2007 um 12:02 am Uhr #8159Gilles QuintonTeilnehmerI am testing Flexpro in order to know whether we can use it (here at Sopra) for airbus engine noise data analysys. At the moment, we use Excel, which is too lights for our needs.
The data are stored in ascii files so complicated that it is impossible to import them with the import wizard. Files can be up to 100 Mb (but are scarcelly more than 5 mb). Each file contains several sets of data, each with different names, units, columns and with texts between each set. See attachment
We then have to write macros to import them automatically into a flexpro database (as we do so far in Excel)
1/Is it possible?
2/Are they VBA or FPscripts? How to implement and run them?
3/ When drawing Diagrams, based on those data, is it also possible to assign permanently the same colours to curves having the same name (for example the column nammed XCG would be always in blue, whatever the dataset it comes from?
September 25, 2007 um 1:26 am Uhr #8789Bernhard KantzTeilnehmerRegarding your questions:
1) Yes it is possible to import these files into a FlexPro database.
2) Basically you have to implement them in VBA (to be more specific: a COM add-in in any COM compatible language would also be possible).
The recommended way is to implement a custom import filter. Please take a look at the ImportFilter example located under
C:\Program Files\Weisang\FlexPro 7.0\Examples\VBA\Importfilter
This example gives a complete framework for an FlexPro import filter in VBA (it is fully documented in the online help). The example implements an import filter for a custom binary data format. I does so by re-using functionality of the binary import filter. In your case you could do something similar by re-using functionality of the text import filter. You just need to figure out the starting and ending positions of your data and you can construct a text import. This saves you the time of collecting all the values manually. The meta data can be collected and added in VBA and added as parameters to the datasets.
3) If you create the diagrams using VBA you can always assign the color in the creation step. For existing or manually created diagrams you could write a simple macro that does the color adjustment for you: First create a dictionary object which contains all the name to color mappings. Then create a makro which takes the active object (diagram), iterates over the curves and looks up the (Y-)dataset name of each curve in the color dictionary. Then update the color of the curve according to the map (or leave it alone if you don’t find the name). The macro can be executed either by connecting it to a toolbar button or you could take an event based approach (in an handler for ObjectModified for instance).
Support
support@weisang.comOktober 1, 2007 um 5:30 pm Uhr #8790Bernhard KantzTeilnehmerFor your information: If you do not have the time to write a custom import filter yourself, you can always ask Weisang to do this job for you. Most import filters take only one to three days of development effort. Please send a short e-mail with your inquiry to info@weisang.com and we will provide you a quotation.
-
AutorBeiträge
- Du musst angemeldet sein, um auf dieses Thema antworten zu können.