Hi,
please find an updated package at
http://www.openapc.com/download/Windows/index.php?c=1&f=libio_mysql.zip
It contains two new plug-ins for converting a line of CSV data to
single elements of type char and number (there also a new liboapc.dll
is included which has to be copied to the system-folder).
Within the configuration you have to define which field of the CSV
data have to be assigned to which output.
These plug-ins will be part of the next release in case the work well for you.
On 03/06/2011, Eoin Ross <eross(a)chemstation.com> wrote:
That's exactly what I had in mind.
Would like to help with the project but until I get some C/C++ skills,
massaging the manual would be about it.
On 06/03/2011 01:06 AM, Jim Hart wrote:
> Hi,
>
> your are right, there is something missing at the moment...
>
> How about this: we add a "CSV to String" and a "CSV to Number"
> conversion plug-in where you can input a line of CSV and can output
> the separated elements. Because there is a maximum of 8 elements you
> can choose within the configuration which field has to be assigned to
> which output. In case you have more fields within your CSV line you
> would need more of these conversion plug-ins.
>
> Would that be a suitable solution for you?
>
> On 02/06/2011, Eoin Ross<eross(a)chemstation.com> wrote:
>> I have the MySQL element querying a table with data passed from a serial
>> RFID reader - and it works great giving me the expected row in a
>> semi-colon separated value string.
>>
>> I would like to run one query, and break the resulting CSV string up
>> into it's fields for use elsewhere in the flow for controlling access to
>> features. I have not been able to find a plugin/element/method that can
>> do this. The closest seems to be the 'CSV to Control' element - but
it's
>> outputs don't fit for this purpose.
>>
>> A workaround seems to be having a 'MySQL Access' element and ' for
each
>> desired field - is this the only way?
>> I have looked into the openSDK, but C/C++ is not something I am
>> knowledgeable on :(
>> _______________________________________________
>> openapc mailing list
>> openapc(a)lists.fedorahosted.org
>>
https://fedorahosted.org/mailman/listinfo/openapc
_______________________________________________
openapc mailing list
openapc(a)lists.fedorahosted.org
https://fedorahosted.org/mailman/listinfo/openapc
--
Kind regards
Jim Hart
http://www.openapc.com